<?php

/*
 * This file is part of Phraseanet
 *
 * (c) 2005-2016 Alchemy
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace Alchemy\Phrasea\Helper;

use Doctrine\DBAL\Connection;

class DatabaseHelper extends Helper
{
    public function checkConnection()
    {
        $hostname = $this->request->query->get('hostname', '127.0.0.1');
        $port = (int) $this->request->query->get('port', 3306);
        $user = $this->request->query->get('user');
        $password = $this->request->query->get('password');
        $db_name = $this->request->query->get('db_name');

        $is_databox = $is_appbox = $empty = false;

        /** @var Connection $connection */
        $connection = $this->app['dbal.provider']([
            'host'     => $hostname,
            'port'     => $port,
            'user'     => $user,
            'password' => $password,
            'dbname'   => $db_name,
        ]);

        try {
            $connection->connect();
            $dbOK = true;
        } catch (\Exception $exception) {
            $dbOK = false;
        }

        if ($dbOK && false !== $connection->isConnected()) {
            $sql = "SHOW TABLE STATUS";
            $stmt = $connection->prepare($sql);
            $stmt->execute();

            $empty = $stmt->rowCount() === 0;

            $rs = $stmt->fetchAll(\PDO::FETCH_ASSOC);
            $stmt->closeCursor();

            foreach ($rs as $row) {
                if ($row["Name"] === 'sitepreff') {
                    $is_appbox = true;
                }
                if ($row["Name"] === 'pref') {
                    $is_databox = true;
                }
            }
            $connection->close();
        }

        unset($connection);

        $this->app['connection.pool.manager']->closeAll();

        return [
            'connection' => $dbOK,
            'innodb'     => true,
            'database'   => $dbOK,
            'is_empty'   => $empty,
            'is_appbox'  => $is_appbox,
            'is_databox' => $is_databox
        ];
    }
}