sqlc

type Aliasable interface {
	Alias() string
	MaybeAlias() string
}

type Condition struct {
	Binding   FieldBinding
	Predicate PredicateType
}

type DeleteWhereStep interface {
	Executable
	Where(...Condition) Executable
}

type Dialect int

type Executable interface {
	Renderable
	Exec(Dialect, *sql.DB) (sql.Result, error)
}

type Field interface {
	Aliasable
	Functional
	Name() string
	As(string) Field
	Function() FieldFunction
}

type FieldBinding struct {
	Field Field
	Value interface{}
}

type FieldFunction struct {
	Child *FieldFunction
	Name  string
	Expr  string
	Args  []interface{}
}

type FieldMeta struct {
	Name string
	Type string
}

type Functional interface {
	Avg() Field

	Max() Field

	Min() Field

	Ceil() Field

	Div(_0 interface{}) Field

	Cast(_0 interface{}) Field

	Md5() Field

	Lower() Field

	Hex() Field
}

type InsertResultStep interface {
	Renderable
	Fetch(Dialect, *sql.DB) (*sql.Row, error)
}

type InsertSetMoreStep interface {
	Executable
	InsertSetStep
	Returning(TableField) InsertResultStep
}

type InsertSetStep interface {
	SetString(StringField, string) InsertSetMoreStep

	SetInt(IntField, int) InsertSetMoreStep

	SetInt64(Int64Field, int64) InsertSetMoreStep

	SetTime(TimeField, time.Time) InsertSetMoreStep
}

type Int64Field interface {
	TableField

	Eq(value int64) Condition
	IsEq(value Int64Field) JoinCondition

	Gt(value int64) Condition
	IsGt(value Int64Field) JoinCondition

	Ge(value int64) Condition
	IsGe(value Int64Field) JoinCondition

	Lt(value int64) Condition
	IsLt(value Int64Field) JoinCondition

	Le(value int64) Condition
	IsLe(value Int64Field) JoinCondition
}

type IntField interface {
	TableField

	Eq(value int) Condition
	IsEq(value IntField) JoinCondition

	Gt(value int) Condition
	IsGt(value IntField) JoinCondition

	Ge(value int) Condition
	IsGe(value IntField) JoinCondition

	Lt(value int) Condition
	IsLt(value IntField) JoinCondition

	Le(value int) Condition
	IsLe(value IntField) JoinCondition
}

type JoinCondition struct {
	Lhs, Rhs  TableField
	Predicate PredicateType
}

type JoinType int

type Options struct {
	File    string `short:"f" long:"file" description:"The path to the sqlite file"`
	Url     string `short:"u" long:"url" description:"The DB URL"`
	Output  string `short:"o" long:"output" description:"The path to save the generated objects to" required:"true"`
	Package string `short:"p" long:"package" description:"The package to put the generated objects into" required:"true"`
	Type    string `short:"t" long:"type" description:"The type of the DB (mysql,postgres,sqlite)" required:"true"`
	Schema  string `short:"s" long:"schema" description:"The target DB schema (required for MySQL and Postgres)"`
	Version func() `short:"V" long:"version" description:"Print sqlc version and exit"`
	Dialect Dialect
}

type PredicateType int

type Provenance struct {
	Version   string
	Timestamp time.Time
}

type Query interface {
	Renderable
	Selectable
	Query(Dialect, *sql.DB) (*sql.Rows, error)
	QueryRow(Dialect, *sql.DB) (*sql.Row, error)
}

type Queryable interface {
	Fields() []Field
}

type Reflectable interface {
	StringField(name string) StringField

	IntField(name string) IntField

	Int64Field(name string) Int64Field

	TimeField(name string) TimeField
}

type Renderable interface {
	Render(Dialect, io.Writer) []interface{}
	String(Dialect) string
}

type SelectFromStep interface {
	From(Selectable) SelectWhereStep
}

type SelectGroupByStep interface {
	GroupBy(...Field) SelectHavingStep
}

type SelectHavingStep interface {
	SelectOrderByStep
	Query
}

type SelectJoinStep interface {
	Join(Selectable) SelectOnStep
	LeftOuterJoin(Selectable) SelectOnStep
}

type SelectLimitStep interface {
	Query
}

type SelectOnStep interface {
	On(...JoinCondition) SelectWhereStep
	Query
}

type SelectOrderByStep interface {
	OrderBy(...Field) SelectLimitStep
}

type SelectWhereStep interface {
	Query
	SelectGroupByStep
	SelectJoinStep
	Where(conditions ...Condition) Query
}

type Selectable interface {
	Aliasable
	Reflectable
	IsSelectable()
}

type StringField interface {
	TableField

	Eq(value string) Condition
	IsEq(value StringField) JoinCondition

	Gt(value string) Condition
	IsGt(value StringField) JoinCondition

	Ge(value string) Condition
	IsGe(value StringField) JoinCondition

	Lt(value string) Condition
	IsLt(value StringField) JoinCondition

	Le(value string) Condition
	IsLe(value StringField) JoinCondition
}

type TableField interface {
	Field
	Parent() Selectable
}

type TableFieldBinding struct {
	Field TableField
	Value interface{}
}

type TableLike interface {
	Selectable
	Name() string
	As(string) Selectable
	Queryable
}

type TableMeta struct {
	Name   string
	Fields []FieldMeta
}

type TimeField interface {
	TableField

	Eq(value time.Time) Condition
	IsEq(value TimeField) JoinCondition

	Gt(value time.Time) Condition
	IsGt(value TimeField) JoinCondition

	Ge(value time.Time) Condition
	IsGe(value TimeField) JoinCondition

	Lt(value time.Time) Condition
	IsLt(value TimeField) JoinCondition

	Le(value time.Time) Condition
	IsLe(value TimeField) JoinCondition
}

type UpdateSetMoreStep interface {
	Executable
	UpdateSetStep
	Where(conditions ...Condition) Executable
}

type UpdateSetStep interface {
	SetString(StringField, string) UpdateSetMoreStep

	SetInt(IntField, int) UpdateSetMoreStep

	SetInt64(Int64Field, int64) UpdateSetMoreStep

	SetTime(TimeField, time.Time) UpdateSetMoreStep
}