#include </usr/include/mysql++/mysql++.h>
#include <stdio.h>
#include <iostream>
#include <fstream>
#include <sstream>
#include <ostream>
#include <string>
#include <vector>

using namespace std;
using namespace mysqlpp;

int main()
{
  //<----------------------------------------------------->
  mysqlpp::Connection conn;
  if (conn.connect("dsgsports","127.0.0.1" , "root", "")) {
          printf("Creating guides...\n");  
  }
  else {
    printf("Database connection failure.");
    return 1;
  }
  //<----------------------------------------------------->

  string todaysdate;  
  stringstream transfer;
  time_t rawtime;
  struct tm* timeinfo;
  time(&rawtime);
  timeinfo = localtime(&rawtime);
  //Format todaysdate.
  transfer << timeinfo->tm_year + 1900;
  transfer << timeinfo->tm_mon+1;
  transfer << timeinfo->tm_mday;
  todaysdate = transfer.str();
  cout << "Todays date:" << todaysdate << endl;

  vector<Row> todayslive;
  Query querya = conn.query();
  querya << "select * from sports_schedule where tf_air_date='" << todaysdate + "' " << "and tf_live_tape_delay='Live' order by tf_database_key";
  querya.storein(todayslive);
  cout << "'todayslive.size()'=" <<  todayslive.size() << endl;

  vector<Row> todayslivedet;
  for(int i=0;i<todayslive.size();i++) {
    mysqlpp::String transfer = todayslive.at(i)["tf_database_key"];
    string tf_database_key = string(transfer.data(),transfer.length());
    //cout << i << " " << tf_database_key  << endl;
    Query queryb = conn.query();
    queryb << "select * from sports_program where tf_database_key='" << tf_database_key + "'";
    queryb.storein(todayslivedet);
    //StoreQueryResult res = queryb.store();
    //todayslivedet.push_back(res);  
  }
 
  cout << "'todayslivedet.size()='" << todayslivedet.size() << endl;
  
  for(int i=0;i<todayslive.size();i++) {
    cout << todayslive.at(i)["tf_database_key"] << " " <<  todayslivedet.at(i)["tf_database_key"] << endl;
  }

  
  //Load tl & tld.i
  string tl[todayslive.size()][2];
  string tld[todayslivedet.size()][3];
  
  for(int i=0;i<todayslive.size();i++) {
    mysqlpp::String transfer;
    string transfer2;
      
    transfer = todayslive.at(i)["tf_database_key"];
    transfer2 = string(transfer.data(),transfer.length());
    tl[i][0]="mystring";
    transfer = todayslive.at(i)["tf_air_time"];
    transfer2 = string(transfer.data(),transfer.length());
    tl[i][1]="mystring";
    transfer = todayslive.at(i)["tf_duration"];
    transfer2 = string(transfer.data(),transfer.length());
    tl[i][2]="mystring";

    //transfer = todayslivedet.at(i)["tf_database_key"];
    //transfer2 = string(transfer.data(),transfer.length());
    //tld[i][0]=transfer2;
    //transfer = todayslivedet.at(i)["tf_title"];
    //transfer2 = string(transfer.data(),transfer.length());
    //tld[i][1]=transfer2;
    //transfer = todayslivedet.at(i)["tf_genre_desc138"];
    //transfer2 = string(transfer.data(),transfer.length());
    //tld[i][2]=transfer2;
    //transfer = todayslivedet.at(i)["tf_epi_title"];
    //transfer2 = string(transfer.data(),transfer.length());
    //tld[i][3]=transfer2;
  }
  //End Load tl & tld.

  //vector<string> genres;
  //cout << tld[0][2] << endl;
  //cout << tld[1][2] << endl;
  //cout << tld[2][2] << endl;
  
  //File IO is done here.  
  std::ofstream outfile("guide.txt", std::ios::out);
  if(outfile.is_open())
  {
    //for(int i=0;i<todayslive.size();i++) {
      //for(int x=0;x<tl.size();x++){ outfile << tl.at(x) + " "; }
      //outfile << endl;
      //for(int x=0;x<tld.size();x++) { outfile << tld.at(x) + " "; }
      //outfile << endl;    
    //}
    //outfile.close();
  }
  else
    std::cout << "Could not open file." << endl;
  //End of File IO.





  cout << "Guides created successfully." << endl;    
  return 0;
}