summaryrefslogtreecommitdiff
path: root/tests/simple_unit/ActiveRecord/FindBySqlTestCase.php
diff options
context:
space:
mode:
authorwei <>2007-05-07 04:17:37 +0000
committerwei <>2007-05-07 04:17:37 +0000
commiteab6bb13b9efb3e1c6d725368368de4d74b00946 (patch)
tree57aa3462b6f18ad190527483e753dc148971bc63 /tests/simple_unit/ActiveRecord/FindBySqlTestCase.php
parente91ac8550a4e6dfa255874860f108935841c16f6 (diff)
Update Active Record docs.
Diffstat (limited to 'tests/simple_unit/ActiveRecord/FindBySqlTestCase.php')
-rw-r--r--tests/simple_unit/ActiveRecord/FindBySqlTestCase.php29
1 files changed, 27 insertions, 2 deletions
diff --git a/tests/simple_unit/ActiveRecord/FindBySqlTestCase.php b/tests/simple_unit/ActiveRecord/FindBySqlTestCase.php
index 953f83e6..7f22afc5 100644
--- a/tests/simple_unit/ActiveRecord/FindBySqlTestCase.php
+++ b/tests/simple_unit/ActiveRecord/FindBySqlTestCase.php
@@ -1,7 +1,20 @@
-<?php
-
+<?php
Prado::using('System.Data.ActiveRecord.TActiveRecord');
require_once(dirname(__FILE__).'/records/DepartmentRecord.php');
+require_once(dirname(__FILE__).'/records/UserRecord.php');
+
+class UserRecord2 extends UserRecord
+{
+ public $another_value;
+}
+
+class SqlTest extends TActiveRecord
+{
+ public $category;
+ public $item;
+
+ const TABLE='items';
+}
class FindBySqlTestCase extends UnitTestCase
{
@@ -16,6 +29,18 @@ class FindBySqlTestCase extends UnitTestCase
$deps = DepartmentRecord::finder()->findBySql('SELECT * FROM departments');
$this->assertTrue(count($deps) > 0);
}
+
+ function test_find_by_sql_arb()
+ {
+ $sql = 'SELECT c.name as category, i.name as item
+ FROM items i, categories c
+ WHERE i.category_id = c.category_id LIMIT 2';
+ $items = TActiveRecord::finder('SqlTest')->findBySql($sql);
+
+ $sql = "SELECT users.*, 'hello' as another_value FROM users LIMIT 2";
+ $users = TActiveRecord::finder('UserRecord2')->findBySql($sql);
+ var_dump($users);
+ }
}
?> \ No newline at end of file