sb

package module

Go to main page

Versions in this module

v0

v0.23.0

Mar 27, 2026

Changes in this version

+ var ErrMSSQLOffsetRequiresOrderBy = &BuilderError

+ var ErrOffsetWithoutLimit = &BuilderError

+ func TestMSSQLOffsetBug(t *testing.T)

v0.22.0

Mar 22, 2026

v0.21.0

Mar 22, 2026

v0.20.0

Mar 20, 2026

v0.19.0

Mar 20, 2026

Changes in this version

+ const INDEX_TYPE_BRIN

+ const INDEX_TYPE_BTREE

+ const INDEX_TYPE_FULLTEXT

+ const INDEX_TYPE_GIN

+ const INDEX_TYPE_GIST

+ const INDEX_TYPE_HASH

+ const INDEX_TYPE_SPATIAL

type Builder

+ func (b *Builder) CreateCompositeIndex(name string, columns []IndexColumn) (string, error)

+ func (b *Builder) CreateCoveringIndex(name string, include []string, columns ...string) (string, error)

+ func (b *Builder) CreateIndexWithOptions(name string, opts IndexOptions) (string, error)

+ func (b *Builder) CreatePartialIndex(name string, where string, columns ...string) (string, error)

+ func (b *Builder) CreateUniqueIndex(name string, columns ...string) (string, error)

+ func (b *Builder) DropIndexWithOptions(name string, opts DropIndexOptions) (string, error)

type BuilderInterface

+ CreateCompositeIndex func(name string, columns []IndexColumn) (string, error)

+ CreateCoveringIndex func(name string, include []string, columns ...string) (string, error)

+ CreateIndexWithOptions func(name string, opts IndexOptions) (string, error)

+ CreatePartialIndex func(name string, where string, columns ...string) (string, error)

+ CreateUniqueIndex func(name string, columns ...string) (string, error)

+ DropIndexWithOptions func(name string, opts DropIndexOptions) (string, error)

+ type DropIndexOptions struct

+ IfExists bool

+ Schema string

+ type IndexColumn struct

+ Direction string

+ Length int

+ Name string

+ type IndexOptions struct

+ Columns []IndexColumn

+ Comment string

+ IfNotExists bool

+ Include []string

+ Storage string

+ Unique bool

+ Using string

+ Where string

v0.18.0

Mar 20, 2026

Changes in this version

type Builder

+ func (b *Builder) WithInterpolatedValues() BuilderInterface

type BuilderInterface

+ WithInterpolatedValues func() BuilderInterface

v0.17.0

Mar 20, 2026

Changes in this version

+ var ErrEmptyColumnName = &BuilderError

+ var ErrEmptyColumns = &BuilderError

+ var ErrEmptyIndexName = &BuilderError

+ var ErrEmptyOnCondition = &BuilderError

+ var ErrEmptyTableName = &BuilderError

+ var ErrInvalidDialect = &BuilderError

+ var ErrInvalidJoinType = &BuilderError

+ var ErrMissingTable = &BuilderError

+ var ErrNilSubquery = &BuilderError

+ var ErrSubqueryColumns = &BuilderError

type Builder

+ func (b *Builder) Exists(subquery BuilderInterface) (BuilderInterface, error)

+ func (b *Builder) InSubquery(subquery BuilderInterface) (BuilderInterface, error)

+ func (b *Builder) InnerJoin(table string, onCondition string) BuilderInterface

+ func (b *Builder) Join(joinType JoinType, table string, onCondition string) BuilderInterface

+ func (b *Builder) JoinWithAlias(joinType JoinType, table string, alias string, onCondition string) BuilderInterface

+ func (b *Builder) LeftJoin(table string, onCondition string) BuilderInterface

+ func (b *Builder) NotExists(subquery BuilderInterface) (BuilderInterface, error)

+ func (b *Builder) NotInSubquery(subquery BuilderInterface) (BuilderInterface, error)

