mysql

Documentation

Index

• Constants
• func BuildFilters(s sq.SelectBuilder, operators ...*skillz.Operator) sq.SelectBuilder
• func BuildOperators(operators ...*skillz.Operator) *builder.Builder
• func NewAllianceRepository(db QueryExecContext) skillz.AllianceRepository
• func NewCharacterRepository(db QueryExecContext) skillz.CharacterRepository
• func NewCloneRepository(db QueryExecContext) skillz.CloneRepository
• func NewContactRepository(db QueryExecContext) skillz.ContactRepository
• func NewCorporationRepository(db QueryExecContext) skillz.CorporationRepository
• func NewETagRepository(db QueryExecContext) skillz.EtagRepository
• func NewQueryLogger(execer QueryExecContext, logger *logrus.Logger) *queryLogger
• func NewSkillRepository(db QueryExecContext) skillz.CharacterSkillRepository
• func NewUniverseRepository(db QueryExecContext) skillz.UniverseRepository
• func NewUserRepository(db QueryExecContext) skillz.UserRepository
• func OnDuplicateKeyStmt(columns ...string) string
• type QueryExecContext

Constants

const (
	AllianceID                    string = "id"
	AllianceName                  string = "name"
	AllianceTicker                string = "ticker"
	AllianceDateFounded           string = "date_founded"
	AllianceCreatorID             string = "creator_id"
	AllianceCreatorCorporationID  string = "creator_corporation_id"
	AllianceExecutorCorporationID string = "executor_corporation_id"
	AllianceIsClosed              string = "is_closed"
)

const (
	CharacterID             string = "id"
	CharacterName           string = "name"
	CharacterCorporationID  string = "corporation_id"
	CharacterAllianceID     string = "alliance_id"
	CharacterFactionID      string = "faction_id"
	CharacterSecurityStatus string = "security_status"
	CharacterGender         string = "gender"
	CharacterBirthday       string = "birthday"
	CharacterTitle          string = "title"
	CharacterBloodlineID    string = "bloodline_id"
	CharacterRaceID         string = "race_id"

	HistoryRecordID      string = "record_id"
	HistoryCorporationID string = "corporation_id"
	HistoryIsDeleted     string = "is_deleted"
	HistoryStartDate     string = "start_date"
)

const (
	MetaLastCloneJumpDate     string = "last_clone_jump_date"
	MetaLastStationChangeDate string = "last_station_change_date"

	DeathLocationID   string = "location_id"
	DeathLocationType string = "location_type"

	JumpJumpCloneID  string = "jump_clone_id"
	JumpLocationID   string = "location_id"
	JumpLocationType string = "location_type"
	JumpImplantIDs   string = "implant_ids"

	ImplantsImplantID string = "implant_id"
)

const (
	ColumnCharacterID string = "character_id"
	ColumnCreatedAt   string = "created_at"
	ColumnUpdatedAt   string = "updated_at"
)

const (
	TableAlliances                   string = "alliances"
	TableBloodlines                  string = "bloodlines"
	TableCharacters                  string = "characters"
	TableCharacterAttributes         string = "character_attributes"
	TableCharacterCloneMeta          string = "character_clone_meta"
	TableCharacterContacts           string = "character_contacts"
	TableCharacterCorporationHistory string = "character_corporation_history"
	TableCharacterFlyableShips       string = "character_flyable_ships"
	TableCharacterHomeClone          string = "character_home_clone"
	TableCharacterImplants           string = "character_implants"
	TableCharacterJumpClones         string = "character_jump_clones"
	TableCharacterSkillQueue         string = "character_skillqueue"
	TableCharacterSkills             string = "character_skills"
	TableCharacterSkillMeta          string = "character_skill_meta"
	TableCorporations                string = "corporations"
	TableCorporationAllianceHistory  string = "corporation_alliance_history"
	TableEtags                       string = "etags"
	TableFactions                    string = "factions"
	TableMapConstellations           string = "map_constellations"
	TableMapRegions                  string = "map_regions"
	TableMapSolarSystems             string = "map_solar_systems"
	TableMapStations                 string = "map_stations"
	TableStructures                  string = "map_structures"
	TableRaces                       string = "races"
	TableTypes                       string = "types"
	TableTypeAttributes              string = "type_attributes"
	TableTypeCategories              string = "type_categories"
	TableTypeGroups                  string = "type_groups"
	TableUsers                       string = "users"
	TableUserSettings                string = "user_settings_new"
)

