db

package

Go to main page

Versions in this module

v0

v0.4.0

Apr 27, 2025

Changes in this version

+ type ConnectionParams struct

+ FirstId int

+ SecondId int

+ type NpcArea struct

+ AreaId int

+ NpcId int

+ type NpcLocation struct

+ LocationId int

+ NpcId int

+ type NpcQuest struct

+ NpcId int

+ QuestId int

+ type NpcWorld struct

+ NpcId int

+ WorldId int

type Queries

+ func (q *Queries) CreateNpcAreaConnection(ctx context.Context, params ConnectionParams) (*NpcArea, error)

+ func (q *Queries) CreateNpcLocationConnection(ctx context.Context, params ConnectionParams) (*NpcLocation, error)

+ func (q *Queries) CreateNpcQuestConnection(ctx context.Context, params ConnectionParams) (*NpcQuest, error)

+ func (q *Queries) CreateNpcWorldConnection(ctx context.Context, params ConnectionParams) (*NpcWorld, error)

+ func (q *Queries) CreateQuestAreaConnection(ctx context.Context, params ConnectionParams) (*QuestArea, error)

+ func (q *Queries) CreateQuestLocationConnection(ctx context.Context, params ConnectionParams) (*QuestLocation, error)

+ func (q *Queries) CreateQuestWorldConnection(ctx context.Context, params ConnectionParams) (*QuestWorld, error)

+ func (q *Queries) GetAreaById(ctx context.Context, id int) (*Area, error)

+ func (q *Queries) GetLocationById(ctx context.Context, id int) (*Location, error)

+ func (q *Queries) GetNpcConnectedAreas(ctx context.Context, npcId int) ([]*Area, error)

+ func (q *Queries) GetNpcConnectedLocations(ctx context.Context, npcId int) ([]*Location, error)

+ func (q *Queries) GetNpcConnectedQuests(ctx context.Context, npcId int) ([]*Quest, error)

+ func (q *Queries) GetQuestById(ctx context.Context, id int) (*Quest, error)

+ func (q *Queries) GetQuestConnectedAreas(ctx context.Context, questId int) ([]*Area, error)

+ func (q *Queries) GetQuestConnectedLocations(ctx context.Context, questId int) ([]*Location, error)

+ func (q *Queries) GetQuestConnectedNpcs(ctx context.Context, questId int) ([]*Npc, error)

+ func (q *Queries) GetWorldById(ctx context.Context, id int) (*World, error)

+ type QuestArea struct

+ AreaId int

+ QuestId int

+ type QuestLocation struct

+ LocationId int

+ QuestId int

+ type QuestWorld struct

+ QuestId int

+ WorldId int

v0.4.0-beta.3

Apr 27, 2025

v0.4.0-beta.2

Apr 27, 2025

v0.4.0-beta

Apr 27, 2025

v0.3.0

Feb 4, 2025

Changes in this version

type Queries

+ func (q *Queries) AddQuest(ctx context.Context, p *QuestParams) (*Quest, error)

+ func (q *Queries) DeleteNpcById(ctx context.Context, id int) error

+ func (q *Queries) DeleteQuestById(ctx context.Context, id int) error

+ func (q *Queries) GetAllAreas(ctx context.Context) ([]*Area, error)

+ func (q *Queries) GetAllLocations(ctx context.Context) ([]*Location, error)

+ func (q *Queries) GetNpcById(ctx context.Context, id int) (*Npc, error)

+ func (q *Queries) GetQuestByIdQuery(ctx context.Context, id int) (*Quest, error)

+ func (q *Queries) GetQuestsByName(ctx context.Context, name string) ([]*Quest, error)

+ func (q *Queries) GetXQuests(ctx context.Context, x int, offset int) ([]*Quest, error)

+ func (q *Queries) UpdateQuestById(ctx context.Context, p UpdateQuestParams) (*Quest, error)

+ type Quest struct

+ Desc string

+ Id int

+ IsFinished bool

+ IsStarted bool

+ Level int

+ Name string

+ Notes string

+ Rewards string

+ WorldId int

+ type QuestParams struct

+ Desc string

+ IsFinished bool

+ IsStarted bool

+ Level int

+ Name string

+ Notes string

+ Rewards string

+ WorldId int

+ type UpdateQuestParams struct

+ Desc string

+ Id int

+ IsFinished bool

+ IsStarted bool

+ Level int

+ Name string

+ Notes string

+ Rewards string

+ WorldId int

v0.3.0-rc2

Feb 1, 2025

v0.3.0-rc

Feb 1, 2025

v0.2.1

Jan 30, 2025

Changes in this version

type Npc

+ WorldId int

type NpcParams

+ WorldId int

type Queries

+ func (q *Queries) WorldCount(ctx context.Context) (int, error)

