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


  Wed Aug 15 22:10:24 EDT 2007, v0.01 sdy

*/

/* g++ 5minutes_2.c -o 5minutes_2 -lsqlite3 */
/* g++ -Wall -O2 -static 5minutes_2.c -o 5minutes_2 -lsqlite3 */

/* SOURCE:  http://www.sqlite.org/quickstart.html */

//  C++

#include <iostream>

//  SQLITE3

#include <sqlite3.h>

static int
callback(void *NotUsed, int argc, char **argv, char **azColName)
{
  int i;
  for(i=0; i<argc; i++){
    std::cout << azColName[i]
              << " = " << (argv[i] ? argv[i] : "NULL")
              << std::endl;
  }
//  std::cout << std::endl; // nl between rows?
  return 0;
}

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

  if (argc != 3) {
    std::cerr << "Usage: " << argv[0] << " DATABASE SQL-STATEMENT" << std::endl; 
    exit(1);
  }

  rc = sqlite3_open(argv[1], &db);
  if (rc) {
    std::cerr << "Can't open database: " << sqlite3_errmsg(db) << std::endl;
    sqlite3_close(db);
    exit(1);
  }

  rc = sqlite3_exec(db, argv[2], callback, 0, &zErrMsg);

  if (rc != SQLITE_OK) {
    std::cerr << "SQL error: "<< zErrMsg<< std::endl;
    sqlite3_free(zErrMsg);
  }

  sqlite3_close(db);

}