Versions in this module Expand all Collapse all v1 v1.0.6 Jun 11, 2023 v1.0.5 Jun 11, 2023 v1.0.4 Jun 9, 2023 Changes in this version + type DbHandler interface + Init func(db *sql.DB) error v1.0.3 Jun 7, 2023 v1.0.2 Jun 7, 2023 v1.0.1 Jun 6, 2023 Changes in this version + type Db struct + Db *sql.DB + func (db *Db) GetDbHandlers() (*DbHandlers, error) type DbActivity + PreparedStatements *DbActivityPreparedStatements + func (dbActivity *DbActivity) CreateActivity(instanceId string, membershipIds string, membershipType int, ...) error + func (dbActivity *DbActivity) GetActivitiesByInstanceId(instanceId string) ([]*DbActivityData, error) + func (dbActivity *DbActivity) GetActivitiesByMembershipIdMembershipTypeCharacterId(membershipId string, membershipType int, characterId string) ([]*DbActivityData, error) + func (dbActivity *DbActivity) Init(db *sql.DB) error + func (dbActivity *DbActivity) UpdateActivityById(id int, instanceId string, membershipIds string, membershipType int, ...) error + type DbActivityData struct + CharacterIds string + Id int + InstanceId string + MembershipIds string + MembershipType int type DbActivityHistory + PreparedStatements *DbActivityHistoryPreparedStatements + func (dbActivityHistory *DbActivityHistory) CreateActivityHistory(membershipId string, membershipType int, characterId string, activityCount int) error + func (dbActivityHistory *DbActivityHistory) GetActivityHistoryByMembershipIdMembershipTypeCharacterId(membershipId string, membershipType int, characterId string) (*DbActivityHistoryData, error) + func (dbActivityHistory *DbActivityHistory) Init(db *sql.DB) error + func (dbActivityHistory *DbActivityHistory) UpdateActivityHistoryById(id int, membershipId string, membershipType int, characterId string, ...) error + type DbActivityHistoryData struct + ActivityCount int + CharacterId string + Id int + MembershipId string + MembershipType int + type DbActivityHistoryPreparedStatements struct + Create *sql.Stmt + GetByMembershipIdMembershipTypeCharacterId *sql.Stmt + UpdateById *sql.Stmt + type DbActivityPreparedStatements struct + Create *sql.Stmt + GetByInstanceId *sql.Stmt + GetByMembershipIdMembershipTypeCharacterId *sql.Stmt + UpdateById *sql.Stmt + type DbHandlers struct + Activity *DbActivity + ActivityHistory *DbActivityHistory + PostGameCarnageReport *DbPostGameCarnageReport + Profile *DbProfile type DbPostGameCarnageReport + PreparedStatements *DbPostGameCarnageReportPreparedStatements + func (dbPostGameCarnageReport *DbPostGameCarnageReport) CreatePostGameCarnageReport(instanceId string, json string) error + func (dbPostGameCarnageReport *DbPostGameCarnageReport) GetPostGameCarnageReportsByInstanceId(instanceId string) ([]*DbPostGameCarnageReportData, error) + func (dbPostGameCarnageReport *DbPostGameCarnageReport) Init(db *sql.DB) error + func (dbPostGameCarnageReport *DbPostGameCarnageReport) UpdatePostGameCarnageReportById(id int, instanceId string, json string) error + type DbPostGameCarnageReportData struct + Id int + InstanceId string + Json string + type DbPostGameCarnageReportPreparedStatements struct + Create *sql.Stmt + GetByInstanceId *sql.Stmt + UpdateById *sql.Stmt type DbProfile + PreparedStatements *DbProfilePreparedStatements + func (dbProfile *DbProfile) CreateProfile(username string, membershipType int, membershipId string, json string) error + func (dbProfile *DbProfile) GetProfileByMembershipId(membershipId string) ([]*DbProfileData, error) + func (dbProfile *DbProfile) GetProfilesByUsername(username string) ([]*DbProfileData, error) + func (dbProfile *DbProfile) Init(db *sql.DB) error + func (dbProfile *DbProfile) UpdateProfileById(id int, username string, membershipType int, membershipId string, json string) error + type DbProfileData struct + Id int + Json string + MembershipId string + MembershipType int + Username string + type DbProfilePreparedStatements struct + Create *sql.Stmt + GetByMembershipId *sql.Stmt + GetByUsername *sql.Stmt + UpdateById *sql.Stmt v1.0.0 Jun 5, 2023 Changes in this version + func CreateActivity(db *sql.DB, instanceId string, membershipIds string, membershipType int, ...) error + func CreateActivityHistory(db *sql.DB, membershipId string, membershipType int, characterId string, ...) error + func CreatePostGameCarnageReport(db *sql.DB, instanceId string, json string) error + func CreateProfile(db *sql.DB, username string, membershipType int, membershipId string, ...) error + func GetDb() (*sql.DB, error) + func UpdateActivityById(db *sql.DB, id int, instanceId string, membershipIds string, ...) error + func UpdateActivityHistoryById(db *sql.DB, id int, membershipId string, membershipType int, ...) error + func UpdatePostGameCarnageReportById(db *sql.DB, id int, instanceId string, json string) error + func UpdateProfileById(db *sql.DB, id int, username string, membershipType int, membershipId string, ...) error + type DbActivity struct + CharacterIds string + Id int + InstanceId string + MembershipIds string + MembershipType int + func GetActivitiesByInstanceId(db *sql.DB, instanceId string) ([]*DbActivity, error) + func GetActivitiesByMembershipIdMembershipTypeCharacterId(db *sql.DB, membershipId string, membershipType int, characterId string) ([]*DbActivity, error) + type DbActivityHistory struct + ActivityCount int + CharacterId string + Id int + MembershipId string + MembershipType int + func GetActivityHistoryByMembershipIdMembershipTypeCharacterId(db *sql.DB, membershipId string, membershipType int, characterId string) (*DbActivityHistory, error) + type DbPostGameCarnageReport struct + Id int + InstanceId string + Json string + func GetPostGameCarnageReportsByInstanceId(db *sql.DB, instanceId string) ([]*DbPostGameCarnageReport, error) + type DbProfile struct + Id int + Json string + MembershipId string + MembershipType int + Username string + func GetProfileByMembershipId(db *sql.DB, membershipId string) ([]*DbProfile, error) + func GetProfilesByUsername(db *sql.DB, username string) ([]*DbProfile, error)