db

package

v0.0.0-...-c877efe Latest Latest Go to latest Published: Mar 31, 2022 License: MIT Imports: 6 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 = "database"
	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
}

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

Connect to the Database

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)