data

type Address struct {
	Id             int64  `db:"id" structs:"-"`
	BuildingNumber int64  `db:"building_number" structs:"building_number"`
	Street         string `db:"street" structs:"street"`
	City           string `db:"city" structs:"city"`
	District       string `db:"district" structs:"district"`
	Region         string `db:"region" structs:"region"`
	PostalCode     string `db:"postal_code" structs:"postal_code"`
}

type AddressesQ interface {
	New() AddressesQ

	Get() (*Address, error)
	Select() ([]Address, error)

	Transaction(fn func(q AddressesQ) error) error

	Insert(address Address) (Address, error)
	Update(address Address) (Address, error)
	Delete(id int64) error

	Page(pageParams pgdb.OffsetPageParams) AddressesQ

	FilterById(ids ...int64) AddressesQ
	FilterByBuildingNumber(numbers ...int64) AddressesQ
	FilterByStreet(streets ...string) AddressesQ
	FilterByCities(cities ...string) AddressesQ
	FilterByDistricts(districts ...string) AddressesQ
	FilterByRegion(regions ...string) AddressesQ
	FilterByPostalCodes(codes ...string) AddressesQ
}

type Cafe struct {
	Id        int64   `db:"id" structs:"-"`
	CafeName  string  `db:"cafe_name" structs:"cafe_name"`
	AddressId int64   `db:"address_id" structs:"address_id"`
	Rating    *string `db:"rating" structs:"rating"`
}

type CafesQ interface {
	New() CafesQ

	Get() (*Cafe, error)
	Select() ([]Cafe, error)

	Transaction(fn func(q CafesQ) error) error

	Insert(cafe Cafe) (Cafe, error)
	Update(cafe Cafe) (Cafe, error)
	Delete(id int64) error

	Page(pageParams pgdb.OffsetPageParams) CafesQ

	FilterById(ids ...int64) CafesQ
	FilterByNames(names ...string) CafesQ
	FilterByRatingFrom(ratings ...float64) CafesQ
	FilterByRatingTo(ratings ...float64) CafesQ
	FilterByAddressId(ids ...int64) CafesQ

	JoinAddress() CafesQ
}