sqlf

type ColumnList struct {
	// contains filtered or unexported fields
}

type DeleteInfo struct {
	TableName    TableName
	WhereColumns ColumnList
}

type Dialect interface {
	// Quote a table name or column name so that it does
	// not clash with any reserved words. The SQL-99 standard
	// specifies double quotes (eg "table_name"), but many
	// dialects, including MySQL use the backtick (eg `table_name`).
	// SQL server uses square brackets (eg [table_name]).
	Quote(name string) string

	// Return the placeholder for binding a variable value.
	// Most SQL dialects support a single question mark (?), but
	// PostgreSQL uses numbered placeholders (eg $1).
	Placeholder(n int) string
}

type ExecCommand interface {
	// Command returns the SQL statement with placeholders for arguments..
	Command() string

	// Exec executes the SQL statement with the arguments given.
	Exec(db sqlx.Execer, args ...interface{}) (sql.Result, error)
}

type InsertInfo struct {
	// Table name for use in INSERT INTO clause.
	TableName TableName

	// Columns that should appear in the parentheses
	// after  INSERT INTO table(...). By default these
	// are all columns except for any auto-increment columns.
	Columns ColumnList

	// Placeholders that match the Columns list.
	Values ColumnList
}

type InsertRowCommand interface {
	// Command returns the SQL insert statement with placeholders for arguments..
	Command() string

	// Args returns an array of arguments for the SQL command
	// based on the contents of the row.
	Args(row interface{}) ([]interface{}, error)

	// Exec executes the SQL insert statement with the arguments
	// appropriate for the contents of the row. If the row has
	// an auto-increment column, it will be populated with the value
	// generated by the database server.
	Exec(db sqlx.Execer, row interface{}) error
}

type Placeholder struct {
	// contains filtered or unexported fields
}

type QueryCommand interface {
	// Command returns the SQL select statement with placeholders for arguments..
	Command() string

	// Query executes the query with the arguments given.
	Query(db sqlx.Queryer, args ...interface{}) (*sqlx.Rows, error)

	// QueryRow executes the query, which is expected to return at most one row.
	// QueryRow always returns a non-nil value. Errors are deferred until the Scan
	// method is called on the Row.
	QueryRow(db sqlx.Queryer, args ...interface{}) *sqlx.Row

	// Select executes a query using the provided Queryer, and StructScans each
	// row into dest, which must be a slice. If the slice elements are scannable,
	// then the result set must have only one column. Otherwise StructScan is
	// used. The *sql.Rows are closed automatically.
	Select(db sqlx.Queryer, dest interface{}, args ...interface{}) error
}

type SelectInfo struct {
	TableName TableName
	Columns   ColumnList
	OrderBy   ColumnList
}

type Settings struct {
	Dialect        Dialect
	ColumnNameFunc func(name string) string
}

type TableInfo struct {
	Name   string
	Select SelectInfo
	Insert InsertInfo
	Update UpdateInfo
	Delete DeleteInfo
	// contains filtered or unexported fields
}

type TableName struct {
	// contains filtered or unexported fields
}

type UpdateInfo struct {
	TableName    TableName
	SetColumns   ColumnList
	WhereColumns ColumnList
}

type UpdateRowCommand interface {
	// Command returns the SQL update/delete statement with placeholders for arguments..
	Command() string

	// Args returns an array of arguments for the SQL update/delete command
	// based on the contents of the row.
	Args(row interface{}) ([]interface{}, error)

	// Exec executes the SQL update/delete statement with the arguments
	// appropriate for the contents of the row. Returns the number
	// of rows updated, which should be zero or one. The contents of the
	// row struct are unchanged.
	Exec(db sqlx.Execer, row interface{}) (rowCount int, err error)
}