Page MenuHomeDevCentral

Check table and view existence
ClosedPublic

Authored by dereckson on Feb 11 2022, 00:21.
Tags
None
Referenced Files
F7712035: D2511.diff
Thu, May 1, 12:44
F7709720: D2511.id6334.diff
Thu, May 1, 11:29
F7672090: D2511.id6337.diff
Wed, Apr 30, 19:47
Unknown Object (File)
Wed, Apr 30, 09:11
Unknown Object (File)
Wed, Apr 30, 06:31
Unknown Object (File)
Tue, Apr 29, 02:28
Unknown Object (File)
Mon, Apr 28, 18:46
Unknown Object (File)
Fri, Apr 25, 16:22
Subscribers
None

Details

Summary

An example of use is Zed site health check for database views.
This check detect frequent import/export issues with views:

$notExistingViews = Vector::from(self::DOCUMENTED_VIEWS)
    ->filter(fn($view) => !$this->db->isExistingTable(
        $this->config['database']['database'],
        $view
    ));
$viewsAsTables = Vector::from(self::DOCUMENTED_VIEWS)
    ->filter(fn($view) => !$this->db->isView(
        $this->config['database']['database'],
        $view
    ));

Ref T1678.

Diff Detail

Repository
rKDB Keruald Database
Lint
Lint Not Applicable
Unit
Tests Not Applicable

Event Timeline

dereckson created this revision.
This revision is now accepted and ready to land.Feb 11 2022, 00:43
This revision was landed with ongoing or failed builds.Feb 11 2022, 00:52
This revision was automatically updated to reflect the committed changes.