View on
MetaCPAN
search.cpan.org is shutting down
For details read Perl NOC. After June 25th this page will redirect to MetaCPAN.org
Clinton Wolfe > Class-ReluctantORM-0.52_0 > Class::ReluctantORM::Driver::SQLite

Download:
Class-ReluctantORM-0.52_0.tar.gz

Dependencies

Annotate this POD

Source  

NAME ^

Class::ReluctantORM::Driver::SQLite - SQLite driver for CRO

SYNOPSIS ^

  # See Class::ReluctantORM::Driver

DRIVER IDIOSYNCRACIES ^

Supports any version of sqlite supported by DBD::SQLite.

SQLite is itself fairly idiosyncratic. Here are how they impact this driver:

No RETURNING support on INSERT/UPDATE/DELETE

Since SQLite doesn't support this SQL extension, and DBD::SQLite doesn't support using output binds to read them (a hack the Oracle DBD provides), you can't use RETURNING to get columns from INSERT/UPDATE/DELETE statements you provide in SQL, nor can you add output columns to SQL objects performing those operations. Worse, if your model uses refresh_on_update columns, they must be fetched by a separate SELECT (handled internally by the Driver, but you need to be aware of the penalty).

Column names forced to be lowercase
syntax highlighting: