public function getNextValue($sequence = '', $tableGenerator = 'manager_sequence')
{
$sql = new \database\MSQL("value", $tableGenerator, "(sequence='" . $sequence . "')");
$sql->setDb($this->db);
$result = $this->db->query($sql->select());
$value = $result[0][0];
$sql = new \database\MSQL("value", $tableGenerator, "(sequence='" . $sequence . "')");
$sql->setDb($this->db);
$result = $this->db->query($sql->update(':value + 1'));
return $value;
}
public function getUpdateStatementId($object, $id, $value = NULL)
{
// $id = array com PK dos objetos associados
$statement = new \database\MSQL();
$statement->setDb($this->fromClassMap->getDb());
$statement->setTables($this->toClassMap->getTableName());
$a = new OperandArray($id);
$statement->setColumns($this->toAttributeMap->getName());
$whereCondition = $this->toClassMap->getKeyAttributeName() . ' IN ' . $a->getSql();
$statement->setWhere($whereCondition);
//$statement->setParameters($object->getOIDValue());
$statement->setParameters($value);
return $statement->update();
}
