database

type Break struct {
	ID          int64       `json:"id,string" example:"1234567812345678"`
	VehicleID   int64       `json:"vehicle_id,string" example:"1234567812345678"`
	Service     string      `json:"service" example:"00:02:00"`
	Data        interface{} `json:"data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
	CreatedAt   string      `json:"created_at" example:"2021-12-01T13:00:00"`
	UpdatedAt   string      `json:"updated_at" example:"2021-12-01T13:00:00"`
	TimeWindows [][]string  `json:"time_windows"`
}

type CreateBreakParams struct {
	VehicleID   *int64       `json:"vehicle_id,string" example:"1234567812345678" validate:"required" swaggerignore:"true"`
	Service     *string      `json:"service" validate:"omitempty" example:"00:02:00"`
	Data        *interface{} `json:"data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
	TimeWindows *[][]string  `json:"time_windows" validate:"omitempty,dive,min=2,max=2,dive,datetime=2006-01-02T15:04:05"`
}

type CreateJobParams struct {
	Location    *util.LocationParams `json:"location" validate:"required"`
	Setup       *string              `json:"setup"    validate:"omitempty" example:"00:00:00"`
	Service     *string              `json:"service"  validate:"omitempty" example:"00:02:00"`
	Delivery    *[]int64             `json:"delivery" validate:"omitempty,dive,min=0" example:"10,20"`
	Pickup      *[]int64             `json:"pickup"   validate:"omitempty,dive,min=0" example:"5,15"`
	Skills      *[]int32             `json:"skills"   validate:"omitempty,dive,min=0" example:"1,5"`
	Priority    *int32               `json:"priority" validate:"omitempty,min=0,max=100" example:"10"`
	TimeWindows *[][]string          `json:"time_windows" validate:"omitempty,dive,min=2,max=2,dive,datetime=2006-01-02T15:04:05"`
	ProjectID   *int64               `json:"project_id,string" validate:"required" swaggerignore:"true"`
	Data        *interface{}         `json:"data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
}

type CreateProjectParams struct {
	Name             *string      `json:"name" example:"Sample Project" validate:"required"`
	DurationCalc     *string      `json:"duration_calc" example:"euclidean" validate:"omitempty,oneof=euclidean valhalla osrm"`
	ExplorationLevel *int64       `json:"exploration_level" example:"5" validate:"omitempty,lte=5,gte=0"`
	Timeout          *string      `json:"timeout" example:"00:10:00"`
	MaxShift         *string      `json:"max_shift" example:"00:30:00" validate:"omitempty"`
	Data             *interface{} `json:"data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
}

type CreateShipmentParams struct {
	PLocation    *util.LocationParams `json:"p_location" validate:"required"`
	PSetup       *string              `json:"p_setup"    validate:"omitempty" example:"00:00:00"`
	PService     *string              `json:"p_service"  validate:"omitempty" example:"00:02:00"`
	DLocation    *util.LocationParams `json:"d_location" validate:"required"`
	DSetup       *string              `json:"d_setup"    validate:"omitempty" example:"00:00:00"`
	DService     *string              `json:"d_service"  validate:"omitempty" example:"00:02:00"`
	Amount       *[]int64             `json:"amount"     validate:"omitempty,dive,min=0" example:"5,15"`
	Skills       *[]int32             `json:"skills"     validate:"omitempty,dive,min=0" example:"1,5"`
	PTimeWindows *[][]string          `json:"p_time_windows" validate:"omitempty,dive,min=2,max=2,dive,datetime=2006-01-02T15:04:05"`
	DTimeWindows *[][]string          `json:"d_time_windows" validate:"omitempty,dive,min=2,max=2,dive,datetime=2006-01-02T15:04:05"`
	Priority     *int32               `json:"priority"   validate:"omitempty,min=0,max=100" example:"10"`
	ProjectID    *int64               `json:"project_id,string" validate:"required" swaggerignore:"true"`
	PData        *interface{}         `json:"p_data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
	DData        *interface{}         `json:"d_data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
}

