db

type Account struct {
	AccountID   uuid.UUID      `json:"account_id"`
	AccountName string         `json:"account_name"`
	Dob         time.Time      `json:"dob"`
	Address     sql.NullString `json:"address"`
	Status      sql.NullString `json:"status"`
	Description sql.NullString `json:"description"`
	CreatedAt   sql.NullTime   `json:"created_at"`
	CreatedBy   uuid.UUID      `json:"created_by"`
}

type CreateAccountParams struct {
	AccountName string         `json:"account_name"`
	Dob         time.Time      `json:"dob"`
	Address     sql.NullString `json:"address"`
	Description sql.NullString `json:"description"`
	CreatedBy   uuid.UUID      `json:"created_by"`
}

type CreateUserParams struct {
	FirstName string         `json:"first_name"`
	LastName  sql.NullString `json:"last_name"`
	Email     string         `json:"email"`
	Password  string         `json:"password"`
}

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 DeleteAccountParams struct {
	AccountID uuid.UUID `json:"account_id"`
	CreatedBy uuid.UUID `json:"created_by"`
}

type FindUserRow struct {
	UserID   uuid.UUID `json:"user_id"`
	Email    string    `json:"email"`
	Password string    `json:"password"`
}

type NullRelationStatus struct {
	RelationStatus RelationStatus
	Valid          bool // Valid is true if String is not NULL
}

type Querier interface {
	CreateAccount(ctx context.Context, arg CreateAccountParams) (uuid.UUID, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
	DeleteAccount(ctx context.Context, arg DeleteAccountParams) error
	FindUser(ctx context.Context, lower string) (FindUserRow, error)
	ReadAccount(ctx context.Context, arg ReadAccountParams) (ReadAccountRow, error)
	ReadAllAccount(ctx context.Context, arg ReadAllAccountParams) ([]ReadAllAccountRow, error)
	UpdateAccount(ctx context.Context, arg UpdateAccountParams) (uuid.UUID, error)
}

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

type ReadAccountParams struct {
	AccountID uuid.UUID `json:"account_id"`
	CreatedBy uuid.UUID `json:"created_by"`
}

type ReadAccountRow struct {
	AccountID   uuid.UUID      `json:"account_id"`
	AccountName string         `json:"account_name"`
	Dob         time.Time      `json:"dob"`
	Address     sql.NullString `json:"address"`
	Description sql.NullString `json:"description"`
	CreatedAt   sql.NullTime   `json:"created_at"`
}

type ReadAllAccountParams struct {
	CreatedBy uuid.UUID `json:"created_by"`
	Offset    int32     `json:"offset"`
	Limit     int32     `json:"limit"`
}

type ReadAllAccountRow struct {
	AccountID   uuid.UUID      `json:"account_id"`
	AccountName string         `json:"account_name"`
	Dob         time.Time      `json:"dob"`
	Address     sql.NullString `json:"address"`
	Description sql.NullString `json:"description"`
	CreatedAt   sql.NullTime   `json:"created_at"`
}

type Relation struct {
	ObserverID uuid.UUID      `json:"observer_id"`
	ObservedID uuid.UUID      `json:"observed_id"`
	Status     RelationStatus `json:"status"`
}

type RelationStatus string

type UpdateAccountParams struct {
	AccountName string         `json:"account_name"`
	Dob         time.Time      `json:"dob"`
	Address     sql.NullString `json:"address"`
	Description sql.NullString `json:"description"`
	AccountID   uuid.UUID      `json:"account_id"`
	CreatedBy   uuid.UUID      `json:"created_by"`
}

type User struct {
	UserID    uuid.UUID      `json:"user_id"`
	FirstName string         `json:"first_name"`
	LastName  sql.NullString `json:"last_name"`
	Email     string         `json:"email"`
	Password  string         `json:"password"`
	CreatedAt sql.NullTime   `json:"created_at"`
	UpdatedAt sql.NullTime   `json:"updated_at"`
}