PHP Maestro\Database\MSQL::setDbの例

コード例 #1

ファイル: Platform.php プロジェクト: elymatos/expressive

 public function getNextValue($sequence = '', $tableGenerator = 'manager_sequence')
 {
     $sql = new \Maestro\Database\MSQL("value", $tableGenerator, "(sequence='" . $sequence . "')");
     $sql->setDb($this->db);
     $result = $this->db->query($sql->select());
     $value = $result[0][0];
     $sql = new \Maestro\Database\MSQL("value", $tableGenerator, "(sequence='" . $sequence . "')");
     $sql->setDb($this->db);
     $result = $this->db->query($sql->update(':value + 1'));
     return $value;
 }