You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
70 lines
1.7 KiB
PHTML
70 lines
1.7 KiB
PHTML
|
10 years ago
|
<?php
|
||
|
|
|
||
|
|
namespace Illuminate\Database\Query\Processors;
|
||
|
|
|
||
|
|
use Exception;
|
||
|
|
use Illuminate\Database\Query\Builder;
|
||
|
|
|
||
|
|
class SqlServerProcessor extends Processor
|
||
|
|
{
|
||
|
|
/**
|
||
|
|
* Process an "insert get ID" query.
|
||
|
|
*
|
||
|
|
* @param \Illuminate\Database\Query\Builder $query
|
||
|
|
* @param string $sql
|
||
|
|
* @param array $values
|
||
|
|
* @param string $sequence
|
||
|
|
* @return int
|
||
|
|
*/
|
||
|
|
public function processInsertGetId(Builder $query, $sql, $values, $sequence = null)
|
||
|
|
{
|
||
|
|
$connection = $query->getConnection();
|
||
|
|
|
||
|
|
$connection->insert($sql, $values);
|
||
|
|
|
||
|
|
if ($connection->getConfig('odbc') === true) {
|
||
|
|
$id = $this->processInsertGetIdForOdbc($connection);
|
||
|
|
} else {
|
||
|
|
$id = $connection->getPdo()->lastInsertId();
|
||
|
|
}
|
||
|
|
|
||
|
|
return is_numeric($id) ? (int) $id : $id;
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Process an "insert get ID" query for ODBC.
|
||
|
|
*
|
||
|
|
* @param \Illuminate\Database\Connection $connection
|
||
|
|
* @return int
|
||
|
|
*/
|
||
|
|
protected function processInsertGetIdForOdbc($connection)
|
||
|
|
{
|
||
|
|
$result = $connection->selectFromWriteConnection('SELECT CAST(COALESCE(SCOPE_IDENTITY(), @@IDENTITY) AS int) AS insertid');
|
||
|
|
|
||
|
|
if (! $result) {
|
||
|
|
throw new Exception('Unable to retrieve lastInsertID for ODBC.');
|
||
|
|
}
|
||
|
|
|
||
|
|
$row = $result[0];
|
||
|
|
|
||
|
|
return is_object($row) ? $row->insertid : $row['insertid'];
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Process the results of a column listing query.
|
||
|
|
*
|
||
|
|
* @param array $results
|
||
|
|
* @return array
|
||
|
|
*/
|
||
|
|
public function processColumnListing($results)
|
||
|
|
{
|
||
|
|
$mapping = function ($r) {
|
||
|
|
$r = (object) $r;
|
||
|
|
|
||
|
|
return $r->name;
|
||
|
|
};
|
||
|
|
|
||
|
|
return array_map($mapping, $results);
|
||
|
|
}
|
||
|
|
}
|