Faulancer\Console\Helper\DbTables::getTableData()

Complexity

Conditions	3
Paths	3

Size

Total Lines	29
Code Lines	15

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public static function getTableData(Config $config)
    {

        $result = [];

        $dbConf = new DbConfig(
            $config->get('db:type'),
            $config->get('db:name'),
            $config->get('db:username'),
            $config->get('db:password'),
            $config->get('db:host')
        );

        $entityManager = new EntityManager([EntityManager::OPT_CONNECTION => $dbConf]);
        $tables        = $entityManager->getConnection()->query('SHOW TABLES')->fetchAll(\PDO::FETCH_UNIQUE);

        foreach (array_keys($tables) as $table) {

            $columns = $entityManager->getConnection()->query('SHOW COLUMNS FROM ' . $table)->fetchAll(\PDO::FETCH_ASSOC);

            foreach ($columns as $column) {
                $result[$table][] = $column;
            }

        }

        return $result;

    }

}