+ func (b *Builder) RightJoin(table string, onCondition string) BuilderInterface

+ func (b *Builder) Subquery() BuilderInterface

+ type BuilderError struct

+ Cause error

+ Message string

+ Type string

+ func NewConfigurationError(message string) *BuilderError

+ func NewSubqueryError(message string, cause error) *BuilderError

+ func NewValidationError(message string) *BuilderError

+ func (e *BuilderError) Error() string

+ func (e *BuilderError) Unwrap() error

type BuilderInterface

+ Exists func(subquery BuilderInterface) (BuilderInterface, error)

+ InSubquery func(subquery BuilderInterface) (BuilderInterface, error)

+ InnerJoin func(table string, onCondition string) BuilderInterface

+ Join func(joinType JoinType, table string, onCondition string) BuilderInterface

+ JoinWithAlias func(joinType JoinType, table string, alias string, onCondition string) BuilderInterface

+ LeftJoin func(table string, onCondition string) BuilderInterface

+ NotExists func(subquery BuilderInterface) (BuilderInterface, error)

+ NotInSubquery func(subquery BuilderInterface) (BuilderInterface, error)

+ RightJoin func(table string, onCondition string) BuilderInterface

+ Subquery func() BuilderInterface

+ type Join struct

+ Alias string

+ Columns []string

+ OnCondition string

+ Table string

+ Type JoinType

+ type JoinType string

+ const JOIN_CROSS

+ const JOIN_FULL

+ const JOIN_INNER

+ const JOIN_LEFT

+ const JOIN_RIGHT

type Where

+ IsNot bool

+ Subquery *Builder

v0.16.0

Mar 19, 2026

Changes in this version

type Builder

+ func (b *Builder) DropIndex(indexName string) string

+ func (b *Builder) DropIndexIfExists(indexName string) string

+ func (b *Builder) DropIndexWithSchema(indexName string, schema string) string

+ func (b *Builder) TruncateWithOptions(opts TruncateOptions) string

type BuilderInterface

+ DropIndex func(indexName string) string

+ DropIndexIfExists func(indexName string) string

+ DropIndexWithSchema func(indexName string, schema string) string

+ Truncate func() string

+ TruncateWithOptions func(opts TruncateOptions) string

+ type TruncateOptions struct

+ Cascade bool

+ ResetIdentity bool

v0.15.0

Nov 21, 2025

v0.14.0

Nov 21, 2025

v0.13.0

Nov 21, 2025

v0.12.0

Nov 5, 2025

v0.11.0

Sep 1, 2025

Changes in this version

+ const ASC

+ const COLUMN_ATTRIBUTE_AUTO

+ const COLUMN_ATTRIBUTE_DECIMALS

+ const COLUMN_ATTRIBUTE_LENGTH

+ const COLUMN_ATTRIBUTE_NULLABLE

+ const COLUMN_ATTRIBUTE_PRIMARY

+ const COLUMN_TYPE_BLOB

+ const COLUMN_TYPE_DATE

+ const COLUMN_TYPE_DATETIME

+ const COLUMN_TYPE_DECIMAL

+ const COLUMN_TYPE_FLOAT

+ const COLUMN_TYPE_INTEGER

+ const COLUMN_TYPE_LONGTEXT

+ const COLUMN_TYPE_STRING

+ const COLUMN_TYPE_TEXT

+ const DESC

+ const DIALECT_MSSQL

+ const DIALECT_MYSQL

+ const DIALECT_POSTGRES

+ const DIALECT_SQLITE

+ const MAX_DATE

+ const MAX_DATETIME

+ const NO

+ const NULL_DATE

+ const NULL_DATETIME

+ const YES

+ func DatabaseDriverName(db *sql.DB) string

+ func TableColumnExists(ctx database.QueryableContext, tableName, columnName string) (exists bool, err error)

+ func TableCreate(db *sql.DB, tableName string, columns []Column) error

