query

package
v1.128.0 Latest Latest
Warning

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

Go to latest
Published: Oct 12, 2026 License: MIT Imports: 12 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func CountWithSelectQueryBuilder2

func CountWithSelectQueryBuilder2(ctx context.Context, db *sqlx.DB, qb *builder.SelectQueryBuilder) (count int64, err error)

CountWithSelectQueryBuilder2 executes a COUNT query using SelectQueryBuilder and returns the count. Builds SELECT COUNT(*) query from SelectQueryBuilder (SourceName, WHERE, JOIN, GROUP BY, HAVING).

func DeleteWithDeleteQueryBuilder2

func DeleteWithDeleteQueryBuilder2(ctx context.Context, db *sqlx.DB, qb *builder.DeleteQueryBuilder) (result sql.Result, returningRows []utils.JSON, err error)

DeleteWithDeleteQueryBuilder2 executes a DELETE using DeleteQueryBuilder. If RETURNING fields are specified, returns the deleted rows. Otherwise, returns sql.Result info.

func InsertWithInsertQueryBuilder2

func InsertWithInsertQueryBuilder2(ctx context.Context, db *sqlx.DB, qb *builder.InsertQueryBuilder) (result sql.Result, returningRow utils.JSON, err error)

InsertWithInsertQueryBuilder2 executes an INSERT using InsertQueryBuilder. If RETURNING fields are specified, returns the inserted row. Otherwise returns sql.Result info.

func SelectOneWithSelectQueryBuilder2

func SelectOneWithSelectQueryBuilder2(ctx context.Context, db *sqlx.DB, qb *builder.SelectQueryBuilder, fieldTypeMapping databaseDb.DXDatabaseTableFieldTypeMapping) (rowsInfo *databaseDb.DXDatabaseTableRowsInfo, r utils.JSON, err error)

SelectOneWithSelectQueryBuilder2 executes a query using SelectQueryBuilder and returns a single row. Sets LimitValue to 1 automatically.

func SelectWithSelectQueryBuilder2

func SelectWithSelectQueryBuilder2(ctx context.Context, db *sqlx.DB, qb *builder.SelectQueryBuilder, fieldTypeMapping databaseDb.DXDatabaseTableFieldTypeMapping) (rowsInfo *databaseDb.DXDatabaseTableRowsInfo, r []utils.JSON, err error)

SelectWithSelectQueryBuilder2 executes a query using SelectQueryBuilder and returns all matching rows. Builds SELECT query from SelectQueryBuilder (SourceName, OutFields, WHERE, JOIN, GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET) and calls NamedQueryRows2.

func ShouldSelectOneWithSelectQueryBuilder2

func ShouldSelectOneWithSelectQueryBuilder2(ctx context.Context, db *sqlx.DB, qb *builder.SelectQueryBuilder, fieldTypeMapping databaseDb.DXDatabaseTableFieldTypeMapping) (rowsInfo *databaseDb.DXDatabaseTableRowsInfo, r utils.JSON, err error)

ShouldSelectOneWithSelectQueryBuilder2 executes a query using SelectQueryBuilder and returns a single row, erroring if no row found.

func ShouldSelectWithSelectQueryBuilder2

func ShouldSelectWithSelectQueryBuilder2(ctx context.Context, db *sqlx.DB, qb *builder.SelectQueryBuilder, fieldTypeMapping databaseDb.DXDatabaseTableFieldTypeMapping) (rowsInfo *databaseDb.DXDatabaseTableRowsInfo, r []utils.JSON, err error)

ShouldSelectWithSelectQueryBuilder2 executes a query using SelectQueryBuilder and returns all matching rows, erroring if no rows found.

func TxCountWithSelectQueryBuilder2

func TxCountWithSelectQueryBuilder2(ctx context.Context, dtx *databases.DXDatabaseTx, qb *builder.SelectQueryBuilder) (count int64, err error)

TxCountWithSelectQueryBuilder2 executes a COUNT query within a transaction using SelectQueryBuilder and returns the count. Builds SELECT COUNT(*) query from SelectQueryBuilder (SourceName, WHERE, JOIN, GROUP BY, HAVING).

func TxDeleteWithDeleteQueryBuilder2

