sql

type Column struct {
	Name      string
	Type      string
	NotNull   bool
	Default   string
	Reference *Reference
}

type DefaultDialect struct{}

type Dialect interface {
	Name() string
	Features() Features
	RowId() string
	ColumnType(field *ir.Field) string
	Rebind(sql string) string
	EscapeString(s string) string
	BoolLit(v bool) string
	DefaultLit(v string) string
	// ReturningLit returns with literal to be used for returning values from an insert.
	ReturningLit() string

	// CreateSchema generates SQL from abstract schema to create all the required tables/indexes.
	CreateSchema(schema *Schema) []sqlgen.SQL

	// DropSchema drops all the resources from the schema. Useful for testing.
	DropSchema(schema *Schema) []sqlgen.SQL
}

type Features struct {
	// Supports DEFAULT VALUES in INSERT statement
	DefaultValues bool

	// Supports comparing tuples, such as (a, b) < (c, d)
	TupleComparsion bool

	// Supports positional argument placeholders
	PositionalArguments bool

	// Token used with LIMIT to mean "no limit"
	NoLimitToken string

	// What style the database uses to handle replacement creates
	ReplaceStyle ReplaceStyle

	// Supports the STORING feature of indexes
	Storing bool
}

type GroupBy struct {
	Fields []string
}

type Index struct {
	Name    string
	Table   string
	Columns []string
	Unique  bool
	Where   []sqlgen.SQL
	Storing []string
}

type Insert struct {
	Table      string
	PrimaryKey []string

	// StaticColumns are column names without defaults, requested to be inserted
	StaticColumns []string

	// DynamicColumns are column names with defaults, requested to be inserted
	DynamicColumns []string

	// AllDefaults are all the available non-ref columns (even if they are not requested as insert parameters).
	AllDefaults []string

	Returning    []string
	ReplaceStyle *ReplaceStyle
	// SupportDefaultValues should be true, if `INSERT INTO .... DEFAULT VALUES` is supported
	SupportDefaultValues bool
	ReturningLit         string
}

type Join struct {
	Type  string
	Table string
	Left  string
	Right string
}

type OrderBy struct {
	Entries []OrderByEntry
}

type OrderByEntry struct {
	Field      string
	Descending bool
}

type Reference struct {
	Table    string
	Column   string
	OnDelete string
	OnUpdate string
}

type ReplaceStyle int

type Schema struct {
	Tables  []Table
	Indexes []Index
}

type Select struct {
	From    string
	Fields  []string
	Joins   []Join
	Where   []sqlgen.SQL
	GroupBy *GroupBy
	OrderBy *OrderBy
	Limit   string
	Offset  string
	Has     bool
}

type Table struct {
	Name       string
	Columns    []Column
	PrimaryKey []string
	Unique     [][]string
}

type Update struct {
	Table        string
	Where        []sqlgen.SQL
	Returning    []string
	In           sqlgen.SQL
	ReturningLit string
}