Module Modeling.DatabaseAdaptors.SQLiteAdaptorLayer.SQLiteSQLExpression

Supports generation of SQL statements for SQLite

The SQLite embedded db-server supports a subset of standard SQL. Limitations are documented at: http://www.sqlite.org/omitted.html

The custom SQLiteSQLExpression addresses the following issues:

• ALTER TABLE not supported: constraints for primary key and foreign keys should be declared when creating a table (see also: SQLiteSchemaGeneration)
• nested JOINS are not supported: see _addTableJoinsForAlias() below

CVS information

$Id: SQLiteSQLExpression.py,v 1.6 2004/08/02 19:58:54 sbigaret Exp $