builder.go

package dat

// Builder interface is used to tie SQL generators to executors.
type Builder interface {
	// ToSQL builds the SQL and arguments from builder.
	ToSQL() (string, []interface{})

	// Interpolate builds the interpolation SQL and arguments from builder.
	// If interpolation flag is disabled then this is just a passthrough to ToSQL.
	Interpolate() (string, []interface{}, error)

	// IsInterpolated determines if this builder will interpolate when
	// Interpolate() is called.
	IsInterpolated() bool
}

// Call creates a new CallBuilder for the given sproc and args.
func Call(sproc string, args ...interface{}) *CallBuilder {
	b := NewCallBuilder(sproc, args...)
	b.Execer = nullExecer
	return b
}

// DeleteFrom creates a new DeleteBuilder for the given table.
func DeleteFrom(table string) *DeleteBuilder {
	b := NewDeleteBuilder(table)
	b.Execer = nullExecer
	return b
}

// InsertInto creates a new InsertBuilder for the given table.
func InsertInto(table string) *InsertBuilder {
	b := NewInsertBuilder(table)
	b.Execer = nullExecer
	return b
}

// Insect inserts into a table if does not exist.
func Insect(table string) *InsectBuilder {
	b := NewInsectBuilder(table)
	b.Execer = nullExecer
	return b
}

// Select creates a new SelectBuilder for the given columns.
func Select(columns ...string) *SelectBuilder {
	b := NewSelectBuilder(columns...)
	b.Execer = nullExecer
	return b
}

// SelectDoc creates a new SelectDocBuilder for the given columns.
func SelectDoc(columns ...string) *SelectDocBuilder {
	b := NewSelectDocBuilder(columns...)
	b.Execer = nullExecer
	return b
}

// SQL creates a new raw SQL builder.
func SQL(sql string, args ...interface{}) *RawBuilder {
	b := NewRawBuilder(sql, args...)
	b.Execer = nullExecer
	return b
}

// Update creates a new UpdateBuilder for the given table.
func Update(table string) *UpdateBuilder {
	b := NewUpdateBuilder(table)
	b.Execer = nullExecer
	return b
}

// Upsert insert (if it does not exist) or updates a row.
func Upsert(table string) *UpsertBuilder {
	b := NewUpsertBuilder(table)
	b.Execer = nullExecer
	return b
}