public function testSelectFetchRowAsObject() { $result = DB::select()->from('public.users')->where('id', 5)->fetchRow(); $this->assertThat($result, $this->logicalAnd($this->isInstanceOf('stdClass'), $this->ObjectHasAttribute('name'))); }
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); }