dbmodels

package

Go to main page

Versions in this module

v0

v0.0.3

Jul 16, 2023

Changes in this version

+ type AddItemToInventoryParams struct

+ ItemTypeID int64

+ PlayerID int64

+ Quantity sql.NullInt64

type Character

+ AuxPart0ID sql.NullInt64

+ AuxPart1ID sql.NullInt64

+ AuxPart2ID sql.NullInt64

+ AuxPart3ID sql.NullInt64

+ AuxPart4ID sql.NullInt64

+ CutInID sql.NullInt64

+ HairColor int64

+ ItemID int64

+ Mastery int64

+ Part00ItemID sql.NullInt64

+ Part00ItemTypeID int64

+ Part01ItemID sql.NullInt64

+ Part01ItemTypeID int64

+ Part02ItemID sql.NullInt64

+ Part02ItemTypeID int64

+ Part03ItemID sql.NullInt64

+ Part03ItemTypeID int64

+ Part04ItemID sql.NullInt64

+ Part04ItemTypeID int64

+ Part05ItemID sql.NullInt64

+ Part05ItemTypeID int64

+ Part06ItemID sql.NullInt64

+ Part06ItemTypeID int64

+ Part07ItemID sql.NullInt64

+ Part07ItemTypeID int64

+ Part08ItemID sql.NullInt64

+ Part08ItemTypeID int64

+ Part09ItemID sql.NullInt64

+ Part09ItemTypeID int64

+ Part10ItemID sql.NullInt64

+ Part10ItemTypeID int64

+ Part11ItemID sql.NullInt64

+ Part11ItemTypeID int64

+ Part12ItemID sql.NullInt64

+ Part12ItemTypeID int64

+ Part13ItemID sql.NullInt64

+ Part13ItemTypeID int64

+ Part14ItemID sql.NullInt64

+ Part14ItemTypeID int64

+ Part15ItemID sql.NullInt64

+ Part15ItemTypeID int64

+ Part16ItemID sql.NullInt64

+ Part16ItemTypeID int64

+ Part17ItemID sql.NullInt64

+ Part17ItemTypeID int64

+ Part18ItemID sql.NullInt64

+ Part18ItemTypeID int64

+ Part19ItemID sql.NullInt64

+ Part19ItemTypeID int64

+ Part20ItemID sql.NullInt64

+ Part20ItemTypeID int64

+ Part21ItemID sql.NullInt64

+ Part21ItemTypeID int64

+ Part22ItemID sql.NullInt64

+ Part22ItemTypeID int64

+ Part23ItemID sql.NullInt64

+ Part23ItemTypeID int64

+ Shirt int64

type CreateCharacterParams

+ HairColor int64

+ ItemID int64

+ Mastery int64

+ Part00ItemTypeID int64

+ Part01ItemTypeID int64

+ Part02ItemTypeID int64

+ Part03ItemTypeID int64

+ Part04ItemTypeID int64

+ Part05ItemTypeID int64

+ Part06ItemTypeID int64

+ Part07ItemTypeID int64

+ Part08ItemTypeID int64

+ Part09ItemTypeID int64

+ Part10ItemTypeID int64

+ Part11ItemTypeID int64

+ Part12ItemTypeID int64

+ Part13ItemTypeID int64

+ Part14ItemTypeID int64

+ Part15ItemTypeID int64

+ Part16ItemTypeID int64

+ Part17ItemTypeID int64

+ Part18ItemTypeID int64

+ Part19ItemTypeID int64

+ Part20ItemTypeID int64

+ Part21ItemTypeID int64

+ Part22ItemTypeID int64

+ Part23ItemTypeID int64

+ Shirt int64

type CreatePlayerParams

+ Pang int64

+ type GetCharacterRow struct

+ AuxPart0ID sql.NullInt64

+ AuxPart1ID sql.NullInt64

+ AuxPart2ID sql.NullInt64

+ AuxPart3ID sql.NullInt64

+ AuxPart4ID sql.NullInt64

+ CharacterID int64

+ CharacterTypeID int64

+ CutInID sql.NullInt64

+ HairColor int64

+ InventoryAuxPart0TypeIDFIXNULL int64

+ InventoryAuxPart1TypeIDFIXNULL int64

+ InventoryAuxPart2TypeIDFIXNULL int64

+ InventoryAuxPart3TypeIDFIXNULL int64

+ InventoryAuxPart4TypeIDFIXNULL int64

