/*
 * MySQL++ example
 *
 *  Created on: Jun 14, 2010
 */

#include <iostream>
#include <iomanip>
#include <mysql++.h>

using namespace std;

int main(int argc, char* argv[])
{
    int exit_code = 0;

    const char *db = NULL, *server = NULL, *user = NULL, *pass = NULL;

    db      = "mysql";
    server  = "localhost";
    user    = "root";
    pass    = "";

    mysqlpp::Connection conn(false);

    if (conn.connect(db, server, user, pass)) {
        mysqlpp::Query query = conn.query("SELECT * FROM user");

        if (mysqlpp::StoreQueryResult result = query.store()) {
            for (mysqlpp::StoreQueryResult::iterator it_row = result.begin(); it_row < result.end(); it_row++) {
                for (mysqlpp::Row::iterator it_column = (*it_row).begin(); it_column < (*it_row).end(); it_column++) {
                    cout << " " << *it_column;
                }

                cout  << endl;
            }
        }
        else {
            cerr << "Failed to get item list: " << query.error() << endl;
            exit_code = 1;
        }
    } else {
        cerr << "Failed connection to database:" << endl;
        cerr << setw(10) << left << "Server:" << setw(20) << server << endl;
        cerr << setw(10) << left << "Database:" << setw(20) << db << endl;
        cerr << setw(10) << left << "Error:" << setw(20) << conn.error() << endl;
        exit_code = 2;
    }

    return exit_code;
}