database

package
v0.0.0-...-29bd376 Latest Latest
Warning

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

 Go to latest Published: Dec 17, 2024 License: MIT Imports: 4 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Balance 

type Balance struct {
	ID         int64   `json:"id"`
	UserID     int64   `json:"user_id"`
	CurrencyID int64   `json:"currency_id"`
	Balance    float64 `json:"balance"`
	Address    string  `json:"address"`
}

type CardConfirmation 

type CardConfirmation struct {
	ID         int64  `json:"id"`
	UserID     int64  `json:"user_id"`
	CurrencyID int64  `json:"currency_id"`
	Address    string `json:"address"`
	Verified   bool   `json:"verified"`
	Image      []byte `json:"image"`
}

type Chat 

type Chat struct {
	ID       int64  `json:"id"`
	Uuid     string `json:"uuid"`
	Resolved bool   `json:"resolved"`
}

type ChatMessage 

type ChatMessage struct {
	ChatID    int64     `json:"chat_id"`
	Outgoing  bool      `json:"outgoing"`
	Message   string    `json:"message"`
	CreatedAt time.Time `json:"created_at"`
}

type ConnectTelegramParams 

type ConnectTelegramParams struct {
	Email          string `json:"email"`
	TelegramChatID int64  `json:"telegram_chat_id"`
}

type CreateBalanceParams 

type CreateBalanceParams struct {
	UserID     int64   `json:"user_id"`
	CurrencyID int64   `json:"currency_id"`
	Balance    float64 `json:"balance"`
	Address    string  `json:"address"`
}

type CreateCardConfirmationParams 

type CreateCardConfirmationParams struct {
	UserID     int64  `json:"user_id"`
	CurrencyID int64  `json:"currency_id"`
	Address    string `json:"address"`
	Verified   bool   `json:"verified"`
}

type CreateChatMessageParams 

type CreateChatMessageParams struct {
	ChatID   int64  `json:"chat_id"`
	Message  string `json:"message"`
	Outgoing bool   `json:"outgoing"`
}

type CreateChatParams 

type CreateChatParams struct {
	Uuid     string `json:"uuid"`
	Resolved bool   `json:"resolved"`
}

type CreateCurrencyParams 

type CreateCurrencyParams struct {
	Code        string `json:"code"`
	Description string `json:"description"`
}

type CreateExchangerParams 

type CreateExchangerParams struct {
	Description                string  `json:"description"`
	Inmin                      float64 `json:"inmin"`
	RequirePaymentVerification bool    `json:"require_payment_verification"`
	InCurrency                 int64   `json:"in_currency"`
	OutCurrency                int64   `json:"out_currency"`
}

type CreateOrderParams 

type CreateOrderParams struct {
	UserID           int64   `json:"user_id"`
	OperatorID       int64   `json:"operator_id"`
	ExchangerID      int64   `json:"exchanger_id"`
	AmountIn         float64 `json:"amount_in"`
	AmountOut        float64 `json:"amount_out"`
	Cancelled        bool    `json:"cancelled"`
	ReceiveAddress   string  `json:"receive_address"`
	Finished         bool    `json:"finished"`
	ConfirmImage     []byte  `json:"confirm_image"`
	PaymentConfirmed bool    `json:"payment_confirmed"`
}

type CreateUserParams 

type CreateUserParams struct {
	Email          string `json:"email"`
	Verified       bool   `json:"verified"`
	Passwhash      string `json:"passwhash"`
	Admin          bool   `json:"admin"`
	Operator       bool   `json:"operator"`
	Token          string `json:"token"`
	TelegramChatID int64  `json:"telegram_chat_id"`
	Busy           bool   `json:"busy"`
}

type Currency 

type Currency struct {
	ID          int64  `json:"id"`
	Code        string `json:"code"`
	Description string `json:"description"`
}

type DBTX 

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type Exchanger 

type Exchanger struct {
	ID                         int64   `json:"id"`
	Inmin                      float64 `json:"inmin"`
	Description                string  `json:"description"`
	RequirePaymentVerification bool    `json:"require_payment_verification"`
	InCurrency                 int64   `json:"in_currency"`
	OutCurrency                int64   `json:"out_currency"`
}

type GetBalanceByIdParams 

type GetBalanceByIdParams struct {
	ID     int64 `json:"id"`
	UserID int64 `json:"user_id"`
}

type GetCardConfirmationParams 

type GetCardConfirmationParams struct {
	UserID     int64 `json:"user_id"`
	CurrencyID int64 `json:"currency_id"`
}

type GetExchangerByCurrencyIdsParams 

type GetExchangerByCurrencyIdsParams struct {
	InCurrency  int64 `json:"in_currency"`
	OutCurrency int64 `json:"out_currency"`
}

type Order 

