db

type Criteria struct {
	Prefix    string
	Field     string
	Operation string
	Value     string
	Suffix    string
}

type DataSet interface {
	Open()
	Close()
	GetBy(key string, ids ...string) (*sql.Rows, error)
	Find(q *Query) (*sql.Rows, error)
	Query(stmt string, args ...interface{}) (*sql.Rows, error)
	Save(fieldList []FieldValue) error
	Delete(field FieldValue) error
}

type DatasetField struct {
	Name   string
	Type   string
	Extras string
	IsID   bool
}

type FieldValue struct {
	Name  string
	Value interface{}
}

type Limit struct {
	//Offset nr of record to skip
	Offset int
	// Size length of the set to return
	Size int
}

type OrderBy struct {
	Field string
	Sort  Sort
}

type Query struct {
	// Criteria list of WHERE parameters
	Criteria []Criteria
	// OrderBy the order of the query
	OrderBy OrderBy
	Limit   Limit
}

type Sort string

type SqliteDataset struct {
	DataSet
	// contains filtered or unexported fields
}