goqu

Documentation

Index

• type QueryBuilder
  • func New(db *sql.DB) *QueryBuilder
  • func (qb *QueryBuilder) AddPerson(person models.Person) (lastID string, err error)
  • func (qb *QueryBuilder) DeletePerson(id string) (err error)
  • func (qb *QueryBuilder) GenerateWhere(filter models.Filter) (where goqu.Ex, err error)
  • func (qb *QueryBuilder) GetPerson(id string) (found bool, person models.Person, err error)
  • func (qb *QueryBuilder) ListPersons(filter models.FilterPerson) (persons []models.Person, err error)
  • func (qb *QueryBuilder) UpdatePerson(id string, person models.Person) (err error)

Types

type QueryBuilder

type QueryBuilder struct {
	// DB is the connection pool to database
	DB *sql.DB
	// contains filtered or unexported fields
}

QueryBuilder is the query builder to goqu

func New

func New(db *sql.DB) *QueryBuilder

New creates query builder

func (*QueryBuilder) AddPerson

func (qb *QueryBuilder) AddPerson(person models.Person) (lastID string, err error)

AddPerson adds new person

func (*QueryBuilder) DeletePerson

func (qb *QueryBuilder) DeletePerson(id string) (err error)

DeletePerson deletes a person

func (*QueryBuilder) GenerateWhere

func (qb *QueryBuilder) GenerateWhere(filter models.Filter) (where goqu.Ex, err error)

GenerateWhere generates the where map

func (*QueryBuilder) GetPerson

func (qb *QueryBuilder) GetPerson(id string) (found bool, person models.Person, err error)

GetPerson gets a person by id

func (*QueryBuilder) ListPersons

func (qb *QueryBuilder) ListPersons(filter models.FilterPerson) (persons []models.Person, err error)

ListPersons lists persons using a filter

func (*QueryBuilder) UpdatePerson

func (qb *QueryBuilder) UpdatePerson(id string, person models.Person) (err error)

UpdatePerson updates a person by its id