package tk

type Example interface {
	CreateCriteria() Criteria
	Or(criteria Criteria) Example
	And(criteria Criteria) Example
	OrderBy(order string) Example
	Distinct(d bool) Example
	explain() (string, []interface{})
	String() string
}

type Criteria interface {
	AndIsNull(field string) Criteria
	AndIsNotNull(field string) Criteria
	AndEqualTo(field string, value interface{}) Criteria
	AndNotEqualTo(field string, value interface{}) Criteria
	AndGreaterThan(field string, value interface{}) Criteria
	AndNotGreaterThan(field string, value interface{}) Criteria
	AndLessThan(field string, value interface{}) Criteria
	AndNotLessThan(field string, value interface{}) Criteria
	AndIn(field string, list ...interface{}) Criteria
	AndNotIn(field string, list ...interface{}) Criteria
	AndLike(field string, value interface{}) Criteria
	AndNotLike(field string, value interface{}) Criteria
	AndBetween(field string, value1, value2 interface{}) Criteria
	AndNotBetween(field string, value1, value2 interface{}) Criteria

	OrIsNull(field string) Criteria
	OrIsNotNull(field string) Criteria
	OrEqualTo(field string, value interface{}) Criteria
	OrNotEqualTo(field string, value interface{}) Criteria
	OrGreaterThan(field string, value interface{}) Criteria
	OrNotGreaterThan(field string, value interface{}) Criteria
	OrLessThan(field string, value interface{}) Criteria
	OrNotLessThan(field string, value interface{}) Criteria
	OrIn(field string, list ...interface{}) Criteria
	OrNotIn(field string, list ...interface{}) Criteria
	OrLike(field string, value interface{}) Criteria
	OrNotLike(field string, value interface{}) Criteria
	OrBetween(field string, value1, value2 interface{}) Criteria
	OrNotBetween(field string, value1, value2 interface{}) Criteria

	raw() (string, []interface{})
}

type ISelectMapper interface {
	SelectByExample(example Example, value interface{})
}