db

Documentation

Index

• Constants
• Variables
• type Database
  • func Initialize(username, password, database string, host string) (Database, error)
  • func (db Database) AddItem(item *models.Item) error
  • func (db Database) DeleteItem(itemId int) error
  • func (db Database) DeleteUser(userId int) error
  • func (db Database) GetAllItems() (*models.ItemList, error)
  • func (db Database) GetAllUsers() (*models.UserList, error)
  • func (db Database) GetItemById(itemId int) (models.Item, error)
  • func (db Database) GetUserById(userId int) (models.User, error)
  • func (db Database) GetUserByIdUsernameAndPassword(user *models.User) (*models.User, error)
  • func (db Database) GetUserByUsername(user *models.User) (*models.User, error)
  • func (db Database) NewUser(user *models.User) 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, host string) (Database, error)

Connect to the Database

func (Database) AddItem

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

func (Database) DeleteItem

func (db Database) DeleteItem(itemId int) error

func (Database) DeleteUser

func (db Database) DeleteUser(userId int) error

func (Database) GetAllItems

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

func (Database) GetAllUsers

func (db Database) GetAllUsers() (*models.UserList, error)

func (Database) GetItemById

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

func (Database) GetUserById

func (db Database) GetUserById(userId int) (models.User, error)

func (Database) GetUserByIdUsernameAndPassword

func (db Database) GetUserByIdUsernameAndPassword(user *models.User) (*models.User, error)

func (Database) GetUserByUsername

func (db Database) GetUserByUsername(user *models.User) (*models.User, error)

func (Database) NewUser

func (db Database) NewUser(user *models.User) error

func (Database) UpdateItem

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