v0.2.0

Jan 28, 2025

v0.1.3

Jan 26, 2025

v0.1.2

Jan 25, 2025

Changes in this version

+ const AREA

+ const DEFAULT_PATH

+ const LOCATION

+ const SUBLOCATION

+ const WORLD

+ func OpenDb(cfg *config.Config) (*sql.DB, error)

+ type Area struct

+ Desc string

+ Id int

+ Name string

+ Type string

+ WorldId int

+ func (a *Area) Inspect() (int, string)

+ func (a *Area) PlaceType() PlaceType

+ type AreaParams struct

+ Desc string

+ Name string

+ Type string

+ WorldId int

+ 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 Location struct

+ AreaId int

+ Desc string

+ Id int

+ Name string

+ Type string

+ func (l *Location) Inspect() (int, string)

+ func (l *Location) PlaceType() PlaceType

+ type LocationParams struct

+ AreaId int

+ Desc string

+ Name string

+ Type string

+ type Npc struct

+ Alignment string

+ Class string

+ Description string

+ Hitpoints int

+ Id int

+ Languages string

+ Level int

+ Name string

+ Race string

+ Sex string

+ Subclass string

+ type NpcParams struct

+ Alignment string

+ Class string

+ Description string

+ Hitpoints int

+ Languages string

+ Level int

+ Name string

+ Race string

+ Sex string

+ Subclass string

+ type Place interface

+ Inspect func() (int, string)

+ PlaceType func() PlaceType

+ type PlaceType string

+ type Queries struct

+ Db DBTX

+ func New(db DBTX) *Queries

+ func (q *Queries) AddArea(ctx context.Context, params *AreaParams) (*Area, error)

+ func (q *Queries) AddLocation(ctx context.Context, params *LocationParams) (*Location, error)

+ func (q *Queries) AddNpc(ctx context.Context, params *NpcParams) (*Npc, error)

+ func (q *Queries) AddSublocation(ctx context.Context, params *SublocationParams) (*Sublocation, error)

+ func (q *Queries) AddWorld(ctx context.Context, params *WorldParams) (*World, error)

+ func (q *Queries) DeleteAreaByIdQuery(ctx context.Context, id int) error

+ func (q *Queries) DeleteLocationByIdQuery(ctx context.Context, id int) error

+ func (q *Queries) DeleteWorldByIdQuery(ctx context.Context, id int) error

+ func (q *Queries) EditNpcById(ctx context.Context, npc *Npc) (*Npc, error)

+ func (q *Queries) GetAreaByName(ctx context.Context, name string) (*Area, error)

+ func (q *Queries) GetLocationByName(ctx context.Context, name string) (*Location, error)

+ func (q *Queries) GetSublocationByName(ctx context.Context, name string) (*Sublocation, error)

+ func (q *Queries) GetWorldByName(ctx context.Context, name string) (*World, error)

+ func (q *Queries) GetXAreas(ctx context.Context, worldId int, x int, offset int) ([]*Area, error)

+ func (q *Queries) GetXLocations(ctx context.Context, x int, offset int) ([]*Location, error)

+ func (q *Queries) GetXWorlds(ctx context.Context, x int, offset int) ([]*World, error)

+ func (q *Queries) SearchAreasByName(ctx context.Context, params SearchParams) ([]*Area, error)

+ func (q *Queries) SearchLocationsByName(ctx context.Context, params SearchParams) ([]*Location, error)

+ func (q *Queries) SearchNpcsByName(ctx context.Context, name string) ([]*Npc, error)

+ func (q *Queries) SearchWorldsByName(ctx context.Context, params SearchParams) ([]*World, error)

+ func (q *Queries) UpdateAreaById(ctx context.Context, area Area) (*Area, error)

+ func (q *Queries) UpdateLocationById(ctx context.Context, location Location) (*Location, error)

+ func (q *Queries) UpdateWorldById(ctx context.Context, world World) (*World, error)

+ func (q *Queries) ViewNpcByName(ctx context.Context, name string) (*Npc, error)

+ type SearchParams struct

+ Limit int

+ Name string

+ Offset int

+ type Sublocation struct

+ Desc string

+ Id int

+ LocationId int

+ Name string

+ Type string

+ func (s *Sublocation) Inspect() (int, string)

+ func (s *Sublocation) PlaceType() PlaceType

+ type SublocationParams struct

+ Desc string

+ LocationId string

+ Name string

+ Type string

+ type World struct

+ Desc string

+ Id int

+ Name string

+ func (w *World) Inspect() (int, string)

+ func (w *World) PlaceType() PlaceType

+ type WorldParams struct

+ Desc string

+ Name string

v0.1.1

Jan 25, 2025

v0.1.0

Jan 25, 2025

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