/*
      _______                          .__ .__   .__   .__                 
      \      \    ____   __ __ _______ |__||  |  |  |  |__|  ____    ____  
      /   |   \ _/ __ \ |  |  \\_  __ \|  ||  |  |  |  |  | /  _ \  /    \ 
     /    |    \\  ___/ |  |  / |  | \/|  ||  |__|  |__|  |(  <_> )|   |  \
     \____|__  / \___  >|____/  |__|   |__||____/|____/|__| \____/ |___|  /
    =========\/======\/=================================================\/==
  v0.01 03/AUG/2007 © Copyright 2007-2007 Scott D. Yelich SOME RIGHTS RESERVED
 .,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.-*~'`^`'~*-,._.,-*~'`^`'~*-,. 


  LICENSE:  Creative Commons Attribution 3.0 License.
  SEE:      http://creativecommons.org/licenses/by/3.0/


  Mon Aug 13 23:19:12 EDT 2007, v0.01 sdy

  This is a *very* simple program written to do test basic sqlite3 
  functionality.

*/

//  C++
#include <iostream>
#include <sstream>

#include <vector>

//  LOCAL

#include "Xql3.h" // Sqlite3

class Xql4 : public Xql3
{
  public:

  std::vector<std::string> h;  //  used to hold reponse headers.
  std::vector<std::string> d;  //  used to hold response data.

  int callback_out(void *NotUsed, int argc, char **argv, char **azColName)
  {
    std::cout << "Xql4::callback_out()\n";
    int i;
    if ( h.size() == 0 ) {
      for(i=0; i<argc; i++){
        h.push_back(azColName[i] ? azColName[i] : "NULL");
      }
    }
    for(i=0; i<argc; i++){
      d.push_back(argv[i] ? argv[i] : "NULL");
    }
    //  From:  http://www.sqlite.org/capi3ref.html#sqlite3_exec
    //  This callback should normally return 0. If the callback returns a
    //  non-zero value then the query is aborted, all subsequent SQL
    //  statements are skipped and the sqlite3_exec() function returns the
    //  SQLITE_ABORT.
    return 0;
  }

};

int
main()
{
  Xql4 sql3; // was: Xql3 sql3; // Xql4 allows the override of callback_out ...
  sql3.open("./data.db");

  std::stringstream sql_command_ss;
  sql_command_ss.str("");
  sql_command_ss << "DROP TABLE IF EXISTS simple_v2b;";
  sql_command_ss << "CREATE TABLE simple_v2b (text,int,time);";
  sql_command_ss << "INSERT INTO simple_v2b VALUES('sample v2b text1',1,DATETIME('NOW'));";
  sql_command_ss << "UPDATE simple_v2b SET int=int+1 where text='sample v2b text';";
  sql_command_ss << "INSERT INTO simple_v2b VALUES('sample v2b text2',2,DATETIME('NOW'));";
  sql_command_ss << "SELECT rowid,* FROM simple_v2b WHERE int<5;";

  int rc;

  sql3.h.clear();
  sql3.d.clear();
  rc = sql3.exec(sql_command_ss.str());
  sql3.close();

  int header_count = sql3.h.size();
  if ( header_count > 0 ) {
    int i;
    char sep = '|';

    for(i=0; i<header_count-1; i++){
      std::cout << sql3.h[i];
      std::cout << sep;
    }
    std::cout << sql3.h[i];
    std::cout << std::endl;

    int data_count = sql3.d.size();
    for(i=0; i<data_count; i++){
      std::cout << sql3.d[i];
      if ( (i+1)%header_count ) {
        std::cout << sep;
      } else {
        std::cout << std::endl;
      }
    }

  }

}