+ ItemID int64

+ Mastery int64

+ Part00ItemID sql.NullInt64

+ Part00ItemTypeID int64

+ Part01ItemID sql.NullInt64

+ Part01ItemTypeID int64

+ Part02ItemID sql.NullInt64

+ Part02ItemTypeID int64

+ Part03ItemID sql.NullInt64

+ Part03ItemTypeID int64

+ Part04ItemID sql.NullInt64

+ Part04ItemTypeID int64

+ Part05ItemID sql.NullInt64

+ Part05ItemTypeID int64

+ Part06ItemID sql.NullInt64

+ Part06ItemTypeID int64

+ Part07ItemID sql.NullInt64

+ Part07ItemTypeID int64

+ Part08ItemID sql.NullInt64

+ Part08ItemTypeID int64

+ Part09ItemID sql.NullInt64

+ Part09ItemTypeID int64

+ Part10ItemID sql.NullInt64

+ Part10ItemTypeID int64

+ Part11ItemID sql.NullInt64

+ Part11ItemTypeID int64

+ Part12ItemID sql.NullInt64

+ Part12ItemTypeID int64

+ Part13ItemID sql.NullInt64

+ Part13ItemTypeID int64

+ Part14ItemID sql.NullInt64

+ Part14ItemTypeID int64

+ Part15ItemID sql.NullInt64

+ Part15ItemTypeID int64

+ Part16ItemID sql.NullInt64

+ Part16ItemTypeID int64

+ Part17ItemID sql.NullInt64

+ Part17ItemTypeID int64

+ Part18ItemID sql.NullInt64

+ Part18ItemTypeID int64

+ Part19ItemID sql.NullInt64

+ Part19ItemTypeID int64

+ Part20ItemID sql.NullInt64

+ Part20ItemTypeID int64

+ Part21ItemID sql.NullInt64

+ Part21ItemTypeID int64

+ Part22ItemID sql.NullInt64

+ Part22ItemTypeID int64

+ Part23ItemID sql.NullInt64

+ Part23ItemTypeID int64

+ PlayerID int64

+ Shirt int64

+ type GetCharactersByPlayerRow struct

+ AuxPart0ID sql.NullInt64

+ AuxPart1ID sql.NullInt64

+ AuxPart2ID sql.NullInt64

+ AuxPart3ID sql.NullInt64

+ AuxPart4ID sql.NullInt64

+ CharacterID int64

+ CharacterTypeID int64

+ CutInID sql.NullInt64

+ HairColor int64

+ ItemID int64

+ Mastery int64

+ Part00ItemID sql.NullInt64

+ Part00ItemTypeID int64

+ Part01ItemID sql.NullInt64

+ Part01ItemTypeID int64

+ Part02ItemID sql.NullInt64

+ Part02ItemTypeID int64

+ Part03ItemID sql.NullInt64

+ Part03ItemTypeID int64

+ Part04ItemID sql.NullInt64

+ Part04ItemTypeID int64

+ Part05ItemID sql.NullInt64

+ Part05ItemTypeID int64

+ Part06ItemID sql.NullInt64

+ Part06ItemTypeID int64

+ Part07ItemID sql.NullInt64

+ Part07ItemTypeID int64

+ Part08ItemID sql.NullInt64

+ Part08ItemTypeID int64

+ Part09ItemID sql.NullInt64

+ Part09ItemTypeID int64

+ Part10ItemID sql.NullInt64

+ Part10ItemTypeID int64

+ Part11ItemID sql.NullInt64

+ Part11ItemTypeID int64

+ Part12ItemID sql.NullInt64

+ Part12ItemTypeID int64

+ Part13ItemID sql.NullInt64

+ Part13ItemTypeID int64

+ Part14ItemID sql.NullInt64

+ Part14ItemTypeID int64

+ Part15ItemID sql.NullInt64

+ Part15ItemTypeID int64

+ Part16ItemID sql.NullInt64

+ Part16ItemTypeID int64

+ Part17ItemID sql.NullInt64

+ Part17ItemTypeID int64

+ Part18ItemID sql.NullInt64

+ Part18ItemTypeID int64

+ Part19ItemID sql.NullInt64

+ Part19ItemTypeID int64

+ Part20ItemID sql.NullInt64

+ Part20ItemTypeID int64

+ Part21ItemID sql.NullInt64

+ Part21ItemTypeID int64

+ Part22ItemID sql.NullInt64

