sqlc

type ArchiveVehicleParams struct {
	ID         int32
	ArchivedAt *time.Time
}

type CreateRegionParams struct {
	Name           string
	StGeomfromtext interface{}
}

type CreateSensorParams struct {
	ID                     string
	Status                 SensorStatus
	Latitude               float64
	Longitude              float64
	Provider               *string
	AdditionalInformations []byte
}

type CreateTreeClusterParams struct {
	Name                   string
	RegionID               *int32
	Address                string
	Description            string
	MoistureLevel          float64
	WateringStatus         WateringStatus
	SoilCondition          TreeSoilCondition
	Provider               *string
	AdditionalInformations []byte
}

type CreateTreeParams struct {
	TreeClusterID          *int32
	SensorID               *string
	PlantingYear           int32
	Species                string
	Number                 string
	Description            *string
	WateringStatus         WateringStatus
	Latitude               float64
	Longitude              float64
	Provider               *string
	AdditionalInformations []byte
}

type CreateVehicleParams struct {
	NumberPlate            string
	Description            string
	WaterCapacity          float64
	Type                   VehicleType
	Status                 VehicleStatus
	Model                  string
	DrivingLicense         DrivingLicense
	Height                 float64
	Length                 float64
	Width                  float64
	Weight                 float64
	Provider               *string
	AdditionalInformations []byte
}

type CreateWateringPlanParams struct {
	Date                   time.Time
	Description            string
	Status                 WateringPlanStatus
	Distance               *float64
	TotalWaterRequired     *float64
	CancellationNote       string
	Provider               *string
	AdditionalInformations []byte
}

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

type DrivingLicense string

type FindNearestTreeParams struct {
	StMakepoint   interface{}
	StMakepoint_2 interface{}
}

type GetAllRegionsParams struct {
	Limit  int32
	Offset int32
}

type GetAllSensorsParams struct {
	Limit    int32
	Offset   int32
	Provider interface{}
}

type GetAllTreeClusterRegionsWithWateringPlanCountRow struct {
	Name              string
	WateringPlanCount int64
}

type GetAllTreeClustersParams struct {
	Limit          int32
	Offset         int32
	WateringStatus []string
	Region         []string
	Provider       interface{}
}

type GetAllTreesCountParams struct {
	WateringStatus []string
	Provider       interface{}
	Years          []int32
	HasCluster     *bool
}

type GetAllTreesParams struct {
	Limit          int32
	Offset         int32
	WateringStatus []string
	Provider       interface{}
	Years          []int32
	HasCluster     *bool
}

type GetAllVehiclesByTypeCountParams struct {
	Type     VehicleType
	Provider interface{}
}

type GetAllVehiclesByTypeParams struct {
	Type     VehicleType
	Limit    int32
	Offset   int32
	Provider interface{}
}

type GetAllVehiclesByTypeWithArchivedCountParams struct {
	Type     VehicleType
	Provider interface{}
}

type GetAllVehiclesByTypeWithArchivedParams struct {
	Type     VehicleType
	Limit    int32
	Offset   int32
	Provider interface{}
}

type GetAllVehiclesParams struct {
	Limit    int32
	Offset   int32
	Provider interface{}
}

type GetAllVehiclesWithArchivedParams struct {
	Limit    int32
	Offset   int32
	Provider interface{}
}

type GetAllVehiclesWithWateringPlanCountRow struct {
	NumberPlate       string
	WateringPlanCount int64
}

type GetAllWateringPlansParams struct {
	Limit    int32
	Offset   int32
	Provider interface{}
}

type GetTreeByCoordinatesParams struct {
	Latitude  float64
	Longitude float64
}

type GetTreeClustersCountParams struct {
	WateringStatus []string
	Region         []string
	Provider       interface{}
}

type GetVehicleByWateringPlanIDParams struct {
	WateringPlanID int32
	Type           VehicleType
}

type InsertSensorDataParams struct {
	SensorID string
	Data     []byte
}