func TxDeleteWithDeleteQueryBuilder2(ctx context.Context, dtx *databases.DXDatabaseTx, qb *builder.DeleteQueryBuilder) (result sql.Result, returningRows []utils.JSON, err error)

TxDeleteWithDeleteQueryBuilder2 executes a DELETE within a transaction using DeleteQueryBuilder. If RETURNING fields are specified, returns the deleted rows. Otherwise returns sql.Result info.

func TxInsertWithInsertQueryBuilder2

func TxInsertWithInsertQueryBuilder2(ctx context.Context, dtx *databases.DXDatabaseTx, qb *builder.InsertQueryBuilder) (result sql.Result, returningRow utils.JSON, err error)

TxInsertWithInsertQueryBuilder2 executes an INSERT within a transaction using InsertQueryBuilder. If RETURNING fields are specified, returns the inserted row. Otherwise returns sql.Result info.

func TxSelectOneWithSelectQueryBuilder2

func TxSelectOneWithSelectQueryBuilder2(ctx context.Context, dtx *databases.DXDatabaseTx, qb *builder.SelectQueryBuilder, fieldTypeMapping databaseDb.DXDatabaseTableFieldTypeMapping) (rowsInfo *databaseDb.DXDatabaseTableRowsInfo, r utils.JSON, err error)

TxSelectOneWithSelectQueryBuilder2 executes a query within a transaction using SelectQueryBuilder and returns a single row. Sets LimitValue to 1 automatically.

func TxSelectWithSelectQueryBuilder2

func TxSelectWithSelectQueryBuilder2(ctx context.Context, dtx *databases.DXDatabaseTx, qb *builder.SelectQueryBuilder, fieldTypeMapping databaseDb.DXDatabaseTableFieldTypeMapping) (rowsInfo *databaseDb.DXDatabaseTableRowsInfo, r []utils.JSON, err error)

TxSelectWithSelectQueryBuilder2 executes a query within a transaction using SelectQueryBuilder and returns all matching rows. Builds SELECT query from SelectQueryBuilder (SourceName, OutFields, WHERE, JOIN, GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET) and calls TxNamedQueryRows2.

func TxShouldSelectOneWithSelectQueryBuilder2

func TxShouldSelectOneWithSelectQueryBuilder2(ctx context.Context, dtx *databases.DXDatabaseTx, qb *builder.SelectQueryBuilder, fieldTypeMapping databaseDb.DXDatabaseTableFieldTypeMapping) (rowsInfo *databaseDb.DXDatabaseTableRowsInfo, r utils.JSON, err error)

TxShouldSelectOneWithSelectQueryBuilder2 executes a query within a transaction using SelectQueryBuilder and returns a single row, erroring if no row found.

func TxShouldSelectWithSelectQueryBuilder2

func TxShouldSelectWithSelectQueryBuilder2(ctx context.Context, dtx *databases.DXDatabaseTx, qb *builder.SelectQueryBuilder, fieldTypeMapping databaseDb.DXDatabaseTableFieldTypeMapping) (rowsInfo *databaseDb.DXDatabaseTableRowsInfo, r []utils.JSON, err error)

TxShouldSelectWithSelectQueryBuilder2 executes a query within a transaction using SelectQueryBuilder and returns all matching rows, erroring if no rows found.

func TxUpdateWithUpdateQueryBuilder2

func TxUpdateWithUpdateQueryBuilder2(ctx context.Context, dtx *databases.DXDatabaseTx, qb *builder.UpdateQueryBuilder) (result sql.Result, returningRows []utils.JSON, err error)

TxUpdateWithUpdateQueryBuilder2 executes an UPDATE within a transaction using UpdateQueryBuilder. If RETURNING fields are specified, returns the affected rows. Otherwise, returns sql.Result info.

func UpdateWithUpdateQueryBuilder2

func UpdateWithUpdateQueryBuilder2(ctx context.Context, db *sqlx.DB, qb *builder.UpdateQueryBuilder) (result sql.Result, returningRows []utils.JSON, err error)

UpdateWithUpdateQueryBuilder2 executes an UPDATE using UpdateQueryBuilder. If RETURNING fields are specified, returns the affected rows. Otherwise, returns sql.Result info.

Types

This section is empty.

Directories

Path Synopsis

Jump to

Keyboard shortcuts

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