summaryrefslogtreecommitdiff
path: root/test
AgeCommit message (Collapse)Author
2014-05-29Fixed testing logic.Stefan Andres Charsley
2014-05-29Fixed testing.Stefan Andres Charsley
2014-05-28Merge pull request #202 from lrlopez/where_id_in-2Simon Holywell
where_id_in() for selecting multiple records by primary key
2014-05-28Merge pull request #201 from lrlopez/where_any_isSimon Holywell
Multiple OR'ed conditions support
2014-05-18where_id_in() for selecting multiple records by primary keyLuis Ramón López
2014-05-18Multiple OR'ed conditions supportLuis Ramón López
Multiple OR'ed conditions ------------------------- You can add simple ORed conditions to the same WHERE clause using ``where_any_is``. You should specify multiple conditions using an array of items. Each item will be an associative array that contains a multiple conditions. ```php <?php $people = ORM::for_table('person') ->where_any_is(array( array('name' => 'Joe', 'age' => 10), array('name' => 'Fred', 'age' => 20))) ->find_many(); // Creates SQL: SELECT * FROM `widget` WHERE (( `name` = 'Joe' AND `age` = '10' ) OR ( `name` = 'Fred' AND `age` = '20' )); ``` By default, it uses the equal operator for every column, but it can be overriden for any column using a second parameter: ```php <?php $people = ORM::for_table('person') ->where_any_is(array( array('name' => 'Joe', 'age' => 10), array('name' => 'Fred', 'age' => 20)), array('age' => '>')) ->find_many(); // Creates SQL: SELECT * FROM `widget` WHERE (( `name` = 'Joe' AND `age` > '10' ) OR ( `name` = 'Fred' AND `age` > '20' )); ``` If you want to set the default operator for all the columns, just pass it as the second parameter: ```php <?php $people = ORM::for_table('person') ->where_any_is(array( array('score' => '5', 'age' => 10), array('score' => '15', 'age' => 20)), '>') ->find_many(); // Creates SQL: SELECT * FROM `widget` WHERE (( `score` > '5' AND `age` > '10' ) OR ( `score` > '15' AND `age` > '20' )); ```
2014-05-06Modify test to run query with db not explicitly setAndrew Meredith
2014-04-261. Adjustment of code to work with multiple raw_joins 2. Test multiple raw joinsIgor Moiseev
2014-04-26Implemetation of raw_joinIgor Moiseev
2014-04-26Tests for compound primary keys queries addedLuis Ramón López
2014-04-26INSERT queries are now compound primary keys awareLuis Ramón López
2014-04-26FIX: Added parameter array checkingStefan Andres Charsley
Remove some empty results from the array before checking.
2014-04-26FIX: Added parameter array checkingStefan Andres Charsley
Updated preg_match_all parameters.
2014-04-26FIX: Added parameter array checkingStefan Andres Charsley
Changed some debugging code.
2014-04-26FIX: Added parameter array checkingStefan Andres Charsley
Added some more debug code.
2014-04-26FIX: Added parameter array checkingStefan Andres Charsley
Added debug code to see why it's failing.
2014-04-26FIX: Added parameter array checkingStefan Andres Charsley
Fixed the regex not having backslashes escaped.
2014-04-26FIX: Added parameter array checkingStefan Andres Charsley
Updated regex to disregard placeholders within quotes.
2014-04-26FIX: Added parameter array checkingStefan Andres Charsley
Fixed regex issue that caused almost all tests to fail.
2014-04-26Added parameter array checkingStefan Andres Charsley
Testing: Checks the parameter array to ensure the correct number of values inside the parameter with sequential integer indexes. Production: Strips out any non-integer indexes from the parameter array inside the _log_query function.
2014-01-23Merge branch 'develop' of github.com:j4mie/idiorm into developSimon Holywell
2014-01-23Issue #176 add test for reported case - passesSimon Holywell
2013-12-26Adds regression tests for missing magic method calls to ORM and IdiormResultSetmichaelward82
2013-08-30Minor improvement to test/bootstrap.phpSimon Holywell
2013-08-30Repair mock results generatorSimon Holywell
2013-08-28Add MS SQL `TOP` style syntax supportSimon Holywell
2013-08-28Merge branch 'master' of https://github.com/JoelMarcey/idiorm into developSimon Holywell
2013-08-28Correct class nameSimon Holywell
2013-08-28Test and document the query logger callbackSimon Holywell
2013-08-28Repair state after completing testSimon Holywell
2013-08-28Document and test PSR-1 compliant method accessSimon Holywell
2013-08-28Update bootstrap.php so the tests can run on both HHVM and ZendJoel Marcey
PDOStatement does not have a direct constructor (i.e., __construct). Newing up a PDOStatement or subclass (e.g., MockPDOStatement) does technically work in Zend, but HHVM throws. A correct way to have the code currently structured in bootstrap.php work correctly on both Zend and HHVM is provide a default constructor and execute method in MockPDOStatement. It would probably best long term to avoid newing up a PDOStatement and create the queries another way. But this works for now.
2013-08-28Merge branch 'vicvicvic-wherealias' of https://github.com/vicvicvic/idiorm ↵Simon Holywell
into develop
2013-08-28Merge pull request #120 from tassoevan/developSimon Holywell
Ignore result columns when calling a aggregate function
2013-08-18Corrects typo in "testJoinWithAliasesAndWhere" method name.Victor Andrée
2013-08-16Add static method `get_config`Mike Estes
2013-08-14Uses table alias in WHEREVictor Andrée
If a table alias is used for the main table, it's not valid according to the SQL standard to refer to it by it's "real name" (see http://www.postgresql.org/docs/8.2/static/queries-table-expressions.html #QUERIES-TABLE-ALIASES). This causes problems when doing JOIN with a table alias for the "main table", since previous code always used table name. Now, we check for a table alias.
2013-05-08Ignore result columns when calling a aggregate functionTasso Evangelista
2013-04-16Add support for T-SQL style TOP clausesSebastien Bariteau
2013-01-23Remove obselete testing systemSimon Holywell
2013-01-23Remove duplicate code from test bootstrapSimon Holywell
2013-01-23Separate test for multiple connection cachesSimon Holywell
2013-01-23Merge branch 'develop' into multiple-connectionsSimon Holywell
Conflicts: test/test_classes.php test/test_queries.php
2013-01-23Finish transferring tests into PHPUnitSimon Holywell
2013-01-23Merge remote-tracking branch 'tag/dev-multi' into multiple-connectionsSimon Holywell
2013-01-22Add in more phpunit tests\!Simon Holywell
2013-01-22Apparently not all files were included in previous commit.Tom Gregory
2013-01-22Merge remote-tracking branch 'upstream/develop' into dev-multi. Updated ↵Tom Gregory
documentation to rat format, and tests to use phpunit. (Resolved)Conflicts: README.markdown idiorm.php test/test_queries.php
2013-01-21Add more query building testsSimon Holywell
2013-01-18Add more tests to suiteSimon Holywell
generated by cgit v1.2.3 (git 2.25.1) at 2024-07-17 23:28:52 +0000