db

type DB interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row

	QueryxContext(context.Context, string, ...interface{}) (*sqlx.Rows, error)
	QueryRowxContext(context.Context, string, ...interface{}) *sqlx.Row
}

type ErrInsertFailed struct {
	Err error
}

type ErrUpdateFailed struct {
	Err error
}

type ErrUpsertFailed struct {
	Err error
}

type Error string

type GooseDbVersionIDT = int

type GooseDbVersionIsAppliedT = bool

type GooseDbVersionModel struct {
	ID        int       `json:"id" db:"id"`
	VersionID int64     `json:"version_id" db:"version_id"`
	IsApplied bool      `json:"is_applied" db:"is_applied"`
	Tstamp    time.Time `json:"tstamp" db:"tstamp"`
}

type GooseDbVersionTable struct {
	sqli.Table
	ID        sqli.Column[int]
	VersionID sqli.Column[int64]
	IsApplied sqli.Column[bool]
	Tstamp    sqli.Column[time.Time]
}

type GooseDbVersionTstampT = time.Time

type GooseDbVersionVersionIDT = int64

type InsertIntoOfficeUserReturningOfficeIDUserIDResult struct {
	OfficeID uuid.UUID `json:"office_id" db:"office_id"`
	UserID   uuid.UUID `json:"user_id" db:"user_id"`
}

type InsertableGooseDbVersionModel struct {
	VersionID int64     `json:"version_id" db:"version_id"`
	IsApplied bool      `json:"is_applied" db:"is_applied"`
	Tstamp    time.Time `json:"tstamp" db:"tstamp"`
}

type InsertableOfficeModel struct {
	ID        uuid.UUID    `json:"id" db:"id"`
	Name      string       `json:"name" db:"name"`
	CreatedAt time.Time    `json:"created_at" db:"created_at"`
	UpdatedAt sql.NullTime `json:"updated_at" db:"updated_at"`
}

type InsertableOfficeUserModel struct {
	OfficeID  uuid.UUID    `json:"office_id" db:"office_id"`
	UserID    uuid.UUID    `json:"user_id" db:"user_id"`
	CreatedAt time.Time    `json:"created_at" db:"created_at"`
	UpdatedAt sql.NullTime `json:"updated_at" db:"updated_at"`
}

type InsertableUserModel struct {
	ID        uuid.UUID    `json:"id" db:"id"`
	Name      string       `json:"name" db:"name"`
	Email     string       `json:"email" db:"email"`
	Password  string       `json:"password" db:"password"`
	CreatedAt time.Time    `json:"created_at" db:"created_at"`
	UpdatedAt sql.NullTime `json:"updated_at" db:"updated_at"`
	Role      string       `json:"role" db:"role"`
}

type OfficeCreatedAtT = time.Time

type OfficeIDT = uuid.UUID

type OfficeModel struct {
	ID        uuid.UUID    `json:"id" db:"id"`
	Name      string       `json:"name" db:"name"`
	CreatedAt time.Time    `json:"created_at" db:"created_at"`
	UpdatedAt sql.NullTime `json:"updated_at" db:"updated_at"`
}

type OfficeNameT = string

type OfficeTable struct {
	sqli.Table
	ID        sqli.Column[uuid.UUID]
	Name      sqli.Column[string]
	CreatedAt sqli.Column[time.Time]
	UpdatedAt sqli.Column[sql.NullTime]
}

type OfficeUpdatedAtT = sql.NullTime

type OfficeUserCreatedAtT = time.Time

type OfficeUserModel struct {
	OfficeID  uuid.UUID    `json:"office_id" db:"office_id"`
	UserID    uuid.UUID    `json:"user_id" db:"user_id"`
	CreatedAt time.Time    `json:"created_at" db:"created_at"`
	UpdatedAt sql.NullTime `json:"updated_at" db:"updated_at"`
}

type OfficeUserOfficeIDT = uuid.UUID

type OfficeUserTable struct {
	sqli.Table
	OfficeID  sqli.Column[uuid.UUID]
	UserID    sqli.Column[uuid.UUID]
	CreatedAt sqli.Column[time.Time]
	UpdatedAt sqli.Column[sql.NullTime]
}

type OfficeUserUpdatedAtT = sql.NullTime

type OfficeUserUserIDT = uuid.UUID

type TablesSt struct {
	GooseDbVersion string `json:"goose_db_version" db:"goose_db_version"`
	Office         string `json:"office" db:"office"`
	OfficeUser     string `json:"office_user" db:"office_user"`
	User           string `json:"user" db:"user"`
}

type UpdatableGooseDbVersionModel struct {
	ID        *int       `json:"id" db:"id"`
	VersionID *int64     `json:"version_id" db:"version_id"`
	IsApplied *bool      `json:"is_applied" db:"is_applied"`
	Tstamp    *time.Time `json:"tstamp" db:"tstamp"`
}

type UpdatableOfficeModel struct {
	ID        *uuid.UUID    `json:"id" db:"id"`
	Name      *string       `json:"name" db:"name"`
	CreatedAt *time.Time    `json:"created_at" db:"created_at"`
	UpdatedAt *sql.NullTime `json:"updated_at" db:"updated_at"`
}

type UpdatableOfficeUserModel struct {
	OfficeID  *uuid.UUID    `json:"office_id" db:"office_id"`
	UserID    *uuid.UUID    `json:"user_id" db:"user_id"`
	CreatedAt *time.Time    `json:"created_at" db:"created_at"`
	UpdatedAt *sql.NullTime `json:"updated_at" db:"updated_at"`
}

type UpdatableUserModel struct {
	ID        *uuid.UUID    `json:"id" db:"id"`
	Name      *string       `json:"name" db:"name"`
	Email     *string       `json:"email" db:"email"`
	Password  *string       `json:"password" db:"password"`
	CreatedAt *time.Time    `json:"created_at" db:"created_at"`
	UpdatedAt *sql.NullTime `json:"updated_at" db:"updated_at"`
	Role      *string       `json:"role" db:"role"`
}

type UserCreatedAtT = time.Time

type UserEmailT = string

type UserIDT = uuid.UUID

type UserModel struct {
	ID        uuid.UUID    `json:"id" db:"id"`
	Name      string       `json:"name" db:"name"`
	Email     string       `json:"email" db:"email"`
	Password  string       `json:"password" db:"password"`
	CreatedAt time.Time    `json:"created_at" db:"created_at"`
	UpdatedAt sql.NullTime `json:"updated_at" db:"updated_at"`
	Role      string       `json:"role" db:"role"`
}

type UserNameT = string

type UserPasswordT = string

type UserRoleT = string

type UserTable struct {
	sqli.Table
	ID        sqli.Column[uuid.UUID]
	Name      sqli.Column[string]
	Email     sqli.Column[string]
	Password  sqli.Column[string]
	CreatedAt sqli.Column[time.Time]
	UpdatedAt sqli.Column[sql.NullTime]
	Role      sqli.Column[string]
}

type UserUpdatedAtT = sql.NullTime