database

type Db struct {
	Db *sql.DB
}

type DbActivity struct {
	Db
	PreparedStatements *DbActivityPreparedStatements
}

type DbActivityData struct {
	Id             int
	InstanceId     string
	MembershipIds  string
	MembershipType int
	CharacterIds   string
}

type DbActivityHistory struct {
	Db
	PreparedStatements *DbActivityHistoryPreparedStatements
}

type DbActivityHistoryData struct {
	Id             int
	MembershipId   string
	MembershipType int
	CharacterId    string
	ActivityCount  int
}

type DbActivityHistoryPreparedStatements struct {
	GetByMembershipIdMembershipTypeCharacterId *sql.Stmt
	Create                                     *sql.Stmt
	UpdateById                                 *sql.Stmt
}

type DbActivityPreparedStatements struct {
	GetByInstanceId                            *sql.Stmt
	GetByMembershipIdMembershipTypeCharacterId *sql.Stmt
	Create                                     *sql.Stmt
	UpdateById                                 *sql.Stmt
}

type DbHandler interface {
	Init(db *sql.DB) error
}

type DbHandlers struct {
	Profile               *DbProfile
	Activity              *DbActivity
	ActivityHistory       *DbActivityHistory
	PostGameCarnageReport *DbPostGameCarnageReport
}

type DbPostGameCarnageReport struct {
	Db
	PreparedStatements *DbPostGameCarnageReportPreparedStatements
}

type DbPostGameCarnageReportData struct {
	Id         int
	InstanceId string
	Json       string
}

type DbPostGameCarnageReportPreparedStatements struct {
	GetByInstanceId *sql.Stmt
	Create          *sql.Stmt
	UpdateById      *sql.Stmt
}

type DbProfile struct {
	Db
	PreparedStatements *DbProfilePreparedStatements
}

type DbProfileData struct {
	Id             int
	Username       string
	MembershipType int
	MembershipId   string
	Json           string
}

type DbProfilePreparedStatements struct {
	GetByUsername     *sql.Stmt
	GetByMembershipId *sql.Stmt
	Create            *sql.Stmt
	UpdateById        *sql.Stmt
}