Page MenuHomeDevCentral

Check table and view existence
ClosedPublic

Authored by dereckson on Feb 11 2022, 00:21.
Tags
None
Referenced Files
F4038871: D2511.id6334.diff
Tue, Jan 21, 23:58
Unknown Object (File)
Sat, Jan 18, 16:43
Unknown Object (File)
Sat, Jan 18, 16:23
Unknown Object (File)
Sat, Jan 18, 07:19
Unknown Object (File)
Sat, Jan 18, 03:44
Unknown Object (File)
Wed, Jan 15, 01:10
Unknown Object (File)
Sat, Jan 11, 20:39
Unknown Object (File)
Thu, Jan 9, 02:27
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.