Page MenuHomeDevCentral

Check table and view existence
ClosedPublic

Authored by dereckson on Feb 11 2022, 00:21.
Tags
None
Referenced Files
Unknown Object (File)
Tue, Apr 23, 16:43
Unknown Object (File)
Tue, Apr 23, 07:21
Unknown Object (File)
Sun, Apr 21, 22:29
Unknown Object (File)
Sat, Apr 20, 23:55
Unknown Object (File)
Fri, Apr 19, 16:01
Unknown Object (File)
Thu, Apr 18, 04:40
Unknown Object (File)
Thu, Apr 18, 03:23
Unknown Object (File)
Mon, Apr 15, 06:03
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.