const (
	ContactContactID   string = "contact_id"
	ContactContactType string = "contact_type"
	ContactStanding    string = "standing"
)

const (
	CorporationID            string = "id"
	CorporationAllianceID    string = "alliance_id"
	CorporationCeoID         string = "ceo_id"
	CorporationCreatorID     string = "creator_id"
	CorporationDateFounded   string = "date_founded"
	CorporationFactionID     string = "faction_id"
	CorporationHomeStationID string = "home_station_id"
	CorporationMemberCount   string = "member_count"
	CorporationName          string = "name"
	CorporationShares        string = "shares"
	CorporationTaxRate       string = "tax_rate"
	CorporationTicker        string = "ticker"
	CorporationURL           string = "url"
	CorporationWarEligible   string = "war_eligible"

	AllianceHistoryCorporationID string = "corporation_id"
	AllianceHistoryRecordID      string = "record_id"
	AllianceHistoryAllianceID    string = "alliance_id"
	AllianceHistoryIsDeleteed    string = "is_deleted"
	AllianceHistoryStartDate     string = "start_date"
)

const (
	ETagPath        = "path"
	ETagETag        = "etag"
	ETagCachedUntil = "cached_until"
)

const (
	MetaTotalSP       string = "total_sp"
	MetaUnallocatedSP string = "unallocated_sp"

	SkillsActiveSkillLevel   string = "active_skill_level"
	SkillsSkillID            string = "skill_id"
	SkillsSkillpointsInSkill string = "skillpoints_in_skill"
	SkillsTrainedSkillLevel  string = "trained_skill_level"

	QueueQueuePosition   string = "queue_position"
	QueueSkillID         string = "skill_id"
	QueueFinishedLevel   string = "finished_level"
	QueueTrainingStartSP string = "training_start_sp"
	QueueLevelStartSP    string = "level_start_sp"
	QueueLevelEndSP      string = "level_end_sp"
	QueueStartDate       string = "start_date"
	QueueFinishDate      string = "finish_date"

	AttributesCharisma                 string = "charisma"
	AttributesIntelligence             string = "intelligence"
	AttributesMemory                   string = "memory"
	AttributesPerception               string = "perception"
	AttributesWillpower                string = "willpower"
	AttributesBonusRemaps              string = "bonus_remaps"
	AttributesLastRemapDate            string = "last_remap_date"
	AttributesAccruedRemapCooldownDate string = "accrued_remap_cooldown_date"

	FlyableShipTypeID string = "ship_type_id"
	FlyableFlyable    string = "flyable"
)

