コード例 #1
0
 public function testSelectFetchRowAsObject()
 {
     $result = DB::select()->from('public.users')->where('id', 5)->fetchRow();
     $this->assertThat($result, $this->logicalAnd($this->isInstanceOf('stdClass'), $this->ObjectHasAttribute('name')));
 }
コード例 #2
0
 public function testCallFunctionInFrom()
 {
     $result = DB::select('generate_series(?::date, ?::date, ?)::date', ['2015-04-25', '2015-04-27', '1 day'])->fetchColumn();
     $this->assertEquals(['2015-04-25', '2015-04-26', '2015-04-27'], $result);
 }