private function Schema::defaultValueExpression in Drupal driver for SQL Server and SQL Azure 3.0.x

Same name and namespace in other branches

1. 8 drivers/lib/Drupal/Driver/Database/sqlsrv/Schema.php \Drupal\Driver\Database\sqlsrv\Schema::defaultValueExpression()

Get the SQL expression for a default value.

Parameters

string $sqlsr_type: Database data type.

mixed $default: Default value.

Return value

string An SQL Default expression.

3 calls to Schema::defaultValueExpression()

Schema::addField in drivers/lib/Drupal/Driver/Database/sqlsrv/Schema.php

Add a new field to a table.

Schema::changeField in drivers/lib/Drupal/Driver/Database/sqlsrv/Schema.php

Change a field definition.

Schema::createFieldSql in drivers/lib/Drupal/Driver/Database/sqlsrv/Schema.php

Create Field SQL.

File

drivers/lib/Drupal/Driver/Database/sqlsrv/Schema.php, line 1499

Class

Schema

Namespace

Drupal\Driver\Database\sqlsrv

Code

private function defaultValueExpression($sqlsr_type, $default) {

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