type CreateVehicleParams struct {
	StartLocation *util.LocationParams `json:"start_location" validate:"required"`
	EndLocation   *util.LocationParams `json:"end_location" validate:"required"`
	Capacity      *[]int64             `json:"capacity" validate:"omitempty,dive,min=0" example:"50,25"`
	Skills        *[]int32             `json:"skills" validate:"omitempty,dive,min=0" example:"1,5"`
	TwOpen        *string              `json:"tw_open" validate:"omitempty,datetime=2006-01-02T15:04:05" example:"2021-12-31T23:00:00"`
	TwClose       *string              `json:"tw_close" validate:"omitempty,datetime=2006-01-02T15:04:05" example:"2021-12-31T23:59:00"`
	SpeedFactor   *float64             `json:"speed_factor" validate:"omitempty,gt=0" example:"1.0"`
	MaxTasks      *int32               `json:"max_tasks" validate:"omitempty,gt=0" example:"20"`
	ProjectID     *int64               `json:"project_id,string" validate:"required" swaggerignore:"true"`
	Data          *interface{}         `json:"data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
}

type DBTX interface {
	BeginTx(context.Context, pgx.TxOptions) (pgx.Tx, error)
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type Job struct {
	ID          int64               `json:"id,string" example:"1234567812345678"`
	Location    util.LocationParams `json:"location"`
	Setup       string              `json:"setup" example:"00:00:00"`
	Service     string              `json:"service" example:"00:02:00"`
	Delivery    []int64             `json:"delivery" example:"10,20"`
	Pickup      []int64             `json:"pickup" example:"5,15"`
	Skills      []int32             `json:"skills" example:"1,5"`
	Priority    int32               `json:"priority" example:"10"`
	ProjectID   int64               `json:"project_id,string" example:"1234567812345678"`
	Data        interface{}         `json:"data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
	CreatedAt   string              `json:"created_at" example:"2021-12-01T13:00:00"`
	UpdatedAt   string              `json:"updated_at" example:"2021-12-01T13:00:00"`
	TimeWindows [][]string          `json:"time_windows"`
}

type Project struct {
	ID               int64       `json:"id,string" example:"1234567812345678"`
	Name             string      `json:"name" example:"Sample Project"`
	DurationCalc     string      `json:"duration_calc" example:"euclidean"`
	ExplorationLevel int64       `json:"exploration_level" example:"5"`
	Timeout          string      `json:"timeout" example:"00:10:00"`
	MaxShift         string      `json:"max_shift" example:"00:30:00"`
	Data             interface{} `json:"data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
	CreatedAt        string      `json:"created_at" example:"2021-12-01T13:00:00"`
	UpdatedAt        string      `json:"updated_at" example:"2021-12-01T13:00:00"`
}

type Querier interface {
	// Break
	DBCreateBreakWithTw(ctx context.Context, arg CreateBreakParams) (Break, error)
	DBListBreaks(ctx context.Context, vehicleID int64) ([]Break, error)
	DBGetBreak(ctx context.Context, id int64) (Break, error)
	DBUpdateBreakWithTw(ctx context.Context, arg UpdateBreakParams, break_id int64) (Break, error)
	DBDeleteBreakWithTw(ctx context.Context, id int64) error

	// Job
	DBCreateJobWithTw(ctx context.Context, arg CreateJobParams) (Job, error)
	DBListJobs(ctx context.Context, projectID int64) ([]Job, error)
	DBGetJob(ctx context.Context, id int64) (Job, error)
	DBUpdateJobWithTw(ctx context.Context, arg UpdateJobParams, job_id int64) (Job, error)
	DBDeleteJobWithTw(ctx context.Context, id int64) error

	// Project
	DBCreateProject(ctx context.Context, arg CreateProjectParams) (Project, error)
	DBListProjects(ctx context.Context) ([]Project, error)
	DBGetProject(ctx context.Context, id int64) (Project, error)
	DBUpdateProject(ctx context.Context, arg UpdateProjectParams, project_id int64) (Project, error)
	DBDeleteProject(ctx context.Context, id int64) (Project, error)

	// Schedule
	DBCreateSchedule(ctx context.Context, id int64, fresh string) error
	DBGetSchedule(ctx context.Context, id int64) (util.ScheduleData, error)
	DBGetScheduleJob(ctx context.Context, id int64) (util.ScheduleData, error)
	DBGetScheduleShipment(ctx context.Context, id int64) (util.ScheduleData, error)
	DBGetScheduleVehicle(ctx context.Context, id int64) (util.ScheduleData, error)
	DBDeleteSchedule(ctx context.Context, id int64) error

	// Shipment
	DBCreateShipmentWithTw(ctx context.Context, arg CreateShipmentParams) (Shipment, error)
	DBListShipments(ctx context.Context, projectID int64) ([]Shipment, error)
	DBGetShipment(ctx context.Context, id int64) (Shipment, error)
	DBUpdateShipmentWithTw(ctx context.Context, arg UpdateShipmentParams, shipment_id int64) (Shipment, error)
	DBDeleteShipmentWithTw(ctx context.Context, id int64) error

	// Vehicle
	DBCreateVehicle(ctx context.Context, arg CreateVehicleParams) (Vehicle, error)
	DBListVehicles(ctx context.Context, projectID int64) ([]Vehicle, error)
	DBGetVehicle(ctx context.Context, id int64) (Vehicle, error)
	DBUpdateVehicle(ctx context.Context, arg UpdateVehicleParams, vehicle_id int64) (Vehicle, error)
	DBDeleteVehicle(ctx context.Context, id int64) (Vehicle, error)

	// Locations
	DBGetProjectLocations(ctx context.Context, project_id int64) ([]int64, error)
}

type Queries struct {
	// contains filtered or unexported fields
}

type Shipment struct {
	ID           int64               `json:"id,string" example:"1234567812345678"`
	PLocation    util.LocationParams `json:"p_location" `
	PSetup       string              `json:"p_setup" example:"00:00:00"`
	PService     string              `json:"p_service" example:"00:02:00"`
	DLocation    util.LocationParams `json:"d_location"`
	DSetup       string              `json:"d_setup" example:"00:00:00"`
	DService     string              `json:"d_service" example:"00:02:00"`
	Amount       []int64             `json:"amount" example:"5,15"`
	Skills       []int32             `json:"skills" example:"1,5"`
	Priority     int32               `json:"priority" example:"10"`
	ProjectID    int64               `json:"project_id,string" example:"1234567812345678"`
	PData        interface{}         `json:"p_data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
	DData        interface{}         `json:"d_data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
	CreatedAt    string              `json:"created_at" example:"2021-12-01T13:00:00"`
	UpdatedAt    string              `json:"updated_at" example:"2021-12-01T13:00:00"`
	PTimeWindows [][]string          `json:"p_time_windows"`
	DTimeWindows [][]string          `json:"d_time_windows"`
}

type ShipmentTimeWindowParams struct {
	Kind    string `json:"kind" validate:"required,oneof=p d" example:"p"`
	TwOpen  string `json:"tw_open" validate:"required,datetime=2006-01-02T15:04:05" example:"2021-12-31T23:00:00"`
	TwClose string `json:"tw_close" validate:"required,datetime=2006-01-02T15:04:05" example:"2021-12-31T23:59:00"`
}

type Store struct {
	Querier
	// contains filtered or unexported fields
}

type TimeWindowParams struct {
	TwOpen  string `json:"tw_open" validate:"required,datetime=2006-01-02T15:04:05" example:"2021-12-31T23:00:00"`
	TwClose string `json:"tw_close" validate:"required,datetime=2006-01-02T15:04:05" example:"2021-12-31T23:59:00"`
}

type UpdateBreakParams struct {
	VehicleID   *int64       `json:"vehicle_id,string" example:"1234567812345678" swaggerignore:"true"`
	Service     *string      `json:"service" validate:"omitempty" example:"00:02:00"`
	Data        *interface{} `json:"data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
	TimeWindows *[][]string  `json:"time_windows" validate:"omitempty,dive,min=2,max=2,dive,datetime=2006-01-02T15:04:05"`
}

