#include <iostream>
#include <fstream>
#include <mysql_driver.h>
#include <mysql_connection.h>
#include <cppconn/driver.h>
#include <cppconn/statement.h>
#include <cppconn/resultset.h>
#include <cppconn/exception.h>

int main()
{
    sql::mysql::MySQL_Driver* Driver = sql::mysql::get_mysql_driver_instance();
    sql::Connection* Connection;
    sql::Statement* Statement;
    sql::ResultSet* Result;

    try
    {
        Connection = Driver->connect("tcp://host.pl", "test", "test");
        Statement = Connection->createStatement();
        Statement->execute("USE tester");
        Result = Statement->executeQuery("SELECT ss_users.username "
                                         "FROM ss_users "
                                         "INNER JOIN ss_user_service ON (ss_users.uid = ss_user_service.uid) "
                                         "WHERE ss_user_service.service = 'ADMIN'");
    }
    catch(sql::SQLException &e)
    {
        std::cout << "MySQL exception caught" << std::endl;
        std::cout << e.what() << " (" << e.getErrorCode() << ")" << std::endl;
        std::cout << "Exitting" << std::endl;
        delete Connection;
        return -1;
    }

    std::ofstream OutFile("query.txt");
    if(!OutFile)
    {
        std::cout << "Failed to create 'query.txt'!" << std::endl << "Exitting" << std::endl;
        delete Connection;
        return -1;
    }
    while(Result->next())
        OutFile << Result->getString(1) << std::endl;
    OutFile.close();
    OutFile.clear();
    delete Connection;
    return 0;
}