public function testSuccess()
{
$task = new Query($this->entityManager->recordManager);
$this->assertTrue($task instanceof Query);
$this->assertTrue($task instanceof Task);
$task->setObject(new Raw("SELECT 1"));
$this->assertTrue($task->execute($this->db));
}
public function testInitIncompatibleObject()
{
$base = new Query($this->entityManager->recordManager);
$this->assertFalse($base->setObject(new stdClass(), false));
$this->assertNull($base->getObject());
$this->setExpectedException("Bond\\RecordManager\\Exception\\BadTaskException");
$base->setObject(new stdClass());
}
/**
* Get the current (ie, value most recently obtained) from a list of named Sequences
*
* @param array $sequences array of sequence names
* @param Pg $db Database connection to use
* @return array Array of sequence values
*/
protected static function getSequenceCurval(array $sequences, Pg $db)
{
// anything to do
if (!$sequences) {
return array();
}
// sequence components
foreach ($sequences as $key => &$sequence) {
$sequence = sprintf("currval('%s'::regclass) as %s", $sequence, Query::quoteIdentifier($key));
}
$sequences = implode(', ', $sequences);
return $db->query(new Query("SELECT {$sequences};"))->fetchSingle(Result::FLATTEN_PREVENT);
}
