database

package
v0.0.0-...-18f9ab3 Latest Latest
Warning

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

Go to latest
Published: Nov 3, 2023 License: MIT Imports: 3 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

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 Game

type Game struct {
	ID        int32
	Host      string
	Players   []string
	Answer    string
	Questions []string
	Guesses   []string
	StartTime time.Time
	EndTime   sql.NullTime
	Ended     sql.NullBool
}

type Guess

type Guess struct {
	ID      int32
	Guess   string
	UserID  int32
	GameID  int32
	Correct sql.NullBool
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) DeleteUser

func (q *Queries) DeleteUser(ctx context.Context, username string) error

func (*Queries) GetUser

func (q *Queries) GetUser(ctx context.Context, username string) (User, error)

func (*Queries) UpdateUser

func (q *Queries) UpdateUser(ctx context.Context, username string) error

func (*Queries) WithTx

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

type Question

type Question struct {
	ID       int32
	Question string
	UserID   int32
	GameID   int32
}

type User

type User struct {
	ID        int32
	Username  string
	CreatedAt time.Time
}

Jump to

Keyboard shortcuts

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