db

type Equipment struct {
	bun.BaseModel  `bun:"table:equipment,alias:e"`
	EquipmentID    int64  `bun:"equipment_id,pk,autoincrement"`
	EquipmentUUID  string `bun:"equipment_uuid,notnull,unique"`
	EquipmentName  string `bun:"equipment_name,notnull"`
	EquipmentType  string `bun:"equipment_type,notnull"`
	Manufacturer   string `bun:"manufacturer"`
	Model          string `bun:"model"`
	ProductionYear int    `bun:"production_year"`
	Location       string `bun:"location"`
}

type EquipmentWithLatestData struct {
	Equipment                                            // Embedding Equipment struct to hold equipment data.
	LatestFuelLevel           FuelLevel                  `bun:"rel:has-one,join:equipment_id=equipment_id"` // Latest fuel level.
	LatestOilPressure         OilPressure                `bun:"rel:has-one,join:equipment_id=equipment_id"` // Latest oil pressure.
	LatestOilEngineTemp       OilEngineTemperature       `bun:"rel:has-one,join:equipment_id=equipment_id"` // Latest oil engine temperature.
	LatestTransmissionOilTemp TransmissionOilTemperature `bun:"rel:has-one,join:equipment_id=equipment_id"` // Latest transmission oil temp.
}

type FuelLevel struct {
	bun.BaseModel    `bun:"table:fuellevel,alias:f"`
	FuelLevelID      int64     `bun:"fuel_level_id,pk,autoincrement"`
	EquipmentUUID    string    `bun:"equipment_uuid,notnull"`
	EquipmentID      int64     `bun:"equipment_id,notnull"`
	Timestamp        time.Time `bun:"timestamp,default:current_timestamp"`
	FuelLevelDecimal float64   `bun:"fuel_level"`
}

type Model struct {
	Postgres
	// contains filtered or unexported fields
}

type OilEngineTemperature struct {
	bun.BaseModel               `bun:"table:oilenginetemperature,alias:t"`
	OilEngineTempID             int64     `bun:"oil_engine_temp_id,pk,autoincrement"`
	EquipmentUUID               string    `bun:"equipment_uuid,notnull"`
	EquipmentID                 int64     `bun:"equipment_id,notnull"`
	Timestamp                   time.Time `bun:"timestamp,default:current_timestamp"`
	OilEngineTemperatureDecimal float64   `bun:"oil_engine_temperature"`
}

type OilPressure struct {
	bun.BaseModel      `bun:"table:oilpressure,alias:o"`
	OilPressureID      int64     `bun:"oil_pressure_id,pk,autoincrement"`
	EquipmentUUID      string    `bun:"equipment_uuid,notnull"`
	EquipmentID        int64     `bun:"equipment_id,notnull"`
	Timestamp          time.Time `bun:"timestamp,default:current_timestamp"`
	OilPressureDecimal float64   `bun:"oil_pressure"`
}

type Postgres struct {
	Host       string `yaml:"host"`
	Port       string `yaml:"port"`
	User       string `yaml:"user"`
	Password   string `yaml:"password"`
	Database   string `yaml:"database"`
	ClientCert string `yaml:"client_cert"`
	ClientKey  string `yaml:"client_key"`
	ServerCert string `yaml:"server_cert"`
}

type TransmissionOilTemperature struct {
	bun.BaseModel                     `bun:"table:transmissionoiltemperature,alias:trans"`
	TransmissionOilTempID             int64     `bun:"transmission_oil_temp_id,pk,autoincrement"`
	EquipmentUUID                     string    `bun:"equipment_uuid,notnull"`
	EquipmentID                       int64     `bun:"equipment_id,notnull"`
	Timestamp                         time.Time `bun:"timestamp,default:current_timestamp"`
	TransmissionOilTemperatureDecimal float64   `bun:"transmission_oil_temperature"`
}