sql

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

type PgQuery struct {
	*Pg
}

type PgTable struct {
	*Pg
}

type Query interface {
	Sort(filed string, sortBy string) Query
	Offset(offset int64) Query
	Limit(limit int64) Query
	Group(group string) Query
	Find(dest interface{}) error
	Count(count *int64) error
	Sum(sum *int64) error
	Avg(avg *int64) error
}

type SQL interface {
	Conn() *sql.DB
	Table(tableName string) Table
	// contains filtered or unexported methods
}

type Table interface {
	Select(fields string) Table
	Where(where string, argc ...interface{}) Table
	WhereOr(where string, argc ...interface{}) Table
	Sort(filed string, sortBy string) Query
	Offset(offset int64) Query
	Limit(limit int64) Query
	Group(group string) Query
	Find(dest interface{}) error
	Count(count *int64) error
	Sum(sum *int64) error
	Avg(avg *int64) error
	Update(dest interface{}) error
	Save(dest interface{}) error
	Delete() error
	SetInc(field string) error // feature:field value + 1
	SetDec(field string) error // feature:field value - 1
	// contains filtered or unexported methods
}