clauses

type DeleteClause interface {
	Where(condition interface{}) DeleteClause
	WhereOr(condition interface{}) DeleteClause
	WhereNot(condition interface{}) DeleteClause
	Limit(number int) DeleteClause
	GetSQLQuery() string
	Exec() (sql.Result, error)
}

type InsertClause interface {
	SetData(data interface{}) InsertClause
	GetSQLQuery() string
	Exec() (sql.Result, error)
}

type SelectClause interface {
	Limit(number int) SelectClause
	OrderBy(orderBy []string) SelectClause
	Where(condition interface{}) SelectClause
	WhereNot(condition interface{}) SelectClause
	WhereOr(condition interface{}) SelectClause
	GetSQLQuery() string
	All(target interface{}) error
	First(target interface{}) error
	Last(target interface{}) error
}

type UpdateClause interface {
	SetData(data interface{}) UpdateClause
	Where(condition interface{}) UpdateClause
	WhereOr(condition interface{}) UpdateClause
	WhereNot(condition interface{}) UpdateClause
	GetSQLQuery() string
	Exec() (sql.Result, error)
	OrderBy(orderBy []string) UpdateClause
	Limit(number int) UpdateClause
}