Versions in this module Expand all Collapse all v0 v0.2.0 Mar 7, 2026 v0.1.1 Mar 4, 2026 Changes in this version + type BotVisit struct + BotName string + ID int64 + IpHash string + Path string + Timestamp time.Time + UserAgent string + type BrowserStatsRow struct + Count int64 + Name string + type DBTX interface + ExecContext func(context.Context, string, ...interface{}) (sql.Result, error) + PrepareContext func(context.Context, string) (*sql.Stmt, error) + QueryContext func(context.Context, string, ...interface{}) (*sql.Rows, error) + QueryRowContext func(context.Context, string, ...interface{}) *sql.Row + type DailyBotVisitsRow struct + Date string + Views int64 + type DailyViewsRow struct + Date string + Views int64 + type DeviceStatsRow struct + Count int64 + Name string + type HourlyBotVisitsRow struct + Date string + Views int64 + type HourlyViewsRow struct + Date string + Views int64 + type InsertBotVisitParams struct + BotName string + IpHash string + Path string + Timestamp time.Time + UserAgent string + type InsertVisitParams struct + Browser string + Device string + DurationSec sql.NullInt64 + IpHash string + Os string + Path string + Referrer sql.NullString + ScreenSize sql.NullString + SessionID string + Timestamp time.Time + VisitorID string + type LatestPagesRow struct + Browser string + Path string + Timestamp time.Time + type MonthlyBotVisitsRow struct + Date string + Views int64 + type MonthlyViewsRow struct + Date string + Views int64 + type OSStatsRow struct + Count int64 + Name string + type Querier interface + AvgDuration func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) (sql.NullFloat64, error) + BrowserStats func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]BrowserStatsRow, error) + CountBotVisits func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) (int64, error) + CountRealtimeVisitors func(ctx context.Context, timestamp time.Time) (int64, error) + CountUniqueVisitors func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) (int64, error) + CountVisits func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) (int64, error) + DailyBotVisits func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]DailyBotVisitsRow, error) + DailyViews func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]DailyViewsRow, error) + DeleteOldBotVisits func(ctx context.Context, timestamp time.Time) error + DeleteOldVisits func(ctx context.Context, timestamp time.Time) error + DeviceStats func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]DeviceStatsRow, error) + GetSetting func(ctx context.Context, key string) (string, error) + HourlyBotVisits func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]HourlyBotVisitsRow, error) + HourlyViews func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]HourlyViewsRow, error) + InsertBotVisit func(ctx context.Context, arg InsertBotVisitParams) error + InsertVisit func(ctx context.Context, arg InsertVisitParams) error + LatestPages func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]LatestPagesRow, error) + MonthlyBotVisits func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]MonthlyBotVisitsRow, error) + MonthlyViews func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]MonthlyViewsRow, error) + OSStats func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]OSStatsRow, error) + ReferrerStats func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]ReferrerStatsRow, error) + TopBotPages func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]TopBotPagesRow, error) + TopBots func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]TopBotsRow, error) + TopPages func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]TopPagesRow, error) + UpdateVisitDuration func(ctx context.Context, arg UpdateVisitDurationParams) error + UpsertSetting func(ctx context.Context, key string, value string) error + type Queries struct + func New(db DBTX) *Queries + func (q *Queries) AvgDuration(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) (sql.NullFloat64, error) + func (q *Queries) BrowserStats(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]BrowserStatsRow, error) + func (q *Queries) CountBotVisits(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) (int64, error) + func (q *Queries) CountRealtimeVisitors(ctx context.Context, timestamp time.Time) (int64, error) + func (q *Queries) CountUniqueVisitors(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) (int64, error) + func (q *Queries) CountVisits(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) (int64, error) + func (q *Queries) DailyBotVisits(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]DailyBotVisitsRow, error) + func (q *Queries) DailyViews(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]DailyViewsRow, error) + func (q *Queries) DeleteOldBotVisits(ctx context.Context, timestamp time.Time) error + func (q *Queries) DeleteOldVisits(ctx context.Context, timestamp time.Time) error + func (q *Queries) DeviceStats(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]DeviceStatsRow, error) + func (q *Queries) GetSetting(ctx context.Context, key string) (string, error) + func (q *Queries) HourlyBotVisits(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]HourlyBotVisitsRow, error) + func (q *Queries) HourlyViews(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]HourlyViewsRow, error) + func (q *Queries) InsertBotVisit(ctx context.Context, arg InsertBotVisitParams) error + func (q *Queries) InsertVisit(ctx context.Context, arg InsertVisitParams) error + func (q *Queries) LatestPages(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]LatestPagesRow, error) + func (q *Queries) MonthlyBotVisits(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]MonthlyBotVisitsRow, error) + func (q *Queries) MonthlyViews(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]MonthlyViewsRow, error) + func (q *Queries) OSStats(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]OSStatsRow, error) + func (q *Queries) ReferrerStats(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]ReferrerStatsRow, error) + func (q *Queries) TopBotPages(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]TopBotPagesRow, error) + func (q *Queries) TopBots(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]TopBotsRow, error) + func (q *Queries) TopPages(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) ([]TopPagesRow, error) + func (q *Queries) UpdateVisitDuration(ctx context.Context, arg UpdateVisitDurationParams) error + func (q *Queries) UpsertSetting(ctx context.Context, key string, value string) error + func (q *Queries) WithTx(tx *sql.Tx) *Queries + type ReferrerStatsRow struct + Count int64 + Name string + type Setting struct + Key string + Value string + type TopBotPagesRow struct + Path string + Views int64 + type TopBotsRow struct + Count int64 + Name string + type TopPagesRow struct + Path string + Views int64 + type UpdateVisitDurationParams struct + DurationSec sql.NullInt64 + Path string + VisitorID string + type Visit struct + Browser string + Device string + DurationSec sql.NullInt64 + ID int64 + IpHash string + Os string + Path string + Referrer sql.NullString + ScreenSize sql.NullString + SessionID string + Timestamp time.Time + VisitorID string v0.1.0 Mar 3, 2026
Go to main page