+ func TableCreateSql(db *sql.DB, tableName string, columns []Column) string

+ func TableDrop(ctx database.QueryableContext, tableName string) error

+ func TableDropIfExists(ctx database.QueryableContext, tableName string) error

+ func TableDropIfExistsSql(ctx database.QueryableContext, tableName string) (string, error)

+ func TableDropSql(ctx database.QueryableContext, tableName string) (string, error)

+ type Builder struct

+ Dialect string

+ func NewBuilder(dialect string) *Builder

+ func (b *Builder) Column(column Column) BuilderInterface

+ func (b *Builder) Create() string

+ func (b *Builder) CreateIfNotExists() string

+ func (b *Builder) CreateIndex(indexName string, columnName ...string) string

+ func (b *Builder) Delete() string

+ func (b *Builder) Drop() string

+ func (b *Builder) DropIfExists() string

+ func (b *Builder) GroupBy(groupBy GroupBy) BuilderInterface

+ func (b *Builder) Insert(columnValuesMap map[string]string) string

+ func (b *Builder) Limit(limit int64) BuilderInterface

+ func (b *Builder) Offset(offset int64) BuilderInterface

+ func (b *Builder) OrderBy(columnName, direction string) BuilderInterface

+ func (b *Builder) Select(columns []string) string

+ func (b *Builder) Table(tableName string) BuilderInterface

+ func (b *Builder) TableColumnAdd(tableName string, column Column) (sql string, err error)

+ func (b *Builder) TableColumnChange(tableName string, column Column) (sqlString string, err error)

+ func (b *Builder) TableColumnDrop(tableName string, columnName string) (sqlString string, err error)

+ func (b *Builder) TableColumnExists(tableName, columnName string) (sql string, params []interface{}, err error)

+ func (b *Builder) TableColumnRename(tableName, oldColumnName, newColumnName string) (sql string, err error)

+ func (b *Builder) TableRename(oldTableName, newTableName string) (sql string, err error)

+ func (b *Builder) Truncate() string

+ func (b *Builder) Update(columnValues map[string]string) string

+ func (b *Builder) View(viewName string) BuilderInterface

+ func (b *Builder) ViewColumns(columns []string) BuilderInterface

+ func (b *Builder) ViewSQL(sql string) BuilderInterface

+ func (b *Builder) Where(where Where) BuilderInterface

+ type BuilderInterface interface

+ Column func(column Column) BuilderInterface

+ Create func() string

+ CreateIfNotExists func() string

+ CreateIndex func(indexName string, columnName ...string) string

+ Delete func() string

+ Drop func() string

+ DropIfExists func() string

+ GroupBy func(groupBy GroupBy) BuilderInterface

+ Insert func(columnValuesMap map[string]string) string

+ Limit func(limit int64) BuilderInterface

+ Offset func(offset int64) BuilderInterface

+ OrderBy func(columnName string, sortDirection string) BuilderInterface

+ Select func(columns []string) string

+ Table func(name string) BuilderInterface

+ TableColumnAdd func(tableName string, column Column) (sqlString string, err error)

+ TableColumnChange func(tableName string, column Column) (sqlString string, err error)

+ TableColumnDrop func(tableName string, columnName string) (sqlString string, err error)

+ TableColumnExists func(tableName, columnName string) (sqlString string, sqlParams []any, err error)

+ TableColumnRename func(tableName, oldColumnName, newColumnName string) (sqlString string, err error)

+ TableRename func(oldTableName string, newTableName string) (sqlString string, err error)

+ Update func(columnValues map[string]string) string

+ View func(name string) BuilderInterface

+ ViewColumns func(columns []string) BuilderInterface

+ ViewSQL func(sql string) BuilderInterface

+ Where func(where Where) BuilderInterface

+ type Column struct

+ AutoIncrement bool

+ Decimals int

+ Default string

+ Length int

+ Name string

+ Nullable bool

+ PrimaryKey bool

