/*
      _______                           __  __    __    __                 
      \      \    ____   __ __ _______ |__||  |  |  |  |__|  ____    ____  
      /   |   \ _/ __ \ |  |  \\_  __ \|  ||  |  |  |  |  | /  _ \  /    \ 
     /    |    \\  ___/ |  |  / |  | \/|  ||  |__|  |__|  |(  <_> )|   |  \
     \____|__  / \___  >|____/  |__|   |__||____/|____/|__| \____/ |___|  /
    =========\/======\/=================================================\/==
  v0.01 03/AUG/2007 (C) 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(std::vector<std::string> & headers, 
	       std::vector<std::string> & data )
  {
    std::cout << "Xql4::callback()\n";
  
    int header_count = headers.size();
    int i;
    if (    h.size() == 0
         && header_count > 0 ) {
      for(i=0; i<header_count; i++){
        h.push_back(headers[i]);
      }
    }
    int data_count = data.size();
    if ( data_count > 0 ) {
      for(i=0; i<data_count; i++){
        d.push_back(data[i]);
      }
    }
  }

};

int
main()
{

  Xql4 sql3; // was: Xql3 sql3; // Xql4 allows the override of callback ...

  try { 

    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 text1';";
    sql_command_ss << "INSERT INTO simple_v2b VALUES('sample v2b text2',2,DATETIME('NOW'));";
    sql_command_ss << "SELECT rowid,* FROM simple_v2b WHERE int<500;";

    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;
        }
      }

    }

    sql3.close();

  }
  catch (Xql3Exception & e) {
    std::cerr << "sqlite3_error: " <<  sql3.dberrcode()
              << " --> " << sql3.dberrmsg() << std::endl;
    std::cerr << "Xql3Exception: " << e.code() << " --> "
              << e.what() << std::endl;
    sql3.close();
  }
}