Germania\Websites\PdoAllWebsites::__construct()

Complexity

Conditions	6
Paths	2

Size

Total Lines

52

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	15
CRAP Score	7.1598

Importance

Changes

0

<?php
    public function __construct( \PDO $pdo, $table, WebsiteAbstract $website = null  )
    {
        $this->table = $table;

        // ID is listed twice here in order to use it with FETCH_UNIQUE as array key
        $sql = "SELECT
        id,
        id,
        title,
        via,
        route,
        route_name,
        content_file,
        middleware,
        controller,
        template,
        dom_id,
        javascripts,
        stylesheets,
        is_active

        FROM {$this->table}

        WHERE 1";

        $stmt = $pdo->prepare( $sql );

        $stmt->setFetchMode( \PDO::FETCH_CLASS, $website ? get_class($website) : Website::class );

        if (!$stmt->execute()):
            throw new \RuntimeException("Could not retrieve Websites from database");
        endif;

        $this->websites = array_map(function($row) {

            // Cast numeric is_active field to integer
            $row->is_active = (int) $row->is_active;

            // Split into array
            if (isset($row->javascripts)):
                $row->javascripts = preg_split("/[\s,]+/", trim($row->javascripts));
            endif;
            if (isset($row->stylesheets)):
                $row->stylesheets = preg_split("/[\s,]+/", trim($row->stylesheets));
            endif;
            if (isset($row->via)):
                $row->via = preg_split("/[\s,]+/", trim($row->via));
            endif;

            return $row;
        }, $stmt->fetchAll(\PDO::FETCH_UNIQUE));
    }