protected function scanForInsertId(Grid $grid) { if (!$grid->isLoaded()) { $primaryKey = $grid->primaryKey(); $foundKeyColumn = false; if (is_array($primaryKey)) { foreach ($primaryKey as $keyColumn) { if (!$keyColumn->isGeneratedOnPublish() || $keyColumn->hasData()) { continue; } $foundKeyColumn = $keyColumn; break; } } else { if ($primaryKey->isGeneratedOnPublish() && !$primaryKey->hasData()) { $foundKeyColumn = $primaryKey; } } if ($foundKeyColumn) { $result = $this->query('SELECT SCOPE_IDENTITY() AS [LAST_INSERT_ID]'); if (!$result || mssql_num_rows($result) != 1) { $this->throwException('Attempt to fetch last insert id value failed: ' . $this->error()); } $dataRow = $this->fetch_row($result); $foundKeyColumn->setData(array_shift($dataRow)); } } }
protected function scanForInsertId(Grid $grid) { if (!$grid->isLoaded()) { $primaryKey = $grid->primaryKey(); $foundKeyColumn = false; if (is_array($primaryKey)) { foreach ($primaryKey as $keyColumn) { if (!$keyColumn->isGeneratedOnPublish() || $keyColumn->hasData()) { continue; } $foundKeyColumn = $keyColumn; break; } } else { if ($primaryKey->isGeneratedOnPublish() && !$primaryKey->hasData()) { $foundKeyColumn = $primaryKey; } } if ($foundKeyColumn && ($lastInsertId = sqlite_last_insert_rowid($this->getConnection()))) { $foundKeyColumn->setData($lastInsertId); } } }
protected function scanForInsertId(Grid $grid, $sequence, $next = true) { if (!$grid->isLoaded()) { $primaryKey = $grid->primaryKey(); $foundKeyColumn = false; if (is_array($primaryKey)) { foreach ($primaryKey as $keyColumn) { if (!$keyColumn->isGeneratedOnPublish() || $keyColumn->hasData()) { continue; } $foundKeyColumn = $keyColumn; break; } } else { if ($primaryKey->isGeneratedOnPublish() && !$primaryKey->hasData()) { $foundKeyColumn = $primaryKey; } } if ($foundKeyColumn) { $result = $this->query('SELECT ' . $this->escapeDataName($sequence) . '.' . $this->escapeDataName($next ? 'NEXTVAL' : 'CURRVAL') . ' ' . $this->asColumnOperator . ' ' . $this->escapeDataNameAlias('LAST_INSERT_ID') . ' FROM ' . $this->escapeDataName('DUAL')); if (!is_resource($result)) { $this->throwException('Attempt to fetch last insert id value failed: ' . $this->error()); } $dataRow = $this->fetch_row($result); $foundKeyColumn->setData(array_shift($dataRow)); } } }
protected function scanForInsertId(Grid $grid) { if (!$grid->isLoaded()) { $primaryKey = $grid->primaryKey(); $foundKeyColumn = false; if (is_array($primaryKey)) { foreach ($primaryKey as $keyColumn) { if (!$keyColumn->isGeneratedOnPublish() || $keyColumn->hasData()) { continue; } $foundKeyColumn = $keyColumn; break; } } else { if ($primaryKey instanceof Column && $primaryKey->isGeneratedOnPublish() && !$primaryKey->hasData()) { $foundKeyColumn = $primaryKey; } } if ($foundKeyColumn && in_array($foundKeyColumn->getType(), array(Column::TYPE_FLOAT, Column::TYPE_INTEGER, Column::TYPE_UNSIGNED_INTEGER))) { // Executing the query directly, since the mysql_insert_id() command casts the return // value to c(long), and may truncate. $result = $this->query('SELECT LAST_INSERT_ID()'); if (!$result || $this->num_rows($result) != 1) { $this->throwException('Attempt to fetch last insert id value failed: ' . $this->error()); } $dataRow = $this->fetch_row($result); $foundKeyColumn->setData(array_shift($dataRow)); } } }