Add simple query caching - issue #11

1 files changed, 9 insertions, 0 deletions

diff --git a/test/test_queries.php b/test/test_queries.php
index 68223c6..d30c78e 100644
--- a/test/test_queries.php
+++ b/test/test_queries.php
@@ -232,5 +232,14 @@
     $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();
 ?>