database

package

v0.0.0-...-2a132e7 Latest Latest Go to latest Published: May 17, 2022 License: MIT Imports: 5 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

View Source

const (
	HOST = "localhost"
	PORT = 5432
)

View Source

var ErrNoMatch = fmt.Errorf("no matching record")

ErrNoMatch is returned when we request a row that doesn't exist

This section is empty.

type Database struct {
	Conn *sql.DB
}

Database is a struct for database functions

func Initialize(username, password, database string) (Database, error)

Initialize is a method for initialize the database connection

func (db Database) CreateTransaction(transaction *models.Transaction) error

CreateTransaction is a method for create a transaction in database

func (db Database) DeleteTransaction(transactionId int) error

DeleteTransaction is a method for delete a transaction in database

func (db Database) GetAllTransactions() (*models.TransactionList, error)

GetAllTransactions is a method for get all transactions in database

func (db Database) GetTransactionById(transactionId int) (models.Transaction, error)

GetTransactionById is a method for get one transaction by id

func (db Database) UpdateTransaction(transactionId int, itemData models.Transaction) (models.Transaction, error)

UpdateTransaction is a method for update a transaction in database