+ Part22ItemTypeID int64

+ Part23ItemID sql.NullInt64

+ Part23ItemTypeID int64

+ PlayerID int64

+ Shirt int64

+ type GetItemParams struct

+ ItemID int64

+ PlayerID int64

+ type GetItemsByTypeIDParams struct

+ ItemTypeID int64

+ PlayerID int64

+ type GetPlayerConsumablesRow struct

+ Slot0TypeID int64

+ Slot1TypeID int64

+ Slot2TypeID int64

+ Slot3TypeID int64

+ Slot4TypeID int64

+ Slot5TypeID int64

+ Slot6TypeID int64

+ Slot7TypeID int64

+ Slot8TypeID int64

+ Slot9TypeID int64

+ type GetPlayerCurrencyRow struct

+ Pang int64

+ Points int64

+ type GetPlayerRankRow struct

+ Exp int64

+ Rank int64

+ type GetPlayerRow struct

+ AuxPart0ID sql.NullInt64

+ AuxPart1ID sql.NullInt64

+ AuxPart2ID sql.NullInt64

+ AuxPart3ID sql.NullInt64

+ AuxPart4ID sql.NullInt64

+ BackgroundID sql.NullInt64

+ BackgroundTypeID sql.NullInt64

+ BallTypeID int64

+ CaddieID sql.NullInt64

+ CaddieTypeID sql.NullInt64

+ CharacterID sql.NullInt64

+ CharacterID_2 int64

+ CharacterTypeID sql.NullInt64

+ ClubID sql.NullInt64

+ ClubTypeID sql.NullInt64

+ CutInID sql.NullInt64

+ CutInID_2 sql.NullInt64

+ CutInTypeID sql.NullInt64

+ Exp int64

+ FrameID sql.NullInt64

+ FrameTypeID sql.NullInt64

+ HairColor int64

+ ItemID int64

+ MascotTypeID int64

+ Mastery int64

+ Nickname sql.NullString

+ Pang int64

+ Part00ItemID sql.NullInt64

+ Part00ItemTypeID int64

+ Part01ItemID sql.NullInt64

+ Part01ItemTypeID int64

+ Part02ItemID sql.NullInt64

+ Part02ItemTypeID int64

+ Part03ItemID sql.NullInt64

+ Part03ItemTypeID int64

+ Part04ItemID sql.NullInt64

+ Part04ItemTypeID int64

+ Part05ItemID sql.NullInt64

+ Part05ItemTypeID int64

+ Part06ItemID sql.NullInt64

+ Part06ItemTypeID int64

+ Part07ItemID sql.NullInt64

+ Part07ItemTypeID int64

+ Part08ItemID sql.NullInt64

+ Part08ItemTypeID int64

+ Part09ItemID sql.NullInt64

+ Part09ItemTypeID int64

+ Part10ItemID sql.NullInt64

+ Part10ItemTypeID int64

+ Part11ItemID sql.NullInt64

+ Part11ItemTypeID int64

+ Part12ItemID sql.NullInt64

+ Part12ItemTypeID int64

+ Part13ItemID sql.NullInt64

+ Part13ItemTypeID int64

+ Part14ItemID sql.NullInt64

+ Part14ItemTypeID int64

+ Part15ItemID sql.NullInt64

+ Part15ItemTypeID int64

+ Part16ItemID sql.NullInt64

+ Part16ItemTypeID int64

+ Part17ItemID sql.NullInt64

+ Part17ItemTypeID int64

+ Part18ItemID sql.NullInt64

+ Part18ItemTypeID int64

+ Part19ItemID sql.NullInt64

+ Part19ItemTypeID int64

+ Part20ItemID sql.NullInt64

+ Part20ItemTypeID int64

+ Part21ItemID sql.NullInt64

+ Part21ItemTypeID int64

+ Part22ItemID sql.NullInt64

+ Part22ItemTypeID int64

+ Part23ItemID sql.NullInt64

+ Part23ItemTypeID int64

+ PasswordHash string

+ PlayerID int64

+ PlayerID_2 int64

+ Points int64

+ Poster0ID sql.NullInt64

+ Poster0TypeID sql.NullInt64

+ Poster1ID sql.NullInt64

+ Poster1TypeID sql.NullInt64

+ Rank int64

+ Shirt int64

+ Slot0TypeID int64

+ Slot1TypeID int64

+ Slot2TypeID int64

+ Slot3TypeID int64

