db

package

v0.0.0-...-73aec22 Latest Latest Go to latest Published: May 20, 2021 License: MIT Imports: 7 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

This section is empty.

View Source

var ErrNoMatch = errors.New("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 represents a Database connection

func Connect() (Database, error)

Connect opens a connection with Database

func (db Database) DeleteItem(itemID string) error

DeleteItem handles the deletion of an item by its ID

func (db Database) GetItems() (*models.ItemList, error)

GetItems returns all items in database

func (db Database) NewItem(item *models.Item) error

NewItem handles the insertion of a new item in the database

func (db Database) SearchItemByID(itemID string) (models.Item, error)

SearchItemByID handles the searching of an item by its ID

func (db Database) UpdateItem(itemID string, itemData models.Item) (models.Item, error)

UpdateItem handles the update of an item by its ID