db

package

Go to main page

Versions in this module

v1

v1.0.0

Jun 13, 2023

Changes in this version

+ const ForeignKeyViolation

+ const UniqueViolation

+ var ErrRecordNotFound = pgx.ErrNoRows

+ var ErrUniqueViolation = &pgconn.PgError

+ func ErrorCode(err error) string

+ type CreateSessionParams struct

+ ClientIp string

+ ExpiresAt time.Time

+ ID uuid.UUID

+ IsBlocked bool

+ RefreshToken string

+ UserAgent string

+ Username string

+ type CreateUserTxParams struct

+ AfterCreate func(user User) error

+ type CreateUserTxResult struct

+ User User

+ type CreateVerifyEmailParams struct

+ Email string

+ SecretCode string

+ Username string

type Querier

+ CreateSession func(ctx context.Context, arg CreateSessionParams) (Session, error)

+ CreateVerifyEmail func(ctx context.Context, arg CreateVerifyEmailParams) (VerifyEmail, error)

+ GetSession func(ctx context.Context, username string) (Session, error)

+ UpdateUser func(ctx context.Context, arg UpdateUserParams) (User, error)

+ UpdateVerifyEmail func(ctx context.Context, arg UpdateVerifyEmailParams) (VerifyEmail, error)

type Queries

+ func (q *Queries) CreateSession(ctx context.Context, arg CreateSessionParams) (Session, error)

+ func (q *Queries) CreateVerifyEmail(ctx context.Context, arg CreateVerifyEmailParams) (VerifyEmail, error)

+ func (q *Queries) GetSession(ctx context.Context, username string) (Session, error)

+ func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error)

+ func (q *Queries) UpdateVerifyEmail(ctx context.Context, arg UpdateVerifyEmailParams) (VerifyEmail, error)

+ type Session struct

+ ClientIp string

+ CreatedAt time.Time

+ ExpiresAt time.Time

+ ID uuid.UUID

+ IsBlocked bool

+ RefreshToken string

+ UserAgent string

+ Username string

type SqlStore

+ func (sqlStore *SqlStore) CreateUserTx(ctx context.Context, arg CreateUserTxParams) (CreateUserTxResult, error)

+ func (sqlStore *SqlStore) VerifyEmailTx(ctx context.Context, arg VerifyEmailTxParams) (VerifyEmailTxResult, error)

type Store

+ CreateUserTx func(ctx context.Context, arg CreateUserTxParams) (CreateUserTxResult, error)

+ VerifyEmailTx func(ctx context.Context, arg VerifyEmailTxParams) (VerifyEmailTxResult, error)

+ type UpdateUserParams struct

+ Email sql.NullString

+ FullName sql.NullString

+ HashedPassword sql.NullString

+ IsEmailVerified sql.NullBool

+ PasswordChangedAt sql.NullTime

+ Username string

+ type UpdateVerifyEmailParams struct

+ ID int64

+ SecretCode string

type User

+ IsEmailVerified bool

+ type VerifyEmail struct

+ CreatedAt time.Time

+ Email string

+ ExpiredAt time.Time

+ ID int64

+ IsUsed bool

+ SecretCode string

+ Username string

+ type VerifyEmailTxParams struct

+ EmailId int64

+ SecreteCode string

+ type VerifyEmailTxResult struct

+ User User

+ VerifyEmail VerifyEmail

v0

v0.8.1

Jun 5, 2023

v0.8.0

Jun 3, 2023

v0.7.5

Jun 3, 2023

v0.7.4

Jun 3, 2023

v0.7.3

Jun 2, 2023

Changes in this version

+ type CreateUserParams struct

+ Email string

+ FullName string

+ HashedPassword string

+ Username string

type Querier

+ CreateUser func(ctx context.Context, arg CreateUserParams) (User, error)

+ GetUser func(ctx context.Context, username string) (User, error)

type Queries

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

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

+ type User struct

+ CreatedAt time.Time

+ Email string

+ FullName string

+ HashedPassword string

+ PasswordChangedAt time.Time

+ Username string

v0.7.2

Jun 2, 2023

v0.7.1

Jun 2, 2023

v0.7.0

Jun 2, 2023

Changes in this version

+ type SqlStore struct

+ func (sqlStore *SqlStore) TransferTx(ctx context.Context, arg TransferTxParams) (TransferTxResult, error)

v0.6.0

Jun 1, 2023

v0.5.0

Jun 1, 2023

v0.4.0

May 31, 2023

Changes in this version

+ type AddAccountBalanceParams struct

+ Amount int64

+ ID int64

type Querier

+ AddAccountBalance func(ctx context.Context, arg AddAccountBalanceParams) (Account, error)

+ GetAccountForUpdate func(ctx context.Context, id int64) (Account, error)

type Queries

+ func (q *Queries) AddAccountBalance(ctx context.Context, arg AddAccountBalanceParams) (Account, error)

+ func (q *Queries) GetAccountForUpdate(ctx context.Context, id int64) (Account, error)

v0.2.0

May 30, 2023

Changes in this version

+ type CreateEntryParams struct

+ AccountID int64

+ Amount int64

+ type ListAccountsParams struct

+ Limit int32

+ Offset int32

+ Owner string

+ type ListTransfersParams struct

+ FromAccountID int64

+ Limit int32

+ Offset int32

+ ToAccountID int64

type Querier