type LinkTreesToTreeClusterParams struct {
	Column1       []int32
	TreeClusterID *int32
}

type NullDrivingLicense struct {
	DrivingLicense DrivingLicense
	Valid          bool // Valid is true if DrivingLicense is not NULL
}

type NullSensorStatus struct {
	SensorStatus SensorStatus
	Valid        bool // Valid is true if SensorStatus is not NULL
}

type NullTreeSoilCondition struct {
	TreeSoilCondition TreeSoilCondition
	Valid             bool // Valid is true if TreeSoilCondition is not NULL
}

type NullVehicleStatus struct {
	VehicleStatus VehicleStatus
	Valid         bool // Valid is true if VehicleStatus is not NULL
}

type NullVehicleType struct {
	VehicleType VehicleType
	Valid       bool // Valid is true if VehicleType is not NULL
}

type NullWateringPlanStatus struct {
	WateringPlanStatus WateringPlanStatus
	Valid              bool // Valid is true if WateringPlanStatus is not NULL
}

type NullWateringStatus struct {
	WateringStatus WateringStatus
	Valid          bool // Valid is true if WateringStatus is not NULL
}

type Querier interface {
	ArchiveTreeCluster(ctx context.Context, id int32) (int32, error)
	ArchiveVehicle(ctx context.Context, arg *ArchiveVehicleParams) (int32, error)
	CalculateGroupedCentroids(ctx context.Context, dollar_1 []int32) (string, error)
	CalculateTreesCentroid(ctx context.Context, treeClusterID *int32) (string, error)
	CreateRegion(ctx context.Context, arg *CreateRegionParams) (int32, error)
	CreateSensor(ctx context.Context, arg *CreateSensorParams) (string, error)
	CreateTree(ctx context.Context, arg *CreateTreeParams) (int32, error)
	CreateTreeCluster(ctx context.Context, arg *CreateTreeClusterParams) (int32, error)
	CreateVehicle(ctx context.Context, arg *CreateVehicleParams) (int32, error)
	CreateWateringPlan(ctx context.Context, arg *CreateWateringPlanParams) (int32, error)
	DeleteAllTreeClusterFromWateringPlan(ctx context.Context, wateringPlanID int32) error
	DeleteAllUsersFromWateringPlan(ctx context.Context, wateringPlanID int32) error
	DeleteAllVehiclesFromWateringPlan(ctx context.Context, wateringPlanID int32) error
	DeleteRegion(ctx context.Context, id int32) error
	DeleteSensor(ctx context.Context, id string) error
	DeleteTree(ctx context.Context, id int32) (int32, error)
	DeleteTreeCluster(ctx context.Context, id int32) (int32, error)
	DeleteVehicle(ctx context.Context, id int32) (int32, error)
	DeleteWateringPlan(ctx context.Context, id int32) (int32, error)
	FindNearestTree(ctx context.Context, arg *FindNearestTreeParams) (*Tree, error)
	GetAllArchivedVehicles(ctx context.Context) ([]*Vehicle, error)
	GetAllLatestSensorDataByTreeClusterID(ctx context.Context, id int32) ([]*SensorDatum, error)
	GetAllRegions(ctx context.Context, arg *GetAllRegionsParams) ([]*Region, error)
	GetAllRegionsCount(ctx context.Context) (int64, error)
	GetAllSensorDataByID(ctx context.Context, sensorID string) ([]*SensorDatum, error)
	GetAllSensors(ctx context.Context, arg *GetAllSensorsParams) ([]*Sensor, error)
	GetAllSensorsCount(ctx context.Context, provider interface{}) (int64, error)
	GetAllTreeClusterRegionsWithWateringPlanCount(ctx context.Context) ([]*GetAllTreeClusterRegionsWithWateringPlanCountRow, error)
	GetAllTreeClusterWateringPlanByID(ctx context.Context, wateringPlanID int32) ([]*TreeClusterWateringPlan, error)
	GetAllTreeClusters(ctx context.Context, arg *GetAllTreeClustersParams) ([]*TreeCluster, error)
	GetAllTrees(ctx context.Context, arg *GetAllTreesParams) ([]*Tree, error)
	GetAllTreesCount(ctx context.Context, arg *GetAllTreesCountParams) (int64, error)
	GetAllUserWateringPlanCount(ctx context.Context) (int64, error)
	GetAllVehicles(ctx context.Context, arg *GetAllVehiclesParams) ([]*Vehicle, error)
	GetAllVehiclesByType(ctx context.Context, arg *GetAllVehiclesByTypeParams) ([]*Vehicle, error)
	GetAllVehiclesByTypeCount(ctx context.Context, arg *GetAllVehiclesByTypeCountParams) (int64, error)
	GetAllVehiclesByTypeWithArchived(ctx context.Context, arg *GetAllVehiclesByTypeWithArchivedParams) ([]*Vehicle, error)
	GetAllVehiclesByTypeWithArchivedCount(ctx context.Context, arg *GetAllVehiclesByTypeWithArchivedCountParams) (int64, error)
	GetAllVehiclesCount(ctx context.Context, provider interface{}) (int64, error)
	GetAllVehiclesWithArchived(ctx context.Context, arg *GetAllVehiclesWithArchivedParams) ([]*Vehicle, error)
	GetAllVehiclesWithArchivedCount(ctx context.Context, provider interface{}) (int64, error)
	GetAllVehiclesWithWateringPlanCount(ctx context.Context) ([]*GetAllVehiclesWithWateringPlanCountRow, error)
	GetAllWateringPlans(ctx context.Context, arg *GetAllWateringPlansParams) ([]*WateringPlan, error)
	GetAllWateringPlansCount(ctx context.Context, provider interface{}) (int64, error)
	GetLatestSensorDataByID(ctx context.Context, sensorID string) (*SensorDatum, error)
	GetLinkedTreesByTreeClusterID(ctx context.Context, id int32) ([]*Tree, error)
	GetRegionById(ctx context.Context, id int32) (*Region, error)
	GetRegionByName(ctx context.Context, name string) (*Region, error)
	GetRegionByPoint(ctx context.Context, stGeomfromtext interface{}) (*Region, error)
	GetRegionByTreeClusterID(ctx context.Context, id int32) (*Region, error)
	GetSensorByID(ctx context.Context, id string) (*Sensor, error)
	GetSensorByStatus(ctx context.Context, status SensorStatus) ([]*Sensor, error)
	GetSensorByTreeID(ctx context.Context, id int32) (*Sensor, error)
	GetTotalConsumedWater(ctx context.Context) (int64, error)
	GetTreeByCoordinates(ctx context.Context, arg *GetTreeByCoordinatesParams) (*Tree, error)
	GetTreeByID(ctx context.Context, id int32) (*Tree, error)
	GetTreeBySensorID(ctx context.Context, sensorID *string) (*Tree, error)
	GetTreeClusterByID(ctx context.Context, id int32) (*TreeCluster, error)
	GetTreeClusterByTreeID(ctx context.Context, id int32) (*TreeCluster, error)
	GetTreeClustersByWateringPlanID(ctx context.Context, wateringPlanID int32) ([]*TreeCluster, error)
	GetTreeClustersCount(ctx context.Context, arg *GetTreeClustersCountParams) (int64, error)
	GetTreesByIDs(ctx context.Context, dollar_1 []int32) ([]*Tree, error)
	GetTreesBySensorIDs(ctx context.Context, dollar_1 []string) ([]*Tree, error)
	GetTreesByTreeClusterID(ctx context.Context, treeClusterID *int32) ([]*Tree, error)
	GetTreesClustersByIDs(ctx context.Context, dollar_1 []int32) ([]*TreeCluster, error)
	GetUsersByWateringPlanID(ctx context.Context, wateringPlanID int32) ([]uuid.UUID, error)
	GetVehicleByID(ctx context.Context, id int32) (*Vehicle, error)
	GetVehicleByPlate(ctx context.Context, numberPlate string) (*Vehicle, error)
	GetVehicleByWateringPlanID(ctx context.Context, arg *GetVehicleByWateringPlanIDParams) (*Vehicle, error)
	GetWateringPlanByID(ctx context.Context, id int32) (*WateringPlan, error)
	InsertSensorData(ctx context.Context, arg *InsertSensorDataParams) error
	LinkTreesToTreeCluster(ctx context.Context, arg *LinkTreesToTreeClusterParams) error
	RemoveTreeClusterLocation(ctx context.Context, id int32) error
	SetSensorLocation(ctx context.Context, arg *SetSensorLocationParams) error
	SetTreeClusterLocation(ctx context.Context, arg *SetTreeClusterLocationParams) error
	SetTreeClusterToWateringPlan(ctx context.Context, arg *SetTreeClusterToWateringPlanParams) error
	SetTreeLocation(ctx context.Context, arg *SetTreeLocationParams) error
	SetUserToWateringPlan(ctx context.Context, arg *SetUserToWateringPlanParams) error
	SetVehicleToWateringPlan(ctx context.Context, arg *SetVehicleToWateringPlanParams) error
	UnlinkSensorIDFromTrees(ctx context.Context, sensorID *string) error
	UnlinkTreeClusterID(ctx context.Context, treeClusterID *int32) ([]int32, error)
	UpdateRegion(ctx context.Context, arg *UpdateRegionParams) error
	UpdateSensor(ctx context.Context, arg *UpdateSensorParams) error
	UpdateTree(ctx context.Context, arg *UpdateTreeParams) error
	UpdateTreeCluster(ctx context.Context, arg *UpdateTreeClusterParams) error
	UpdateTreeClusterID(ctx context.Context, arg *UpdateTreeClusterIDParams) error
	UpdateTreeClusterWateringPlan(ctx context.Context, arg *UpdateTreeClusterWateringPlanParams) error
	UpdateTreeGeometry(ctx context.Context, arg *UpdateTreeGeometryParams) error
	UpdateVehicle(ctx context.Context, arg *UpdateVehicleParams) error
	UpdateWateringPlan(ctx context.Context, arg *UpdateWateringPlanParams) error
}

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

