database

package
v0.0.4 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Apr 23, 2025 License: GPL-3.0 Imports: 3 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type AddKeyParams 

type AddKeyParams struct {
	Keyname string
	Keycode int64
}

type AddMouseDownParams 

type AddMouseDownParams struct {
	EventType string
	Button    string
}

type AddWindowsParams added in v0.0.2 

type AddWindowsParams struct {
	WmClass   string
	IsActive  int64
	UpdatedAt time.Time
}

type AddWmClassParams added in v0.0.2 

type AddWmClassParams struct {
	WmClass        string
	WmName         string
	StartTime      time.Time
	EndTime        time.Time
	Duration       int64
	ActiveDuration int64
	IsActive       int64
	UpdatedAt      time.Time
}

type DBTX 

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 Key 

type Key struct {
	ID        int64
	Keyname   string
	Keycode   int64
	CreatedAt time.Time
}

type ListKeysPressedLast24HoursRow 

type ListKeysPressedLast24HoursRow struct {
	Keyname    string
	Keycode    int64
	PressCount int64
}

type ListKeysPressedLastHourRow 

type ListKeysPressedLastHourRow struct {
	Keyname    string
	Keycode    int64
	PressCount int64
}

type ListMouseEventsLast24HoursRow 

type ListMouseEventsLast24HoursRow struct {
	EventType  string
	Button     string
	EventCount int64
}

type ListMouseEventsLastHourRow 

type ListMouseEventsLastHourRow struct {
	EventType  string
	Button     string
	EventCount int64
}

type Mouse 

type Mouse struct {
	ID        int64
	EventType string
	Button    string
	CreatedAt time.Time
}

type Queries 

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

func New 

func New(db DBTX) *Queries

func (*Queries) AddKey 

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

func (*Queries) AddMouseDown 

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

func (*Queries) AddWindows added in v0.0.2 

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

func (*Queries) AddWmClass added in v0.0.2 

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

func (*Queries) CreateUser 

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

func (*Queries) DelteUser 

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

func (*Queries) GetWinByWmName added in v0.0.3 

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

func (*Queries) ListAllKeys 

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

func (*Queries) ListAllMouse 

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

func (*Queries) ListAllWindows added in v0.0.2 

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

func (*Queries) ListAllWmclass added in v0.0.2 

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

func (*Queries) ListKeysPressedLast24Hours 

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

func (*Queries) ListKeysPressedLastHour 

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

func (*Queries) ListLastDayWindows added in v0.0.2 

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

func (*Queries) ListLastDayWmClass added in v0.0.2 

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

func (*Queries) ListLastHourWindows added in v0.0.2 

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

func (*Queries) ListLastHourWmClass added in v0.0.2 

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

func (*Queries) ListMouseEventsLast24Hours 

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

func (*Queries) ListMouseEventsLastHour 

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

func (*Queries) ListUsers 

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

func (*Queries) ListWinByWmClass added in v0.0.2 

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

func (*Queries) TopActiveDurationWinLastDay added in v0.0.3 

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

func (*Queries) TopActiveDurationWinLastHour added in v0.0.3 

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

func (*Queries) TopDurationWinLastDay added in v0.0.3 

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

The below are leaving out because of the bugs in sqlc library beware of bug: >sqlc generate # package sql/queries/wmclass.sql:1:1: duplicate query name: AddWmClass

func (*Queries) TopDurationWinLastHour added in v0.0.3 

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

func (*Queries) TopWindowsLastDay added in v0.0.2 

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

func (*Queries) TopWindowsLastHour added in v0.0.2 

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

func (*Queries) WithTx 

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

type TopActiveDurationWinLastDayRow added in v0.0.3 

type TopActiveDurationWinLastDayRow struct {
	WmClass        string
	ActiveDuration int64
}

type TopActiveDurationWinLastHourRow added in v0.0.3 

type TopActiveDurationWinLastHourRow struct {
	WmClass        string
	ActiveDuration int64
}

type TopWindowsLastDayRow added in v0.0.2 

type TopWindowsLastDayRow struct {
	WmClass    string
	EventCount int64
}

type TopWindowsLastHourRow added in v0.0.2 

type TopWindowsLastHourRow struct {
	WmClass    string
	EventCount int64
}

type User 

type User struct {
	ID        int64
	Name      string
	CreatedAt time.Time
	UpdatedAt time.Time
}

type Window added in v0.0.2 

type Window struct {
	ID        int64
	WmClass   string
	IsActive  int64
	CreatedAt time.Time
	UpdatedAt time.Time
}

type Wmclass added in v0.0.2 

type Wmclass struct {
	ID             int64
	WmClass        string
	WmName         string
	StartTime      time.Time
	EndTime        time.Time
	Duration       int64
	ActiveDuration int64
	IsActive       int64
	CreatedAt      time.Time
	UpdatedAt      time.Time
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.