+ Type string

+ Unique bool

+ func TableColumns(ctx database.QueryableContext, tableName string, commonize bool) (columns []Column, err error)

+ type ColumnSQLGenerator interface

+ GenerateSQL func(column Column) string

+ type Database struct

+ func (d *Database) BeginTransaction() (err error)

+ func (d *Database) BeginTransactionWithContext(ctx context.Context, opts *sql.TxOptions) (err error)

+ func (d *Database) Close() (err error)

+ func (d *Database) CommitTransaction() (err error)

+ func (d *Database) DB() *sql.DB

+ func (d *Database) DebugEnable(debug bool)

+ func (d *Database) Exec(sqlStr string, args ...any) (sql.Result, error)

+ func (d *Database) ExecInTransaction(fn func(d *Database) error) (err error)

+ func (d *Database) IsMssql() bool

+ func (d *Database) IsMysql() bool

+ func (d *Database) IsPostgres() bool

+ func (d *Database) IsSqlite() bool

+ func (d *Database) Open() (err error)

+ func (d *Database) Query(sqlStr string, args ...any) (*sql.Rows, error)

+ func (d *Database) RollbackTransaction() (err error)

+ func (d *Database) SelectToMapAny(sqlStr string, args ...any) ([]map[string]any, error)

+ func (d *Database) SelectToMapString(sqlStr string, args ...any) ([]map[string]string, error)

+ func (d *Database) SqlLog() []map[string]string

+ func (d *Database) SqlLogEmpty()

+ func (d *Database) SqlLogEnable(enable bool)

+ func (d *Database) SqlLogLen() int

+ func (d *Database) SqlLogShrink(leaveLast int)

+ func (d *Database) Tx() *sql.Tx

+ func (d *Database) Type() string

+ type DatabaseInterface interface

+ BeginTransaction func() (err error)

+ BeginTransactionWithContext func(ctx context.Context, opts *sql.TxOptions) (err error)

+ Close func() (err error)

+ CommitTransaction func() (err error)

+ DB func() *sql.DB

+ DebugEnable func(debug bool)

+ Exec func(sqlStr string, args ...any) (sql.Result, error)

+ ExecInTransaction func(fn func(d *Database) error) (err error)

+ IsMssql func() bool

+ IsMysql func() bool

+ IsPostgres func() bool

+ IsSqlite func() bool

+ Open func() (err error)

+ Query func(sqlStr string, args ...any) (*sql.Rows, error)

+ RollbackTransaction func() (err error)

+ SelectToMapAny func(sqlStr string, args ...any) ([]map[string]any, error)

+ SelectToMapString func(sqlStr string, args ...any) ([]map[string]string, error)

+ SqlLog func() []map[string]string

+ SqlLogEmpty func()

+ SqlLogEnable func(enable bool)

+ SqlLogLen func() int

+ SqlLogShrink func(leaveLast int)

+ Tx func() *sql.Tx

+ Type func() string

+ func NewDatabase(db *sql.DB, databaseType string) DatabaseInterface

+ func NewDatabaseFromDriver(driverName, dataSourceName string) (DatabaseInterface, error)

+ type GroupBy struct

+ Column string

+ type MSSQLColumnSQLGenerator struct

+ func (g MSSQLColumnSQLGenerator) GenerateSQL(column Column) string

+ type MySQLColumnSQLGenerator struct

+ func (g MySQLColumnSQLGenerator) GenerateSQL(column Column) string

+ type OrderBy struct

+ Column string

+ Direction string

+ type PostgreSQLColumnSQLGenerator struct

+ func (g PostgreSQLColumnSQLGenerator) GenerateSQL(column Column) string

+ type SQLiteColumnSQLGenerator struct

+ func (g SQLiteColumnSQLGenerator) GenerateSQL(column Column) string

+ type Where struct

+ Children []Where

+ Column string

+ Operator string

+ Raw string

+ Type string

+ Value string

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL