database

package
v0.0.1 Latest Latest
Warning

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

Go to latest
Published: Feb 15, 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 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) 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) ListAllKeys

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

func (*Queries) ListAllMouse

func (q *Queries) ListAllMouse(ctx context.Context) ([]Mouse, 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) 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) WithTx

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

type User

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

Jump to

Keyboard shortcuts

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