diff options
| -rw-r--r-- | modules/database/classes/database/query.php | 2 | ||||
| -rw-r--r-- | tests/modules/database/driver/pdo/queryTest.php | 5 |
2 files changed, 5 insertions, 2 deletions
diff --git a/modules/database/classes/database/query.php b/modules/database/classes/database/query.php index d4f23a2..c48407c 100644 --- a/modules/database/classes/database/query.php +++ b/modules/database/classes/database/query.php @@ -5,8 +5,6 @@ * Database drivers extend this class so that they can generate database specific queries. * The idea is to provide a database agnostic interface to query writing. * - * @method mixed table(string $table = null) Set table to query. - * Without arguments returns current table, returns self otherwise. * * @method mixed data(array $data = null) Set data for insert or update queries. * Without arguments returns current data, returns self otherwise. diff --git a/tests/modules/database/driver/pdo/queryTest.php b/tests/modules/database/driver/pdo/queryTest.php index a9272a2..158a0f7 100644 --- a/tests/modules/database/driver/pdo/queryTest.php +++ b/tests/modules/database/driver/pdo/queryTest.php @@ -249,5 +249,10 @@ class Query_PDO_DriverTest extends PHPUnit_Framework_TestCase $this->assertEquals('SELECT * FROM (SELECT * FROM `fairies` ) AS a0 LEFT JOIN `pixies` ON `fairies`.`id` = `pixie`.`id` LEFT JOIN `fairies` AS fae ON `fairies`.`id` = `fae`.`id` LEFT JOIN (SELECT * FROM `fairies` ) AS fae2 ON `fairies`.`id` = `fae2`.`id` ',current($this->object->query())); } + public function testExpressionSelect() + { + $this->object->table('fairies')->where('id','in',DB::expr("(SELECT id from fairies)")); + $this->assertEquals('SELECT * FROM `fairies` WHERE `fairies`.`id` in (SELECT id from fairies) ',current($this->object->query())); + } } |