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); }