mysql

Documentation

Index

• type Mysql
  • func (b *Mysql) Close() error
  • func (b *Mysql) ItemByID(ctx context.Context, id int32) (*model.Item, error)
  • func (b *Mysql) ItemDiscoveredOnlyByID(ctx context.Context, itemID uint32) (*model.Item, error)
  • func (b *Mysql) ItemRecipeAll(ctx context.Context) ([]*model.ItemRecipe, error)
  • func (b *Mysql) ItemSearchByName(ctx context.Context, name string) ([]*model.ItemSearch, error)
  • func (b *Mysql) ItemsAll(ctx context.Context) ([]*model.Item, error)
  • func (b *Mysql) NpcByNpcID(ctx context.Context, npcID int64) (*model.Npc, error)
  • func (b *Mysql) NpcFactionsByFactionID(ctx context.Context, factionID int64) (*model.NpcFaction, error)
  • func (b *Mysql) NpcLootByLootTableID(ctx context.Context, lootTableID int64) (*model.NpcLoot, error)
  • func (b *Mysql) NpcMerchantByNpcID(ctx context.Context, npcID int64) (*model.NpcMerchant, error)
  • func (b *Mysql) NpcSearchByName(ctx context.Context, name string) ([]*model.Npc, error)
  • func (b *Mysql) NpcSpawnByNpcID(ctx context.Context, npcID int64) (*model.NpcSpawn, error)
  • func (b *Mysql) NpcSpellsByNpcSpellsID(ctx context.Context, npcSpellID int64) (*model.NpcSpell, error)
  • func (b *Mysql) NpcsAll(ctx context.Context) ([]*model.Npc, error)
  • func (b *Mysql) Open(conn string) (*sqlx.DB, error)
  • func (b *Mysql) Ping() error
  • func (b *Mysql) PlayerByCharacterID(ctx context.Context, characterID int64) (*model.Player, error)
  • func (b *Mysql) SpellByID(ctx context.Context, spellID int64) (*model.Spell, error)
  • func (b *Mysql) SpellSearchByName(ctx context.Context, name string) ([]*model.Spell, error)
  • func (b *Mysql) SpellsAll(ctx context.Context) ([]*model.Spell, error)
  • func (b *Mysql) ZoneByShortName(ctx context.Context, shortName string) (*model.Zone, error)
  • func (b *Mysql) ZoneByZoneIDNumber(ctx context.Context, zoneID int64) (*model.Zone, error)
  • func (b *Mysql) ZoneSearchByName(ctx context.Context, name string) ([]*model.ZoneSearch, error)
  • func (b *Mysql) ZonesAll(ctx context.Context) ([]*model.Zone, error)

Types

type Mysql

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

Mysql is a mysql database

func (*Mysql) Close

func (b *Mysql) Close() error

Close should be called when done with the database

func (*Mysql) ItemByID

func (b *Mysql) ItemByID(ctx context.Context, id int32) (*model.Item, error)

func (*Mysql) ItemDiscoveredOnlyByID

func (b *Mysql) ItemDiscoveredOnlyByID(ctx context.Context, itemID uint32) (*model.Item, error)

func (*Mysql) ItemRecipeAll

func (b *Mysql) ItemRecipeAll(ctx context.Context) ([]*model.ItemRecipe, error)

func (*Mysql) ItemSearchByName

func (b *Mysql) ItemSearchByName(ctx context.Context, name string) ([]*model.ItemSearch, error)

func (*Mysql) ItemsAll

func (b *Mysql) ItemsAll(ctx context.Context) ([]*model.Item, error)

func (*Mysql) NpcByNpcID

func (b *Mysql) NpcByNpcID(ctx context.Context, npcID int64) (*model.Npc, error)

func (*Mysql) NpcFactionsByFactionID

func (b *Mysql) NpcFactionsByFactionID(ctx context.Context, factionID int64) (*model.NpcFaction, error)

func (*Mysql) NpcLootByLootTableID

func (b *Mysql) NpcLootByLootTableID(ctx context.Context, lootTableID int64) (*model.NpcLoot, error)

func (*Mysql) NpcMerchantByNpcID

func (b *Mysql) NpcMerchantByNpcID(ctx context.Context, npcID int64) (*model.NpcMerchant, error)

func (*Mysql) NpcSearchByName

func (b *Mysql) NpcSearchByName(ctx context.Context, name string) ([]*model.Npc, error)

func (*Mysql) NpcSpawnByNpcID

func (b *Mysql) NpcSpawnByNpcID(ctx context.Context, npcID int64) (*model.NpcSpawn, error)

func (*Mysql) NpcSpellsByNpcSpellsID

func (b *Mysql) NpcSpellsByNpcSpellsID(ctx context.Context, npcSpellID int64) (*model.NpcSpell, error)

func (*Mysql) NpcsAll

func (b *Mysql) NpcsAll(ctx context.Context) ([]*model.Npc, error)

func (*Mysql) Open

func (b *Mysql) Open(conn string) (*sqlx.DB, error)

Open should rarely be used, if you must be sure to close the database

func (*Mysql) Ping

func (b *Mysql) Ping() error

func (*Mysql) PlayerByCharacterID

func (b *Mysql) PlayerByCharacterID(ctx context.Context, characterID int64) (*model.Player, error)

func (*Mysql) SpellByID

func (b *Mysql) SpellByID(ctx context.Context, spellID int64) (*model.Spell, error)

func (*Mysql) SpellSearchByName

func (b *Mysql) SpellSearchByName(ctx context.Context, name string) ([]*model.Spell, error)

func (*Mysql) SpellsAll

func (b *Mysql) SpellsAll(ctx context.Context) ([]*model.Spell, error)

func (*Mysql) ZoneByShortName

func (b *Mysql) ZoneByShortName(ctx context.Context, shortName string) (*model.Zone, error)

func (*Mysql) ZoneByZoneIDNumber

func (b *Mysql) ZoneByZoneIDNumber(ctx context.Context, zoneID int64) (*model.Zone, error)

func (*Mysql) ZoneSearchByName

func (b *Mysql) ZoneSearchByName(ctx context.Context, name string) ([]*model.ZoneSearch, error)

func (*Mysql) ZonesAll

func (b *Mysql) ZonesAll(ctx context.Context) ([]*model.Zone, error)