//
// Tutorial example from [url]http://www.sqlite.org/quickstart.html[/url]
//
// Original example can be saved as a .cpp file and compiled
// the "normal" way as a C++ program.
//
// Just for kicks, I replaced printf statements with C++ I/O
// to prove that it's OK.
//
//
// Compiled with GNU compiler (version 4.1.2) on my Linux system
// with the following command line:
//
// g++ -Wall -W -pedantic sqlite3Example.cpp -osqlite3Example -lsqlite3
//
// davekw7x
//
#include <iostream>
#include <sqlite3.h>

using namespace std;

static int callback(void *NotUsed, int argc, char **argv, char **azColName)
{
    int i;
    for (i = 0; i < argc; i++) {
        cout << azColName[i] << (argv[i] ? argv[i] : "NULL") << endl;
        //printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
    }
    cout << endl;
    //printf("\n");
    return 0;
}

int main(int argc, char **argv)
{
    sqlite3 *db;
    char *zErrMsg = 0;
    int rc;

    if (argc != 3) {
        cerr << "Usage: " << argv[0] << " DATABASE SQL-STATEMENT" << endl;
        //fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv[0]);
        return (1);
    }
    rc = sqlite3_open(argv[1], &db);
    if (rc) {
        cerr << "Can't open database: " << sqlite3_errmsg(db) << endl;
        //fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
        sqlite3_close(db);
        return (1);
    }
    rc = sqlite3_exec(db, argv[2], callback, 0, &zErrMsg);
    if (rc != SQLITE_OK) {
        cerr << "SQL error: " << zErrMsg << endl;
        //fprintf(stderr, "SQL error: %s\n", zErrMsg);
        sqlite3_free(zErrMsg);
    }
    sqlite3_close(db);
    return 0;
}

// testSqlite3.cpp
//
//  Prepare a data base from a command line with the following:
//    sqlite3 sqtest.db
//    sqlite> create table clients (name text);
//    sqlite> insert into clients (name) values('John Galt');
//    sqlite> insert into clients (name) values('Zaphod Beeblebrox');
//    sqlite> insert into clients (name) values('Elroy Q. Shagnasti');
//    sqlite> .quit
//
//    Then run this program to show the table entries.
//
//    This program compiled with GNU g++ as follows:
//
//    g++ -Wall -W -pedantic testSqlite3.cpp lsqlite3 -o testSqlite3
//
//  
//  davekw7x
//
#include <iostream>
#include <cstring>
#include <cstdlib>
#include <sqlite3.h>

using namespace std;

int main(int argc, char **argv)
{

    const char *defaultName = "sqtest.db";
    const char *defaultTable = "Clients";

    const char *dbName;

    // Can optionally give data base name on command line.
    if (argc > 1) {
        dbName = argv[1];
    }
    else {
        dbName = defaultName;
    }

    // Can optionally give table name on command line.
    string cmd("Select * FROM ");
    if (argc > 2) {
        cmd += string(argv[2]);
    }
    else {
        cmd += defaultTable;
    }
    const char *sel = cmd.c_str();

    int status;
    sqlite3 *db;

    if ((status = sqlite3_open(dbName, &db)) != 0) {
        cerr << "sqlite3_open(" << dbName << ",...) failed with status " 
             << status << ": " << sqlite3_errmsg(db) << endl;
        exit(EXIT_FAILURE);
    }
    
    sqlite3_stmt *stmt;

    if ((status = sqlite3_prepare_v2(db, sel, strlen(sel) + 1, &stmt, __null)) != 0) {
        cerr << "sqlite3_prepare_v2(...," << sel << ",...) failed with status "
             << status << ": " << sqlite3_errmsg(db) << endl;
        exit(EXIT_FAILURE);
    } 
    

    int stepVal;
    int row = 0;
    while ((stepVal = sqlite3_step(stmt)) != SQLITE_DONE) {
        if (stepVal == SQLITE_ROW) {
            ++row;
            const unsigned char *name  = sqlite3_column_text(stmt, 0);
            cout << "Row " << row << ": " << name << endl;
            // Do something with this name???
        }
        else {
            cerr << "Hmmm...sqlite3_step() failed." << endl;
            exit(EXIT_FAILURE);
        }
    }
    cout << endl;
    cout << "Number of entries in the table = " << row << endl;
    return 0;
}