Documentation
¶
Index ¶
- Constants
- type BatchUpdateBuilder
- func (b *BatchUpdateBuilder) AddBigintColumn(name string) *BatchUpdateBuilder
- func (b *BatchUpdateBuilder) AddBooleanColumn(name string) *BatchUpdateBuilder
- func (b *BatchUpdateBuilder) AddDateColumn(name string) *BatchUpdateBuilder
- func (b *BatchUpdateBuilder) AddFloatColumn(name string) *BatchUpdateBuilder
- func (b *BatchUpdateBuilder) AddTextColumn(name string) *BatchUpdateBuilder
- func (b *BatchUpdateBuilder) AddTimeStampColumn(name string) *BatchUpdateBuilder
- func (b *BatchUpdateBuilder) AddVarCharColumn(name string) *BatchUpdateBuilder
- func (b *BatchUpdateBuilder) NumberOfRows(n int) *BatchUpdateBuilder
- func (b *BatchUpdateBuilder) PrimaryKey(pks ...string) *BatchUpdateBuilder
- func (b *BatchUpdateBuilder) QueryxContext(db sqlx.ExtContext, args []any, scanFunc func(*sqlx.Rows, *int) error) error
- func (b *BatchUpdateBuilder) Returning(cols ...string) *BatchUpdateBuilder
- func (b *BatchUpdateBuilder) ReturningCreatedAt() *BatchUpdateBuilder
- func (b *BatchUpdateBuilder) ReturningID() *BatchUpdateBuilder
- func (b *BatchUpdateBuilder) Table(table string) *BatchUpdateBuilder
- type DeleteBuilder
- func (d *DeleteBuilder) From(table string) *DeleteBuilder
- func (d *DeleteBuilder) IsActive() *DeleteBuilder
- func (d *DeleteBuilder) IsDeleted(deleted bool) *DeleteBuilder
- func (d *DeleteBuilder) Returning(fields ...string) *DeleteBuilder
- func (d *DeleteBuilder) ToSQL() (query string, args []any, err error)
- func (d *DeleteBuilder) Where(pred any, args ...any) *DeleteBuilder
- func (d *DeleteBuilder) WhereID(id any) *DeleteBuilder
- func (d *DeleteBuilder) WhereMap(clauses map[string]any) *DeleteBuilder
- type InsertBuilder
- func (i *InsertBuilder) Columns(columns ...string) *InsertBuilder
- func (i *InsertBuilder) Into(table string) *InsertBuilder
- func (i *InsertBuilder) OnConflict(clause string) *InsertBuilder
- func (i *InsertBuilder) OnConflictDoNothing() *InsertBuilder
- func (i *InsertBuilder) OnConflictDoUpdate(conflictColumn string, updateColumns ...string) *InsertBuilder
- func (i *InsertBuilder) QueryxContext(db sqlx.ExtContext, scanFunc func(*sqlx.Rows, *int) error) error
- func (i *InsertBuilder) Returning(fields ...string) *InsertBuilder
- func (i *InsertBuilder) ReturningID() *InsertBuilder
- func (i *InsertBuilder) SetMap(clauses map[string]any) *InsertBuilder
- func (i *InsertBuilder) ToSQL() (query string, args []any, err error)
- func (i *InsertBuilder) Values(values ...any) *InsertBuilder
- type SelectBuilder
- func (s *SelectBuilder) Columns(columns ...string) *SelectBuilder
- func (s *SelectBuilder) From(table string) *SelectBuilder
- func (s *SelectBuilder) GroupBy(groupBys ...string) *SelectBuilder
- func (s *SelectBuilder) Having(pred any, args ...any) *SelectBuilder
- func (s *SelectBuilder) InnerJoin(join string, args ...any) *SelectBuilder
- func (s *SelectBuilder) IsActive() *SelectBuilder
- func (s *SelectBuilder) IsDeleted(deleted bool) *SelectBuilder
- func (s *SelectBuilder) Join(join string, args ...any) *SelectBuilder
- func (s *SelectBuilder) LeftJoin(join string, args ...any) *SelectBuilder
- func (s *SelectBuilder) Limit(limit uint64) *SelectBuilder
- func (s *SelectBuilder) Offset(offset uint64) *SelectBuilder
- func (s *SelectBuilder) OrderBy(orderBys ...string) *SelectBuilder
- func (s *SelectBuilder) RightJoin(join string, args ...any) *SelectBuilder
- func (s *SelectBuilder) ToSQL() (query string, args []any, err error)
- func (s *SelectBuilder) Where(pred any, args ...any) *SelectBuilder
- func (s *SelectBuilder) WhereID(id any) *SelectBuilder
- type UpdateBuilder
- func (u *UpdateBuilder) IsActive() *UpdateBuilder
- func (u *UpdateBuilder) IsDeleted(deleted bool) *UpdateBuilder
- func (u *UpdateBuilder) Returning(fields ...string) *UpdateBuilder
- func (u *UpdateBuilder) Set(column string, value any) *UpdateBuilder
- func (u *UpdateBuilder) SetMap(clauses map[string]any) *UpdateBuilder
- func (u *UpdateBuilder) Table(table string) *UpdateBuilder
- func (u *UpdateBuilder) ToSQL() (query string, args []any, err error)
- func (u *UpdateBuilder) Where(pred any, args ...any) *UpdateBuilder
- func (u *UpdateBuilder) WhereID(id any) *UpdateBuilder
- func (u *UpdateBuilder) WhereMap(clauses map[string]any) *UpdateBuilder
Constants ¶
const ( ID = "id" IsDeleted = "is_deleted" IsActive = "is_active" CreatedAt = "created_at" ModifiedAt = "modified_at" )
const MaxParams = 65535
MaxParams is the maximum number of parameters allowed in a single Postgres query.
Variables ¶
This section is empty.
Functions ¶
This section is empty.
Types ¶
type BatchUpdateBuilder ¶
type BatchUpdateBuilder struct {
// contains filtered or unexported fields
}
func BatchUpdate ¶
func BatchUpdate(ctx context.Context) *BatchUpdateBuilder
BatchUpdate creates a new BatchUpdateBuilder
func (*BatchUpdateBuilder) AddBigintColumn ¶
func (b *BatchUpdateBuilder) AddBigintColumn(name string) *BatchUpdateBuilder
func (*BatchUpdateBuilder) AddBooleanColumn ¶
func (b *BatchUpdateBuilder) AddBooleanColumn(name string) *BatchUpdateBuilder
func (*BatchUpdateBuilder) AddDateColumn ¶
func (b *BatchUpdateBuilder) AddDateColumn(name string) *BatchUpdateBuilder
func (*BatchUpdateBuilder) AddFloatColumn ¶
func (b *BatchUpdateBuilder) AddFloatColumn(name string) *BatchUpdateBuilder
func (*BatchUpdateBuilder) AddTextColumn ¶
func (b *BatchUpdateBuilder) AddTextColumn(name string) *BatchUpdateBuilder
func (*BatchUpdateBuilder) AddTimeStampColumn ¶
func (b *BatchUpdateBuilder) AddTimeStampColumn(name string) *BatchUpdateBuilder
func (*BatchUpdateBuilder) AddVarCharColumn ¶
func (b *BatchUpdateBuilder) AddVarCharColumn(name string) *BatchUpdateBuilder
func (*BatchUpdateBuilder) NumberOfRows ¶
func (b *BatchUpdateBuilder) NumberOfRows(n int) *BatchUpdateBuilder
func (*BatchUpdateBuilder) PrimaryKey ¶
func (b *BatchUpdateBuilder) PrimaryKey(pks ...string) *BatchUpdateBuilder
func (*BatchUpdateBuilder) QueryxContext ¶
func (b *BatchUpdateBuilder) QueryxContext(db sqlx.ExtContext, args []any, scanFunc func(*sqlx.Rows, *int) error) error
func (*BatchUpdateBuilder) Returning ¶
func (b *BatchUpdateBuilder) Returning(cols ...string) *BatchUpdateBuilder
func (*BatchUpdateBuilder) ReturningCreatedAt ¶
func (b *BatchUpdateBuilder) ReturningCreatedAt() *BatchUpdateBuilder
func (*BatchUpdateBuilder) ReturningID ¶
func (b *BatchUpdateBuilder) ReturningID() *BatchUpdateBuilder
func (*BatchUpdateBuilder) Table ¶
func (b *BatchUpdateBuilder) Table(table string) *BatchUpdateBuilder
type DeleteBuilder ¶
type DeleteBuilder struct {
// contains filtered or unexported fields
}
func HardDelete ¶
func HardDelete(ctx context.Context) *DeleteBuilder
HardDelete creates a new DeleteBuilder for HARD DELETE operations
func (*DeleteBuilder) From ¶
func (d *DeleteBuilder) From(table string) *DeleteBuilder
From sets the table to delete from
func (*DeleteBuilder) IsActive ¶
func (d *DeleteBuilder) IsActive() *DeleteBuilder
IsActive adds a WHERE clause for is_active = true
func (*DeleteBuilder) IsDeleted ¶
func (d *DeleteBuilder) IsDeleted(deleted bool) *DeleteBuilder
IsDeleted adds a WHERE clause for is_deleted filtering
func (*DeleteBuilder) Returning ¶
func (d *DeleteBuilder) Returning(fields ...string) *DeleteBuilder
Returning adds RETURNING clause
func (*DeleteBuilder) ToSQL ¶
func (d *DeleteBuilder) ToSQL() (query string, args []any, err error)
ToSQL builds and returns the SQL query string and arguments
func (*DeleteBuilder) Where ¶
func (d *DeleteBuilder) Where(pred any, args ...any) *DeleteBuilder
Where adds a WHERE clause
func (*DeleteBuilder) WhereID ¶
func (d *DeleteBuilder) WhereID(id any) *DeleteBuilder
WhereID adds a WHERE clause for id = value
func (*DeleteBuilder) WhereMap ¶
func (d *DeleteBuilder) WhereMap(clauses map[string]any) *DeleteBuilder
WhereMap adds WHERE clauses from a map
type InsertBuilder ¶
type InsertBuilder struct {
// contains filtered or unexported fields
}
func Insert ¶
func Insert(ctx context.Context) *InsertBuilder
Insert creates a new InsertBuilder with Dollar placeholder format
func (*InsertBuilder) Columns ¶
func (i *InsertBuilder) Columns(columns ...string) *InsertBuilder
Columns sets the columns to insert
func (*InsertBuilder) Into ¶
func (i *InsertBuilder) Into(table string) *InsertBuilder
Into sets the table to insert into
func (*InsertBuilder) OnConflict ¶
func (i *InsertBuilder) OnConflict(clause string) *InsertBuilder
OnConflict adds ON CONFLICT clause for upsert operations
func (*InsertBuilder) OnConflictDoNothing ¶
func (i *InsertBuilder) OnConflictDoNothing() *InsertBuilder
OnConflictDoNothing adds ON CONFLICT DO NOTHING clause
func (*InsertBuilder) OnConflictDoUpdate ¶
func (i *InsertBuilder) OnConflictDoUpdate(conflictColumn string, updateColumns ...string) *InsertBuilder
OnConflictDoUpdate adds ON CONFLICT DO UPDATE clause
func (*InsertBuilder) QueryxContext ¶
func (i *InsertBuilder) QueryxContext(db sqlx.ExtContext, scanFunc func(*sqlx.Rows, *int) error) error
QueryxContext executes the insert query with automatic batching when exceeding MaxParams
func (*InsertBuilder) Returning ¶
func (i *InsertBuilder) Returning(fields ...string) *InsertBuilder
Returning adds RETURNING clause
func (*InsertBuilder) ReturningID ¶
func (i *InsertBuilder) ReturningID() *InsertBuilder
ReturningID adds RETURNING id clause
func (*InsertBuilder) SetMap ¶
func (i *InsertBuilder) SetMap(clauses map[string]any) *InsertBuilder
SetMap sets column values from a map
func (*InsertBuilder) ToSQL ¶
func (i *InsertBuilder) ToSQL() (query string, args []any, err error)
ToSQL builds and returns the SQL query string and arguments
func (*InsertBuilder) Values ¶
func (i *InsertBuilder) Values(values ...any) *InsertBuilder
Values adds a row of values to insert
type SelectBuilder ¶
type SelectBuilder struct {
// contains filtered or unexported fields
}
SelectBuilder wraps squirrel.SelectBuilder with additional functionality
func Select ¶
func Select(ctx context.Context) *SelectBuilder
Select creates a new SelectBuilder with Dollar placeholder format
func (*SelectBuilder) Columns ¶
func (s *SelectBuilder) Columns(columns ...string) *SelectBuilder
Columns sets the columns to select
func (*SelectBuilder) From ¶
func (s *SelectBuilder) From(table string) *SelectBuilder
From sets the table to select from
func (*SelectBuilder) GroupBy ¶
func (s *SelectBuilder) GroupBy(groupBys ...string) *SelectBuilder
GroupBy adds a GROUP BY clause
func (*SelectBuilder) Having ¶
func (s *SelectBuilder) Having(pred any, args ...any) *SelectBuilder
Having adds a HAVING clause
func (*SelectBuilder) InnerJoin ¶
func (s *SelectBuilder) InnerJoin(join string, args ...any) *SelectBuilder
InnerJoin adds an INNER JOIN clause
func (*SelectBuilder) IsActive ¶
func (s *SelectBuilder) IsActive() *SelectBuilder
IsActive adds a WHERE clause for is_active = true
func (*SelectBuilder) IsDeleted ¶
func (s *SelectBuilder) IsDeleted(deleted bool) *SelectBuilder
IsDeleted adds a WHERE clause for is_deleted = false (not deleted records by default)
func (*SelectBuilder) Join ¶
func (s *SelectBuilder) Join(join string, args ...any) *SelectBuilder
Join adds a JOIN clause
func (*SelectBuilder) LeftJoin ¶
func (s *SelectBuilder) LeftJoin(join string, args ...any) *SelectBuilder
LeftJoin adds a LEFT JOIN clause
func (*SelectBuilder) Limit ¶
func (s *SelectBuilder) Limit(limit uint64) *SelectBuilder
Limit adds a LIMIT clause
func (*SelectBuilder) Offset ¶
func (s *SelectBuilder) Offset(offset uint64) *SelectBuilder
Offset adds an OFFSET clause
func (*SelectBuilder) OrderBy ¶
func (s *SelectBuilder) OrderBy(orderBys ...string) *SelectBuilder
OrderBy adds an ORDER BY clause
func (*SelectBuilder) RightJoin ¶
func (s *SelectBuilder) RightJoin(join string, args ...any) *SelectBuilder
RightJoin adds a RIGHT JOIN clause
func (*SelectBuilder) ToSQL ¶
func (s *SelectBuilder) ToSQL() (query string, args []any, err error)
ToSQL builds and returns the SQL query string and arguments
func (*SelectBuilder) Where ¶
func (s *SelectBuilder) Where(pred any, args ...any) *SelectBuilder
Where adds a WHERE clause
func (*SelectBuilder) WhereID ¶
func (s *SelectBuilder) WhereID(id any) *SelectBuilder
WhereID adds a WHERE clause for id = value
type UpdateBuilder ¶
type UpdateBuilder struct {
// contains filtered or unexported fields
}
UpdateBuilder wraps squirrel.UpdateBuilder with additional functionality
func SoftDelete ¶
func SoftDelete(ctx context.Context) *UpdateBuilder
SoftDelete creates a new UpdateBuilder configured for SOFT DELETE operations
func Update ¶
func Update(ctx context.Context) *UpdateBuilder
Update creates a new UpdateBuilder with Dollar placeholder format
func (*UpdateBuilder) IsActive ¶
func (u *UpdateBuilder) IsActive() *UpdateBuilder
IsActive adds a WHERE clause for is_active = true
func (*UpdateBuilder) IsDeleted ¶
func (u *UpdateBuilder) IsDeleted(deleted bool) *UpdateBuilder
IsDeleted adds a WHERE clause for is_deleted = false (not deleted records by default)
func (*UpdateBuilder) Returning ¶
func (u *UpdateBuilder) Returning(fields ...string) *UpdateBuilder
Returning adds RETURNING clause
func (*UpdateBuilder) Set ¶
func (u *UpdateBuilder) Set(column string, value any) *UpdateBuilder
Set sets a column value
func (*UpdateBuilder) SetMap ¶
func (u *UpdateBuilder) SetMap(clauses map[string]any) *UpdateBuilder
SetMap sets multiple column values from a map
func (*UpdateBuilder) Table ¶
func (u *UpdateBuilder) Table(table string) *UpdateBuilder
Table sets the table to update
func (*UpdateBuilder) ToSQL ¶
func (u *UpdateBuilder) ToSQL() (query string, args []any, err error)
ToSQL builds and returns the SQL query string and arguments
func (*UpdateBuilder) Where ¶
func (u *UpdateBuilder) Where(pred any, args ...any) *UpdateBuilder
Where adds a WHERE clause
func (*UpdateBuilder) WhereID ¶
func (u *UpdateBuilder) WhereID(id any) *UpdateBuilder
WhereID adds a WHERE clause for id = value
func (*UpdateBuilder) WhereMap ¶
func (u *UpdateBuilder) WhereMap(clauses map[string]any) *UpdateBuilder
WhereMap adds WHERE clauses from a map