models

type PageStats struct {
	New            bool      `db:"-" json:"-"`
	SiteID         int64     `db:"site_id" json:"-"`
	HostnameID     int64     `db:"hostname_id" json:"-"`
	PathnameID     int64     `db:"pathname_id" json:"-"`
	Hostname       string    `db:"hostname"`
	Pathname       string    `db:"pathname"`
	Pageviews      int64     `db:"pageviews"`
	Visitors       int64     `db:"visitors"`
	Entries        int64     `db:"entries"`
	BounceRate     float64   `db:"bounce_rate"`
	AvgDuration    float64   `db:"avg_duration"`
	KnownDurations int64     `db:"known_durations"`
	Date           time.Time `db:"ts" json:",omitempty"`
}

type Pageview struct {
	ID             string    `db:"id"`
	SiteTrackingID string    `db:"site_tracking_id"`
	Hostname       string    `db:"hostname"`
	Pathname       string    `db:"pathname"`
	IsNewVisitor   bool      `db:"is_new_visitor"`
	IsNewSession   bool      `db:"is_new_session"`
	IsUnique       bool      `db:"is_unique"`
	IsBounce       bool      `db:"is_bounce"`
	IsFinished     bool      `db:"is_finished"`
	Referrer       string    `db:"referrer"`
	Duration       int64     `db:"duration"`
	Timestamp      time.Time `db:"timestamp"`
}

type ReferrerStats struct {
	New            bool      `db:"-" json:"-"`
	SiteID         int64     `db:"site_id" json:"-"`
	HostnameID     int64     `db:"hostname_id" json:"-"`
	PathnameID     int64     `db:"pathname_id" json:"-"`
	Hostname       string    `db:"hostname"`
	Pathname       string    `db:"pathname"`
	Group          string    `db:"groupname"`
	Visitors       int64     `db:"visitors"`
	Pageviews      int64     `db:"pageviews"`
	BounceRate     float64   `db:"bounce_rate"`
	AvgDuration    float64   `db:"avg_duration"`
	KnownDurations int64     `db:"known_durations"`
	Date           time.Time `db:"ts" json:",omitempty"`
}

type Site struct {
	ID         int64  `db:"id" json:"id"`
	TrackingID string `db:"tracking_id" json:"trackingId"`
	Name       string `db:"name" json:"name"`
}

type SiteStats struct {
	New            bool      `db:"-" json:"-" `
	SiteID         int64     `db:"site_id" json:"-"`
	Visitors       int64     `db:"visitors"`
	Pageviews      int64     `db:"pageviews"`
	Sessions       int64     `db:"sessions"`
	BounceRate     float64   `db:"bounce_rate"`
	AvgDuration    float64   `db:"avg_duration"`
	KnownDurations int64     `db:"known_durations" json:",omitempty"`
	Date           time.Time `db:"ts" json:",omitempty"`
}

type User struct {
	ID       int64
	Email    string
	Password string `json:"-"`
}