/**
 * db_bridge/main.cpp
 * Copyright (C) 2008 Markus Broeker
 */

#ifdef WITH_POSTGRESQL
#include <postgresql_db.h>
#else
#include <mysql_db.h>
#endif

int main (int argc, char **argv)
{
    Abstract_DB *db;

    std::vector <std::string> vec;
    std::vector <std::vector <std::string> >result;
    unsigned int i, j;

#ifdef WITH_POSTGRESQL
    db = new PostgreSQL_DB ("", "largo", "", "clubstatistik");
#else
    db = new MySQL_DB ("localhost", "dbuser", "dbpasswd", "datenbank");
#endif

    if (db->connect () == false) {
        std::cerr << "Kann mich nicht zur Datenbank verbinden. Passwoerter falsch?" << std::endl;
        return EXIT_FAILURE;
    }

    result = db->query ("select * from euroleague");

    for (i = 0; i < result.size (); i++) {
        vec = result[i];
        for (j = 0; j < vec.size (); j++) {
            std::cout << vec[j] << " ";
        }
        std::cout << std::endl;
    }

    delete db;

    return EXIT_SUCCESS;
}