dal

type Dal struct {
	Connection *sql.DB
	Schema     *Schema
}

type Field struct {
	Name         string
	Type         string
	DefaultValue string
}

type IQuery interface {
	Query() (*sql.Rows, error)
	Exec() (result sql.Result, e error)
	And() IQuery
	Or() IQuery
	Where(name string, value interface{}) IQuery
	Set(fieldName string, value interface{}) IQuery
	Join(tableName string) IQuery
	OnValue(tableName string, value interface{}) IQuery
	OnField(fieldName string, joinTable string, joinField string) IQuery
	Limit(limit int) IQuery
	Offset(offset int) IQuery
	Order(field string, direction string) IQuery
	ToSQL() string
	GetValues() []interface{}
	SelectJoinField(tableName string, fieldName string, as string) IQuery
}

type ISchema interface {
	Select(tableName string) IQuery
	Update(tableName string) IQuery
	Delete(tableName string) IQuery
	Insert(tableName string) IQuery
	AddTable(name string, fields []string) error
	Table(name string) (t *Table)
	Exec(query string, args ...interface{}) (sql.Result, error)
	Query(query string, args ...interface{}) (result *sql.Rows, e error)
	GetTables() map[string]*Table
}

type Join struct {
	Table  *Table
	Fields []JoinField
}

type JoinField struct {
	FieldName string
	Value     interface{}
	JoinTable string
	JoinField string
}

type Query struct {
	Table *Table

	// Filters are the phrases used in the where clause
	Filters []ValueField

	Params []string
	Joins  []Join

	GroupBy     string
	SetFields   []string
	QueryType   string
	ValueFields []ValueField
	Dal         *Dal
	Values      []interface{}
	OrderBy     string
	OrderDir    string
	// SelectJoinFields is a collection of fields included in the list of fields selected
	// Format: `joinedTablePrefix`.`fieldName`
	SelectJoinFields []string
	// contains filtered or unexported fields
}

type Schema struct {
	Name    string
	Tables  map[string]*Table
	Aliases map[string]string
	Dal     *Dal
}

type Table struct {
	Name      string
	Fields    map[string]*Field
	Alias     string
	FieldKeys []string
}

type ValueField struct {
	Name  string
	Value interface{}
}