#include <stdio.h>
#include <iostream>
#include <stdlib.h>
#include <mysql/mysql.h>
#include <string>

#include "Database.h"
#include "Query.h"

using namespace std;

int main()
{
	int    bookId;
	string bookName;
	int    numChaptersInBook;
   string query;
	string sBookId;
	string sNumChaptersInBook;
	string dummy;

	Database db("localhost","cs3610","","test");
	Query q(db);

	cout << "The following records are in the test database, shomper table:\n\n";
	q.get_result("select * from shomper");
	while (q.fetch_row())
	{
		bookId = q.getval();
		bookName = q.getstr();
		numChaptersInBook = q.getval();

		printf("\tBook#%d: %s has %d chapter(s)\n", bookId, bookName.c_str(), 
															     numChaptersInBook );
	}
	q.free_result();

	cout << "\nWhich book would you like to delete (denote id number):  ";
	cin  >> sBookId;

   query = "delete from shomper where bid = " + sBookId;
	q.execute(query.c_str());

	cout << "\nWhick book would you like to insert in the database:\n\tid:  ";
   cin  >> sBookId;
	getline(cin, dummy, '\n');
	cout << "\tname:  ";
	getline(cin, bookName, '\n');
	cout << "\tnumber of chapters in book:  ";
	cin  >> sNumChaptersInBook;

   query = "insert into shomper (bid, name, chapters) values (" + 
			  sBookId + ", '" + bookName + "', " + sNumChaptersInBook + ")";
	q.execute(query.c_str());
}