sql_statement

type BaseStatement interface {
	Execute() error
}

type BuilderFactories struct {
	Insert InsertBuilderFactory
	Update UpdateBuilderFactory
	Delete DeleteBuilderFactory
	Select SelectBuilderFactory
}

type DeleteBuilder interface {
	Where(condition string, args ...interface{}) DeleteBuilder
	RowsAffectedDest(rowsAffectedDest *int64) DeleteBuilder
	Build() DeleteStatement
}

type DeleteBuilderFactory interface {
	FromDialect(dialect databases.Dialect, tableName string) DeleteBuilder
	Mysql(tableName string) DeleteBuilder
	Sqlite(tableName string) DeleteBuilder
	Postgres(tableName string) DeleteBuilder
}

type DeleteStatement interface {
	BaseStatement
}

type InsertBuilder interface {
	Set(name string, value interface{}) InsertBuilder
	LastInsertIdDest(lastInsertIdDest *int64) InsertBuilder
	Build() InsertStatement
}

type InsertBuilderFactory interface {
	FromDialect(dialect databases.Dialect, tableName string) InsertBuilder
	Mysql(tableName string) InsertBuilder
	Sqlite(tableName string) InsertBuilder
	Postgres(tableName string) InsertBuilder
}

type InsertStatement interface {
	BaseStatement
}

type SelectBuilder interface {
	Where(condition string, args ...interface{}) SelectBuilder
	OrderBy(orderBy string) SelectBuilder
	Limit(limit int) SelectBuilder
	Offset(offset int) SelectBuilder
	Map(colName string, destValue interface{}) SelectBuilder
	MapCountStar(destValue *int) SelectBuilder
	MapSlice(destSlice interface{}) SelectBuilder

	ClearMappings() SelectBuilder
	ClearLimit() SelectBuilder
	ClearOffset() SelectBuilder

	Clone() SelectBuilder

	Build() SelectStatement
}

type SelectBuilderFactory interface {
	FromDialect(dialect databases.Dialect, tableName string) SelectBuilder
	Mysql(tableName string) SelectBuilder
	Sqlite(tableName string) SelectBuilder
	Postgres(tableName string) SelectBuilder
}

type SelectStatement interface {
	BaseStatement
}

type UpdateBuilder interface {
	Where(condition string, args ...interface{}) UpdateBuilder
	Set(name string, value interface{}) UpdateBuilder
	RowsAffectedDest(rowsAffectedDest *int64) UpdateBuilder
	Build() UpdateStatement
}

type UpdateBuilderFactory interface {
	FromDialect(dialect databases.Dialect, tableName string) UpdateBuilder
	Mysql(tableName string) UpdateBuilder
	Sqlite(tableName string) UpdateBuilder
	Postgres(tableName string) UpdateBuilder
}

type UpdateStatement interface {
	BaseStatement
}