public function Scheme::DefaultValueExpression in Drupal driver for SQL Server and SQL Azure 8.2

Get the SQL expression for a default value that can be embedded directly into a query.

Parameters

string $sqlsr_type: Sql server type: nvarchar, varbinary, char, ntext, etc.

mixed $default: The default value.

File

drivers/lib/Drupal/Driver/Database/sqlsrv/Scheme.php, line 44

Class

Scheme

Namespace

Drupal\Driver\Database\sqlsrv

Code

public function DefaultValueExpression($sqlsr_type, $default) {

  // The actual expression depends on the target data type as it might require conversions.
  $result = is_string($default) ? $this->cnn
    ->quote($default) : $default;
  if (Utils::GetMSSQLType($sqlsr_type) == 'varbinary') {
    $default = $this->cnn
      ->quote($default);
    $result = "CONVERT({$sqlsr_type}, {$default})";
  }
  return $result;
}