type Order struct {
	ID               int64     `json:"id"`
	UserID           int64     `json:"user_id"`
	OperatorID       int64     `json:"operator_id"`
	ExchangerID      int64     `json:"exchanger_id"`
	AmountIn         float64   `json:"amount_in"`
	AmountOut        float64   `json:"amount_out"`
	ReceiveAddress   string    `json:"receive_address"`
	CreatedAt        time.Time `json:"created_at"`
	Cancelled        bool      `json:"cancelled"`
	Finished         bool      `json:"finished"`
	ConfirmImage     []byte    `json:"confirm_image"`
	PaymentConfirmed bool      `json:"payment_confirmed"`
}

type Queries 

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

func New 

func New(db DBTX) *Queries

func (*Queries) ConnectTelegram 

func (q *Queries) ConnectTelegram(ctx context.Context, arg ConnectTelegramParams) (User, error)

func (*Queries) CreateBalance 

func (q *Queries) CreateBalance(ctx context.Context, arg CreateBalanceParams) (Balance, error)

func (*Queries) CreateCardConfirmation 

func (q *Queries) CreateCardConfirmation(ctx context.Context, arg CreateCardConfirmationParams) (CardConfirmation, error)

func (*Queries) CreateChat 

func (q *Queries) CreateChat(ctx context.Context, arg CreateChatParams) (Chat, error)

func (*Queries) CreateChatMessage 

func (q *Queries) CreateChatMessage(ctx context.Context, arg CreateChatMessageParams) (ChatMessage, error)

func (*Queries) CreateCurrency 

func (q *Queries) CreateCurrency(ctx context.Context, arg CreateCurrencyParams) (Currency, error)

func (*Queries) CreateExchanger 

func (q *Queries) CreateExchanger(ctx context.Context, arg CreateExchangerParams) (Exchanger, error)

func (*Queries) CreateOrder 

func (q *Queries) CreateOrder(ctx context.Context, arg CreateOrderParams) (Order, error)

func (*Queries) CreateUser 

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

func (*Queries) GetBalanceById 

func (q *Queries) GetBalanceById(ctx context.Context, arg GetBalanceByIdParams) (Balance, error)

func (*Queries) GetCardConfirmation 

func (q *Queries) GetCardConfirmation(ctx context.Context, arg GetCardConfirmationParams) (CardConfirmation, error)

func (*Queries) GetCardConfirmations 

func (q *Queries) GetCardConfirmations(ctx context.Context) ([]CardConfirmation, error)

func (*Queries) GetCardConfirmationsForUser 

func (q *Queries) GetCardConfirmationsForUser(ctx context.Context, userID int64) ([]CardConfirmation, error)

func (*Queries) GetChat 

func (q *Queries) GetChat(ctx context.Context, uuid string) (Chat, error)

func (*Queries) GetChatMessages 

func (q *Queries) GetChatMessages(ctx context.Context, chatID int64) ([]ChatMessage, error)

func (*Queries) GetCurrencyByCode 

func (q *Queries) GetCurrencyByCode(ctx context.Context, code string) (Currency, error)

func (*Queries) GetCurrencyById 

func (q *Queries) GetCurrencyById(ctx context.Context, id int64) (Currency, error)

func (*Queries) GetExchangerByCurrencyIds 

func (q *Queries) GetExchangerByCurrencyIds(ctx context.Context, arg GetExchangerByCurrencyIdsParams) (Exchanger, error)

func (*Queries) GetExchangerById 

func (q *Queries) GetExchangerById(ctx context.Context, id int64) (Exchanger, error)

func (*Queries) GetFinishedOrders 

func (q *Queries) GetFinishedOrders(ctx context.Context, operatorID int64) ([]Order, error)

func (*Queries) GetFreeOperators 

func (q *Queries) GetFreeOperators(ctx context.Context) ([]User, error)

func (*Queries) GetOrder 

func (q *Queries) GetOrder(ctx context.Context, id int64) (Order, error)

func (*Queries) GetOrders 

func (q *Queries) GetOrders(ctx context.Context, operatorID int64) ([]Order, error)

func (*Queries) GetOrdersForUser 

func (q *Queries) GetOrdersForUser(ctx context.Context, userID int64) ([]Order, error)

func (*Queries) GetUnresolvedChats 

func (q *Queries) GetUnresolvedChats(ctx context.Context) ([]Chat, error)

func (*Queries) GetUser 

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

func (*Queries) GetUserById 

func (q *Queries) GetUserById(ctx context.Context, id int64) (User, error)

func (*Queries) GetUserByToken 

func (q *Queries) GetUserByToken(ctx context.Context, token string) (User, error)

func (*Queries) ListBalances 

func (q *Queries) ListBalances(ctx context.Context, userID int64) ([]Balance, error)

func (*Queries) ListCurrencies 

func (q *Queries) ListCurrencies(ctx context.Context) ([]Currency, error)

func (*Queries) ListExchangers 

func (q *Queries) ListExchangers(ctx context.Context) ([]Exchanger, error)

func (*Queries) ListOperators 

func (q *Queries) ListOperators(ctx context.Context) ([]User, error)

func (*Queries) ListUsers 

