BulkSqlUtil Module

Table of Contents

• Introduction to the BulkSqlUtil Module
• Release Notes
  • BulkSqlUtil v1.3
  • BulkSqlUtil v1.2
  • BulkSqlUtil v1.1
  • BulkSqlUtil v1.0

Introduction to the BulkSqlUtil Module

The BulkSqlUtil module provides APIs for bulk DML operations using SqlUtil in Qore. Bulk DML is the process of sending multiple rows to the dataserver in a single operation which allows for the most efficient processing of large amounts of data.

Currently insert and upsert (SQL merge) operations are supported.

The main functionality provided by this module:

• AbstractBulkOperation: abstract base class for bulk DML operation classes
• BulkInsertOperation: provides a high-level API for bulk DML inserts
• BulkUpsertOperation: provides a high-level API for bulk DML upsert uperations (ie SQL merge)

See the above classes for detailed information and examples.

Release Notes

BulkSqlUtil v1.3

• updated the module to use the AbstractSQLStatement class instead of the SQLStatement

BulkSqlUtil v1.2

• updated the module to support drivers without bulk DML
• updated for complex types
• added AbstractBulkOperation::size()

BulkSqlUtil v1.1

• fixed a bug in the BulkInsertOperation class where inserts would fail or silently insert invalid data in the second or later blocks when constant hashes were used (issue 1625)

BulkSqlUtil v1.0

• initial release of the module