+ Slot4TypeID int64

+ Slot5TypeID int64

+ Slot6TypeID int64

+ Slot7TypeID int64

+ Slot8TypeID int64

+ Slot9TypeID int64

+ SlotID sql.NullInt64

+ SlotTypeID sql.NullInt64

+ StickerID sql.NullInt64

+ StickerTypeID sql.NullInt64

+ TitleID sql.NullInt64

+ TitleTypeID sql.NullInt64

+ Username string

+ type Inventory struct

+ ItemID int64

+ ItemTypeID int64

+ PlayerID int64

+ Quantity sql.NullInt64

type Player

+ BackgroundID sql.NullInt64

+ BallTypeID int64

+ CaddieID sql.NullInt64

+ CharacterID sql.NullInt64

+ ClubID sql.NullInt64

+ CutInID sql.NullInt64

+ Exp int64

+ FrameID sql.NullInt64

+ MascotTypeID int64

+ Points int64

+ Poster0ID sql.NullInt64

+ Poster1ID sql.NullInt64

+ Slot0TypeID int64

+ Slot1TypeID int64

+ Slot2TypeID int64

+ Slot3TypeID int64

+ Slot4TypeID int64

+ Slot5TypeID int64

+ Slot6TypeID int64

+ Slot7TypeID int64

+ Slot8TypeID int64

+ Slot9TypeID int64

+ SlotID sql.NullInt64

+ StickerID sql.NullInt64

+ TitleID sql.NullInt64

type Queries

+ func (q *Queries) AddItemToInventory(ctx context.Context, arg AddItemToInventoryParams) (Inventory, error)

+ func (q *Queries) GetItem(ctx context.Context, arg GetItemParams) (Inventory, error)

+ func (q *Queries) GetItemsByTypeID(ctx context.Context, arg GetItemsByTypeIDParams) ([]Inventory, error)

+ func (q *Queries) GetPlayerConsumables(ctx context.Context, playerID int64) (GetPlayerConsumablesRow, error)

+ func (q *Queries) GetPlayerCurrency(ctx context.Context, playerID int64) (GetPlayerCurrencyRow, error)

+ func (q *Queries) GetPlayerInventory(ctx context.Context, playerID int64) ([]Inventory, error)

+ func (q *Queries) GetPlayerRank(ctx context.Context, playerID int64) (GetPlayerRankRow, error)

+ func (q *Queries) RemoveItemFromInventory(ctx context.Context, arg RemoveItemFromInventoryParams) error

+ func (q *Queries) SetCharacterParts(ctx context.Context, arg SetCharacterPartsParams) (Character, error)

+ func (q *Queries) SetItemQuantity(ctx context.Context, arg SetItemQuantityParams) (Inventory, error)

+ func (q *Queries) SetPlayerCaddie(ctx context.Context, arg SetPlayerCaddieParams) (Player, error)

+ func (q *Queries) SetPlayerCharacter(ctx context.Context, arg SetPlayerCharacterParams) (Player, error)

+ func (q *Queries) SetPlayerClubSet(ctx context.Context, arg SetPlayerClubSetParams) (Player, error)

+ func (q *Queries) SetPlayerComet(ctx context.Context, arg SetPlayerCometParams) (Player, error)

+ func (q *Queries) SetPlayerConsumables(ctx context.Context, arg SetPlayerConsumablesParams) (Player, error)

+ func (q *Queries) SetPlayerCurrency(ctx context.Context, arg SetPlayerCurrencyParams) (SetPlayerCurrencyRow, error)

+ func (q *Queries) SetPlayerDecoration(ctx context.Context, arg SetPlayerDecorationParams) (Player, error)

+ func (q *Queries) SetPlayerRank(ctx context.Context, arg SetPlayerRankParams) (SetPlayerRankRow, error)

+ type RemoveItemFromInventoryParams struct

+ ItemID int64

+ PlayerID int64

+ type SetCharacterPartsParams struct

+ CharacterID int64

+ CutInID sql.NullInt64

+ Part00ItemID sql.NullInt64

+ Part00ItemTypeID int64

+ Part01ItemID sql.NullInt64

+ Part01ItemTypeID int64

+ Part02ItemID sql.NullInt64

+ Part02ItemTypeID int64

+ Part03ItemID sql.NullInt64

+ Part03ItemTypeID int64

+ Part04ItemID sql.NullInt64

+ Part04ItemTypeID int64

