sqlcgen

type BotVisit struct {
	ID        int64
	BotName   string
	IpHash    string
	UserAgent string
	Path      string
	Timestamp time.Time
}

type BrowserStatsRow struct {
	Name  string
	Count int64
}

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type DailyBotVisitsRow struct {
	Date  string
	Views int64
}

type DailyViewsRow struct {
	Date  string
	Views int64
}

type DeviceStatsRow struct {
	Name  string
	Count int64
}

type HourlyBotVisitsRow struct {
	Date  string
	Views int64
}

type HourlyViewsRow struct {
	Date  string
	Views int64
}

type InsertBotVisitParams struct {
	BotName   string
	IpHash    string
	UserAgent string
	Path      string
	Timestamp time.Time
}

type InsertVisitParams struct {
	VisitorID   string
	SessionID   string
	IpHash      string
	Browser     string
	Os          string
	Device      string
	Path        string
	Referrer    sql.NullString
	ScreenSize  sql.NullString
	Timestamp   time.Time
	DurationSec sql.NullInt64
}

type LatestPagesRow struct {
	Path      string
	Timestamp time.Time
	Browser   string
}

type MonthlyBotVisitsRow struct {
	Date  string
	Views int64
}

type MonthlyViewsRow struct {
	Date  string
	Views int64
}

type OSStatsRow struct {
	Name  string
	Count int64
}

type Querier interface {
	AvgDuration(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) (sql.NullFloat64, error)
	BrowserStats(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]BrowserStatsRow, error)
	// Bot aggregations
	CountBotVisits(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) (int64, error)
	// Realtime
	CountRealtimeVisitors(ctx context.Context, timestamp time.Time) (int64, error)
	CountUniqueVisitors(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) (int64, error)
	// Visitor aggregations
	CountVisits(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) (int64, error)
	DailyBotVisits(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]DailyBotVisitsRow, error)
	DailyViews(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]DailyViewsRow, error)
	DeleteOldBotVisits(ctx context.Context, timestamp time.Time) error
	// Cleanup
	DeleteOldVisits(ctx context.Context, timestamp time.Time) error
	DeviceStats(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]DeviceStatsRow, error)
	// Settings
	GetSetting(ctx context.Context, key string) (string, error)
	HourlyBotVisits(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]HourlyBotVisitsRow, error)
	HourlyViews(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]HourlyViewsRow, error)
	InsertBotVisit(ctx context.Context, arg InsertBotVisitParams) error
	// Inserts
	InsertVisit(ctx context.Context, arg InsertVisitParams) error
	LatestPages(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]LatestPagesRow, error)
	MonthlyBotVisits(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]MonthlyBotVisitsRow, error)
	MonthlyViews(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]MonthlyViewsRow, error)
	OSStats(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]OSStatsRow, error)
	ReferrerStats(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]ReferrerStatsRow, error)
	TopBotPages(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]TopBotPagesRow, error)
	TopBots(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]TopBotsRow, error)
	TopPages(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]TopPagesRow, error)
	// Duration update
	UpdateVisitDuration(ctx context.Context, arg UpdateVisitDurationParams) error
	UpsertSetting(ctx context.Context, key string, value string) error
}

type Queries struct {
	// contains filtered or unexported fields
}

type ReferrerStatsRow struct {
	Name  string
	Count int64
}

type Setting struct {
	Key   string
	Value string
}

type TopBotPagesRow struct {
	Path  string
	Views int64
}

type TopBotsRow struct {
	Name  string
	Count int64
}

type TopPagesRow struct {
	Path  string
	Views int64
}

type UpdateVisitDurationParams struct {
	DurationSec sql.NullInt64
	VisitorID   string
	Path        string
}

type Visit struct {
	ID          int64
	VisitorID   string
	SessionID   string
	IpHash      string
	Browser     string
	Os          string
	Device      string
	Path        string
	Referrer    sql.NullString
	ScreenSize  sql.NullString
	Timestamp   time.Time
	DurationSec sql.NullInt64
}