Diffusion Keruald libraries development repository 7a4563141b9c

Check table and view existence
7a4563141b9c
Actions

Description

Check table and view existence

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.

Reviewers: dereckson

Reviewed By: dereckson

Maniphest Tasks: T1678

Differential Revision: https://devcentral.nasqueron.org/D2511