db

Documentation

Index

• Constants
• Variables
• type Database
  • func Initialize(username, password, database string) (Database, error)
  • func (db Database) AddItem(item *models.Item) error
  • func (db Database) DeleteItem(itemId int) error
  • func (db Database) GetAllItems() (*models.ItemList, error)
  • func (db Database) GetItemById(itemId int) (models.Item, error)
  • func (db Database) UpdateItem(itemId int, itemData models.Item) (models.Item, error)

Constants

const (
	HOST = "database"
	PORT = 5432
)

Variables

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

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

Types

type Database

type Database struct {
	Conn *sql.DB
}

func Initialize

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

func (Database) AddItem

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

func (Database) DeleteItem

func (db Database) DeleteItem(itemId int) error

func (Database) GetAllItems

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

func (Database) GetItemById

func (db Database) GetItemById(itemId int) (models.Item, error)

func (Database) UpdateItem

func (db Database) UpdateItem(itemId int, itemData models.Item) (models.Item, error)