models

type DBQuerier interface {
	Querier
	DB() *sql.DB
	BeginTx(ctx context.Context, opts *sql.TxOptions) (*sql.Tx, error)
}

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

type Querier interface {
	Count(ctx context.Context) (int64, error)
	CountMany(ctx context.Context, isActive bool, isAdministrator bool) (int64, error)
	CreateUser(ctx context.Context, email string, username string, password string, firstName string, lastName string, isAdministrator bool, isActive bool) (int64, error)
	DeleteUser(ctx context.Context, id uint64) error
	Retrieve(ctx context.Context, limit int32, offset int32) ([]*User, error)
	RetrieveByEmail(ctx context.Context, email string) (*User, error)
	RetrieveByID(ctx context.Context, id uint64) (*User, error)
	RetrieveByUsername(ctx context.Context, username string) (*User, error)
	RetrieveMany(ctx context.Context, isActive bool, isAdministrator bool, limit int32, offset int32) ([]*User, error)
	UpdateUser(ctx context.Context, email string, username string, password string, firstName string, lastName string, isAdministrator bool, isActive bool, iD uint64) error
	WithTx(tx *sql.Tx) Querier
	Close() error
}

type User struct {
	ID              uint64        `json:"id" attrs:"primary;readonly"`
	CreatedAt       time.Time     `json:"created_at" attrs:"readonly"`
	UpdatedAt       time.Time     `json:"updated_at" attrs:"readonly"`
	Email           *models.Email `json:"email"`
	Username        string        `json:"username"`
	Password        Password      `json:"password"`
	FirstName       string        `json:"first_name"`
	LastName        string        `json:"last_name"`
	IsAdministrator bool          `json:"is_administrator" attrs:"blank;default=true"`
	IsActive        bool          `json:"is_active" attrs:"blank;default=true"`
	IsLoggedIn      bool          `json:"is_logged_in"`
}