db

package

v0.0.0-...-5008859 Latest Latest Go to latest Published: Jan 23, 2021 License: MIT Imports: 12 Imported by: 0

Documentation ¶

This section is empty.

This section is empty.

func MigrateUp(dbURL string)

MigrateUp runs migrations

type Db struct {
	// contains filtered or unexported fields
}

Db is the database connection

func Connect(dbURL string) *Db

Connect makes a postgres connection

func (db *Db) CloseConnection()

CloseConnection closes the sql conection

func (db *Db) CreatePrices(drinks *[]exel.Drink) (OK bool, error error)

CreatePrices creates new prices for juomas

func (db *Db) DeleteDrinks() error

DeleteDrinks deletes all the drinks from the db

func (db *Db) GetAllBeers() (d []model.Drink, error error)

GetAllBeers gets all the beers from postgres

func (db *Db) GetAllDrinks() ([]model.Drink, error)

GetAllDrinks finds all the drinks

func (db *Db) GetAllPrices() ([]model.Price, error)

GetAllPrices gets all the prices

func (db *Db) GetDrinkByProdID(ProductID string) (d model.Drink, error error)

GetDrinkByProdID gets one juoma with specified productID

func (db *Db) GetPriceHistory(productID string) ([]model.Price, error)

GetPriceHistory returns the price history of one drink

func (db *Db) InsertDrinks(drinks *[]exel.Drink) (OK bool, error error)

InsertDrinks reads the exel file and inserts to postgres

func (db *Db) InsertManyDrinks() (string, error)

InsertManyDrinks reads the alko file and inserts everything to postgres

func (db *Db) SearchForBeer(term string) (d []model.Drink, error error)

SearchForBeer gets one or more beer based on search results

func (db *Db) SearchForDrink(term string) (j []model.Drink, error error)

SearchForDrink gets one or more juoma based on search results