<?php

/* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */

/**
 * Retrieve a database table contain
 *
 * PHP version 5
 *
 * Copyright © 2010-2014 Remi Collet
 *
 * This file is part of rpmphp.
 *
 * rpmphp is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * rpmphp is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with rpmphp.  If not, see <http://www.gnu.org/licenses/>.
 *
 * @category  Main
 * @package   RPMPHP
 *
 * @author    Remi Collet <unknown@unknwown.com>
 * @author    Johan Cwiklinski <johan@x-tnd.be>
 * @copyright 2010-2014 Remi Collet
 * @license   http://www.gnu.org/licenses/agpl-3.0-standalone.html AGPL License 3.0 or (at your option) any later version
 * @link      https://git.remirepo.net/cgit/web/rpmphp.git/
 * @since     The begining of times.
*/
chdir(dirname($_SERVER["SCRIPT_FILENAME"]));
date_default_timezone_set('Europe/Paris');

if (!isset($_GET['table'])) {
    die("Missing arg");
}
require "include/main.php";
require "class/CommonTable.php";

try {
    $db = new PDO ("mysql:dbname=" . MYBASE . ";host=" . MYHOST, MYUSER, MYPASS);

    $result = array();
    switch ($_GET['table']) {
        case 'packagist':
            $pkgist = new TablePackagist($db);
            foreach($pkgist->request(array('ORDER'=>'rpmname')) as $rec) {
                $result[$rec['pkgname']] = $rec['rpmname'];
            }
            break;
        case 'packagist2':
            $pkgist = new TablePackagist($db);
            foreach($pkgist->request(array('ORDER'=>'rpmname')) as $rec) {
                $result[$rec['rpmname']] = $rec['pkgname'];
            }
            break;
        default:
            die("Invalid arg");
    }
    echo json_encode($result, JSON_PRETTY_PRINT);

} catch(PDOException $e) {
    printf("%s ERREUR : %s\n", date("r"), $e->getMessage());
}