type Region struct {
	ID        int32
	Name      string
	CreatedAt time.Time
	UpdatedAt time.Time
	Geometry  *geos.Geom
}

type Sensor struct {
	ID                     string
	CreatedAt              time.Time
	UpdatedAt              time.Time
	Status                 SensorStatus
	Latitude               float64
	Longitude              float64
	Geometry               *geos.Geom
	Provider               *string
	AdditionalInformations []byte
}

type SensorDatum struct {
	ID        int32
	CreatedAt time.Time
	UpdatedAt time.Time
	Data      []byte
	SensorID  string
}

type SensorStatus string

type SetSensorLocationParams struct {
	ID        string
	Latitude  float64
	Longitude float64
}

type SetTreeClusterLocationParams struct {
	ID        int32
	Latitude  *float64
	Longitude *float64
}

type SetTreeClusterToWateringPlanParams struct {
	TreeClusterID  int32
	WateringPlanID int32
}

type SetTreeLocationParams struct {
	ID        int32
	Latitude  float64
	Longitude float64
}

type SetUserToWateringPlanParams struct {
	UserID         uuid.UUID
	WateringPlanID int32
}

type SetVehicleToWateringPlanParams struct {
	VehicleID      int32
	WateringPlanID int32
}

type Tree struct {
	ID                     int32
	CreatedAt              time.Time
	UpdatedAt              time.Time
	TreeClusterID          *int32
	SensorID               *string
	PlantingYear           int32
	Species                string
	Number                 string
	Latitude               float64
	Longitude              float64
	WateringStatus         WateringStatus
	Geometry               *geos.Geom
	Description            *string
	Provider               *string
	AdditionalInformations []byte
	LastWatered            *time.Time
}

