Finish transferring tests into PHPUnit

5 files changed, 324 insertions, 567 deletions

diff --git a/test/ConfigTest.php b/test/ConfigTest.php
new file mode 100644
index 0000000..83194b4
--- /dev/null
+++ b/test/ConfigTest.php
@@ -0,0 +1,100 @@
+<?php
+
+class ConfigTest extends PHPUnit_Framework_TestCase {
+
+    public function setUp() {
+        // Enable logging
+        ORM::configure('logging', true);
+
+        // Set up the dummy database connection
+        $db = new MockPDO('sqlite::memory:');
+        ORM::set_db($db);
+
+        ORM::configure('id_column', 'primary_key');
+    }
+
+    public function tearDown() {
+        ORM::configure('logging', false);
+        ORM::set_db(null);
+
+        ORM::configure('id_column', 'id');
+    }
+
+    protected function setUpIdColumnOverrides() {
+        ORM::configure('id_column_overrides', array(
+            'widget' => 'widget_id',
+            'widget_handle' => 'widget_handle_id',
+        ));
+    }
+
+    protected function tearDownIdColumnOverrides() {
+        ORM::configure('id_column_overrides', array());
+    }
+
+    public function testSettingIdColumn() {
+        ORM::for_table('widget')->find_one(5);
+        $expected = "SELECT * FROM `widget` WHERE `primary_key` = '5' LIMIT 1";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testSettingIdColumnOverridesOne() {
+        $this->setUpIdColumnOverrides();
+
+        ORM::for_table('widget')->find_one(5);
+        $expected = "SELECT * FROM `widget` WHERE `widget_id` = '5' LIMIT 1";
+        $this->assertEquals($expected, ORM::get_last_query());
+
+        $this->tearDownIdColumnOverrides();
+    }
+
+    public function testSettingIdColumnOverridesTwo() {
+        $this->setUpIdColumnOverrides();
+
+        ORM::for_table('widget_handle')->find_one(5);
+        $expected = "SELECT * FROM `widget_handle` WHERE `widget_handle_id` = '5' LIMIT 1";
+        $this->assertEquals($expected, ORM::get_last_query());
+
+        $this->tearDownIdColumnOverrides();
+    }
+
+    public function testSettingIdColumnOverridesThree() {
+        $this->setUpIdColumnOverrides();
+
+        ORM::for_table('widget_nozzle')->find_one(5);
+        $expected = "SELECT * FROM `widget_nozzle` WHERE `primary_key` = '5' LIMIT 1";
+        $this->assertEquals($expected, ORM::get_last_query());
+
+        $this->tearDownIdColumnOverrides();
+    }
+
+    public function testInstanceIdColumnOne() {
+        $this->setUpIdColumnOverrides();
+
+        ORM::for_table('widget')->use_id_column('new_id')->find_one(5);
+        $expected = "SELECT * FROM `widget` WHERE `new_id` = '5' LIMIT 1";
+        $this->assertEquals($expected, ORM::get_last_query());
+
+        $this->tearDownIdColumnOverrides();
+    }
+
+    public function testInstanceIdColumnTwo() {
+        $this->setUpIdColumnOverrides();
+
+        ORM::for_table('widget_handle')->use_id_column('new_id')->find_one(5);
+        $expected = "SELECT * FROM `widget_handle` WHERE `new_id` = '5' LIMIT 1";
+        $this->assertEquals($expected, ORM::get_last_query());
+
+        $this->tearDownIdColumnOverrides();
+    }
+
+    public function testInstanceIdColumnThree() {
+        $this->setUpIdColumnOverrides();
+
+        ORM::for_table('widget_nozzle')->use_id_column('new_id')->find_one(5);
+        $expected = "SELECT * FROM `widget_nozzle` WHERE `new_id` = '5' LIMIT 1";
+        $this->assertEquals($expected, ORM::get_last_query());
+
+        $this->tearDownIdColumnOverrides();
+    }
+
+}
\ No newline at end of file
diff --git a/test/IdiormResultSetTest.php b/test/IdiormResultSetTest.php
index 34d42a0..f41205a 100644
--- a/test/IdiormResultSetTest.php
+++ b/test/IdiormResultSetTest.php
@@ -2,6 +2,20 @@
 
 class IdiormResultSetTest extends PHPUnit_Framework_TestCase {
 
+    public function setUp() {
+        // Enable logging
+        ORM::configure('logging', true);
+
+        // Set up the dummy database connection
+        $db = new MockPDO('sqlite::memory:');
+        ORM::set_db($db);
+    }
+
+    public function tearDown() {
+        ORM::configure('logging', false);
+        ORM::set_db(null);
+    }
+
     public function testGet() {
         $IdiormResultSet = new IdiormResultSet();
         $this->assertInternalType('array', $IdiormResultSet->get_results());
diff --git a/test/QueryBuilderTest.php b/test/QueryBuilderTest.php
index 52cf0c2..bd888c0 100644
--- a/test/QueryBuilderTest.php
+++ b/test/QueryBuilderTest.php
@@ -292,12 +292,186 @@ class QueryBuilderTest extends PHPUnit_Framework_TestCase {
         $this->assertEquals($expected, ORM::get_last_query());
     }
 
+    public function testMainTableAlias() {
+        ORM::for_table('widget')->table_alias('w')->find_many();
+        $expected = "SELECT * FROM `widget` `w`";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
     public function testAliasesInResultColumns() {
         ORM::for_table('widget')->select('widget.name', 'widget_name')->find_many();
         $expected = "SELECT `widget`.`name` AS `widget_name` FROM `widget`";
         $this->assertEquals($expected, ORM::get_last_query());
     }
 
+    public function testAliasesInSelectManyResults() {
+        ORM::for_table('widget')->select_many(array('widget_name' => 'widget.name'), 'widget_handle')->find_many();
+        $expected = "SELECT `widget`.`name` AS `widget_name`, `widget_handle` FROM `widget`";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testLiteralExpressionInResultColumn() {
+        ORM::for_table('widget')->select_expr('COUNT(*)', 'count')->find_many();
+        $expected = "SELECT COUNT(*) AS `count` FROM `widget`";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testLiteralExpressionInSelectManyResultColumns() {
+        ORM::for_table('widget')->select_many_expr(array('count' => 'COUNT(*)'), 'SUM(widget_order)')->find_many();
+        $expected = "SELECT COUNT(*) AS `count`, SUM(widget_order) FROM `widget`";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testSimpleJoin() {
+        ORM::for_table('widget')->join('widget_handle', array('widget_handle.widget_id', '=', 'widget.id'))->find_many();
+        $expected = "SELECT * FROM `widget` JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id`";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testSimpleJoinWithWhereIdIsMethod() {
+        ORM::for_table('widget')->join('widget_handle', array('widget_handle.widget_id', '=', 'widget.id'))->find_one(5);
+        $expected = "SELECT * FROM `widget` JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id` WHERE `widget`.`id` = '5' LIMIT 1";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testInnerJoin() {
+        ORM::for_table('widget')->inner_join('widget_handle', array('widget_handle.widget_id', '=', 'widget.id'))->find_many();
+        $expected = "SELECT * FROM `widget` INNER JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id`";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testLeftOuterJoin() {
+        ORM::for_table('widget')->left_outer_join('widget_handle', array('widget_handle.widget_id', '=', 'widget.id'))->find_many();
+        $expected = "SELECT * FROM `widget` LEFT OUTER JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id`";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testRightOuterJoin() {
+        ORM::for_table('widget')->right_outer_join('widget_handle', array('widget_handle.widget_id', '=', 'widget.id'))->find_many();
+        $expected = "SELECT * FROM `widget` RIGHT OUTER JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id`";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testFullOuterJoin() {
+        ORM::for_table('widget')->full_outer_join('widget_handle', array('widget_handle.widget_id', '=', 'widget.id'))->find_many();
+        $expected = "SELECT * FROM `widget` FULL OUTER JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id`";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testMultipleJoinSources() {
+        ORM::for_table('widget')
+        ->join('widget_handle', array('widget_handle.widget_id', '=', 'widget.id'))
+        ->join('widget_nozzle', array('widget_nozzle.widget_id', '=', 'widget.id'))
+        ->find_many();
+        $expected = "SELECT * FROM `widget` JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id` JOIN `widget_nozzle` ON `widget_nozzle`.`widget_id` = `widget`.`id`";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testJoinWithAliases() {
+        ORM::for_table('widget')->join('widget_handle', array('wh.widget_id', '=', 'widget.id'), 'wh')->find_many();
+        $expected = "SELECT * FROM `widget` JOIN `widget_handle` `wh` ON `wh`.`widget_id` = `widget`.`id`";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testJoinWithStringConstraint() {
+        ORM::for_table('widget')->join('widget_handle', "widget_handle.widget_id = widget.id")->find_many();
+        $expected = "SELECT * FROM `widget` JOIN `widget_handle` ON widget_handle.widget_id = widget.id";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testSelectWithDistinct() {
+        ORM::for_table('widget')->distinct()->select('name')->find_many();
+        $expected = "SELECT DISTINCT `name` FROM `widget`";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testInsertData() {
+        $widget = ORM::for_table('widget')->create();
+        $widget->name = "Fred";
+        $widget->age = 10;
+        $widget->save();
+        $expected = "INSERT INTO `widget` (`name`, `age`) VALUES ('Fred', '10')";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testInsertDataContainingAnExpression() {
+        $widget = ORM::for_table('widget')->create();
+        $widget->name = "Fred";
+        $widget->age = 10;
+        $widget->set_expr('added', 'NOW()');
+        $widget->save();
+        $expected = "INSERT INTO `widget` (`name`, `age`, `added`) VALUES ('Fred', '10', NOW())";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testInsertDataUsingArrayAccess() {
+        $widget = ORM::for_table('widget')->create();
+        $widget['name'] = "Fred";
+        $widget['age'] = 10;
+        $widget->save();
+        $expected = "INSERT INTO `widget` (`name`, `age`) VALUES ('Fred', '10')";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testUpdateData() {
+        $widget = ORM::for_table('widget')->find_one(1);
+        $widget->name = "Fred";
+        $widget->age = 10;
+        $widget->save();
+        $expected = "UPDATE `widget` SET `name` = 'Fred', `age` = '10' WHERE `id` = '1'";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testUpdateDataContainingAnExpression() {
+        $widget = ORM::for_table('widget')->find_one(1);
+        $widget->name = "Fred";
+        $widget->age = 10;
+        $widget->set_expr('added', 'NOW()');
+        $widget->save();
+        $expected = "UPDATE `widget` SET `name` = 'Fred', `age` = '10', `added` = NOW() WHERE `id` = '1'";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testUpdateMultipleFields() {
+        $widget = ORM::for_table('widget')->find_one(1);
+        $widget->set(array("name" => "Fred", "age" => 10));
+        $widget->save();
+        $expected = "UPDATE `widget` SET `name` = 'Fred', `age` = '10' WHERE `id` = '1'";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testUpdateMultipleFieldsContainingAnExpression() {
+        $widget = ORM::for_table('widget')->find_one(1);
+        $widget->set(array("name" => "Fred", "age" => 10));
+        $widget->set_expr(array("added" => "NOW()", "lat_long" => "GeomFromText('POINT(1.2347 2.3436)')"));
+        $widget->save();
+        $expected = "UPDATE `widget` SET `name` = 'Fred', `age` = '10', `added` = NOW(), `lat_long` = GeomFromText('POINT(1.2347 2.3436)') WHERE `id` = '1'";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testUpdateMultipleFieldsContainingAnExpressionAndOverridePreviouslySetExpression() {
+        $widget = ORM::for_table('widget')->find_one(1);
+        $widget->set(array("name" => "Fred", "age" => 10));
+        $widget->set_expr(array("added" => "NOW()", "lat_long" => "GeomFromText('POINT(1.2347 2.3436)')"));
+        $widget->lat_long = 'unknown';
+        $widget->save();
+        $expected = "UPDATE `widget` SET `name` = 'Fred', `age` = '10', `added` = NOW(), `lat_long` = 'unknown' WHERE `id` = '1'";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testDeleteData() {
+        $widget = ORM::for_table('widget')->find_one(1);
+        $widget->delete();
+        $expected = "DELETE FROM `widget` WHERE `id` = '1'";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testDeleteMany() {
+        ORM::for_table('widget')->where_equal('age', 10)->delete_many();
+        $expected = "DELETE FROM `widget` WHERE `age` = '10'";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
     public function testCount() {
         ORM::for_table('widget')->count();
         $expected = "SELECT COUNT(*) AS `count` FROM `widget` LIMIT 1";
@@ -328,5 +502,41 @@ class QueryBuilderTest extends PHPUnit_Framework_TestCase {
         $this->assertEquals($expected, ORM::get_last_query());
     }
 
+    /**
+     * Regression tests
+     */
+    public function testIssue12IncorrectQuotingOfColumnWildcard() {
+        ORM::for_table('widget')->select('widget.*')->find_one();
+        $expected = "SELECT `widget`.* FROM `widget` LIMIT 1";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testIssue57LogQueryRaisesWarningWhenPercentSymbolSupplied() {
+        ORM::for_table('widget')->where_raw('username LIKE "ben%"')->find_many();
+        $expected = 'SELECT * FROM `widget` WHERE username LIKE "ben%"';
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testIssue57LogQueryRaisesWarningWhenQuestionMarkSupplied() {
+        ORM::for_table('widget')->where_raw('comments LIKE "has been released?%"')->find_many();
+        $expected = 'SELECT * FROM `widget` WHERE comments LIKE "has been released?%"';
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testIssue74EscapingQuoteMarksIn_quote_identifier_part() {
+        $widget = ORM::for_table('widget')->find_one(1);
+        $widget->set('ad`ded', '2013-01-04');
+        $widget->save();
+        $expected = "UPDATE `widget` SET `ad``ded` = '2013-01-04' WHERE `id` = '1'";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testIssue90UsingSetExprAloneDoesTriggerQueryGeneration() {
+        $widget = ORM::for_table('widget')->find_one(1);
+        $widget->set_expr('added', 'NOW()');
+        $widget->save();
+        $expected = "UPDATE `widget` SET `added` = NOW() WHERE `id` = '1'";
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
 }
 
diff --git a/test/test_classes.php b/test/test_classes.php
deleted file mode 100644
index ff31764..0000000
--- a/test/test_classes.php
+++ /dev/null
@@ -1,121 +0,0 @@
-<?php
-
-    /**
-     *
-     * Mock version of the PDOStatement class.
-     *
-     */
-    class MockPDOStatement extends PDOStatement {
-
-        private $current_row = 0;
-        /**
-         * Return some dummy data
-         */
-        public function fetch($fetch_style=PDO::FETCH_BOTH, $cursor_orientation=PDO::FETCH_ORI_NEXT, $cursor_offset=0) {
-            if ($this->current_row == 5) {
-                return false;
-            } else {
-                $this->current_row++;
-                return array('name' => 'Fred', 'age' => 10, 'id' => '1');
-            }
-        }
-    }
-
-    /**
-     *
-     * Mock database class implementing a subset
-     * of the PDO API.
-     *
-     */
-    class MockPDO extends PDO {
-
-        /**
-         * Return a dummy PDO statement
-         */
-        public function prepare($statement, $driver_options=array()) {
-            $this->last_query = new MockPDOStatement($statement);
-            return $this->last_query;
-        }
-    }
-
-    /**
-     *
-     * Class to provide simple testing functionality
-     *
-     */
-    class Tester {
-
-        private static $passed_tests = array();
-        private static $failed_tests = array();
-        private static $db;
-
-        private static $term_colours = array(
-            'BLACK' => "30",
-            'RED' => "31",
-            'GREEN' => "32",
-            'DEFAULT' => "00",
-        );
-
-        /**
-         * Format a line for printing. Detects
-         * if the script is being run from the command
-         * line or from a browser.
-         *
-         * Colouring code loosely based on
-         * http://www.zend.com//code/codex.php?ozid=1112&single=1
-         */
-        private static function format_line($line, $colour='DEFAULT') {
-            if (isset($_SERVER['HTTP_USER_AGENT'])) {
-                $colour = strtolower($colour);
-                return "<p style=\"color: $colour;\">$line</p>\n";
-            } else {
-                $colour = self::$term_colours[$colour];
-                return chr(27) . "[0;{$colour}m{$line}" . chr(27) . "[00m\n";
-            }
-        }
-
-        /**
-         * Report a passed test
-         */
-        public static function report_pass($test_name) {
-            echo self::format_line("PASS: $test_name", 'GREEN');
-            self::$passed_tests[] = $test_name;
-        }
-
-        /**
-         * Report a failed test
-         */
-        public static function report_failure($test_name, $expected, $actual) {
-            echo self::format_line("FAIL: $test_name", 'RED');
-            echo self::format_line("Expected: $expected", 'RED');
-            echo self::format_line("Actual: $actual", 'RED');
-            self::$failed_tests[] = $test_name;
-        }
-
-        /**
-         * Print a summary of passed and failed test counts
-         */
-        public static function report() {
-            $passed_count = count(self::$passed_tests);
-            $failed_count = count(self::$failed_tests);
-            echo self::format_line('');
-            echo self::format_line("$passed_count tests passed. $failed_count tests failed.");
-
-            if ($failed_count != 0) {
-                echo self::format_line("Failed tests: " . join(", ", self::$failed_tests));
-            }
-        }
-
-        /**
-         * Check the provided string is equal to the last
-         * query generated by the dummy database class.
-         */
-        public static function check_equal($test_name, $query) {
-            $last_query = ORM::get_last_query();
-            if ($query === $last_query) {
-                self::report_pass($test_name);
-            } else {
-                self::report_failure($test_name, $query, $last_query);
-            }
-        }
-    }
diff --git a/test/test_queries.php b/test/test_queries.php
deleted file mode 100755
index 611ad89..0000000
--- a/test/test_queries.php
+++ /dev/null
@@ -1,446 +0,0 @@
-<?php
-    /*
-     * Basic testing for Idiorm
-     *
-     * Checks that the generated SQL is correct
-     *
-     */
-
-    require_once dirname(__FILE__) . "/../idiorm.php";
-    require_once dirname(__FILE__) . "/test_classes.php";
-
-    // Enable logging
-    ORM::configure('logging', true);
-
-    // Set up the dummy database connection
-    $db = new MockPDO('sqlite::memory:');
-    ORM::set_db($db);
-
-    ORM::for_table('widget')->find_many();
-    $expected = "SELECT * FROM `widget`";
-    Tester::check_equal("Basic unfiltered find_many query", $expected);
-
-    ORM::for_table('widget')->find_one();
-    $expected = "SELECT * FROM `widget` LIMIT 1";
-    Tester::check_equal("Basic unfiltered find_one query", $expected);
-
-    ORM::for_table('widget')->where_id_is(5)->find_one();
-    $expected = "SELECT * FROM `widget` WHERE `id` = '5' LIMIT 1";
-    Tester::check_equal("where_id_is method", $expected);
-
-    ORM::for_table('widget')->find_one(5);
-    $expected = "SELECT * FROM `widget` WHERE `id` = '5' LIMIT 1";
-    Tester::check_equal("Filtering on ID passed into find_one method", $expected);
-
-    ORM::for_table('widget')->count();
-    $expected = "SELECT COUNT(*) AS `count` FROM `widget` LIMIT 1";
-    Tester::check_equal("COUNT query", $expected);
-
-    ORM::for_table('person')->max('height');
-    $expected = "SELECT MAX(`height`) AS `max` FROM `person` LIMIT 1";
-    Tester::check_equal("MAX query", $expected);
-
-    ORM::for_table('person')->min('height');
-    $expected = "SELECT MIN(`height`) AS `min` FROM `person` LIMIT 1";
-    Tester::check_equal("MIN query", $expected);
-
-    ORM::for_table('person')->avg('height');
-    $expected = "SELECT AVG(`height`) AS `avg` FROM `person` LIMIT 1";
-    Tester::check_equal("AVG query", $expected);
-
-    ORM::for_table('person')->sum('height');
-    $expected = "SELECT SUM(`height`) AS `sum` FROM `person` LIMIT 1";
-    Tester::check_equal("SUM query", $expected);
-
-    ORM::for_table('widget')->where('name', 'Fred')->find_one();
-    $expected = "SELECT * FROM `widget` WHERE `name` = 'Fred' LIMIT 1";
-    Tester::check_equal("Single where clause", $expected);
-
-    ORM::for_table('widget')->where('name', 'Fred')->where('age', 10)->find_one();
-    $expected = "SELECT * FROM `widget` WHERE `name` = 'Fred' AND `age` = '10' LIMIT 1";
-    Tester::check_equal("Multiple WHERE clauses", $expected);
-
-    ORM::for_table('widget')->where_not_equal('name', 'Fred')->find_many();
-    $expected = "SELECT * FROM `widget` WHERE `name` != 'Fred'";
-    Tester::check_equal("where_not_equal method", $expected);
-
-    ORM::for_table('widget')->where_like('name', '%Fred%')->find_one();
-    $expected = "SELECT * FROM `widget` WHERE `name` LIKE '%Fred%' LIMIT 1";
-    Tester::check_equal("where_like method", $expected);
-
-    ORM::for_table('widget')->where_not_like('name', '%Fred%')->find_one();
-    $expected = "SELECT * FROM `widget` WHERE `name` NOT LIKE '%Fred%' LIMIT 1";
-    Tester::check_equal("where_not_like method", $expected);
-
-    ORM::for_table('widget')->where_in('name', array('Fred', 'Joe'))->find_many();
-    $expected = "SELECT * FROM `widget` WHERE `name` IN ('Fred', 'Joe')";
-    Tester::check_equal("where_in method", $expected);
-
-    ORM::for_table('widget')->where_not_in('name', array('Fred', 'Joe'))->find_many();
-    $expected = "SELECT * FROM `widget` WHERE `name` NOT IN ('Fred', 'Joe')";
-    Tester::check_equal("where_not_in method", $expected);
-
-    ORM::for_table('widget')->limit(5)->find_many();
-    $expected = "SELECT * FROM `widget` LIMIT 5";
-    Tester::check_equal("LIMIT clause", $expected);
-
-    ORM::for_table('widget')->limit(5)->offset(5)->find_many();
-    $expected = "SELECT * FROM `widget` LIMIT 5 OFFSET 5";
-    Tester::check_equal("LIMIT and OFFSET clause", $expected);
-
-    ORM::for_table('widget')->order_by_desc('name')->find_one();
-    $expected = "SELECT * FROM `widget` ORDER BY `name` DESC LIMIT 1";
-    Tester::check_equal("ORDER BY DESC", $expected);
-
-    ORM::for_table('widget')->order_by_asc('name')->find_one();
-    $expected = "SELECT * FROM `widget` ORDER BY `name` ASC LIMIT 1";
-    Tester::check_equal("ORDER BY ASC", $expected);
-
-    ORM::for_table('widget')->order_by_expr('SOUNDEX(`name`)')->find_one();
-    $expected = "SELECT * FROM `widget` ORDER BY SOUNDEX(`name`) LIMIT 1";
-    Tester::check_equal("ORDER BY expression", $expected);
-
-    ORM::for_table('widget')->order_by_asc('name')->order_by_desc('age')->find_one();
-    $expected = "SELECT * FROM `widget` ORDER BY `name` ASC, `age` DESC LIMIT 1";
-    Tester::check_equal("Multiple ORDER BY", $expected);
-
-    ORM::for_table('widget')->group_by('name')->find_many();
-    $expected = "SELECT * FROM `widget` GROUP BY `name`";
-    Tester::check_equal("GROUP BY", $expected);
-
-    ORM::for_table('widget')->group_by('name')->group_by('age')->find_many();
-    $expected = "SELECT * FROM `widget` GROUP BY `name`, `age`";
-    Tester::check_equal("Multiple GROUP BY", $expected);
-
-    ORM::for_table('widget')->group_by_expr("FROM_UNIXTIME(`time`, '%Y-%m')")->find_many();
-    $expected = "SELECT * FROM `widget` GROUP BY FROM_UNIXTIME(`time`, '%Y-%m')";
-    Tester::check_equal("GROUP BY expression", $expected);
-
-    ORM::for_table('widget')->group_by('name')->having('name', 'Fred')->find_one();
-    $expected = "SELECT * FROM `widget` GROUP BY `name` HAVING `name` = 'Fred' LIMIT 1";
-    Tester::check_equal("Single having clause", $expected);
-
-    ORM::for_table('widget')->group_by('name')->having('name', 'Fred')->having('age', 10)->find_one();
-    $expected = "SELECT * FROM `widget` GROUP BY `name` HAVING `name` = 'Fred' AND `age` = '10' LIMIT 1";
-    Tester::check_equal("Multiple HAVING clauses", $expected);
-
-    ORM::for_table('widget')->group_by('name')->having_not_equal('name', 'Fred')->find_many();
-    $expected = "SELECT * FROM `widget` GROUP BY `name` HAVING `name` != 'Fred'";
-    Tester::check_equal("having_not_equal method", $expected);
-
-    ORM::for_table('widget')->group_by('name')->having_like('name', '%Fred%')->find_one();
-    $expected = "SELECT * FROM `widget` GROUP BY `name` HAVING `name` LIKE '%Fred%' LIMIT 1";
-    Tester::check_equal("having_like method", $expected);
-
-    ORM::for_table('widget')->group_by('name')->having_not_like('name', '%Fred%')->find_one();
-    $expected = "SELECT * FROM `widget` GROUP BY `name` HAVING `name` NOT LIKE '%Fred%' LIMIT 1";
-    Tester::check_equal("having_not_like method", $expected);
-
-    ORM::for_table('widget')->group_by('name')->having_in('name', array('Fred', 'Joe'))->find_many();
-    $expected = "SELECT * FROM `widget` GROUP BY `name` HAVING `name` IN ('Fred', 'Joe')";
-    Tester::check_equal("having_in method", $expected);
-
-    ORM::for_table('widget')->group_by('name')->having_not_in('name', array('Fred', 'Joe'))->find_many();
-    $expected = "SELECT * FROM `widget` GROUP BY `name` HAVING `name` NOT IN ('Fred', 'Joe')";
-    Tester::check_equal("having_not_in method", $expected);
-
-    ORM::for_table('widget')->group_by('name')->having_lt('age', 10)->having_gt('age', 5)->find_many();
-    $expected = "SELECT * FROM `widget` GROUP BY `name` HAVING `age` < '10' AND `age` > '5'";
-    Tester::check_equal("HAVING less than and greater than", $expected);
-
-
-    ORM::for_table('widget')->group_by('name')->having_lte('age', 10)->having_gte('age', 5)->find_many();
-    $expected = "SELECT * FROM `widget` GROUP BY `name` HAVING `age` <= '10' AND `age` >= '5'";
-    Tester::check_equal("HAVING less than or equal and greater than or equal", $expected);
-
-    ORM::for_table('widget')->group_by('name')->having_null('name')->find_many();
-    $expected = "SELECT * FROM `widget` GROUP BY `name` HAVING `name` IS NULL";
-    Tester::check_equal("having_null method", $expected);
-
-    ORM::for_table('widget')->group_by('name')->having_not_null('name')->find_many();
-    $expected = "SELECT * FROM `widget` GROUP BY `name` HAVING `name` IS NOT NULL";
-    Tester::check_equal("having_not_null method", $expected);
-
-    ORM::for_table('widget')->group_by('name')->having_raw('`name` = ? AND (`age` = ? OR `age` = ?)', array('Fred', 5, 10))->find_many();
-    $expected = "SELECT * FROM `widget` GROUP BY `name` HAVING `name` = 'Fred' AND (`age` = '5' OR `age` = '10')";
-    Tester::check_equal("Raw HAVING clause", $expected);
-
-    ORM::for_table('widget')->where('name', 'Fred')->limit(5)->offset(5)->order_by_asc('name')->find_many();
-    $expected = "SELECT * FROM `widget` WHERE `name` = 'Fred' ORDER BY `name` ASC LIMIT 5 OFFSET 5";
-    Tester::check_equal("Complex query", $expected);
-
-    ORM::for_table('widget')->where_lt('age', 10)->where_gt('age', 5)->find_many();
-    $expected = "SELECT * FROM `widget` WHERE `age` < '10' AND `age` > '5'";
-    Tester::check_equal("Less than and greater than", $expected);
-
-    ORM::for_table('widget')->where_lte('age', 10)->where_gte('age', 5)->find_many();
-    $expected = "SELECT * FROM `widget` WHERE `age` <= '10' AND `age` >= '5'";
-    Tester::check_equal("Less than or equal and greater than or equal", $expected);
-
-        ///////////////////////////////////////////
-
-    ORM::for_table('widget')->where_null('name')->find_many();
-    $expected = "SELECT * FROM `widget` WHERE `name` IS NULL";
-    Tester::check_equal("where_null method", $expected);
-
-    ORM::for_table('widget')->where_not_null('name')->find_many();
-    $expected = "SELECT * FROM `widget` WHERE `name` IS NOT NULL";
-    Tester::check_equal("where_not_null method", $expected);
-
-    ORM::for_table('widget')->where_raw('`name` = ? AND (`age` = ? OR `age` = ?)', array('Fred', 5, 10))->find_many();
-    $expected = "SELECT * FROM `widget` WHERE `name` = 'Fred' AND (`age` = '5' OR `age` = '10')";
-    Tester::check_equal("Raw WHERE clause", $expected);
-
-    ORM::for_table('widget')->where_raw('STRFTIME("%Y", "now") = ?', array(2012))->find_many();
-    $expected = "SELECT * FROM `widget` WHERE STRFTIME(\"%Y\", \"now\") = '2012'";
-    Tester::check_equal("Raw WHERE clause with '%'", $expected);
-
-    ORM::for_table('widget')->where_raw('`name` = "Fred"')->find_many();
-    $expected = "SELECT * FROM `widget` WHERE `name` = \"Fred\"";
-    Tester::check_equal("Raw WHERE clause with no parameters", $expected);
-
-    ORM::for_table('widget')->where('age', 18)->where_raw('(`name` = ? OR `name` = ?)', array('Fred', 'Bob'))->where('size', 'large')->find_many();
-    $expected = "SELECT * FROM `widget` WHERE `age` = '18' AND (`name` = 'Fred' OR `name` = 'Bob') AND `size` = 'large'";
-    Tester::check_equal("Raw WHERE clause in method chain", $expected);
-
-    ORM::for_table('widget')->raw_query('SELECT `w`.* FROM `widget` w')->find_many();
-    $expected = "SELECT `w`.* FROM `widget` w";
-    Tester::check_equal("Raw query", $expected);
-
-    ORM::for_table('widget')->raw_query('SELECT `w`.* FROM `widget` w WHERE `name` = ? AND `age` = ?', array('Fred', 5))->find_many();
-    $expected = "SELECT `w`.* FROM `widget` w WHERE `name` = 'Fred' AND `age` = '5'";
-    Tester::check_equal("Raw query with parameters", $expected);
-
-    ORM::for_table('widget')->select('name')->find_many();
-    $expected = "SELECT `name` FROM `widget`";
-    Tester::check_equal("Simple result column", $expected);
-
-    ORM::for_table('widget')->select('name')->select('age')->find_many();
-    $expected = "SELECT `name`, `age` FROM `widget`";
-    Tester::check_equal("Multiple simple result columns", $expected);
-
-    ORM::for_table('widget')->select('widget.name')->find_many();
-    $expected = "SELECT `widget`.`name` FROM `widget`";
-    Tester::check_equal("Specify table name and column in result columns", $expected);
-
-    ORM::for_table('widget')->select('widget.name', 'widget_name')->find_many();
-    $expected = "SELECT `widget`.`name` AS `widget_name` FROM `widget`";
-    Tester::check_equal("Aliases in result columns", $expected);
-
-    /////@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-
-    ORM::for_table('widget')->select_expr('COUNT(*)', 'count')->find_many();
-    $expected = "SELECT COUNT(*) AS `count` FROM `widget`";
-    Tester::check_equal("Literal expression in result columns", $expected);
-
-    ORM::for_table('widget')->select_many(array('widget_name' => 'widget.name'), 'widget_handle')->find_many();
-    $expected = "SELECT `widget`.`name` AS `widget_name`, `widget_handle` FROM `widget`";
-    Tester::check_equal("Aliases in select many result columns", $expected);
-
-    ORM::for_table('widget')->select_many_expr(array('count' => 'COUNT(*)'), 'SUM(widget_order)')->find_many();
-    $expected = "SELECT COUNT(*) AS `count`, SUM(widget_order) FROM `widget`";
-    Tester::check_equal("Literal expression in select many result columns", $expected);
-
-    ORM::for_table('widget')->join('widget_handle', array('widget_handle.widget_id', '=', 'widget.id'))->find_many();
-    $expected = "SELECT * FROM `widget` JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id`";
-    Tester::check_equal("Simple join", $expected);
-
-    ORM::for_table('widget')->join('widget_handle', array('widget_handle.widget_id', '=', 'widget.id'))->find_one(5);
-    $expected = "SELECT * FROM `widget` JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id` WHERE `widget`.`id` = '5' LIMIT 1";
-    Tester::check_equal("Simple join with where_id_is method", $expected);
-
-    ORM::for_table('widget')->inner_join('widget_handle', array('widget_handle.widget_id', '=', 'widget.id'))->find_many();
-    $expected = "SELECT * FROM `widget` INNER JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id`";
-    Tester::check_equal("Inner join", $expected);
-
-    ORM::for_table('widget')->left_outer_join('widget_handle', array('widget_handle.widget_id', '=', 'widget.id'))->find_many();
-    $expected = "SELECT * FROM `widget` LEFT OUTER JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id`";
-    Tester::check_equal("Left outer join", $expected);
-
-    ORM::for_table('widget')->right_outer_join('widget_handle', array('widget_handle.widget_id', '=', 'widget.id'))->find_many();
-    $expected = "SELECT * FROM `widget` RIGHT OUTER JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id`";
-    Tester::check_equal("Right outer join", $expected);
-
-    ORM::for_table('widget')->full_outer_join('widget_handle', array('widget_handle.widget_id', '=', 'widget.id'))->find_many();
-    $expected = "SELECT * FROM `widget` FULL OUTER JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id`";
-    Tester::check_equal("Full outer join", $expected);
-
-    ORM::for_table('widget')
-        ->join('widget_handle', array('widget_handle.widget_id', '=', 'widget.id'))
-        ->join('widget_nozzle', array('widget_nozzle.widget_id', '=', 'widget.id'))
-        ->find_many();
-    $expected = "SELECT * FROM `widget` JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id` JOIN `widget_nozzle` ON `widget_nozzle`.`widget_id` = `widget`.`id`";
-    Tester::check_equal("Multiple join sources", $expected);
-
-    ORM::for_table('widget')->table_alias('w')->find_many();
-    $expected = "SELECT * FROM `widget` `w`";
-    Tester::check_equal("Main table alias", $expected);
-
-    ORM::for_table('widget')->join('widget_handle', array('wh.widget_id', '=', 'widget.id'), 'wh')->find_many();
-    $expected = "SELECT * FROM `widget` JOIN `widget_handle` `wh` ON `wh`.`widget_id` = `widget`.`id`";
-    Tester::check_equal("Join with alias", $expected);
-
-    ORM::for_table('widget')->join('widget_handle', "widget_handle.widget_id = widget.id")->find_many();
-    $expected = "SELECT * FROM `widget` JOIN `widget_handle` ON widget_handle.widget_id = widget.id";
-    Tester::check_equal("Join with string constraint", $expected);
-
-    ORM::for_table('widget')->distinct()->select('name')->find_many();
-    $expected = "SELECT DISTINCT `name` FROM `widget`";
-    Tester::check_equal("Select with DISTINCT", $expected);
-
-    $widget = ORM::for_table('widget')->create();
-    $widget->name = "Fred";
-    $widget->age = 10;
-    $widget->save();
-    $expected = "INSERT INTO `widget` (`name`, `age`) VALUES ('Fred', '10')";
-    Tester::check_equal("Insert data", $expected);
-
-    $widget = ORM::for_table('widget')->create();
-    $widget->name = "Fred";
-    $widget->age = 10;
-    $widget->set_expr('added', 'NOW()');
-    $widget->save();
-    $expected = "INSERT INTO `widget` (`name`, `age`, `added`) VALUES ('Fred', '10', NOW())";
-    Tester::check_equal("Insert data containing an expression", $expected);
-
-    $widget = ORM::for_table('widget')->find_one(1);
-    $widget->name = "Fred";
-    $widget->age = 10;
-    $widget->save();
-    $expected = "UPDATE `widget` SET `name` = 'Fred', `age` = '10' WHERE `id` = '1'";
-    Tester::check_equal("Update data", $expected);
-
-    $widget = ORM::for_table('widget')->find_one(1);
-    $widget->name = "Fred";
-    $widget->age = 10;
-    $widget->set_expr('added', 'NOW()');
-    $widget->save();
-    $expected = "UPDATE `widget` SET `name` = 'Fred', `age` = '10', `added` = NOW() WHERE `id` = '1'";
-    Tester::check_equal("Update data containing an expression", $expected);
-
-    $widget = ORM::for_table('widget')->find_one(1);
-    $widget->set(array("name" => "Fred", "age" => 10));
-    $widget->save();
-    $expected = "UPDATE `widget` SET `name` = 'Fred', `age` = '10' WHERE `id` = '1'";
-    Tester::check_equal("Update multiple fields", $expected);
-
-    $widget = ORM::for_table('widget')->find_one(1);
-    $widget->set(array("name" => "Fred", "age" => 10));
-    $widget->set_expr(array("added" => "NOW()", "lat_long" => "GeomFromText('POINT(1.2347 2.3436)')"));
-    $widget->save();
-    $expected = "UPDATE `widget` SET `name` = 'Fred', `age` = '10', `added` = NOW(), `lat_long` = GeomFromText('POINT(1.2347 2.3436)') WHERE `id` = '1'";
-    Tester::check_equal("Update multiple fields containing an expression", $expected);
-
-    $widget = ORM::for_table('widget')->find_one(1);
-    $widget->set(array("name" => "Fred", "age" => 10));
-    $widget->set_expr(array("added" => "NOW()", "lat_long" => "GeomFromText('POINT(1.2347 2.3436)')"));
-    $widget->lat_long = 'unknown';
-    $widget->save();
-    $expected = "UPDATE `widget` SET `name` = 'Fred', `age` = '10', `added` = NOW(), `lat_long` = 'unknown' WHERE `id` = '1'";
-    Tester::check_equal("Update multiple fields containing an expression (override previously set expression with plain value)", $expected);
-
-    $widget = ORM::for_table('widget')->find_one(1);
-    $widget->delete();
-    $expected = "DELETE FROM `widget` WHERE `id` = '1'";
-    Tester::check_equal("Delete data", $expected);
-
-    $widget = ORM::for_table('widget')->where_equal('age', 10)->delete_many();
-    $expected = "DELETE FROM `widget` WHERE `age` = '10'";
-    Tester::check_equal("Delete many", $expected);
-
-    ORM::raw_execute("INSERT OR IGNORE INTO `widget` (`id`, `name`) VALUES (?, ?)", array(1, 'Tolstoy'));
-    $expected = "INSERT OR IGNORE INTO `widget` (`id`, `name`) VALUES ('1', 'Tolstoy')";
-    Tester::check_equal("Raw execute", $expected); // A bit of a silly test, as query is passed through
-
-    $widget = ORM::for_table('widget')->create();
-    $widget['name'] = "Fred";
-    $widget['age'] = 10;
-    $widget->save();
-    $expected = "INSERT INTO `widget` (`name`, `age`) VALUES ('Fred', '10')";
-    Tester::check_equal("Insert data using ArrayAccess", $expected);
-
-    ORM::for_table('widget')->where('name', 'Fred')->find_one();
-    $statement = ORM::get_last_statement();
-    $test_name = 'get_last_statement() returned MockPDOStatement';
-    if($statement instanceOf MockPDOStatement) {
-        Tester::report_pass($test_name);
-    } else {
-        $actual = gettype($statement);
-        if('object' == $actual) {
-            $actual = get_class($statement);
-        }
-        Tester::report_failure($test_name, 'MockPDOStatement', $actual);
-    }
-
-    // Regression tests
-
-    $widget = ORM::for_table('widget')->select('widget.*')->find_one();
-    $expected = "SELECT `widget`.* FROM `widget` LIMIT 1";
-    Tester::check_equal("Issue #12 - incorrect quoting of column wildcard", $expected);
-
-    $widget = ORM::for_table('widget')->where_raw('username LIKE "ben%"')->find_many();
-    $expected = 'SELECT * FROM `widget` WHERE username LIKE "ben%"';
-    Tester::check_equal('Issue #57 - _log_query method raises a warning when query contains "%"', $expected);
-
-    $widget = ORM::for_table('widget')->where_raw('comments LIKE "has been released?%"')->find_many();
-    $expected = 'SELECT * FROM `widget` WHERE comments LIKE "has been released?%"';
-    Tester::check_equal('Issue #57 - _log_query method raises a warning when query contains "?"', $expected);
-
-    $widget = ORM::for_table('widget')->find_one(1);
-    $widget->set('ad`ded', '2013-01-04');
-    $widget->save();
-    $expected = "UPDATE `widget` SET `ad``ded` = '2013-01-04' WHERE `id` = '1'";
-    Tester::check_equal('Issue #74 - escaping quote symbols in "_quote_identifier_part"', $expected);
-
-    $widget = ORM::for_table('widget')->find_one(1);
-    $widget->set_expr('added', 'NOW()');
-    $widget->save();
-    $expected = "UPDATE `widget` SET `added` = NOW() WHERE `id` = '1'";
-    Tester::check_equal("Issue #90 - When using set_expr alone it doesn't trigger query creation", $expected);
-
-    // Tests that alter Idiorm's config are done last
-
-    ORM::configure('id_column', 'primary_key');
-    ORM::for_table('widget')->find_one(5);
-    $expected = "SELECT * FROM `widget` WHERE `primary_key` = '5' LIMIT 1";
-    Tester::check_equal("Setting: id_column", $expected);
-
-    ORM::configure('id_column_overrides', array(
-        'widget' => 'widget_id',
-        'widget_handle' => 'widget_handle_id',
-    ));
-
-    ORM::for_table('widget')->find_one(5);
-    $expected = "SELECT * FROM `widget` WHERE `widget_id` = '5' LIMIT 1";
-    Tester::check_equal("Setting: id_column_overrides, first test", $expected);
-
-    ORM::for_table('widget_handle')->find_one(5);
-    $expected = "SELECT * FROM `widget_handle` WHERE `widget_handle_id` = '5' LIMIT 1";
-    Tester::check_equal("Setting: id_column_overrides, second test", $expected);
-
-    ORM::for_table('widget_nozzle')->find_one(5);
-    $expected = "SELECT * FROM `widget_nozzle` WHERE `primary_key` = '5' LIMIT 1";
-    Tester::check_equal("Setting: id_column_overrides, third test", $expected);
-
-    ORM::for_table('widget')->use_id_column('new_id')->find_one(5);
-    $expected = "SELECT * FROM `widget` WHERE `new_id` = '5' LIMIT 1";
-    Tester::check_equal("Instance ID column, first test", $expected);
-
-    ORM::for_table('widget_handle')->use_id_column('new_id')->find_one(5);
-    $expected = "SELECT * FROM `widget_handle` WHERE `new_id` = '5' LIMIT 1";
-    Tester::check_equal("Instance ID column, second test", $expected);
-
-    ORM::for_table('widget_nozzle')->use_id_column('new_id')->find_one(5);
-    $expected = "SELECT * FROM `widget_nozzle` WHERE `new_id` = '5' LIMIT 1";
-    Tester::check_equal("Instance ID column, third test", $expected);
-
-    // Test caching. This is a bit of a hack.
-    ORM::configure('caching', true);
-    ORM::for_table('widget')->where('name', 'Fred')->where('age', 17)->find_one();
-    ORM::for_table('widget')->where('name', 'Bob')->where('age', 42)->find_one();
-    $expected = ORM::get_last_query();
-    ORM::for_table('widget')->where('name', 'Fred')->where('age', 17)->find_one(); // this shouldn't run a query!
-    Tester::check_equal("Caching, same query not run twice", $expected);
-
-
-    Tester::report();
\ No newline at end of file