database

package

Go to main page

Versions in this module

v0

v0.0.4

Apr 23, 2025

v0.0.3

Apr 20, 2025

Changes in this version

type AddWmClassParams

+ ActiveDuration int64

type Queries

+ func (q *Queries) GetWinByWmName(ctx context.Context, wmName string) (Wmclass, error)

+ func (q *Queries) TopActiveDurationWinLastDay(ctx context.Context) ([]TopActiveDurationWinLastDayRow, error)

+ func (q *Queries) TopActiveDurationWinLastHour(ctx context.Context) ([]TopActiveDurationWinLastHourRow, error)

+ func (q *Queries) TopDurationWinLastDay(ctx context.Context) ([]Wmclass, error)

+ func (q *Queries) TopDurationWinLastHour(ctx context.Context) ([]Wmclass, error)

+ type TopActiveDurationWinLastDayRow struct

+ ActiveDuration int64

+ WmClass string

+ type TopActiveDurationWinLastHourRow struct

+ ActiveDuration int64

+ WmClass string

type Wmclass

+ ActiveDuration int64

v0.0.2

Feb 19, 2025

Changes in this version

+ type AddWindowsParams struct

+ IsActive int64

+ UpdatedAt time.Time

+ WmClass string

+ type AddWmClassParams struct

+ Duration int64

+ EndTime time.Time

+ IsActive int64

+ StartTime time.Time

+ TotalCount int64

+ UpdatedAt time.Time

+ WmClass string

+ WmName string

type Queries

+ func (q *Queries) AddWindows(ctx context.Context, arg AddWindowsParams) (Window, error)

+ func (q *Queries) AddWmClass(ctx context.Context, arg AddWmClassParams) error

+ func (q *Queries) ListAllWindows(ctx context.Context) ([]Window, error)

+ func (q *Queries) ListAllWmclass(ctx context.Context) ([]Wmclass, error)

+ func (q *Queries) ListLastDayWindows(ctx context.Context) ([]Window, error)

+ func (q *Queries) ListLastDayWmClass(ctx context.Context) ([]Wmclass, error)

+ func (q *Queries) ListLastHourWindows(ctx context.Context) ([]Window, error)

+ func (q *Queries) ListLastHourWmClass(ctx context.Context) ([]Wmclass, error)

+ func (q *Queries) ListWinByWmClass(ctx context.Context, wmClass string) ([]Wmclass, error)

+ func (q *Queries) ListWinByWmName(ctx context.Context, wmName string) (Wmclass, error)

+ func (q *Queries) TopWinLastDay(ctx context.Context) ([]TopWinLastDayRow, error)

+ func (q *Queries) TopWinLastHour(ctx context.Context) ([]TopWinLastHourRow, error)

+ func (q *Queries) TopWindowsLastDay(ctx context.Context) ([]TopWindowsLastDayRow, error)

+ func (q *Queries) TopWindowsLastHour(ctx context.Context) ([]TopWindowsLastHourRow, error)

+ type TopWinLastDayRow struct

+ EventCount int64

+ WmClass string

+ WmName string

+ type TopWinLastHourRow struct

+ EventCount int64

+ WmClass string

+ WmName string

+ type TopWindowsLastDayRow struct

+ EventCount int64

+ WmClass string

+ type TopWindowsLastHourRow struct

+ EventCount int64

+ WmClass string

+ type Window struct

+ CreatedAt time.Time

+ ID int64

+ IsActive int64

+ UpdatedAt time.Time

+ WmClass string

+ type Wmclass struct

+ CreatedAt time.Time

+ Duration int64

+ EndTime time.Time

+ ID int64

+ IsActive int64

+ StartTime time.Time

+ TotalCount int64

+ UpdatedAt time.Time

+ WmClass string

+ WmName string

v0.0.1

Feb 15, 2025

Changes in this version

+ type AddKeyParams struct

+ Keycode int64

+ Keyname string

+ type AddMouseDownParams struct

+ Button string

+ EventType 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 Key struct

+ CreatedAt time.Time

+ ID int64

+ Keycode int64

+ Keyname string

+ type ListKeysPressedLast24HoursRow struct

+ Keycode int64

+ Keyname string

+ PressCount int64

+ type ListKeysPressedLastHourRow struct

+ Keycode int64

+ Keyname string

+ PressCount int64

+ type ListMouseEventsLast24HoursRow struct

+ Button string

+ EventCount int64

+ EventType string

+ type ListMouseEventsLastHourRow struct

+ Button string

+ EventCount int64

+ EventType string

+ type Mouse struct

+ Button string

+ CreatedAt time.Time

+ EventType string

+ ID int64

+ type Queries struct

+ func New(db DBTX) *Queries

+ func (q *Queries) AddKey(ctx context.Context, arg AddKeyParams) (Key, error)

+ func (q *Queries) AddMouseDown(ctx context.Context, arg AddMouseDownParams) (Mouse, error)

+ func (q *Queries) CreateUser(ctx context.Context, name string) (User, error)

+ func (q *Queries) DelteUser(ctx context.Context, name string) error

+ func (q *Queries) ListAllKeys(ctx context.Context) ([]Key, error)

+ func (q *Queries) ListAllMouse(ctx context.Context) ([]Mouse, error)

+ func (q *Queries) ListKeysPressedLast24Hours(ctx context.Context) ([]ListKeysPressedLast24HoursRow, error)

+ func (q *Queries) ListKeysPressedLastHour(ctx context.Context) ([]ListKeysPressedLastHourRow, error)

+ func (q *Queries) ListMouseEventsLast24Hours(ctx context.Context) ([]ListMouseEventsLast24HoursRow, error)

+ func (q *Queries) ListMouseEventsLastHour(ctx context.Context) ([]ListMouseEventsLastHourRow, error)

+ func (q *Queries) ListUsers(ctx context.Context) ([]User, error)

+ func (q *Queries) WithTx(tx *sql.Tx) *Queries

+ type User struct

+ CreatedAt time.Time

+ ID int64

+ Name string

+ UpdatedAt time.Time

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