sqlcgen

package

Go to main page

Versions in this module

v0

v0.5.0

Oct 2, 2026

v0.4.0

Oct 2, 2026

Changes in this version

type BotVisit

+ PageViewID sql.NullString

type InsertBotVisitParams

+ PageViewID sql.NullString

type InsertVisitParams

+ PageViewID sql.NullString

type Querier

+ VisitTotals func(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) (VisitTotalsRow, error)

type Queries

+ func (q *Queries) VisitTotals(ctx context.Context, timestamp time.Time, timestamp_2 time.Time) (VisitTotalsRow, error)

type Visit

+ PageViewID sql.NullString

+ type VisitTotalsRow struct

+ Duration float64

+ Views int64

+ Visitors int64

v0.3.0

Apr 7, 2026

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

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL