public function Connection::escapeAlias

public Connection::escapeAlias($field)

Escapes an alias name string.

Force all alias names to be strictly alphanumeric-plus-underscore. In contrast to DatabaseConnection::escapeField() / DatabaseConnection::escapeTable(), this doesn't allow the period (".") because that is not allowed in aliases.

Parameters

string $field: An unsanitized alias name.

Return value

string The sanitized alias name.

Overrides Connection::escapeAlias

File

core/lib/Drupal/Core/Database/Driver/pgsql/Connection.php, line 228

Class

Connection

PostgreSQL implementation of \Drupal\Core\Database\Connection.

Namespace

Drupal\Core\Database\Driver\pgsql

Code

public function escapeAlias($field) {
  $escaped = preg_replace('/[^A-Za-z0-9_]+/', '', $field);

  // Escape the alias in quotes for case-sensitivity.
  if (preg_match('/[A-Z]/', $escaped)) {
    $escaped = '"' . $escaped . '"';
  }
  elseif (in_array(strtolower($escaped), $this->postgresqlReservedKeyWords)) {
    // Quote the alias name for PostgreSQL reserved key words.
    $escaped = '"' . $escaped . '"';
  }

  return $escaped;
}