<?php

/**
 * Matomo - free/libre analytics platform
 *
 * @link    https://matomo.org
 * @license https://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
 */
namespace Piwik\Plugins\DBStats;

use Exception;
use Piwik\Config;
use Piwik\Db;
/**
 * Data Access Object that serves MySQL stats.
 */
class MySQLMetadataDataAccess
{
    public function getDBStatus()
    {
        if (function_exists('mysql_connect') && function_exists('mysql_stat') && function_exists('mysql_close')) {
            $configDb = Config::getInstance()->database;
            $link = mysql_connect($configDb['host'], $configDb['username'], $configDb['password']);
            $status = mysql_stat($link);
            mysql_close($link);
            $status = explode("  ", $status);
        } else {
            $fullStatus = Db::fetchAssoc('SHOW STATUS');
            if (empty($fullStatus)) {
                throw new Exception('Error, SHOW STATUS failed');
            }
            $status = array(
                'Uptime' => $fullStatus['Uptime']['Value'],
                'Threads' => $fullStatus['Threads_running']['Value'],
                'Questions' => $fullStatus['Questions']['Value'],
                'Slow queries' => $fullStatus['Slow_queries']['Value'],
                'Flush tables' => $fullStatus['Flush_commands']['Value'],
                'Open tables' => $fullStatus['Open_tables']['Value'],
                'Opens' => 'unavailable',
                // not available via SHOW STATUS
                'Queries per second avg' => 'unavailable',
            );
        }
        return $status;
    }
    public function getTableStatus($tableName)
    {
        return Db::fetchRow("SHOW TABLE STATUS LIKE ?", array($tableName));
    }
    public function getAllTablesStatus()
    {
        return Db::fetchAll("SHOW TABLE STATUS");
    }
    public function getRowCountsByArchiveName($tableName, $extraCols)
    {
        // otherwise, create data table & cache it
        $sql = "SELECT name as 'label', COUNT(*) as 'row_count'{$extraCols} FROM `{$tableName}` GROUP BY name";
        return Db::fetchAll($sql);
    }
    public function getColumnsFromTable($tableName)
    {
        return Db::fetchAll("SHOW COLUMNS FROM " . $tableName);
    }
}
