[Gravity] Implemented grouping for sql conditions
Review Request #157 — Created Sept. 26, 2013 and submitted — Latest diff uploaded
Information | |
---|---|
andrea | |
Lunr | |
master | |
Reviewers | |
lunr | |
This change introduces functionality to support logical grouping of SQL conditional statements (WHERE, HAVING, ON). What was possible so far where statements like WHERE col1=1 AND col2=2 OR col3=3 With this change we are now able to do WHERE col1=1 AND (col2=2 OR col3=3)
Checked if calling sql_conditions('a','b','=') after setting bracket to open results in "WHERE ( a = b" Checked if calling sql_bracket_close() adds a ' )' to the condition.
Diff Revision 12 (Latest)
orig
1
2
3
4
5
6
7
8
9
10
11
12
src/Lunr/Gravity/Database/DatabaseDMLQueryBuilder.php |
---|
src/Lunr/Gravity/Database/MySQL/MySQLDMLQueryBuilder.php |
---|
src/Lunr/Gravity/Database/MySQL/Tests/MySQLDMLQueryBuilderConditionTest.php |
---|
src/Lunr/Gravity/Database/SQLite3/SQLite3DMLQueryBuilder.php |
---|
src/Lunr/Gravity/Database/SQLite3/Tests/SQLite3DMLQueryBuilderConditionTest.php |
---|
src/Lunr/Gravity/Database/Tests/DatabaseDMLQueryBuilderBaseTest.php |
---|
src/Lunr/Gravity/Database/Tests/DatabaseDMLQueryBuilderQueryPartsConditionTest.php |
---|