Aimeos\Aimeos\Setup::schema()

Complexity

Conditions	6
Paths	10

Size

Total Lines	37
Code Lines	20

Duplication

Lines	0
Ratio	0 %

Importance

Changes	8
Bugs	0	Features	0

<?php
    public static function schema(array $sql) : array
    {
        $ctx = self::getContext();
        $dbm = $ctx->getDatabaseManager();
        $connectionNames = array_keys($ctx->getConfig()->get( 'resource'));
        $connectionNames = array_filter($connectionNames, fn (string $key): bool => str_starts_with($key, 'db'));

        foreach ($connectionNames as $connectionName) {
            $conn = $dbm->acquire($connectionName);

            $tables = [];

            foreach(['fe_users_', 'madmin_', 'mshop_'] as $prefix) {
                $result = $conn->create('SHOW TABLES like \'' . $prefix . '%\'')->execute();

                while(($row = $result->fetch(\Aimeos\Base\DB\Result\Base::FETCH_NUM)) !== null) {
                    $tables[] = $row[0];
                }
            }

            foreach($tables as $table) {
                $result = $conn->create('SHOW CREATE TABLE `' . $table . '`')->execute();

                while(($row = $result->fetch(\Aimeos\Base\DB\Result\Base::FETCH_NUM)) !== null) {
                    $str = $row[1];

                    $str = str_replace('"', '`', $str);
                    $str = preg_replace('#CONSTRAINT `[a-zA-Z0-9_-]+` #', '', $str);

                    $sql[] = $str . ";\n";
                }
            }

            $dbm->release($conn);
        }

        return ['sqlString' => $sql];
    }