Page MenuHomeDevCentral

Check table and view existence
ClosedPublic

Authored by dereckson on Feb 11 2022, 00:21.
Tags
None
Referenced Files
F7577290: D2511.id6333.diff
Tue, Apr 29, 02:28
F7558781: D2511.diff
Mon, Apr 28, 18:46
Unknown Object (File)
Fri, Apr 25, 16:22
Unknown Object (File)
Fri, Apr 25, 16:22
Unknown Object (File)
Fri, Apr 25, 01:52
Unknown Object (File)
Thu, Apr 24, 21:43
Unknown Object (File)
Sat, Apr 19, 12:02
Unknown Object (File)
Fri, Apr 18, 17:38
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.