[Gravity] add SQLiteDMLQueryBuilder class
Review Request #86 — Created April 22, 2013 and discarded — Latest diff uploaded
Information | |
---|---|
olivier | |
Lunr | |
https://github.com/owizen/lunr/tree/SQLiteBuilder | |
14955 | |
Reviewers | |
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
Diff Revision 2
This is not the most recent revision of the diff. The latest diff is revision 5. See what's changed.
orig
1
2
3
4
5
src/Lunr/Gravity/Database/DatabaseDMLQueryBuilder.php |
---|
src/Lunr/Gravity/Database/MySQL/MySQLDMLQueryBuilder.php |
---|
src/Lunr/Gravity/Database/SQLite/SQLiteConnection.php |
---|
src/Lunr/Gravity/Database/SQLite/SQLiteDMLQueryBuilder.php |
---|