summaryrefslogtreecommitdiff
path: root/tests/simple_unit/ActiveRecord/FindBySqlTestCase.php
diff options
context:
space:
mode:
authorctrlaltca <>2012-07-12 11:21:01 +0000
committerctrlaltca <>2012-07-12 11:21:01 +0000
commit903ae8a581fac1e6917fc3e31d2ad8fb91df80c3 (patch)
treee08bf04f0823650a231227ac3499121270172a23 /tests/simple_unit/ActiveRecord/FindBySqlTestCase.php
parent3e4e6e66aeb3f8fea4e1eb4237498ef9d2358f63 (diff)
standardize the use of unix eol; use svn properties to enforce native eol
Diffstat (limited to 'tests/simple_unit/ActiveRecord/FindBySqlTestCase.php')
-rw-r--r--tests/simple_unit/ActiveRecord/FindBySqlTestCase.php88
1 files changed, 44 insertions, 44 deletions
diff --git a/tests/simple_unit/ActiveRecord/FindBySqlTestCase.php b/tests/simple_unit/ActiveRecord/FindBySqlTestCase.php
index 7f22afc5..e613cc30 100644
--- a/tests/simple_unit/ActiveRecord/FindBySqlTestCase.php
+++ b/tests/simple_unit/ActiveRecord/FindBySqlTestCase.php
@@ -1,46 +1,46 @@
-<?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
-{
- function setup()
- {
- $conn = new TDbConnection('pgsql:host=localhost;dbname=test', 'test','test');
- TActiveRecordManager::getInstance()->setDbConnection($conn);
- }
-
- function test_find_by_sql()
- {
- $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);
- }
-}
+<?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
+{
+ function setup()
+ {
+ $conn = new TDbConnection('pgsql:host=localhost;dbname=test', 'test','test');
+ TActiveRecordManager::getInstance()->setDbConnection($conn);
+ }
+
+ function test_find_by_sql()
+ {
+ $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