db

package
v0.0.0-...-72f23f1 Latest Latest
Warning

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

Go to latest
Published: Mar 7, 2020 License: Apache-2.0 Imports: 10 Imported by: 0

Documentation

Index

Constants

View Source
const BATCH_SIZE = 500

Variables

This section is empty.

Functions

This section is empty.

Types

type Character

type Character struct {
	ID           int64
	AccessToken  string
	RefreshToken string
	Expires      int
	Scopes       string
}

type DB

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

func InitializeDb

func InitializeDb() (*DB, error)

func NewDB

func NewDB(connection string, database string, username string, password string, tokenSecret string) (*DB, error)

func (*DB) CleanupJobLogs

func (d *DB) CleanupJobLogs(category string, characterID int64)

func (*DB) Close

func (d *DB) Close() error

func (*DB) Decrypt

func (d *DB) Decrypt(cipherText string) (string, error)

func (*DB) Encrypt

func (d *DB) Encrypt(plainText string) (string, error)

func (*DB) GetCharacters

func (d *DB) GetCharacters() ([]Character, error)

func (*DB) InsertJournalEntries

func (d *DB) InsertJournalEntries(characterID int64, entries []models.JournalEntry) (int64, error)

func (*DB) InsertLogEntry

func (d *DB) InsertLogEntry(characterID int64, category string, status string, message string, error null.String)

func (*DB) InsertSkills

func (d *DB) InsertSkills(characterID int64, skills []models.CharacterSkill) (int64, int64, error)

func (*DB) InsertWalletTransactions

func (d *DB) InsertWalletTransactions(characterID int64, transactions []models.WalletTransaction) (int64, error)

func (*DB) UpdateBlueprints

func (d *DB) UpdateBlueprints(characterID int64, blueprints []models.Blueprint) (int64, int64, error)

func (*DB) UpdateCharacterMarketOrders

func (d *DB) UpdateCharacterMarketOrders(characterID int64, orders []models.CharacterMarketOrder, history []models.CharacterMarketOrder) (int64, int64, error)

func (*DB) UpdateCharacterSP

func (d *DB) UpdateCharacterSP(characterID int64, totalSP int64) error

func (*DB) UpdateCharacterTokens

func (d *DB) UpdateCharacterTokens(accessToken string, refreshToken string, expiresIn int64, characterId int64) error

func (*DB) UpdateIndustryJobs

func (d *DB) UpdateIndustryJobs(characterID int64, jobs []models.IndustryJob) (int64, int64, error)

func (*DB) UpdateMarketOrders

func (d *DB) UpdateMarketOrders(regionID int, orders []models.MarketOrderPriceItem) (int64, int64, error)

func (*DB) UpdateSkillQueue

func (d *DB) UpdateSkillQueue(characterID int64, skillQueueItems []models.SkillQueueItem) (int64, error)

type TxFn

type TxFn func(tx *sql.Tx) error

Jump to

Keyboard shortcuts

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