db

type Admin struct {
	ID        uuid.UUID `json:"id"`
	AuthID    uuid.UUID `json:"auth_id"`
	Username  string    `json:"username"`
	FullName  string    `json:"full_name"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type AdminTxResult struct {
	Auth  Auth
	Admin Admin
}

type Auth struct {
	ID                uuid.UUID    `json:"id"`
	Email             string       `json:"email"`
	HarshedPassword   string       `json:"harshed_password"`
	PasswordChangedAt time.Time    `json:"password_changed_at"`
	CreatedAt         time.Time    `json:"created_at"`
	UpdatedAt         time.Time    `json:"updated_at"`
	Restricted        bool         `json:"restricted"`
	Deleted           bool         `json:"deleted"`
	Role              NullRoleType `json:"role"`
}

type CreateAdminAuthParams struct {
	ID              uuid.UUID `json:"id"`
	Email           string    `json:"email"`
	HarshedPassword string    `json:"harshed_password"`
}

type CreateAdminParams struct {
	ID       uuid.UUID `json:"id"`
	AuthID   uuid.UUID `json:"auth_id"`
	Username string    `json:"username"`
	FullName string    `json:"full_name"`
}

type CreateAdminTxParams struct {
	CreateAdminAuthParams CreateAdminAuthParams
	CreateAdminParams     CreateAdminParams
}

type CreateAuthParams struct {
	ID              uuid.UUID `json:"id"`
	Email           string    `json:"email"`
	HarshedPassword string    `json:"harshed_password"`
}

type CreateUserParams struct {
	ID       uuid.UUID `json:"id"`
	AuthID   uuid.UUID `json:"auth_id"`
	Username string    `json:"username"`
	FullName string    `json:"full_name"`
}

type CreateUserTxParams struct {
	CreateAuthParams CreateAuthParams
	CreateUserParams CreateUserParams
}

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

type DeleteAuthParams struct {
	ID        uuid.UUID `json:"id"`
	UpdatedAt time.Time `json:"updated_at"`
}

type GetAdminRow struct {
	ID        uuid.UUID `json:"id"`
	Username  string    `json:"username"`
	FullName  string    `json:"full_name"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type GetAuthRow struct {
	ID         uuid.UUID    `json:"id"`
	Email      string       `json:"email"`
	Role       NullRoleType `json:"role"`
	Restricted bool         `json:"restricted"`
	Deleted    bool         `json:"deleted"`
	CreatedAt  time.Time    `json:"created_at"`
	UpdatedAt  time.Time    `json:"updated_at"`
}

type GetUserRow struct {
	ID        uuid.UUID `json:"id"`
	Username  string    `json:"username"`
	FullName  string    `json:"full_name"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type NullRoleType struct {
	RoleType RoleType `json:"role_type"`
	Valid    bool     `json:"valid"` // Valid is true if RoleType is not NULL
}

type Querier interface {
	CreateAdmin(ctx context.Context, arg CreateAdminParams) (Admin, error)
	CreateAdminAuth(ctx context.Context, arg CreateAdminAuthParams) (Auth, error)
	CreateAuth(ctx context.Context, arg CreateAuthParams) (Auth, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
	DeleteAdmin(ctx context.Context, id uuid.UUID) error
	DeleteAuth(ctx context.Context, arg DeleteAuthParams) error
	DeleteUser(ctx context.Context, id uuid.UUID) error
	DeleteUserAuthCron(ctx context.Context, limit int32) ([]Auth, error)
	GetAdmin(ctx context.Context, authID uuid.UUID) (GetAdminRow, error)
	GetAuth(ctx context.Context, id uuid.UUID) (GetAuthRow, error)
	GetDeletedUsers(ctx context.Context) (int64, error)
	GetUser(ctx context.Context, authID uuid.UUID) (GetUserRow, error)
	RestrictAuth(ctx context.Context, arg RestrictAuthParams) error
	UpdateAdmin(ctx context.Context, arg UpdateAdminParams) (Admin, error)
	UpdateAuth(ctx context.Context, arg UpdateAuthParams) (Auth, error)
	UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error)
	ValidateAuth(ctx context.Context, email string) (Auth, error)
}

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

type RestrictAuthParams struct {
	ID        uuid.UUID `json:"id"`
	UpdatedAt time.Time `json:"updated_at"`
}

type RoleType string

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

type Store interface {
	Querier
	CreateUserTx(ctx context.Context, arg CreateUserTxParams) (UserTxResult, error)
	UpdateUserTx(ctx context.Context, arg UpdateUserTxParams) (UserTxResult, error)
	DeleteUserTx(ctx context.Context, authID uuid.UUID, userID uuid.UUID) error
	CreateAdminTx(ctx context.Context, arg CreateAdminTxParams) (AdminTxResult, error)
	UpdateAdminTx(ctx context.Context, arg UpdateAdminTxParams) (AdminTxResult, error)
	DeleteAdminTx(ctx context.Context, authID uuid.UUID, adminID uuid.UUID) error
	DeleteExpDeletedUserRecords(ctx context.Context, batchSize int) (totalDeleted int, err error)
}

type UpdateAdminParams struct {
	Username  sql.NullString `json:"username"`
	FullName  sql.NullString `json:"full_name"`
	UpdatedAt time.Time      `json:"updated_at"`
	ID        uuid.UUID      `json:"id"`
}

type UpdateAdminTxParams struct {
	UpdateAuthParams  UpdateAuthParams
	UpdateAdminParams UpdateAdminParams
}

type UpdateAuthParams struct {
	Email             sql.NullString `json:"email"`
	HarshedPassword   sql.NullString `json:"harshed_password"`
	PasswordChangedAt sql.NullTime   `json:"password_changed_at"`
	UpdatedAt         time.Time      `json:"updated_at"`
	ID                uuid.UUID      `json:"id"`
}

type UpdateUserParams struct {
	Username  sql.NullString `json:"username"`
	FullName  sql.NullString `json:"full_name"`
	UpdatedAt time.Time      `json:"updated_at"`
	ID        uuid.UUID      `json:"id"`
}

type UpdateUserTxParams struct {
	UpdateAuthParams UpdateAuthParams
	UpdateUserParams UpdateUserParams
}

type User struct {
	ID        uuid.UUID `json:"id"`
	AuthID    uuid.UUID `json:"auth_id"`
	Username  string    `json:"username"`
	FullName  string    `json:"full_name"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type UserTxResult struct {
	Auth Auth
	User User
}