public static function EngineVersion::Get in Drupal driver for SQL Server and SQL Azure 8.2

Get an instance of EngineVersion

Parameters

Connection $cnn: The connection to use

Return value

EngineVersion

File

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

Class

EngineVersion

Namespace

Drupal\Driver\Database\sqlsrv\Scheme

Code

public static function Get(Connection $cnn) {
  $data = $cnn
    ->query_execute(<<<EOF
    SELECT CONVERT (varchar,SERVERPROPERTY('productversion')) AS VERSION,
    CONVERT (varchar,SERVERPROPERTY('productlevel')) AS LEVEL,
    CONVERT (varchar,SERVERPROPERTY('edition')) AS EDITION,
    CONVERT (varchar,SERVERPROPERTY('EngineEdition')) AS ENGINEEDITION
EOF
)
    ->fetchAssoc();
  $result = new EngineVersion();
  $result
    ->Version($data['VERSION']);
  $result
    ->Level($data['LEVEL']);
  $result
    ->Edition($data['EDITION']);
  $result
    ->EngineEdition($data['ENGINEEDITION']);
  return $result;
}