diff options
| author | Tristan Darricau <tristan.darricau@sensiolabs.com> | 2015-10-14 16:18:46 +0200 |
|---|---|---|
| committer | Tristan Darricau <tristan.darricau@sensiolabs.com> | 2015-10-14 16:18:46 +0200 |
| commit | cd114a68e956e448df18ffbad855a12a6f597861 (patch) | |
| tree | 3118bd5045b970829b9b84eb17d94dbf672870d2 /tests/dbal/fixtures | |
| parent | 4682b5abdd342bd4ac7dd01afc36cf30c496ac24 (diff) | |
| parent | fe132f19e8d5c821fff936d208fbb981aa6ac92d (diff) | |
| download | forums-cd114a68e956e448df18ffbad855a12a6f597861.tar forums-cd114a68e956e448df18ffbad855a12a6f597861.tar.gz forums-cd114a68e956e448df18ffbad855a12a6f597861.tar.bz2 forums-cd114a68e956e448df18ffbad855a12a6f597861.tar.xz forums-cd114a68e956e448df18ffbad855a12a6f597861.zip | |
Merge pull request #3441 from brunoais/feature/sql-bool-builder
[feature/sql-bool-builder] Extending DBAL query builder for boolean generation
* brunoais/feature/sql-bool-builder:
[feature/sql-bool-builder] Improved tests output to show the SQL error.
[feature/sql-bool-builder] Adding the IS operator to predicted operators
[feature/sql-bool-builder] test_single_not_like
[feature/sql-bool-builder] test_single_like
[feature/sql-bool-builder] test_single_not_in
[feature/sql-bool-builder] test_single_in
[feature/sql-bool-builder] test_and_of_or_of_and
[feature/sql-bool-builder] test_triple_and_with_in
[feature/sql-bool-builder] test_double_and_with_not_of_and
[feature/sql-bool-builder] test_triple_and_with_is_null
[feature/sql-bool-builder] Prepare testing class
[feature/sql-bool-builder] Added LIKE and NOT_LIKE to the comparations
[feature/sql-bool-builder] Explain better the code in the first
[feature/sql-bool-builder] Also use parenthesis for the NOT operator
[feature/sql-bool-builder] AS keyword must be lowercase;
[feature/sql-bool-builder] Added code to use this feature for the WHERE clause
[feature/sql-bool-builder] Removed non-necessary spaces
[feature/sql-bool-builder] First working version
Diffstat (limited to 'tests/dbal/fixtures')
| -rw-r--r-- | tests/dbal/fixtures/boolean_processor.xml | 84 |
1 files changed, 84 insertions, 0 deletions
diff --git a/tests/dbal/fixtures/boolean_processor.xml b/tests/dbal/fixtures/boolean_processor.xml new file mode 100644 index 0000000000..c5da677116 --- /dev/null +++ b/tests/dbal/fixtures/boolean_processor.xml @@ -0,0 +1,84 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<dataset> + <table name="phpbb_banlist"> + <column>ban_id</column> + <column>ban_userid</column> + <row> + <value>1</value> + <value>2</value> + </row> + </table> + <table name="phpbb_users"> + <column>user_id</column> + <column>username</column> + <column>username_clean</column> + <column>user_permissions</column> + <column>user_sig</column> + <row> + <value>1</value> + <value>mass email</value> + <value>mass email</value> + <value></value> + <value></value> + </row> + <row> + <value>2</value> + <value>banned</value> + <value>banned</value> + <value></value> + <value></value> + </row> + <row> + <value>3</value> + <value>helper</value> + <value>helper</value> + <value></value> + <value></value> + </row> + <row> + <value>4</value> + <value>GroupBPal</value> + <value>groupbpal</value> + <value></value> + <value></value> + </row> + <row> + <value>5</value> + <value>GroupBPal2</value> + <value>groupBPal2</value> + <value></value> + <value></value> + </row> + <row> + <value>6</value> + <value>not in group</value> + <value>not in group</value> + <value></value> + <value></value> + </row> + </table> + <table name="phpbb_user_group"> + <column>user_id</column> + <column>group_id</column> + <row> + <value>1</value> + <value>1</value> + </row> + <row> + <value>2</value> + <value>1</value> + </row> + <row> + <value>3</value> + <value>1</value> + </row> + <row> + <value>4</value> + <value>2</value> + </row> + <row> + <value>5</value> + <value>2</value> + </row> + </table> +</dataset> |