query

package
v0.0.0-...-dd0d759 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Apr 16, 2026 License: MIT Imports: 6 Imported by: 0

Documentation

Index

Constants

View Source
const (
	ID         = "id"
	IsDeleted  = "is_deleted"
	IsActive   = "is_active"
	CreatedAt  = "created_at"
	ModifiedAt = "modified_at"
)
View Source
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

Jump to

Keyboard shortcuts

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