+ CreateEntry func(ctx context.Context, arg CreateEntryParams) (Entry, error)

+ CreateTransfer func(ctx context.Context, arg CreateTransferParams) (Transfer, error)

+ DeleteEntry func(ctx context.Context, id int64) error

+ DeleteTransfer func(ctx context.Context, id int64) error

+ GetEntry func(ctx context.Context, id int64) (Entry, error)

+ GetTransfer func(ctx context.Context, id int64) (Transfer, error)

+ ListAccounts func(ctx context.Context, arg ListAccountsParams) ([]Account, error)

+ ListEEntry func(ctx context.Context) ([]Entry, error)

+ ListTransferById func(ctx context.Context) ([]Transfer, error)

+ ListTransfers func(ctx context.Context, arg ListTransfersParams) ([]Transfer, error)

+ UpdateAccount func(ctx context.Context, arg UpdateAccountParams) (Account, error)

+ UpdateEntry func(ctx context.Context, arg UpdateEntryParams) error

+ UpdateTransfer func(ctx context.Context, arg UpdateTransferParams) error

type Queries

+ func (q *Queries) CreateEntry(ctx context.Context, arg CreateEntryParams) (Entry, error)

+ func (q *Queries) DeleteEntry(ctx context.Context, id int64) error

+ func (q *Queries) DeleteTransfer(ctx context.Context, id int64) error

+ func (q *Queries) GetEntry(ctx context.Context, id int64) (Entry, error)

+ func (q *Queries) GetTransfer(ctx context.Context, id int64) (Transfer, error)

+ func (q *Queries) ListAccounts(ctx context.Context, arg ListAccountsParams) ([]Account, error)

+ func (q *Queries) ListEEntry(ctx context.Context) ([]Entry, error)

+ func (q *Queries) ListTransferById(ctx context.Context) ([]Transfer, error)

+ func (q *Queries) ListTransfers(ctx context.Context, arg ListTransfersParams) ([]Transfer, error)

+ func (q *Queries) UpdateAccount(ctx context.Context, arg UpdateAccountParams) (Account, error)

+ func (q *Queries) UpdateEntry(ctx context.Context, arg UpdateEntryParams) error

+ func (q *Queries) UpdateTransfer(ctx context.Context, arg UpdateTransferParams) error

+ type Store struct

+ func NewStore(db *sql.DB) *Store

+ func (store *Store) TransferTx(ctx context.Context, arg TransferTxParams) (TransferTxResult, error)

+ type TransferTxParams struct

+ Amount int64

+ FromAccountID int64

+ ToAccountID int64

+ type TransferTxResult struct

+ FromAccount Account

+ FromEntry Entry

+ ToAccount Account

+ ToEntry Entry

+ Transfer Transfer

+ type UpdateAccountParams struct

+ Balance int64

+ ID int64

+ Owner string

+ type UpdateEntryParams struct

+ AccountID int64

+ Amount int64

+ ID int64

+ type UpdateTransferParams struct

+ Amount int64

+ FromAccountID int64

+ ID int64

+ ToAccountID int64

v0.1.0

May 29, 2023

Changes in this version

+ type Account struct

+ Balance int64

+ CreatedAt time.Time

+ Currency string

+ ID int64

+ Owner string

+ type CreateAccountParams struct

+ Balance int64

+ Currency string

+ Owner string

+ type CreateEntrieParams struct

+ AccountID int64

+ Amount int64

+ type CreateTransferParams struct

+ Amount int64

+ FromAccountID int64

+ ToAccountID int64

+ type DBTX interface

+ ExecContext func(context.Context, string, ...interface{}) (sql.Result, error)

+ PrepareContext func(context.Context, string) (*sql.Stmt, error)

+ QueryContext func(context.Context, string, ...interface{}) (*sql.Rows, error)

+ QueryRowContext func(context.Context, string, ...interface{}) *sql.Row

+ type Entry struct

+ AccountID int64

+ Amount int64

+ CreatedAt time.Time

+ ID int64

+ type Querier interface

+ CreateAccount func(ctx context.Context, arg CreateAccountParams) (Account, error)

+ DeleteAccount func(ctx context.Context, id int64) error

+ GetAccount func(ctx context.Context, id int64) (Account, error)

+ ListAccount func(ctx context.Context) ([]Account, error)

+ UpdateAccounts func(ctx context.Context, arg UpdateAccountsParams) error

+ type Queries struct

+ func New(db DBTX) *Queries

+ func (q *Queries) CreateAccount(ctx context.Context, arg CreateAccountParams) (Account, error)

+ func (q *Queries) CreateEntrie(ctx context.Context, arg CreateEntrieParams) (Entry, error)

+ func (q *Queries) CreateTransfer(ctx context.Context, arg CreateTransferParams) (Transfer, error)

+ func (q *Queries) DeleteAccount(ctx context.Context, id int64) error

+ func (q *Queries) GetAccount(ctx context.Context, id int64) (Account, error)

+ func (q *Queries) ListAccount(ctx context.Context) ([]Account, error)

+ func (q *Queries) UpdateAccounts(ctx context.Context, arg UpdateAccountsParams) error

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

+ type Transfer struct

+ Amount int64

+ CreatedAt time.Time

+ FromAccountID int64

+ ID int64

+ ToAccountID int64

+ type UpdateAccountsParams struct

+ Balance int64

+ Currency string

+ ID int64

+ Owner string

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