models

type ConnectionConfig struct {
	User, Password, Protocol, Address, DbName string
	Port                                      int
}

type Filter interface {
	ForEach(fn ForEachFunc) error
}

type FilterPerson struct {
	ID             *string    `field:"id"         form:"id"             operator:"="`
	Name           *string    `field:"name"       form:"name"           operator:"="`
	City           *string    `field:"city"       form:"city"           operator:"="`
	BirthDateEq    *time.Time `field:"birth_date" form:"birth_date_eq"  operator:"="`
	BirthDateStart *time.Time `field:"birth_date" form:"birth_date_gte" operator:">="`
	BirthDateEnd   *time.Time `field:"birth_date" form:"birth_date_lte" operator:"<="`
	WeightEq       *float32   `field:"weight"     form:"weight_eq"      operator:"="`
	WeightStart    *float32   `field:"weight"     form:"weight_gte"     operator:">="`
	WeightEnd      *float32   `field:"weight"     form:"weight_lte"     operator:"<="`
	HeightEq       *float32   `field:"height"     form:"height_eq"      operator:"="`
	HeightStart    *float32   `field:"height"     form:"height_gte"     operator:">="`
	HeightEnd      *float32   `field:"height"     form:"height_lte"     operator:"<="`
}

type ForEachFunc func(field, operator string, value interface{}) error

type Person struct {
	ID        *string    `json:"id"         db:"id"`
	Name      *string    `json:"name"       db:"name"`
	City      *string    `json:"city"       db:"city"`
	BirthDate *time.Time `json:"birth_date" db:"birth_date"`
	Weight    *float32   `json:"weight"     db:"weight"`
	Height    *float32   `json:"height"     db:"height"`
}

type PersonMethods interface {
	AddPerson(person Person) (lastID string, err error)
	GetPerson(id string) (found bool, person Person, err error)
	ListPersons(filter FilterPerson) (persons []Person, err error)
	UpdatePerson(id string, person Person) (err error)
	DeletePerson(id string) (err error)
}

type QueryBuilder interface {
	PersonMethods
}