const (
	BloodlineID            string = "id"
	BloodlineName          string = "name"
	BloodlineRaceID        string = "race_id"
	BloodlineCorporationID string = "corporation_id"
	BloodlineShipTypeID    string = "ship_type_id"
	BloodlineCharisma      string = "charisma"
	BloodlineIntelligence  string = "intelligence"
	BloodlineMemory        string = "memory"
	BloodlinePerception    string = "perception"
	BloodlineWillpower     string = "willpower"

	CategoryID        string = "id"
	CategoryName      string = "name"
	CategoryPublished string = "published"

	ConstellationID       string = "id"
	ConstellationName     string = "name"
	ConstellationRegionID string = "region_id"

	FactionID                   string = "id"
	FactionName                 string = "name"
	FactionIsUnique             string = "is_unique"
	FactionSizeFactor           string = "size_factor"
	FactionStationCount         string = "station_count"
	FactionStationSystemCount   string = "station_system_count"
	FactionCorporationID        string = "corporation_id"
	FactionMilitiaCorporationID string = "militia_corporation_id"
	FactionSolarSystemID        string = "solar_system_id"

	GroupID         string = "id"
	GroupName       string = "name"
	GroupPublished  string = "published"
	GroupCategoryID string = "category_id"

	RaceID   string = "id"
	RaceName string = "name"

	RegionID   string = "id"
	RegionName string = "name"

	SolarSystemID              string = "id"
	SolarSystemName            string = "name"
	SolarSystemConstellationID string = "constellation_id"
	SolarSystemSecurityStatus  string = "security_status"
	SolarSystemStarID          string = "star_id"
	SolarSystemSecurityClass   string = "security_class"

	StationID                       string = "id"
	StationName                     string = "name"
	StationSystemID                 string = "system_id"
	StationTypeID                   string = "type_id"
	StationRaceID                   string = "race_id"
	StationOwnerCorporationID       string = "owner_corporation_id"
	StationMaxDockableShipVolume    string = "max_dockable_ship_volume"
	StationOfficeRentalCost         string = "office_rental_cost"
	StationReprocessingEfficiency   string = "reprocessing_efficiency"
	StationReprocessingStationsTake string = "reprocessing_stations_take"

	StructureID            string = "id"
	StructureName          string = "name"
	StructureOwnerID       string = "owner_id"
	StructureSolarSystemID string = "solar_system_id"
	StructureTypeID        string = "type_id"

	TypesID             string = "id"
	TypesName           string = "name"
	TypesGroupID        string = "group_id"
	TypesPublished      string = "published"
	TypesCapacity       string = "capacity"
	TypesMarketGroupID  string = "market_group_id"
	TypesMass           string = "mass"
	TypesPackagedVolume string = "packaged_volume"
	TypesPortionSize    string = "portion_size"
	TypesRadius         string = "radius"
	TypesVolume         string = "volume"

	TypeDogmaAttributesTypeID     string = "type_id"
	TypeDogmaAttributeAttributeID string = "attribute_id"
	TypeDogmaAttributeValue       string = "value"
)

const (
	UserID                  = "id"
	UserAccessToken         = "access_token"
	UserRefreshToken        = "refresh_token"
	UserExpires             = "expires"
	UserOwnerHash           = "owner_hash"
	UserScopes              = "scopes"
	UserIsNew               = "is_new"
	UserDisabled            = "disabled"
	UserDisabledReason      = "disabled_reason"
	UserDisabledTimestamp   = "disabled_timestamp"
	UserLastLogin           = "last_login"
	UserLastProcessed       = "last_processed"
	SettingsUserID          = "user_id"
	SettingsVisibility      = "visibility"
	SettingsVisibilityToken = "visibility_token"
	SettingsHideSkills      = "hide_skills"
	SettingsHideQueue       = "hide_queue"
	SettingsHideFlyable     = "hide_flyable"
	SettingsHideAttributes  = "hide_attributes"
)

Functions

func BuildFilters

func BuildFilters(s sq.SelectBuilder, operators ...*skillz.Operator) sq.SelectBuilder

func BuildOperators

func BuildOperators(operators ...*skillz.Operator) *builder.Builder

func NewAllianceRepository

func NewAllianceRepository(db QueryExecContext) skillz.AllianceRepository

func NewCharacterRepository

func NewCharacterRepository(db QueryExecContext) skillz.CharacterRepository

func NewCloneRepository

func NewCloneRepository(db QueryExecContext) skillz.CloneRepository

func NewContactRepository

func NewContactRepository(db QueryExecContext) skillz.ContactRepository

func NewCorporationRepository

func NewCorporationRepository(db QueryExecContext) skillz.CorporationRepository

func NewETagRepository

func NewETagRepository(db QueryExecContext) skillz.EtagRepository

func NewQueryLogger

func NewQueryLogger(execer QueryExecContext, logger *logrus.Logger) *queryLogger

func NewSkillRepository

func NewSkillRepository(db QueryExecContext) skillz.CharacterSkillRepository

func NewUniverseRepository

func NewUniverseRepository(db QueryExecContext) skillz.UniverseRepository

func NewUserRepository

func NewUserRepository(db QueryExecContext) skillz.UserRepository

func OnDuplicateKeyStmt

func OnDuplicateKeyStmt(columns ...string) string

Types

type QueryExecContext

type QueryExecContext interface {
	SelectContext(context.Context, interface{}, string, ...interface{}) error
	GetContext(context.Context, interface{}, string, ...interface{}) error
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
}