db

type Account struct {
	ID         int64     `json:"id"`
	OwnerEmail string    `json:"owner_email"`
	Balance    int64     `json:"balance"`
	Currency   string    `json:"currency"`
	CreatedAt  time.Time `json:"created_at"`
	UpdatedAt  time.Time `json:"updated_at"`
}

type AccountTransactionsEntry struct {
	Uid           uuid.UUID `json:"uid"`
	TransactionID int64     `json:"transaction_id"`
	AccountID     int64     `json:"account_id"`
	OtherAccount  int64     `json:"other_account"`
	// must be positive
	Amount    int64     `json:"amount"`
	Currency  string    `json:"currency"`
	Type      string    `json:"type"`
	CreatedAt time.Time `json:"created_at"`
}

type CreateAccountParams struct {
	OwnerEmail string `json:"owner_email"`
	Balance    int64  `json:"balance"`
	Currency   string `json:"currency"`
}

type CreateAccountStatementEntryParams struct {
	TransactionID int64  `json:"transaction_id"`
	AccountID     int64  `json:"account_id"`
	OtherAccount  int64  `json:"other_account"`
	Amount        int64  `json:"amount"`
	Type          string `json:"type"`
	Currency      string `json:"currency"`
}

type CreateSessionParams struct {
	Email        string    `json:"email"`
	UserAgent    string    `json:"user_agent"`
	ClientIp     string    `json:"client_ip"`
	RefreshToken string    `json:"refresh_token"`
	ExpiresAt    time.Time `json:"expires_at"`
}

type CreateTransferEntryParams struct {
	TransactionID int64  `json:"transaction_id"`
	AccountID     int64  `json:"account_id"`
	OtherAccount  int64  `json:"other_account"`
	Amount        int64  `json:"amount"`
	Type          string `json:"type"`
}

type CreateTransferRecordParams struct {
	TransactionID int64  `json:"transaction_id"`
	FromAccountID int64  `json:"from_account_id"`
	ToAccountID   int64  `json:"to_account_id"`
	Amount        int64  `json:"amount"`
	Currency      string `json:"currency"`
}

type CreateUserParams struct {
	UserEmail    string `json:"user_email"`
	Username     string `json:"username"`
	PasswordHash string `json:"password_hash"`
	IsVerified   bool   `json:"is_verified"`
}

type CreateUserRow struct {
	UserEmail string `json:"user_email"`
	Username  string `json:"username"`
}

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 GetUserDetailsRow struct {
	UserEmail    string `json:"user_email"`
	Username     string `json:"username"`
	PasswordHash string `json:"password_hash"`
}

type ListAccountsParams struct {
	Offset int32 `json:"offset"`
	Limit  int32 `json:"limit"`
}

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

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

type Querier interface {
	BlockSessionById(ctx context.Context, sessionID uuid.UUID) (Session, error)
	BlockSessionFamily(ctx context.Context, email string) (Session, error)
	CreateAccount(ctx context.Context, arg CreateAccountParams) (Account, error)
	CreateAccountStatementEntry(ctx context.Context, arg CreateAccountStatementEntryParams) (AccountTransactionsEntry, error)
	CreateSession(ctx context.Context, arg CreateSessionParams) (Session, error)
	CreateTransferRecord(ctx context.Context, arg CreateTransferRecordParams) (Transaction, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (CreateUserRow, error)
	DeleteAccount(ctx context.Context, id int64) error
	GetAccountById(ctx context.Context, id int64) (Account, error)
	GetAccountByOwnerEmail(ctx context.Context, ownerEmail string) (Account, error)
	GetBalanceByAccountId(ctx context.Context, id int64) (int64, error)
	GetBalanceByOwnerEmail(ctx context.Context, ownerEmail string) (int64, error)
	GetSession(ctx context.Context, sessionID uuid.UUID) (Session, error)
	GetTransaction(ctx context.Context, uid uuid.UUID) (Transaction, error)
	GetTransactionsList(ctx context.Context) ([]Transaction, error)
	GetUserDetails(ctx context.Context, userEmail string) (GetUserDetailsRow, error)
	ListAccounts(ctx context.Context, arg ListAccountsParams) ([]Account, error)
	UpdateAccountBalanceById(ctx context.Context, arg UpdateAccountBalanceByIdParams) (Account, error)
}

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

type Session struct {
	SessionID    uuid.UUID `json:"session_id"`
	Email        string    `json:"email"`
	UserAgent    string    `json:"user_agent"`
	ClientIp     string    `json:"client_ip"`
	RefreshToken string    `json:"refresh_token"`
	ExpiresAt    time.Time `json:"expires_at"`
	IsBlocked    bool      `json:"is_blocked"`
	CreatedAt    time.Time `json:"created_at"`
}

type Transaction struct {
	Uid           uuid.UUID `json:"uid"`
	TransactionID int64     `json:"transaction_id"`
	FromAccountID int64     `json:"from_account_id"`
	ToAccountID   int64     `json:"to_account_id"`
	// can be negative depending on debit or credit
	Amount    int64     `json:"amount"`
	Currency  string    `json:"currency"`
	CreatedAt time.Time `json:"created_at"`
}

type UpdateAccountBalanceByIdParams struct {
	ID      int64 `json:"id"`
	Balance int64 `json:"balance"`
}

type User struct {
	UserID       int64     `json:"user_id"`
	Username     string    `json:"username"`
	UserEmail    string    `json:"user_email"`
	PasswordHash string    `json:"password_hash"`
	IsVerified   bool      `json:"is_verified"`
	CreatedAt    time.Time `json:"created_at"`
	UpdatedAt    time.Time `json:"updated_at"`
}