/*
      _______                          .__ .__   .__   .__                 
      \      \    ____   __ __ _______ |__||  |  |  |  |__|  ____    ____  
      /   |   \ _/ __ \ |  |  \\_  __ \|  ||  |  |  |  |  | /  _ \  /    \ 
     /    |    \\  ___/ |  |  / |  | \/|  ||  |__|  |__|  |(  <_> )|   |  \
     \____|__  / \___  >|____/  |__|   |__||____/|____/|__| \____/ |___|  /
    =========\/======\/=================================================\/==
  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/


  Tue Aug 21 20:44:09 EDT 2007, v0.01 sdy

  This is a *very* simple program written to do test basic sqlite3 
  functionality.  This program uses an Xql3 class that has a call
  to the legacy "exec" -- which uses a callback.  This callback
  puts header and data into class vectors of strings.

*/

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

//  LOCAL

#include "Xql3.h" // Sqlite3

int
main()
{

  Xql3 sql3;
  sql3.open("./data.db");

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

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

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

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

  }

}