dbmodels

package
v0.0.2 Latest Latest
Warning

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

Go to latest
Published: Jun 19, 2023 License: Apache-2.0, BSD-3-Clause, ISC Imports: 2 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Character

type Character struct {
	CharacterID     int64
	PlayerID        int64
	CharacterTypeID int64
	CharacterData   []byte
}

type CreateCharacterParams

type CreateCharacterParams struct {
	PlayerID        int64
	CharacterTypeID int64
	CharacterData   []byte
}

type CreatePlayerParams

type CreatePlayerParams struct {
	Username     string
	Nickname     sql.NullString
	PasswordHash string
}

type CreateSessionParams

type CreateSessionParams struct {
	PlayerID         int64
	SessionKey       string
	SessionAddress   string
	SessionExpiresAt int64
}

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 Player

type Player struct {
	PlayerID     int64
	Username     string
	Nickname     sql.NullString
	PasswordHash string
	Pang         int64
	Rank         int64
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateCharacter

func (q *Queries) CreateCharacter(ctx context.Context, arg CreateCharacterParams) (Character, error)

func (*Queries) CreatePlayer

func (q *Queries) CreatePlayer(ctx context.Context, arg CreatePlayerParams) (Player, error)

func (*Queries) CreateSession

func (q *Queries) CreateSession(ctx context.Context, arg CreateSessionParams) (Session, error)

func (*Queries) DeleteExpiredSessions

func (q *Queries) DeleteExpiredSessions(ctx context.Context, sessionExpiresAt int64) error

func (*Queries) GetCharacter

func (q *Queries) GetCharacter(ctx context.Context, characterID int64) (Character, error)

func (*Queries) GetCharactersByPlayer

func (q *Queries) GetCharactersByPlayer(ctx context.Context, playerID int64) ([]Character, error)

func (*Queries) GetPlayer

func (q *Queries) GetPlayer(ctx context.Context, playerID int64) (Player, error)

func (*Queries) GetPlayerByUsername

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

func (*Queries) GetSession

func (q *Queries) GetSession(ctx context.Context, sessionID int64) (Session, error)

func (*Queries) GetSessionByKey

func (q *Queries) GetSessionByKey(ctx context.Context, sessionKey string) (Session, error)

func (*Queries) GetSessionsByPlayer

func (q *Queries) GetSessionsByPlayer(ctx context.Context, playerID int64) ([]Session, error)

func (*Queries) PlayerHasCharacters

func (q *Queries) PlayerHasCharacters(ctx context.Context, playerID int64) (bool, error)

func (*Queries) SetPlayerNickname

func (q *Queries) SetPlayerNickname(ctx context.Context, arg SetPlayerNicknameParams) (Player, error)

func (*Queries) UpdateSessionExpiry

func (q *Queries) UpdateSessionExpiry(ctx context.Context, arg UpdateSessionExpiryParams) (Session, error)

func (*Queries) WithTx

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

type Session

type Session struct {
	SessionID        int64
	PlayerID         int64
	SessionKey       string
	SessionAddress   string
	SessionExpiresAt int64
}

type SetPlayerNicknameParams

type SetPlayerNicknameParams struct {
	Nickname sql.NullString
	PlayerID int64
}

type UpdateSessionExpiryParams

type UpdateSessionExpiryParams struct {
	SessionExpiresAt int64
	SessionID        int64
}

Jump to

Keyboard shortcuts

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