retropg

README

retropg

retropg is a PostgreSQL database implementation of the retro.Storer interface.

Requirements

• Git
• Go

Installation

go get -d -u -v https://github.com/kralamoure/retropg

Documentation

Overview

Package retropg is a PostgreSQL database implementation of the retro.Storer interface (https://github.com/kralamoure/retro).

Index

• type Db
  • func NewDb(pool *pgxpool.Pool) (*Db, error)
  • func (r *Db) AllCharacters(ctx context.Context) (map[int]retro.Character, error)
  • func (r *Db) AllCharactersByAccountId(ctx context.Context, accountId string) (map[int]retro.Character, error)
  • func (r *Db) Character(ctx context.Context, id int) (retro.Character, error)
  • func (r *Db) CharacterItem(ctx context.Context, id int) (retro.CharacterItem, error)
  • func (r *Db) CharacterItemsByCharacterId(ctx context.Context, characterId int) (items map[int]retro.CharacterItem, err error)
  • func (r *Db) Characters(ctx context.Context, gameServerId int) (map[int]retro.Character, error)
  • func (r *Db) CharactersByAccountId(ctx context.Context, gameServerId int, accountId string) (map[int]retro.Character, error)
  • func (r *Db) CharactersByGameMapId(ctx context.Context, gameServerId int, gameMapId int) (map[int]retro.Character, error)
  • func (r *Db) Classes(ctx context.Context) (classes map[retrotyp.ClassId]retro.Class, err error)
  • func (r *Db) CreateCharacter(ctx context.Context, character retro.Character) (id int, err error)
  • func (r *Db) CreateCharacterItem(ctx context.Context, item retro.CharacterItem) (id int, err error)
  • func (r *Db) CreateGameServer(ctx context.Context, gameServer retro.GameServer) error
  • func (r *Db) CreateMarketItem(ctx context.Context, item retro.MarketItem) (id int, err error)
  • func (r *Db) CreateMount(ctx context.Context, mount retro.Mount) (id int, err error)
  • func (r *Db) CreateTicket(ctx context.Context, ticket retro.Ticket) (id string, err error)
  • func (r *Db) DeleteCharacter(ctx context.Context, id int) error
  • func (r *Db) DeleteCharacterItem(ctx context.Context, id int) error
  • func (r *Db) DeleteMarketItem(ctx context.Context, id int) error
  • func (r *Db) DeleteMount(ctx context.Context, id int) error
  • func (r *Db) DeleteTickets(ctx context.Context, before time.Time) (count int, err error)
  • func (r *Db) EffectTemplates(ctx context.Context) (templates map[int]retro.EffectTemplate, err error)
  • func (r *Db) GameMaps(ctx context.Context) (gameMaps map[int]retro.GameMap, err error)
  • func (r *Db) GameServer(ctx context.Context, id int) (gameServer retro.GameServer, err error)
  • func (r *Db) GameServers(ctx context.Context) (gameServers map[int]retro.GameServer, err error)
  • func (r *Db) ItemSets(ctx context.Context) (itemSets map[int]retro.ItemSet, err error)
  • func (r *Db) ItemTemplates(ctx context.Context) (templates map[int]retro.ItemTemplate, err error)
  • func (r *Db) MarketItem(ctx context.Context, id int) (item retro.MarketItem, err error)
  • func (r *Db) MarketItems(ctx context.Context, gameServerId int) (items map[int]retro.MarketItem, err error)
  • func (r *Db) MarketItemsByMarketId(ctx context.Context, marketId string) (items map[int]retro.MarketItem, err error)
  • func (r *Db) Markets(ctx context.Context, gameServerId int) (markets map[string]retro.Market, err error)
  • func (r *Db) Mount(ctx context.Context, id int) (retro.Mount, error)
  • func (r *Db) MountTemplates(ctx context.Context) (map[int]retro.MountTemplate, error)
  • func (r *Db) Mounts(ctx context.Context) (items map[int]retro.Mount, err error)
  • func (r *Db) MountsByCharacterId(ctx context.Context, characterId int) (items map[int]retro.Mount, err error)
  • func (r *Db) NPCDialogs(ctx context.Context) (dialogs map[int]retro.NPCDialog, err error)
  • func (r *Db) NPCResponses(ctx context.Context) (responses map[int]retro.NPCResponse, err error)
  • func (r *Db) NPCTemplates(ctx context.Context) (templates map[int]retro.NPCTemplate, err error)
  • func (r *Db) NPCs(ctx context.Context, gameServerId int) (npcs map[string]retro.NPC, err error)
  • func (r *Db) SetGameServerState(ctx context.Context, id int, state retrotyp.GameServerState) error
  • func (r *Db) Spells(ctx context.Context) (spells map[int]retro.Spell, err error)
  • func (r *Db) Ticket(ctx context.Context, id string) (ticket retro.Ticket, err error)
  • func (r *Db) Tickets(ctx context.Context) (tickets map[string]retro.Ticket, err error)
  • func (r *Db) TriggerByGameMapIdAndCellId(ctx context.Context, gameMapId, cellId int) (retro.Trigger, error)
  • func (r *Db) Triggers(ctx context.Context) (map[string]retro.Trigger, error)
  • func (r *Db) UpdateCharacter(ctx context.Context, character retro.Character) error
  • func (r *Db) UpdateCharacterItem(ctx context.Context, item retro.CharacterItem) error
  • func (r *Db) UpdateMount(ctx context.Context, mount retro.Mount) error
  • func (r *Db) UseTicket(ctx context.Context, id string) (ticket retro.Ticket, err error)

Types

type Db

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

func NewDb

func NewDb(pool *pgxpool.Pool) (*Db, error)

func (*Db) AllCharacters

func (r *Db) AllCharacters(ctx context.Context) (map[int]retro.Character, error)

func (*Db) AllCharactersByAccountId

func (r *Db) AllCharactersByAccountId(ctx context.Context, accountId string) (map[int]retro.Character, error)

func (*Db) Character

func (r *Db) Character(ctx context.Context, id int) (retro.Character, error)

func (*Db) CharacterItem

func (r *Db) CharacterItem(ctx context.Context, id int) (retro.CharacterItem, error)

func (*Db) CharacterItemsByCharacterId

func (r *Db) CharacterItemsByCharacterId(ctx context.Context, characterId int) (items map[int]retro.CharacterItem, err error)

func (*Db) Characters

func (r *Db) Characters(ctx context.Context, gameServerId int) (map[int]retro.Character, error)

func (*Db) CharactersByAccountId

func (r *Db) CharactersByAccountId(ctx context.Context, gameServerId int, accountId string) (map[int]retro.Character, error)

func (*Db) CharactersByGameMapId

func (r *Db) CharactersByGameMapId(ctx context.Context, gameServerId int, gameMapId int) (map[int]retro.Character, error)

func (*Db) Classes

func (r *Db) Classes(ctx context.Context) (classes map[retrotyp.ClassId]retro.Class, err error)

func (*Db) CreateCharacter

func (r *Db) CreateCharacter(ctx context.Context, character retro.Character) (id int, err error)

func (*Db) CreateCharacterItem

func (r *Db) CreateCharacterItem(ctx context.Context, item retro.CharacterItem) (id int, err error)

func (*Db) CreateGameServer

func (r *Db) CreateGameServer(ctx context.Context, gameServer retro.GameServer) error

func (*Db) CreateMarketItem

func (r *Db) CreateMarketItem(ctx context.Context, item retro.MarketItem) (id int, err error)

func (*Db) CreateMount

func (r *Db) CreateMount(ctx context.Context, mount retro.Mount) (id int, err error)

func (*Db) CreateTicket

func (r *Db) CreateTicket(ctx context.Context, ticket retro.Ticket) (id string, err error)

func (*Db) DeleteCharacter

func (r *Db) DeleteCharacter(ctx context.Context, id int) error

func (*Db) DeleteCharacterItem

func (r *Db) DeleteCharacterItem(ctx context.Context, id int) error

func (*Db) DeleteMarketItem

func (r *Db) DeleteMarketItem(ctx context.Context, id int) error

func (*Db) DeleteMount

func (r *Db) DeleteMount(ctx context.Context, id int) error

func (*Db) DeleteTickets

func (r *Db) DeleteTickets(ctx context.Context, before time.Time) (count int, err error)

func (*Db) EffectTemplates

func (r *Db) EffectTemplates(ctx context.Context) (templates map[int]retro.EffectTemplate, err error)

func (*Db) GameMaps

func (r *Db) GameMaps(ctx context.Context) (gameMaps map[int]retro.GameMap, err error)

func (*Db) GameServer

func (r *Db) GameServer(ctx context.Context, id int) (gameServer retro.GameServer, err error)

func (*Db) GameServers

func (r *Db) GameServers(ctx context.Context) (gameServers map[int]retro.GameServer, err error)

func (*Db) ItemSets

func (r *Db) ItemSets(ctx context.Context) (itemSets map[int]retro.ItemSet, err error)

func (*Db) ItemTemplates

func (r *Db) ItemTemplates(ctx context.Context) (templates map[int]retro.ItemTemplate, err error)

func (*Db) MarketItem

func (r *Db) MarketItem(ctx context.Context, id int) (item retro.MarketItem, err error)

func (*Db) MarketItems

func (r *Db) MarketItems(ctx context.Context, gameServerId int) (items map[int]retro.MarketItem, err error)

func (*Db) MarketItemsByMarketId

func (r *Db) MarketItemsByMarketId(ctx context.Context, marketId string) (items map[int]retro.MarketItem, err error)

func (*Db) Markets

func (r *Db) Markets(ctx context.Context, gameServerId int) (markets map[string]retro.Market, err error)

func (*Db) Mount

func (r *Db) Mount(ctx context.Context, id int) (retro.Mount, error)

func (*Db) MountTemplates

func (r *Db) MountTemplates(ctx context.Context) (map[int]retro.MountTemplate, error)

func (*Db) Mounts

func (r *Db) Mounts(ctx context.Context) (items map[int]retro.Mount, err error)

func (*Db) MountsByCharacterId

func (r *Db) MountsByCharacterId(ctx context.Context, characterId int) (items map[int]retro.Mount, err error)

func (*Db) NPCDialogs

func (r *Db) NPCDialogs(ctx context.Context) (dialogs map[int]retro.NPCDialog, err error)

func (*Db) NPCResponses

func (r *Db) NPCResponses(ctx context.Context) (responses map[int]retro.NPCResponse, err error)

func (*Db) NPCTemplates

func (r *Db) NPCTemplates(ctx context.Context) (templates map[int]retro.NPCTemplate, err error)

func (*Db) NPCs

func (r *Db) NPCs(ctx context.Context, gameServerId int) (npcs map[string]retro.NPC, err error)

func (*Db) SetGameServerState

func (r *Db) SetGameServerState(ctx context.Context, id int, state retrotyp.GameServerState) error

func (*Db) Spells

func (r *Db) Spells(ctx context.Context) (spells map[int]retro.Spell, err error)

func (*Db) Ticket

func (r *Db) Ticket(ctx context.Context, id string) (ticket retro.Ticket, err error)

func (*Db) Tickets

func (r *Db) Tickets(ctx context.Context) (tickets map[string]retro.Ticket, err error)

func (*Db) TriggerByGameMapIdAndCellId

func (r *Db) TriggerByGameMapIdAndCellId(ctx context.Context, gameMapId, cellId int) (retro.Trigger, error)

func (*Db) Triggers

func (r *Db) Triggers(ctx context.Context) (map[string]retro.Trigger, error)

func (*Db) UpdateCharacter

func (r *Db) UpdateCharacter(ctx context.Context, character retro.Character) error

func (*Db) UpdateCharacterItem

func (r *Db) UpdateCharacterItem(ctx context.Context, item retro.CharacterItem) error

func (*Db) UpdateMount

func (r *Db) UpdateMount(ctx context.Context, mount retro.Mount) error

func (*Db) UseTicket

func (r *Db) UseTicket(ctx context.Context, id string) (ticket retro.Ticket, err error)