Part II. The Quince API in Depth

Table of Contents

4. Exceptions

5. Mapped Data Types

Definition, Taxonomy

Polymorphically Mapped Types

boost::optional<...>

std::tuple<...>

User-Defined Class Types

6. Expressions for Server-Side Execution

Server-Side Expressions in General

Arithmetic Operations

String Concatenation

cast<...>()

Function Calls

Pre-wrapped functions

“Scalar” and “Aggregate” Functions

Writing Your Own Function Wrappers

Relational Operations

predicates and Logical Operations

exists()

in()

Collective Comparisons (PostgreSQL only)

Scalar Subqueries

choose()

Visibility

7. Queries

Queries in General

Compositionality

select()

With One Argument

With Multiple Arguments

With Multiple Arguments and a Collector Class

With group(...)

Performance Tip: Avoid Repeated Subexpressions

where()

order()

distinct() and distinct_on()

The join() Family of Functions

join()

inner_join()

left_join()

right_join()

full_join() (PostgreSQL only)

jump()

With a Collector Class

Self Joins

Set-Theoretic Operations

skip() and limit()

Executing Queries

With Multi-Record Output: begin() and const_iterator

With (at most) Single-Record Output: get()

With Single-Value Output: evaluate()

8. Tables

Tables in General

Terminology

Life Cycle of a Table Object

Construction and Primary Key

Indexes and Foreign Key Constraints

Data Manipulation

insert()

update()

remove()

Table Alteration

rename_from()

add_field()

drop_field() (PostgreSQL only)

rename_field() (PostgreSQL only)

set_field_type() (PostgreSQL only)

9. Custom Mappings

Degrees of Freedom

Predefined Concrete Mapper Class Templates

Deployment

To a Database ...

... or to a Table

10. Transactions

11. Connection Management