[Gravity] add SQLiteDMLQueryBuilder class

Review Request #86 — Created April 22, 2013 and discarded — Latest diff uploaded

olivier
Lunr
https://github.com/owizen/lunr/tree/SQLiteBuilder
14955
lunr
Here is the query builder for SQLite.
This review depends on http://reviews.lunr.nl/r/83/

Note the following points concerning not supported features in SQLite compared to MySQL:

-REPLACE statement is an alias of INSERT OR REPLACE statement
-As a consequence there is no replace mode
-There is no DELETE modes
-Specifying a charset is not supported

As a consequence, the get_insert_query and get_replace_query from the abstract class have been overriden.
The index_hint method has been rewritten, have a look at it.

The property $location_delimiter has been introduced and implemented as well in MySQLDMLQueryBuilder
Unit tests
Loading...