queries

package
v0.1.1 Latest Latest
Warning

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

Go to latest
Published: May 4, 2024 License: MIT Imports: 6 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func Schema

func Schema() string

Types

type CreateEveCategoryParams

type CreateEveCategoryParams struct {
	ID          int64
	Name        string
	IsPublished bool
}

type CreateEveCharacterParams

type CreateEveCharacterParams struct {
	ID             int64
	AllianceID     sql.NullInt64
	Birthday       time.Time
	CorporationID  int64
	Description    string
	FactionID      sql.NullInt64
	Gender         string
	Name           string
	RaceID         int64
	SecurityStatus float64
	Title          string
}

type CreateEveConstellationParams

type CreateEveConstellationParams struct {
	ID          int64
	EveRegionID int64
	Name        string
}

type CreateEveEntityParams

type CreateEveEntityParams struct {
	ID       int64
	Category string
	Name     string
}

type CreateEveGroupParams

type CreateEveGroupParams struct {
	ID            int64
	EveCategoryID int64
	Name          string
	IsPublished   bool
}

type CreateEveRaceParams

type CreateEveRaceParams struct {
	ID          int64
	Description string
	Name        string
}

type CreateEveRegionParams

type CreateEveRegionParams struct {
	ID          int64
	Description string
	Name        string
}

type CreateEveSolarSystemParams

type CreateEveSolarSystemParams struct {
	ID                 int64
	EveConstellationID int64
	Name               string
	SecurityStatus     float64
}

type CreateEveTypeParams

type CreateEveTypeParams struct {
	ID          int64
	Description string
	EveGroupID  int64
	Name        string
	IsPublished bool
}

type CreateMailLabelParams

type CreateMailLabelParams struct {
	Color         string
	Name          string
	UnreadCount   int64
	MyCharacterID int64
	LabelID       int64
}

type CreateMailListParams

type CreateMailListParams struct {
	MyCharacterID int64
	EveEntityID   int64
}

type CreateMailMailLabelParams

type CreateMailMailLabelParams struct {
	MailLabelID int64
	MailID      int64
}

type CreateMailParams

type CreateMailParams struct {
	Body          string
	MyCharacterID int64
	FromID        int64
	IsRead        bool
	MailID        int64
	Subject       string
	Timestamp     time.Time
}

type CreateMailRecipientParams

type CreateMailRecipientParams struct {
	MailID      int64
	EveEntityID int64
}

type CreateMyCharacterParams

type CreateMyCharacterParams struct {
	ID            int64
	LastLoginAt   time.Time
	ShipID        int64
	SkillPoints   int64
	LocationID    int64
	WalletBalance float64
}

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 DeleteMailParams

type DeleteMailParams struct {
	MyCharacterID int64
	MailID        int64
}

type DeleteObsoleteMailLabelsParams

type DeleteObsoleteMailLabelsParams struct {
	MyCharacterID   int64
	MyCharacterID_2 int64
}

type DeleteObsoleteMailListsParams

type DeleteObsoleteMailListsParams struct {
	MyCharacterID   int64
	MyCharacterID_2 int64
	MyCharacterID_3 int64
}

type Dictionary

type Dictionary struct {
	Key   string
	Value []byte
}

type EveCategory

type EveCategory struct {
	ID          int64
	Name        string
	IsPublished bool
}

type EveCharacter

type EveCharacter struct {
	AllianceID     sql.NullInt64
	Birthday       time.Time
	CorporationID  int64
	Description    string
	Gender         string
	FactionID      sql.NullInt64
	ID             int64
	Name           string
	RaceID         int64
	SecurityStatus float64
	Title          string
}

type EveCharacterAlliance

type EveCharacterAlliance struct {
	ID       sql.NullInt64
	Category sql.NullString
	Name     sql.NullString
}

type EveCharacterFaction

type EveCharacterFaction struct {
	ID       sql.NullInt64
	Category sql.NullString
	Name     sql.NullString
}

type EveConstellation

type EveConstellation struct {
	ID          int64
	EveRegionID int64
	Name        string
}

type EveEntity

type EveEntity struct {
	ID       int64
	Category string
	Name     string
}

type EveGroup

type EveGroup struct {
	ID            int64
	EveCategoryID int64
	Name          string
	IsPublished   bool
}

type EveRace

type EveRace struct {
	ID          int64
	Description string
	Name        string
}

type EveRegion

type EveRegion struct {
	ID          int64
	Description string
	Name        string
}

type EveSolarSystem

type EveSolarSystem struct {
	ID                 int64
	EveConstellationID int64
	Name               string
	SecurityStatus     float64
}

type EveType

type EveType struct {
	ID          int64
	Description string
	EveGroupID  int64
	Name        string
	IsPublished bool
}

type GetEveCharacterRow

type GetEveCharacterRow struct {
	EveCharacter         EveCharacter
	EveEntity            EveEntity
	EveRace              EveRace
	EveCharacterAlliance EveCharacterAlliance
	EveCharacterFaction  EveCharacterFaction
}

type GetEveConstellationRow

type GetEveConstellationRow struct {
	EveConstellation EveConstellation
	EveRegion        EveRegion
}

type GetEveGroupRow

type GetEveGroupRow struct {
	EveGroup    EveGroup
	EveCategory EveCategory
}

type GetEveSolarSystemRow

type GetEveSolarSystemRow struct {
	EveSolarSystem   EveSolarSystem
	EveConstellation EveConstellation
	EveRegion        EveRegion
}

type GetEveTypeRow

type GetEveTypeRow struct {
	EveType     EveType
	EveGroup    EveGroup
	EveCategory EveCategory
}

type GetMailLabelParams

type GetMailLabelParams struct {
	MyCharacterID int64
	LabelID       int64
}

type GetMailLabelUnreadCountsRow

type GetMailLabelUnreadCountsRow struct {
	LabelID      int64
	UnreadCount2 int64
}

type GetMailListParams

type GetMailListParams struct {
	MyCharacterID int64
	EveEntityID   int64
}

type GetMailListUnreadCountsRow

type GetMailListUnreadCountsRow struct {
	ListID       int64
	UnreadCount2 int64
}

type GetMailParams

type GetMailParams struct {
	MyCharacterID int64
	MailID        int64
}

type GetMailRow

type GetMailRow struct {
	Mail      Mail
	EveEntity EveEntity
}

type GetMyCharacterRow

type GetMyCharacterRow struct {
	MyCharacter          MyCharacter
	EveCharacter         EveCharacter
	EveCategory          EveCategory
	EveGroup             EveGroup
	EveType              EveType
	EveRegion            EveRegion
	EveConstellation     EveConstellation
	EveSolarSystem       EveSolarSystem
	EveEntity            EveEntity
	EveRace              EveRace
	EveCharacterAlliance EveCharacterAlliance
	EveCharacterFaction  EveCharacterFaction
}

type ListEveEntityByNameAndCategoryParams

type ListEveEntityByNameAndCategoryParams struct {
	Name     string
	Category string
}

type ListMailIDsForLabelOrderedParams

type ListMailIDsForLabelOrderedParams struct {
	MyCharacterID int64
	LabelID       int64
}

type ListMailIDsForListOrderedParams

type ListMailIDsForListOrderedParams struct {
	MyCharacterID int64
	EveEntityID   int64
}

type ListMailLabelsByIDsParams

type ListMailLabelsByIDsParams struct {
	MyCharacterID int64
	Ids           []int64
}

type ListMyCharactersRow

type ListMyCharactersRow struct {
	ID   int64
	Name string
}

type Mail

type Mail struct {
	ID            int64
	Body          string
	MyCharacterID int64
	FromID        int64
	IsRead        bool
	MailID        int64
	Subject       string
	Timestamp     time.Time
}

type MailLabel

type MailLabel struct {
	ID            int64
	MyCharacterID int64
	Color         string
	LabelID       int64
	Name          string
	UnreadCount   int64
}

type MailList

type MailList struct {
	MyCharacterID int64
	EveEntityID   int64
}

type MailMailLabel

type MailMailLabel struct {
	MailLabelID int64
	MailID      int64
}

type MailRecipient

type MailRecipient struct {
	MailID      int64
	EveEntityID int64
}

