function PostgreSqlSequenceUpdateTest::getSequenceOwner

Retrieves the sequence owner object.

Return value

object|bool Returns the sequence owner object or bool if it does not exist.

File

core/modules/pgsql/tests/src/Functional/Database/PostgreSqlSequenceUpdateTest.php, line 70

Class

PostgreSqlSequenceUpdateTest

Tests that any unowned sequences created previously have a table owner.

Namespace

Code

protected function getSequenceOwner(string $table, string $field) : object|bool {
    $update_sequence = \Drupal::classResolver(Update10101::class);
    $seq_name = $update_sequence->getSequenceName($table, $field);
    return \Drupal::database()->query("SELECT d.refobjid::regclass as table_name, a.attname as field_name\n      FROM pg_depend d\n      JOIN pg_attribute a ON a.attrelid = d.refobjid AND a.attnum = d.refobjsubid\n      WHERE d.objid = :seq_name::regclass\n      AND d.refobjsubid > 0\n      AND d.classid = 'pg_class'::regclass", [
        ':seq_name' => $seq_name,
    ])
        ->fetchObject();
}