+ Part05ItemID sql.NullInt64

+ Part05ItemTypeID int64

+ Part06ItemID sql.NullInt64

+ Part06ItemTypeID int64

+ Part07ItemID sql.NullInt64

+ Part07ItemTypeID int64

+ Part08ItemID sql.NullInt64

+ Part08ItemTypeID int64

+ Part09ItemID sql.NullInt64

+ Part09ItemTypeID int64

+ Part10ItemID sql.NullInt64

+ Part10ItemTypeID int64

+ Part11ItemID sql.NullInt64

+ Part11ItemTypeID int64

+ Part12ItemID sql.NullInt64

+ Part12ItemTypeID int64

+ Part13ItemID sql.NullInt64

+ Part13ItemTypeID int64

+ Part14ItemID sql.NullInt64

+ Part14ItemTypeID int64

+ Part15ItemID sql.NullInt64

+ Part15ItemTypeID int64

+ Part16ItemID sql.NullInt64

+ Part16ItemTypeID int64

+ Part17ItemID sql.NullInt64

+ Part17ItemTypeID int64

+ Part18ItemID sql.NullInt64

+ Part18ItemTypeID int64

+ Part19ItemID sql.NullInt64

+ Part19ItemTypeID int64

+ Part20ItemID sql.NullInt64

+ Part20ItemTypeID int64

+ Part21ItemID sql.NullInt64

+ Part21ItemTypeID int64

+ Part22ItemID sql.NullInt64

+ Part22ItemTypeID int64

+ Part23ItemID sql.NullInt64

+ Part23ItemTypeID int64

+ type SetItemQuantityParams struct

+ ItemID int64

+ PlayerID int64

+ Quantity sql.NullInt64

+ type SetPlayerCaddieParams struct

+ CaddieID sql.NullInt64

+ PlayerID int64

+ type SetPlayerCharacterParams struct

+ CharacterID sql.NullInt64

+ PlayerID int64

+ type SetPlayerClubSetParams struct

+ ClubID sql.NullInt64

+ PlayerID int64

+ type SetPlayerCometParams struct

+ BallTypeID int64

+ PlayerID int64

+ type SetPlayerConsumablesParams struct

+ PlayerID int64

+ Slot0TypeID int64

+ Slot1TypeID int64

+ Slot2TypeID int64

+ Slot3TypeID int64

+ Slot4TypeID int64

+ Slot5TypeID int64

+ Slot6TypeID int64

+ Slot7TypeID int64

+ Slot8TypeID int64

+ Slot9TypeID int64

+ type SetPlayerCurrencyParams struct

+ Pang int64

+ PlayerID int64

+ Points int64

+ type SetPlayerCurrencyRow struct

+ Pang int64

+ Points int64

+ type SetPlayerDecorationParams struct

+ BackgroundID sql.NullInt64

+ CutInID sql.NullInt64

+ FrameID sql.NullInt64

+ PlayerID int64

+ SlotID sql.NullInt64

+ StickerID sql.NullInt64

+ TitleID sql.NullInt64

+ type SetPlayerRankParams struct

+ Exp int64

+ PlayerID int64

+ Rank int64

+ type SetPlayerRankRow struct

+ Exp int64

+ Rank int64

v0.0.2

Jun 19, 2023

v0.0.1

Jun 3, 2023

Changes in this version

+ type Character struct

+ CharacterData []byte

+ CharacterID int64

+ CharacterTypeID int64

+ PlayerID int64

+ type CreateCharacterParams struct

+ CharacterData []byte

+ CharacterTypeID int64

+ PlayerID int64

+ type CreatePlayerParams struct

+ Nickname sql.NullString

+ PasswordHash string

+ Username string

+ type CreateSessionParams struct

+ PlayerID int64

+ SessionAddress string

+ SessionExpiresAt int64

+ SessionKey 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 Player struct

+ Nickname sql.NullString

+ Pang int64

+ PasswordHash string

+ PlayerID int64

+ Rank int64

+ Username string

+ type Queries struct

+ func New(db DBTX) *Queries

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+ type Session struct

+ PlayerID int64

+ SessionAddress string

+ SessionExpiresAt int64

+ SessionID int64

+ SessionKey string

+ type SetPlayerNicknameParams struct

+ Nickname sql.NullString

+ PlayerID int64

+ type UpdateSessionExpiryParams struct

+ SessionExpiresAt int64

+ SessionID int64

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