Score:2

Drupal

How to check if secondary database definition exists

miststudent2011

9/23/23, 2:19 PM

Can anyone please help me on how to check if secondary database is set. If not throw an error.

I am currently defining database connection as below.

Database::getConnection('default', 'sqlite')

I am trying to defining a if , else condition based the database defining.

When I try

if(Database::getConnection('default', 'sqlite')){
  echo success;
}else {
  echo fail;
}

I am getting below error. If secondary database definition is not defined in settings.php

Drupal\Core\Entity\EntityStorageException: 
The specified database connection is not defined: sqlite in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (line 811 of core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

0 + 0

database

Score:2

Drupal

apaderno

9/24/23, 10:38 AM

To check if a connection has been defined, I would use code similar to the following one.

if ($connections = Database::getAllConnectionInfo() && isset($connections['default']['sqlite'])) {
  // The connection is defined.
}

Database::getConnection() returns a connection object, and it could return the one for default/primary server, when the requested information is for an ignored connection or the requested connection isn't defined.

  // If the requested target does not exist, or if it is ignored, we fall back
  // to the default target. The target is typically either "default" or
  // "replica", indicating to use a replica SQL server if one is available. If
  // it's not available, then the default/primary server is the correct server
  // to use.
  if (!empty(self::$ignoreTargets[$key][$target]) || !isset(self::$databaseInfo[$key][$target])) {
    $target = 'default';
  }
  if (!isset(self::$connections[$key][$target])) {

    // If necessary, a new connection is opened.
    self::$connections[$key][$target] = self::openConnection($key, $target);
  }

This means that expecting an exception from Database::getConnection() when the connection isn't defined is wrong.

0 + 0

miststudent2011

9/25/23, 11:44 AM

Thanks its better than the other answer.

Score:1

Drupal

cilefen

9/23/23, 2:59 PM

try {
    $connection = Database::getConnection('default', 'sqlite');
}
catch (Drupal\Core\Entity\EntityStorageException $e) {
    // Do something here.
}
finally {
    // Optional: do something in any case.
}

0 + 0

miststudent2011

9/24/23, 4:27 AM

Thanks , it works. But just wondering whether we have any method in core to check if the connection exists. Something like `hasConnection()`

Score:-1

Drupal

miststudent2011

9/24/23, 6:36 AM

Although cilefen pointed me in the right direction. It still throws fatal error when using cilefen's answer. I am able to resolve this issue by slightly modifying exception handling.

try {
  $connection = Database::getConnection('default', 'sqlite');
} catch (\Exception $e) {
  return new \Exception("SQLite Database configurtion is not setup.", 1);
}

Created a core issue #3282024 to add native method to check database connection.

0 + 0

cilefen

9/24/23, 10:25 AM

You may need a slash before the exception, like \Drupal\Core\Entity\EntityStorageException. \Exception could be anything at all.

miststudent2011

9/24/23, 10:39 AM

Adding slash produces the same error.

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: How to check if secondary database definition exists

TH: วิธีตรวจสอบว่ามีข้อกำหนดฐานข้อมูลรองอยู่หรือไม่

RO: Cum se verifică dacă există o definiție secundară a bazei de date

RU: Как проверить, существует ли определение вторичной базы данных

VI: Cách kiểm tra xem định nghĩa cơ sở dữ liệu thứ cấp có tồn tại không

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.