sqlc

type Account struct {
	ID        uuid.UUID     `json:"id"`
	OwnerID   uuid.NullUUID `json:"owner_id"`
	Name      string        `json:"name"`
	Balance   string        `json:"balance"`
	Currency  string        `json:"currency"`
	IsSystem  bool          `json:"is_system"`
	CreatedAt sql.NullTime  `json:"created_at"`
}

type CreateAccountParams struct {
	OwnerID  uuid.NullUUID `json:"owner_id"`
	Name     string        `json:"name"`
	Currency string        `json:"currency"`
	IsSystem bool          `json:"is_system"`
}

type CreateEntryParams struct {
	AccountID     uuid.UUID      `json:"account_id"`
	Debit         string         `json:"debit"`
	Credit        string         `json:"credit"`
	TransactionID uuid.UUID      `json:"transaction_id"`
	OperationType OperationType  `json:"operation_type"`
	Description   sql.NullString `json:"description"`
}

type CreateUserParams struct {
	Email          string `json:"email"`
	HashedPassword string `json:"hashed_password"`
}

type CreateUserRow struct {
	ID        uuid.UUID    `json:"id"`
	Email     string       `json:"email"`
	CreatedAt sql.NullTime `json:"created_at"`
}

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 Entry struct {
	ID            uuid.UUID      `json:"id"`
	AccountID     uuid.UUID      `json:"account_id"`
	Debit         string         `json:"debit"`
	Credit        string         `json:"credit"`
	TransactionID uuid.UUID      `json:"transaction_id"`
	OperationType OperationType  `json:"operation_type"`
	Description   sql.NullString `json:"description"`
	CreatedAt     sql.NullTime   `json:"created_at"`
}

type ListEntriesByAccountParams struct {
	AccountID uuid.UUID `json:"account_id"`
	Limit     int32     `json:"limit"`
	Offset    int32     `json:"offset"`
}

type NullOperationType struct {
	OperationType OperationType `json:"operation_type"`
	Valid         bool          `json:"valid"` // Valid is true if OperationType is not NULL
}

type OperationType string

type Querier interface {
	CreateAccount(ctx context.Context, arg CreateAccountParams) (Account, error)
	CreateEntry(ctx context.Context, arg CreateEntryParams) (Entry, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (CreateUserRow, error)
	GetAccount(ctx context.Context, id uuid.UUID) (Account, error)
	// lock prevents concurrent transactions from reading a stale balance.
	GetAccountBalance(ctx context.Context, accountID uuid.UUID) (string, error)
	GetAccountForUpdate(ctx context.Context, id uuid.UUID) (Account, error)
	GetSettlementAccount(ctx context.Context) (Account, error)
	GetSettlementAccountForUpdate(ctx context.Context) (Account, error)
	GetUserByEmail(ctx context.Context, email string) (User, error)
	// locks row for update, prevents TOCTOU races
	ListAccountsByOwner(ctx context.Context, ownerID uuid.NullUUID) ([]Account, error)
	ListEntriesByAccount(ctx context.Context, arg ListEntriesByAccountParams) ([]Entry, error)
	ListEntriesByTransaction(ctx context.Context, transactionID uuid.UUID) ([]Entry, error)
	UpdateAccountBalance(ctx context.Context, arg UpdateAccountBalanceParams) error
}

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

type UpdateAccountBalanceParams struct {
	Balance string    `json:"balance"`
	ID      uuid.UUID `json:"id"`
}

type User struct {
	ID             uuid.UUID    `json:"id"`
	Email          string       `json:"email"`
	HashedPassword string       `json:"hashed_password"`
	CreatedAt      sql.NullTime `json:"created_at"`
}