// ShippedSearch.cpp : Defines the entry point for the console application.
//Developer Command Prompt type in Run 
//cd C:\Users\omar\Documents\Visual Studio 2013\Projects\ShippedSearch\ShippedSearch>
//LIB /DEF:sqlite3.def
//Microsoft (R) Library Manager Version 12.00.31101.0
//LINK : warning LNK4068 : / MACHINE not specified; defaulting to X86
//	   Creating library sqlite3.lib and object sqlite3.exp
// Project -> ProjectNameProperties, Configuration, Linker, Additional, add sqlite3.lib
// now need .h file in Almagation zip put .h only in project folder \ project folder
// c library so use  #include "sqlite3.h" not <sqlite3> 
//should no londer have an underline symbol
//std::cin requires #include <string>
//to remove .dll need .c from almagation zip folder
//Always deploy release not debug, DEBUG Is default
//go to build-> configuration managers Change Debg to Release 2 times
//otherwise will complain MSVCP120D.dll missing or CRASH if you add manually

#include "stdafx.h"
#include <iostream>
#include <ios>
#include "sqlite3.h"
#include <string>

int _tmain(int argc, _TCHAR* argv[])
{
	sqlite3 *db;
	// 5 steps to do a single prepared statement
	//www.sqlite.org/c3ref/stmt.html
	std::string sqlStatement = "SELECT * FROM barcodes where barcode = ? ORDER BY modifytime DESC;";
	int exit = 0;
	//file:///N:/database/file.sqlite?mode=ro
	exit = sqlite3_open("S:\\OK\\barcodes.sqlite3", &db);
	if (exit != SQLITE_OK)
	{
		std::cout << "DB not working\n";
	}
	//Create the prepared statement object using sqlite3_prepare_v2().
	//Bind values to parameters using the sqlite3_bind_*() interfaces.
	//Run the SQL by calling sqlite3_step() one or more times.
	//Reset the prepared statement using sqlite3_reset() then go back to step 2. Do this zero or more times.
	//Destroy the object using sqlite3_finalize().
	sqlite3_stmt * sqlHandler;
	//int sqlite3_prepare_v2(
	//sqlite3 *db,            /* Database handle */
	//const char *zSql,       /* SQL statement, UTF-8 encoded */
	//int nByte,              /* Maximum length of zSql in bytes. */
	//sqlite3_stmt **ppStmt,  /* OUT: Statement handle */
	//const char **pzTail     /* OUT: Pointer to unused portion of zSql */
	//If the nByte argument is negative, then zSql is read up to the first zero terminator.
	exit = sqlite3_prepare_v2(db, sqlStatement.c_str(),
		-1, &sqlHandler, 0);

	if (exit == SQLITE_OK)
	{

		std::string barcode_cin = "test";
		while (barcode_cin != "quit" && barcode_cin != "QUIT")
		{
			std::cout << "\nENTER WORK ORDER:";
			std::cin >> barcode_cin;
			if (barcode_cin == "quit" || barcode_cin == "QUIT")
			{
				break;
			}
			sqlite3_bind_text(sqlHandler, 1,
				barcode_cin.c_str(),
				-1, SQLITE_STATIC);
			int step = sqlite3_step(sqlHandler);
			if (step != SQLITE_ROW)
			{
				std::cout << barcode_cin << " Not Found\n";
				//another one, reset, bind, step repeat
				sqlite3_reset(sqlHandler);
			}

			while (step == SQLITE_ROW)
			{
				//std::string / const unsigned char not same
				//std::string(reinterpret_cast<const char*>(
				// barcodes(barcode text,
				//fullpath text,
				//barcode_type text,
				//pagenum integer,
				//modifytime timestamp
				//re interpret cast
				const unsigned char * row_barcode =
					sqlite3_column_text(sqlHandler, 0);
				const unsigned char* row_path =
					sqlite3_column_text(sqlHandler, 1);
				int row_pagenum =
					sqlite3_column_int(sqlHandler, 3);
				const unsigned char * row_date =
					sqlite3_column_text(sqlHandler, 4);

				printf("Barcode %s path: %s | page:%d\n ",
					row_barcode, row_path,
					row_pagenum
					);
				step = sqlite3_step(sqlHandler);

			}
			//another one, reset, bind, step repeat
			sqlite3_reset(sqlHandler);
		}
	}
	sqlite3_finalize(sqlHandler);

	sqlite3_close(db);

	return 0;
}