type MyCharacter

type MyCharacter struct {
	ID            int64
	LastLoginAt   time.Time
	LocationID    int64
	ShipID        int64
	SkillPoints   int64
	WalletBalance float64
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateEveCategory

func (q *Queries) CreateEveCategory(ctx context.Context, arg CreateEveCategoryParams) (EveCategory, error)

func (*Queries) CreateEveCharacter

func (q *Queries) CreateEveCharacter(ctx context.Context, arg CreateEveCharacterParams) error

func (*Queries) CreateEveConstellation

func (q *Queries) CreateEveConstellation(ctx context.Context, arg CreateEveConstellationParams) error

func (*Queries) CreateEveEntity

func (q *Queries) CreateEveEntity(ctx context.Context, arg CreateEveEntityParams) (EveEntity, error)

func (*Queries) CreateEveGroup

func (q *Queries) CreateEveGroup(ctx context.Context, arg CreateEveGroupParams) error

func (*Queries) CreateEveRace

func (q *Queries) CreateEveRace(ctx context.Context, arg CreateEveRaceParams) (EveRace, error)

func (*Queries) CreateEveRegion

func (q *Queries) CreateEveRegion(ctx context.Context, arg CreateEveRegionParams) (EveRegion, error)

func (*Queries) CreateEveSolarSystem

func (q *Queries) CreateEveSolarSystem(ctx context.Context, arg CreateEveSolarSystemParams) error

func (*Queries) CreateEveType

func (q *Queries) CreateEveType(ctx context.Context, arg CreateEveTypeParams) error

func (*Queries) CreateMail

func (q *Queries) CreateMail(ctx context.Context, arg CreateMailParams) (Mail, error)

func (*Queries) CreateMailLabel

func (q *Queries) CreateMailLabel(ctx context.Context, arg CreateMailLabelParams) (MailLabel, error)

func (*Queries) CreateMailList

func (q *Queries) CreateMailList(ctx context.Context, arg CreateMailListParams) error

func (*Queries) CreateMailMailLabel

func (q *Queries) CreateMailMailLabel(ctx context.Context, arg CreateMailMailLabelParams) error

func (*Queries) CreateMailRecipient

func (q *Queries) CreateMailRecipient(ctx context.Context, arg CreateMailRecipientParams) error

func (*Queries) CreateMyCharacter

func (q *Queries) CreateMyCharacter(ctx context.Context, arg CreateMyCharacterParams) (MyCharacter, error)

func (*Queries) DeleteDictEntry

func (q *Queries) DeleteDictEntry(ctx context.Context, key string) error

func (*Queries) DeleteEveCharacter

func (q *Queries) DeleteEveCharacter(ctx context.Context, id int64) error

func (*Queries) DeleteMail

func (q *Queries) DeleteMail(ctx context.Context, arg DeleteMailParams) error

func (*Queries) DeleteMailMailLabels

func (q *Queries) DeleteMailMailLabels(ctx context.Context, mailID int64) error

func (*Queries) DeleteMyCharacter

func (q *Queries) DeleteMyCharacter(ctx context.Context, id int64) error

func (*Queries) DeleteObsoleteMailLabels

func (q *Queries) DeleteObsoleteMailLabels(ctx context.Context, arg DeleteObsoleteMailLabelsParams) error

func (*Queries) DeleteObsoleteMailLists

func (q *Queries) DeleteObsoleteMailLists(ctx context.Context, arg DeleteObsoleteMailListsParams) error

func (*Queries) GetDictEntry

func (q *Queries) GetDictEntry(ctx context.Context, key string) (Dictionary, error)

func (*Queries) GetEveCategory

func (q *Queries) GetEveCategory(ctx context.Context, id int64) (EveCategory, error)

func (*Queries) GetEveCharacter

func (q *Queries) GetEveCharacter(ctx context.Context, id int64) (GetEveCharacterRow, error)

func (*Queries) GetEveConstellation

func (q *Queries) GetEveConstellation(ctx context.Context, id int64) (GetEveConstellationRow, error)

func (*Queries) GetEveEntity

func (q *Queries) GetEveEntity(ctx context.Context, id int64) (EveEntity, error)

func (*Queries) GetEveGroup

func (q *Queries) GetEveGroup(ctx context.Context, id int64) (GetEveGroupRow, error)

func (*Queries) GetEveRace

func (q *Queries) GetEveRace(ctx context.Context, id int64) (EveRace, error)

func (*Queries) GetEveRegion

func (q *Queries) GetEveRegion(ctx context.Context, id int64) (EveRegion, error)

func (*Queries) GetEveSolarSystem

func (q *Queries) GetEveSolarSystem(ctx context.Context, id int64) (GetEveSolarSystemRow, error)

func (*Queries) GetEveType

func (q *Queries) GetEveType(ctx context.Context, id int64) (GetEveTypeRow, error)

func (*Queries) GetMail

func (q *Queries) GetMail(ctx context.Context, arg GetMailParams) (GetMailRow, error)

func (*Queries) GetMailLabel

func (q *Queries) GetMailLabel(ctx context.Context, arg GetMailLabelParams) (MailLabel, error)

func (*Queries) GetMailLabelUnreadCounts

func (q *Queries) GetMailLabelUnreadCounts(ctx context.Context, myCharacterID int64) ([]GetMailLabelUnreadCountsRow, error)

func (*Queries) GetMailLabels

func (q *Queries) GetMailLabels(ctx context.Context, mailID int64) ([]MailLabel, error)

func (*Queries) GetMailList

func (q *Queries) GetMailList(ctx context.Context, arg GetMailListParams) (MailList, error)

func (*Queries) GetMailListUnreadCounts

func (q *Queries) GetMailListUnreadCounts(ctx context.Context, myCharacterID int64) ([]GetMailListUnreadCountsRow, error)

func (*Queries) GetMailRecipients

func (q *Queries) GetMailRecipients(ctx context.Context, mailID int64) ([]EveEntity, error)

func (*Queries) GetMailUnreadCount

func (q *Queries) GetMailUnreadCount(ctx context.Context, myCharacterID int64) (int64, error)

func (*Queries) GetMyCharacter

func (q *Queries) GetMyCharacter(ctx context.Context, id int64) (GetMyCharacterRow, error)

func (*Queries) GetToken

func (q *Queries) GetToken(ctx context.Context, myCharacterID int64) (Token, error)

func (*Queries) ListEveCharacterIDs

func (q *Queries) ListEveCharacterIDs(ctx context.Context) ([]int64, error)

func (*Queries) ListEveEntitiesByName

func (q *Queries) ListEveEntitiesByName(ctx context.Context, name string) ([]EveEntity, error)

func (*Queries) ListEveEntitiesByPartialName

func (q *Queries) ListEveEntitiesByPartialName(ctx context.Context, name string) ([]EveEntity, error)

func (*Queries) ListEveEntityByNameAndCategory

func (q *Queries) ListEveEntityByNameAndCategory(ctx context.Context, arg ListEveEntityByNameAndCategoryParams) ([]EveEntity, error)

func (*Queries) ListEveEntityIDs

func (q *Queries) ListEveEntityIDs(ctx context.Context) ([]int64, error)

func (*Queries) ListEveRaceIDs

func (q *Queries) ListEveRaceIDs(ctx context.Context) ([]int64, error)

func (*Queries) ListMailIDs

func (q *Queries) ListMailIDs(ctx context.Context, myCharacterID int64) ([]int64, error)

func (*Queries) ListMailIDsForLabelOrdered

func (q *Queries) ListMailIDsForLabelOrdered(ctx context.Context, arg ListMailIDsForLabelOrderedParams) ([]int64, error)

func (*Queries) ListMailIDsForListOrdered

func (q *Queries) ListMailIDsForListOrdered(ctx context.Context, arg ListMailIDsForListOrderedParams) ([]int64, error)

func (*Queries) ListMailIDsNoLabelOrdered

func (q *Queries) ListMailIDsNoLabelOrdered(ctx context.Context, myCharacterID int64) ([]int64, error)

func (*Queries) ListMailIDsOrdered

func (q *Queries) ListMailIDsOrdered(ctx context.Context, myCharacterID int64) ([]int64, error)

func (*Queries) ListMailLabelsByIDs

func (q *Queries) ListMailLabelsByIDs(ctx context.Context, arg ListMailLabelsByIDsParams) ([]MailLabel, error)

func (*Queries) ListMailLabelsOrdered

func (q *Queries) ListMailLabelsOrdered(ctx context.Context, myCharacterID int64) ([]MailLabel, error)

func (*Queries) ListMailListsOrdered

func (q *Queries) ListMailListsOrdered(ctx context.Context, myCharacterID int64) ([]EveEntity, error)

func (*Queries) ListMyCharacterIDs

func (q *Queries) ListMyCharacterIDs(ctx context.Context) ([]int64, error)

func (*Queries) ListMyCharacters

func (q *Queries) ListMyCharacters(ctx context.Context) ([]ListMyCharactersRow, error)

func (*Queries) UpdateEveCharacter

func (q *Queries) UpdateEveCharacter(ctx context.Context, arg UpdateEveCharacterParams) error

func (*Queries) UpdateMail

func (q *Queries) UpdateMail(ctx context.Context, arg UpdateMailParams) error

func (*Queries) UpdateMyCharacter

func (q *Queries) UpdateMyCharacter(ctx context.Context, arg UpdateMyCharacterParams) error

func (*Queries) UpdateOrCreateDictEntry

func (q *Queries) UpdateOrCreateDictEntry(ctx context.Context, arg UpdateOrCreateDictEntryParams) error

func (*Queries) UpdateOrCreateEveEntity

func (q *Queries) UpdateOrCreateEveEntity(ctx context.Context, arg UpdateOrCreateEveEntityParams) (EveEntity, error)

func (*Queries) UpdateOrCreateMailLabel

func (q *Queries) UpdateOrCreateMailLabel(ctx context.Context, arg UpdateOrCreateMailLabelParams) (MailLabel, error)

func (*Queries) UpdateOrCreateMyCharacter

func (q *Queries) UpdateOrCreateMyCharacter(ctx context.Context, arg UpdateOrCreateMyCharacterParams) (MyCharacter, error)

func (*Queries) UpdateOrCreateToken

func (q *Queries) UpdateOrCreateToken(ctx context.Context, arg UpdateOrCreateTokenParams) error

func (*Queries) WithTx

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

type Token

type Token struct {
	AccessToken   string
	MyCharacterID int64
	ExpiresAt     time.Time
	RefreshToken  string
	TokenType     string
}

type UpdateEveCharacterParams

type UpdateEveCharacterParams struct {
	AllianceID     sql.NullInt64
	CorporationID  int64
	Description    string
	FactionID      sql.NullInt64
	Name           string
	SecurityStatus float64
	Title          string
	ID             int64
}

type UpdateMailParams

type UpdateMailParams struct {
	ID     int64
	IsRead bool
}

type UpdateMyCharacterParams

type UpdateMyCharacterParams struct {
	LastLoginAt   time.Time
	ShipID        int64
	SkillPoints   int64
	LocationID    int64
	WalletBalance float64
	ID            int64
}

type UpdateOrCreateDictEntryParams

type UpdateOrCreateDictEntryParams struct {
	Key   string
	Value []byte
}

type UpdateOrCreateEveEntityParams

type UpdateOrCreateEveEntityParams struct {
	ID       int64
	Category string
	Name     string
}

type UpdateOrCreateMailLabelParams

type UpdateOrCreateMailLabelParams struct {
	MyCharacterID int64
	LabelID       int64
	Color         string
	Name          string
	UnreadCount   int64
}

type UpdateOrCreateMyCharacterParams

type UpdateOrCreateMyCharacterParams struct {
	ID            int64
	LastLoginAt   time.Time
	ShipID        int64
	SkillPoints   int64
	LocationID    int64
	WalletBalance float64
}

type UpdateOrCreateTokenParams

type UpdateOrCreateTokenParams struct {
	MyCharacterID int64
	AccessToken   string
	ExpiresAt     time.Time
	RefreshToken  string
	TokenType     string
}

Jump to

Keyboard shortcuts

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