コード例 #1
0
ファイル: SelectTest.php プロジェクト: phossa/phossa-query
 /**
  * pass parameters
  *
  * @covers Phossa\Query\Dialect\Common::select()
  */
 public function testSelect20()
 {
     $str = 'SELECT * FROM "students" WHERE "age" IN RANGE(?, ?)';
     $sel = $this->builder->select()->from("students")->where("age", "IN", $this->builder->raw('RANGE(?, ?)', 1, 1.2));
     $this->assertEquals(preg_replace("/\r\n/", "\n", $str), $sel->getStatement(['positionedParam' => true]));
     $this->assertEquals([1, 1.2], $sel->getBindings());
 }