type UpdateJobParams struct {
	Location    *util.LocationParams `json:"location"`
	Setup       *string              `json:"setup"    validate:"omitempty" example:"00:00:00"`
	Service     *string              `json:"service"  validate:"omitempty" example:"00:02:00"`
	Delivery    *[]int64             `json:"delivery" validate:"omitempty,dive,min=0" example:"10,20"`
	Pickup      *[]int64             `json:"pickup"   validate:"omitempty,dive,min=0" example:"5,15"`
	Skills      *[]int32             `json:"skills"   validate:"omitempty,dive,min=0" example:"1,5"`
	Priority    *int32               `json:"priority" validate:"omitempty,min=0,max=100" example:"10"`
	TimeWindows *[][]string          `json:"time_windows" validate:"omitempty,dive,min=2,max=2,dive,datetime=2006-01-02T15:04:05"`
	ProjectID   *int64               `json:"project_id,string" swaggerignore:"true"`
	Data        *interface{}         `json:"data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
}

type UpdateProjectParams struct {
	Name             *string      `json:"name" example:"Sample Project"`
	DurationCalc     *string      `json:"duration_calc" example:"euclidean" validate:"omitempty,oneof=euclidean valhalla osrm"`
	ExplorationLevel *int64       `json:"exploration_level" example:"5" validate:"omitempty,lte=5,gte=0"`
	Timeout          *string      `json:"timeout" example:"00:10:00"`
	MaxShift         *string      `json:"max_shift" example:"00:30:00" validate:"omitempty"`
	Data             *interface{} `json:"data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
}

type UpdateShipmentParams struct {
	PLocation    *util.LocationParams `json:"p_location"`
	PSetup       *string              `json:"p_setup"    validate:"omitempty" example:"00:00:00"`
	PService     *string              `json:"p_service"  validate:"omitempty" example:"00:02:00"`
	DLocation    *util.LocationParams `json:"d_location"`
	DSetup       *string              `json:"d_setup"    validate:"omitempty" example:"00:00:00"`
	DService     *string              `json:"d_service"  validate:"omitempty" example:"00:02:00"`
	Amount       *[]int64             `json:"amount"     validate:"omitempty,dive,min=0" example:"5,15"`
	Skills       *[]int32             `json:"skills"     validate:"omitempty,dive,min=0" example:"1,5"`
	PTimeWindows *[][]string          `json:"p_time_windows" validate:"omitempty,dive,min=2,max=2,dive,datetime=2006-01-02T15:04:05"`
	DTimeWindows *[][]string          `json:"d_time_windows" validate:"omitempty,dive,min=2,max=2,dive,datetime=2006-01-02T15:04:05"`
	Priority     *int32               `json:"priority"   validate:"omitempty,min=0,max=100" example:"10"`
	ProjectID    *int64               `json:"project_id,string" swaggerignore:"true"`
	PData        *interface{}         `json:"p_data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
	DData        *interface{}         `json:"d_data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
}

type UpdateVehicleParams struct {
	StartLocation *util.LocationParams `json:"start_location"`
	EndLocation   *util.LocationParams `json:"end_location"`
	Capacity      *[]int64             `json:"capacity" validate:"omitempty,dive,min=0" example:"50,25"`
	Skills        *[]int32             `json:"skills" validate:"omitempty,dive,min=0" example:"1,5"`
	TwOpen        *string              `json:"tw_open" validate:"omitempty,datetime=2006-01-02T15:04:05" example:"2021-12-31T23:00:00"`
	TwClose       *string              `json:"tw_close" validate:"omitempty,datetime=2006-01-02T15:04:05" example:"2021-12-31T23:59:00"`
	SpeedFactor   *float64             `json:"speed_factor" validate:"omitempty,gt=0" example:"1.0"`
	MaxTasks      *int32               `json:"max_tasks" validate:"omitempty,gt=0" example:"20"`
	ProjectID     *int64               `json:"project_id,string" swaggerignore:"true"`
	Data          *interface{}         `json:"data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
}

type Vehicle struct {
	ID            int64               `json:"id,string" example:"1234567812345678"`
	StartLocation util.LocationParams `json:"start_location"`
	EndLocation   util.LocationParams `json:"end_location"`
	Capacity      []int64             `json:"capacity" example:"50,25"`
	Skills        []int32             `json:"skills" example:"1,5"`
	TwOpen        string              `json:"tw_open" example:"2021-12-31T23:00:00"`
	TwClose       string              `json:"tw_close" example:"2021-12-31T23:59:00"`
	SpeedFactor   float64             `json:"speed_factor" example:"1.0"`
	MaxTasks      int32               `json:"max_tasks" example:"20"`
	ProjectID     int64               `json:"project_id,string" example:"1234567812345678"`
	Data          interface{}         `json:"data" swaggertype:"object,string" example:"key1:value1,key2:value2"`
	CreatedAt     string              `json:"created_at" example:"2021-12-01T13:00:00"`
	UpdatedAt     string              `json:"updated_at" example:"2021-12-01T13:00:00"`
}