data

type Explorer struct {
	ExplorerId      uint64 `db:"explorer_id" structs:"-"`
	ExplorerAddress string `db:"explorer_address" structs:"explorer_address"`
	TotalStakeTLM   int64  `db:"total_stake_tlm" structs:"total_stake_tlm"`
	TotalStakeBNB   int64  `db:"total_stake_bnb" structs:"total_stake_bnb"`
}

type ExplorerMission struct {
	ExplorerMissionId uint64 `db:"explorer_mission_id" structs:"-"`
	Explorer          int64  `db:"explorer" structs:"explorer"`
	Mission           int64  `db:"mission" structs:"mission"`
	Withdrawn         bool   `db:"withdrawn" structs:"withdrawn"`
	NumberShips       int64  `db:"number_ships" structs:"number_ships"`
	TotalStakeTLM     int64  `db:"total_stake_tlm" structs:"total_stake_tlm"`
	TotalStakeBNB     int64  `db:"total_stake_bnb" structs:"total_stake_bnb"`
}

type ExplorerMissionQ interface {
	New() ExplorerMissionQ

	Get() (*ExplorerMission, error)
	Select() ([]ExplorerMission, error)

	Insert(explorerMission ExplorerMission) (ExplorerMission, error)
	Update(explorerMission ExplorerMission) (ExplorerMission, error)

	FilterByMission(missionId int64) ExplorerMissionQ
	FilterByExplorer(explorerId int64) ExplorerMissionQ
}

type ExplorerQ interface {
	New() ExplorerQ

	Get() (*Explorer, error)

	Select() ([]Explorer, error)

	Insert(explorer Explorer) (Explorer, error)
	Update(explorer Explorer) (Explorer, error)

	FilterByAddress(explorerAddress string) ExplorerQ
}

type JoinEvent struct {
	TransactionId string `db:"transaction_id" structs:"transaction_id"`
}

type JoinEventQ interface {
	New() JoinEventQ

	Get() (*JoinEvent, error)
	Select() ([]JoinEvent, error)

	Insert(JoinEvent JoinEvent) (JoinEvent, error)
	Update(JoinEvent JoinEvent) (JoinEvent, error)

	FilterById(join_event_id string) JoinEventQ
}

type Mission struct {
	MissionId     uint64 `db:"mission_id" structs:"mission_id"`
	Description   string `db:"description" structs:"description"`
	Name          string `db:"name" structs:"name"`
	BoardingTime  int64  `db:"boarding_time" structs:"boarding_time"`
	LaunchTime    int64  `db:"launch_time" structs:"launch_time"`
	EndTime       int64  `db:"end_time" structs:"end_time"`
	Duration      int64  `db:"duration" structs:"duration"`
	MissionType   int64  `db:"mission_type" structs:"mission_type"`
	Reward        int64  `db:"reward" structs:"reward"`
	SpaceshipCost int64  `db:"spaceship_cost" structs:"spaceship_cost"`
	MissionPower  int64  `db:"mission_power" structs:"mission_power"`
	TotalShips    int64  `db:"total_ships" structs:"total_ships"`
	NftContract   []byte `db:"nft_contract" structs:"nft_contract"`
	NftTokenURI   string `db:"nft_token_uri" structs:"nft_token_uri"`
}

type MissionQ interface {
	New() MissionQ

	Get() (*Mission, error)
	// Select() ([]Mission, error)
	Select(query pgdb.OffsetPageParams) ([]Mission, error)
	Insert(mission Mission) (Mission, error)
	Update(mission Mission) (Mission, error)

	FilterById(missionId int64) MissionQ
}