database

package
v1.0.1 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Aug 23, 2025 License: MIT Imports: 2 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Account

type Account struct {
	ID               string
	CreatedAt        string
	UpdatedAt        string
	Name             string
	Type             string
	Subtype          sql.NullString
	Mask             sql.NullString
	OfficialName     sql.NullString
	AvailableBalance sql.NullFloat64
	CurrentBalance   sql.NullFloat64
	IsoCurrencyCode  sql.NullString
	InstitutionName  sql.NullString
	UserID           string
}

type CreateErrorLogParams

type CreateErrorLogParams struct {
	Timestamp    string
	Command      string
	ErrorMessage string
}

type CreateTransactionParams

type CreateTransactionParams struct {
	ID                      string
	AccountID               string
	Amount                  float64
	IsoCurrencyCode         sql.NullString
	Date                    sql.NullString
	MerchantName            sql.NullString
	PaymentChannel          string
	PersonalFinanceCategory string
}

type CreateUserParams

type CreateUserParams struct {
	ID             string
	Name           string
	CreatedAt      string
	UpdatedAt      string
	HashedPassword string
	Email          string
	IsVerified     sql.NullBool
}

type DBTX

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 DeleteAccountsParams

type DeleteAccountsParams struct {
	InstitutionName sql.NullString
	UserID          string
}

type ErrorLog

type ErrorLog struct {
	ID           int64
	Timestamp    string
	Command      string
	ErrorMessage string
}

type GetAccountParams

type GetAccountParams struct {
	Name   string
	UserID string
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) ClearUsers

func (q *Queries) ClearUsers(ctx context.Context) error

func (*Queries) CreateErrorLog

func (q *Queries) CreateErrorLog(ctx context.Context, arg CreateErrorLogParams) error

func (*Queries) CreateTransaction

func (q *Queries) CreateTransaction(ctx context.Context, arg CreateTransactionParams) (Transaction, error)

func (*Queries) CreateUser

func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)

func (*Queries) DeleteAccounts

func (q *Queries) DeleteAccounts(ctx context.Context, arg DeleteAccountsParams) error

func (*Queries) DeleteTransactions

func (q *Queries) DeleteTransactions(ctx context.Context, userID string) error

func (*Queries) DeleteUser

func (q *Queries) DeleteUser(ctx context.Context, name string) error

func (*Queries) GetAccount

func (q *Queries) GetAccount(ctx context.Context, arg GetAccountParams) (Account, error)

func (*Queries) GetAllAccounts

func (q *Queries) GetAllAccounts(ctx context.Context, userID string) ([]Account, error)

func (*Queries) GetLogs

func (q *Queries) GetLogs(ctx context.Context) ([]ErrorLog, error)

func (*Queries) GetTransactions

func (q *Queries) GetTransactions(ctx context.Context, accountID string) ([]Transaction, error)

func (*Queries) GetUser

func (q *Queries) GetUser(ctx context.Context, name string) (User, error)

func (*Queries) GetUserByEmail

func (q *Queries) GetUserByEmail(ctx context.Context, email string) (User, error)

func (*Queries) UpdatePassword

func (q *Queries) UpdatePassword(ctx context.Context, arg UpdatePasswordParams) error

func (*Queries) UpsertAccount

func (q *Queries) UpsertAccount(ctx context.Context, arg UpsertAccountParams) (Account, error)

func (*Queries) VerifyEmail

func (q *Queries) VerifyEmail(ctx context.Context, arg VerifyEmailParams) error

func (*Queries) WithTx

func (q *Queries) WithTx(tx *sql.Tx) *Queries

type Transaction

type Transaction struct {
	ID                      string
	AccountID               string
	Amount                  float64
	IsoCurrencyCode         sql.NullString
	Date                    sql.NullString
	MerchantName            sql.NullString
	PaymentChannel          string
	PersonalFinanceCategory string
}

type UpdatePasswordParams

type UpdatePasswordParams struct {
	HashedPassword string
	UpdatedAt      string
	Name           string
}

type UpsertAccountParams

type UpsertAccountParams struct {
	ID               string
	CreatedAt        string
	UpdatedAt        string
	Name             string
	Type             string
	Subtype          sql.NullString
	Mask             sql.NullString
	OfficialName     sql.NullString
	AvailableBalance sql.NullFloat64
	CurrentBalance   sql.NullFloat64
	IsoCurrencyCode  sql.NullString
	InstitutionName  sql.NullString
	UserID           string
}

type User

type User struct {
	ID             string
	Name           string
	CreatedAt      string
	UpdatedAt      string
	HashedPassword string
	Email          string
	IsVerified     sql.NullBool
}

type VerifyEmailParams

type VerifyEmailParams struct {
	IsVerified sql.NullBool
	UpdatedAt  string
	Name       string
}

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL