spinusdb

type CreateMainMeterParams struct {
	MeterID string
	Energy  Energy
	Address string
	FkUser  int32
}

type CreateMainMeterReadingParams struct {
	FkMainMeter  int32
	ReadingValue float64
	ReadingDate  pgtype.Date
}

type CreateSubMeterParams struct {
	FkMainMeter int32
	MeterID     pgtype.Text
	FkUser      int32
}

type CreateSubMeterReadingParams struct {
	FkSubMeter   int32
	ReadingValue float64
	ReadingDate  pgtype.Date
}

type CreateUserParams struct {
	Username string
	Email    string
	Crypt    string
}

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 Energy string

type GetMainMeterRow struct {
	ID      int32
	MeterID string
	Energy  Energy
	Address string
	FkUser  int32
	Email   string
}

type GetSubMeterParams struct {
	FkMainMeter int32
	Subid       int32
}

type GetSubMeterRow struct {
	ID            int32
	MainMeterID   int32
	Subid         int32
	SubMeterID    pgtype.Text
	SubUserID     int32
	SubUserEmail  string
	Address       string
	MainUserID    int32
	MainUserEmail string
}

type GetUserParams struct {
	Username string
	Crypt    string
}

type ListSubMetersRow struct {
	Subid   int32
	MeterID pgtype.Text
	Email   string
}

type MainMeter struct {
	ID      int32
	MeterID string
	Energy  Energy
	Address string
	FkUser  int32
}

type MainMeterReading struct {
	ID           int32
	FkMainMeter  int32
	Subid        int32
	ReadingValue float64
	ReadingDate  pgtype.Date
}

type NullEnergy struct {
	Energy Energy
	Valid  bool // Valid is true if Energy is not NULL
}

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

type SpinusUser struct {
	ID       int32
	Username string
	Email    string
	Password string
}

type SubMeter struct {
	ID          int32
	FkMainMeter int32
	Subid       int32
	MeterID     pgtype.Text
	FkUser      int32
}

type SubMeterReading struct {
	ID           int32
	FkSubMeter   int32
	Subid        int32
	ReadingValue float64
	ReadingDate  pgtype.Date
}

type UpdateMainMeterParams struct {
	ID      int32
	MeterID string
	Energy  Energy
	Address string
	FkUser  int32
}