<?php

declare(strict_types=1);

require __DIR__.'/vendor/autoload.php';

use Guanguans\SoarPHP\Soar;

$queries = [
    <<<'QUERY'
        SELECT
            DATE_FORMAT (t.last_update, '%Y-%m-%d'),
            COUNT(DISTINCT (t.city))
        FROM
            city t
        WHERE
            t.last_update > '2018-10-22 00:00:00'
            AND t.city LIKE '%Chrome%'
            AND t.city = 'eip'
        GROUP BY
            DATE_FORMAT(t.last_update, '%Y-%m-%d')
        ORDER BY
            DATE_FORMAT(t.last_update, '%Y-%m-%d');
        QUERY,
    'SELECT * FROM `foo`;',
];

/**
 * Examples of scoring.
 */
$scores = Soar::make()->arrayScores($queries); // Basic scoring
dump($scores);

$scores = Soar::make() // Advanced scoring
    ->withTestDsn([
        'user' => 'you_user',
        'password' => 'you_password',
        'addr' => 'you_host:you_port',
        // 'host' => 'you_host',
        // 'port' => 'you_port',
        'schema' => 'you_dbname',
        // 'disable' => false,
    ])
    ->withOnlineDsn([
        'user' => 'you_user',
        'password' => 'you_password',
        // 'addr' => 'you_host:you_port',
        'host' => 'you_host',
        'port' => 'you_port',