type TreeCluster struct {
	ID                     int32
	CreatedAt              time.Time
	UpdatedAt              time.Time
	WateringStatus         WateringStatus
	LastWatered            *time.Time
	MoistureLevel          float64
	Address                string
	Description            string
	Archived               bool
	SoilCondition          TreeSoilCondition
	Latitude               *float64
	Longitude              *float64
	Geometry               *geos.Geom
	RegionID               *int32
	Name                   string
	Provider               *string
	AdditionalInformations []byte
}

type TreeClusterWateringPlan struct {
	TreeClusterID  int32
	WateringPlanID int32
	ConsumedWater  float64
}

type TreeSoilCondition string

type UpdateRegionParams struct {
	ID             int32
	Name           string
	StGeomfromtext interface{}
}

type UpdateSensorParams struct {
	ID                     string
	Status                 SensorStatus
	Provider               *string
	AdditionalInformations []byte
}

type UpdateTreeClusterIDParams struct {
	Column1       []int32
	TreeClusterID *int32
}

type UpdateTreeClusterParams struct {
	ID                     int32
	Name                   string
	RegionID               *int32
	Address                string
	Description            string
	MoistureLevel          float64
	WateringStatus         WateringStatus
	SoilCondition          TreeSoilCondition
	LastWatered            *time.Time
	Archived               bool
	Provider               *string
	AdditionalInformations []byte
}

