db

Documentation

Index

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

Constants

const (
	HOST = "localhost"
	PORT = 5432
)

Variables

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

ErrNotFound indicates requested entity does not 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 *Item) error

func (Database) DeleteItem

func (db Database) DeleteItem(itemId int) error

func (Database) Get1000Items

func (db Database) Get1000Items() (*ItemList, error)

func (Database) GetItemById

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

func (Database) UpdateItem

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

type Item

type Item struct {
	ID          int    `json:"id"`
	Name        string `json:"name"`
	Description string `json:"description"`
	CreatedAt   string `json:"created_at"`
}

type ItemList

type ItemList struct {
	Items []Item `json:"items"`
}