mysql

package
v0.9.2 Latest Latest
Warning

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

Go to latest
Published: May 2, 2022 License: MIT Imports: 10 Imported by: 0

Documentation

Index

Constants

View Source
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"
)
View Source
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"
)
View Source
const (
	ImplantsImplantID string = "implant_id"
	ImplantsSlot      string = "slot"
)
View Source
const (
	ColumnCharacterID string = "character_id"
	ColumnCreatedAt   string = "created_at"
	ColumnUpdatedAt   string = "updated_at"
)
View Source
const (
	TableAlliances                   string = "alliances"
	TableBloodlines                  string = "bloodlines"
	TableCharacters                  string = "characters"
	TableCharacterAttributes         string = "character_attributes"
	TableCharacterContacts           string = "character_contacts"
	TableCharacterCorporationHistory string = "character_corporation_history"
	TableCharacterFlyableShips       string = "character_flyable_ships"
	TableCharacterImplants           string = "character_implants"
	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"
)
View Source
const (
	ContactContactID   string = "contact_id"
	ContactContactType string = "contact_type"
	ContactStanding    string = "standing"
)
View Source
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"
)
View Source
const (
	ETagPath        = "path"
	ETagETag        = "etag"
	ETagCachedUntil = "cached_until"
)
View Source
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"
)
View Source
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"
)
View Source
const (
	UserID                  = "id"
	UserUUID                = "uuid"
	UserAccessToken         = "access_token"
	UserRefreshToken        = "refresh_token"
	UserExpires             = "expires"
	UserOwnerHash           = "owner_hash"
	UserScopes              = "scopes"
	UserIsNew               = "is_new"
	UserIsProcessing        = "is_processing"
	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"
	SettingsHideImplants    = "hide_implants"
)

Variables

This section is empty.

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 NewCloneRepository

func NewCloneRepository(db QueryExecContext) skillz.CloneRepository

func NewContactRepository

func NewContactRepository(db QueryExecContext) skillz.ContactRepository

func NewETagRepository

func NewETagRepository(db QueryExecContext) skillz.EtagRepository

func NewQueryLogger

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

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)
}

Jump to

Keyboard shortcuts

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