type UpdateTreeClusterWateringPlanParams struct {
	WateringPlanID int32
	TreeClusterID  int32
	ConsumedWater  float64
}

type UpdateTreeGeometryParams struct {
	ID             int32
	StGeomfromtext interface{}
}

type UpdateTreeParams struct {
	ID                     int32
	TreeClusterID          *int32
	SensorID               *string
	PlantingYear           int32
	Species                string
	Number                 string
	WateringStatus         WateringStatus
	Description            *string
	Provider               *string
	AdditionalInformations []byte
	LastWatered            *time.Time
}

type UpdateVehicleParams struct {
	ID                     int32
	NumberPlate            string
	Description            string
	WaterCapacity          float64
	Type                   VehicleType
	Status                 VehicleStatus
	Model                  string
	DrivingLicense         DrivingLicense
	Height                 float64
	Length                 float64
	Width                  float64
	Weight                 float64
	Provider               *string
	AdditionalInformations []byte
}

type UpdateWateringPlanParams struct {
	ID                     int32
	Date                   time.Time
	Description            string
	Status                 WateringPlanStatus
	Distance               *float64
	TotalWaterRequired     *float64
	CancellationNote       string
	GpxUrl                 *string
	Duration               float64
	RefillCount            int32
	Provider               *string
	AdditionalInformations []byte
}

type UserWateringPlan struct {
	UserID         uuid.UUID
	WateringPlanID int32
}

type Vehicle struct {
	ID                     int32
	CreatedAt              time.Time
	UpdatedAt              time.Time
	NumberPlate            string
	Description            string
	WaterCapacity          float64
	Type                   VehicleType
	Status                 VehicleStatus
	Model                  string
	DrivingLicense         DrivingLicense
	Height                 float64
	Length                 float64
	Width                  float64
	Weight                 float64
	Provider               *string
	AdditionalInformations []byte
	ArchivedAt             *time.Time
}

type VehicleStatus string

type VehicleType string

type VehicleWateringPlan struct {
	VehicleID      int32
	WateringPlanID int32
}

type WateringPlan struct {
	ID                     int32
	CreatedAt              time.Time
	UpdatedAt              time.Time
	Date                   time.Time
	Description            string
	Status                 WateringPlanStatus
	Distance               *float64
	TotalWaterRequired     *float64
	CancellationNote       string
	GpxUrl                 *string
	RefillCount            int32
	Duration               float64
	Provider               *string
	AdditionalInformations []byte
}

type WateringPlanStatus string

type WateringStatus string