func (q *Queries) ListUsers(ctx context.Context) ([]User, error)

func (*Queries) RemoveBalance 

func (q *Queries) RemoveBalance(ctx context.Context, arg RemoveBalanceParams) error

func (*Queries) RemoveCardConfirmation 

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

func (*Queries) RemoveCurrency 

func (q *Queries) RemoveCurrency(ctx context.Context, code string) error

func (*Queries) RemoveExchanger 

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

func (*Queries) RemoveExchangerOrders 

func (q *Queries) RemoveExchangerOrders(ctx context.Context, exchangerID int64) error

func (*Queries) UpdateBalance 

func (q *Queries) UpdateBalance(ctx context.Context, arg UpdateBalanceParams) (Balance, error)

func (*Queries) UpdateCardConfirmationImage 

func (q *Queries) UpdateCardConfirmationImage(ctx context.Context, arg UpdateCardConfirmationImageParams) (CardConfirmation, error)

func (*Queries) UpdateCardConfirmationVerified 

func (q *Queries) UpdateCardConfirmationVerified(ctx context.Context, arg UpdateCardConfirmationVerifiedParams) (CardConfirmation, error)

func (*Queries) UpdateChatResolved 

func (q *Queries) UpdateChatResolved(ctx context.Context, id int64) (Chat, error)

func (*Queries) UpdateChatUnresolved 

func (q *Queries) UpdateChatUnresolved(ctx context.Context, id int64) (Chat, error)

func (*Queries) UpdateOrderCancelled 

func (q *Queries) UpdateOrderCancelled(ctx context.Context, id int64) (Order, error)

func (*Queries) UpdateOrderFinished 

func (q *Queries) UpdateOrderFinished(ctx context.Context, id int64) (Order, error)

func (*Queries) UpdateOrderPaymentConfirmed 

func (q *Queries) UpdateOrderPaymentConfirmed(ctx context.Context, arg UpdateOrderPaymentConfirmedParams) (Order, error)

func (*Queries) UpdateUserBusy 

func (q *Queries) UpdateUserBusy(ctx context.Context, arg UpdateUserBusyParams) (User, error)

func (*Queries) UpdateUserToken 

func (q *Queries) UpdateUserToken(ctx context.Context, arg UpdateUserTokenParams) (User, error)

func (*Queries) UpdateUserTokenAndPassHash 

func (q *Queries) UpdateUserTokenAndPassHash(ctx context.Context, arg UpdateUserTokenAndPassHashParams) (User, error)

func (*Queries) UpdateUserVerified 

func (q *Queries) UpdateUserVerified(ctx context.Context, arg UpdateUserVerifiedParams) (User, error)

func (*Queries) UserOrders 

func (q *Queries) UserOrders(ctx context.Context, userID int64) ([]Order, error)

func (*Queries) WithTx 

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

type RemoveBalanceParams 

type RemoveBalanceParams struct {
	ID     int64 `json:"id"`
	UserID int64 `json:"user_id"`
}

type UpdateBalanceParams 

type UpdateBalanceParams struct {
	ID      int64   `json:"id"`
	UserID  int64   `json:"user_id"`
	Balance float64 `json:"balance"`
	Address string  `json:"address"`
}

type UpdateCardConfirmationImageParams 

type UpdateCardConfirmationImageParams struct {
	ID    int64  `json:"id"`
	Image []byte `json:"image"`
}

type UpdateCardConfirmationVerifiedParams 

type UpdateCardConfirmationVerifiedParams struct {
	ID       int64 `json:"id"`
	Verified bool  `json:"verified"`
}

type UpdateOrderPaymentConfirmedParams 

type UpdateOrderPaymentConfirmedParams struct {
	ID               int64  `json:"id"`
	PaymentConfirmed bool   `json:"payment_confirmed"`
	ConfirmImage     []byte `json:"confirm_image"`
}

type UpdateUserBusyParams 

type UpdateUserBusyParams struct {
	Email string `json:"email"`
	Busy  bool   `json:"busy"`
}

type UpdateUserTokenAndPassHashParams 

type UpdateUserTokenAndPassHashParams struct {
	Email     string `json:"email"`
	Token     string `json:"token"`
	Passwhash string `json:"passwhash"`
}

type UpdateUserTokenParams 

type UpdateUserTokenParams struct {
	ID    int64  `json:"id"`
	Token string `json:"token"`
}

type UpdateUserVerifiedParams 

type UpdateUserVerifiedParams struct {
	Email    string `json:"email"`
	Verified bool   `json:"verified"`
}

type User 

type User struct {
	ID             int64  `json:"id"`
	Email          string `json:"email"`
	Verified       bool   `json:"verified"`
	Passwhash      string `json:"passwhash"`
	Admin          bool   `json:"admin"`
	Operator       bool   `json:"operator"`
	Token          string `json:"token"`
	TelegramChatID int64  `json:"telegram_chat_id"`
	Busy           bool   `json:"busy"`
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.