LIBCXX SQL Library


Index

LIBCXX SQL Library
Introduction
Known issues
Installation, and requirements
I. Core SQL classes
1. Creating an SQL environment
2. Connecting to an SQL server
Connecting to a non-predefined data source
Determining SQL database driver capabilities
3. Executing SQL statements
Logging executed SQL
Combining prepare() with execute()
Vector parameters
Fetching SELECT results
Limiting the number of rows fetched
Bulk SELECT fetches
Creating scrollable cursors
Using scrollable cursors
Modifying fetched rows
Batches and row counts
Using mpf_class values from GMP library
4. Transactions
Disabling and enabling automatic commits
begin_work(), commit_work() and rollback_work()
x::sql::transaction
5. Inserting and fetching blobs
Inserting blobs
Retrieving blobs
6. SQL catalogs
II. SQL database interface
7. Creating resultsets
automake macros
Resultset objects created from a schema file
Resultset class names
Setting upper limit on the number of resultset rows
8. Adding constraints to resultsets
9. Adding joins to resultsets
Specifying columns used in joins, and multiple joins to the same table
Nested resultsets
Prefetching rows from joined tables
10. Adding GROUP BY, HAVING, and ORDER BY to resultsets
11. UPDATE resultsets
UPDATEs using joins
Updating individual rows
12. INSERTing into a resultset
INSERTing into a nested resultset
INSERTing into tables with serial/autoincrement columns
13. Standalone constraints
A. COPYING