db

package
v0.0.0-...-42b0ca7 Latest Latest
Warning

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

Go to latest
Published: Nov 12, 2023 License: MIT Imports: 7 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func SetupDB

func SetupDB(dbConfig models.DBConfig) (db *sql.DB, err error)

SetupDB - function to set up the PostgreSQL database

Types

type TransactionsDB

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

func NewTransactionsDB

func NewTransactionsDB(db *sql.DB) (transactionsDB *TransactionsDB)

func (*TransactionsDB) DeleteActiveTransactionByID

func (t *TransactionsDB) DeleteActiveTransactionByID(id uint64) (err error)

func (*TransactionsDB) DeleteSingleTransaction

func (t *TransactionsDB) DeleteSingleTransaction(txID uint64, userID uint64) (err error)

DeleteSingleTransaction - function to delete user`s single transaction

func (*TransactionsDB) GetActiveTransactionsByStep

func (t *TransactionsDB) GetActiveTransactionsByStep(step string) (activeTransactions []models.ActiveTransaction, err error)

func (*TransactionsDB) GetAllActiveTransactions

func (t *TransactionsDB) GetAllActiveTransactions() (activeTransactions []models.ActiveTransaction, err error)

func (*TransactionsDB) GetOngoingTransactions

func (t *TransactionsDB) GetOngoingTransactions(userID uint64) (ongoingTransactions []models.OngoingTransaction, err error)

func (*TransactionsDB) InsertActiveTransaction

func (t *TransactionsDB) InsertActiveTransaction(userID uint64, txID uint64, step string) (err error)

func (*TransactionsDB) InsertTransactionData

func (t *TransactionsDB) InsertTransactionData(userID uint64, txType, txHash string, txData models.TransactionData) (transactionID uint64, err error)

InsertTransactionData - function to insert user`s new transaction data from JSON

func (*TransactionsDB) SelectAllTransactions

func (t *TransactionsDB) SelectAllTransactions(userID uint64) (allTransactions models.AllTransactions, err error)

SelectAllTransactions - function to select all user`s transactions

func (*TransactionsDB) SelectSingleTransactionStatus

func (t *TransactionsDB) SelectSingleTransactionStatus(txID uint64, userID uint64) (singleTransactionStatusResponse *models.SingleTransactionStatusResponse, err error)

SelectSingleTransactionStatus - function to select user`s single transaction status

func (*TransactionsDB) SelectTransaction

func (t *TransactionsDB) SelectTransaction(id uint64, userID uint64) (tx *models.SingleTransactionResponse, err error)

SelectTransaction - function to select user`s single transaction if exists

func (*TransactionsDB) UpdateActiveTransactionAttempts

func (t *TransactionsDB) UpdateActiveTransactionAttempts(id uint64, attempts int) (err error)

func (*TransactionsDB) UpdateActiveTransactionStep

func (t *TransactionsDB) UpdateActiveTransactionStep(id uint64, step string) (err error)

func (*TransactionsDB) UpdateTransactionData

func (t *TransactionsDB) UpdateTransactionData(txID uint64, userID uint64, txType string, txData models.TransactionData) (err error)

UpdateTransactionData - function to update user`s transaction data from JSON

func (*TransactionsDB) UpdateTransactionHash

func (t *TransactionsDB) UpdateTransactionHash(txID uint64, userID uint64, txHash string) (err error)

UpdateTransactionHash - function to update user`s transaction hash

func (*TransactionsDB) UpdateTransactionStatus

func (t *TransactionsDB) UpdateTransactionStatus(txID uint64, userID uint64, txStatus string) (err error)

UpdateTransactionStatus - function to update user`s single transaction status

type UsersDB

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

func NewUsersDB

func NewUsersDB(db *sql.DB) (userDB *UsersDB)

func (*UsersDB) CreateUser

func (t *UsersDB) CreateUser(userHash string, userRuntime int) (err error)

CreateUser - function to create new user by User Hash and User Runtime variable in database table

func (*UsersDB) SelectUser

func (t *UsersDB) SelectUser(userHash string, userRuntime int) (user models.User, err error)

SelectUser - function to select user`s ID from database table if that user does exist

type UsersDBInterface

type UsersDBInterface interface {
	SelectUser(userHash string, userRuntime int) (user models.User, err error)
	CreateUser(userHash string, userRuntime int) (err error)
}

Interface for users database model

Directories

Path Synopsis

Jump to

Keyboard shortcuts

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