// %%%%%%%%%%
// Qt headers
// %%%%%%%%%%
#include <QtSql>

// %%%%%%%%%%%%%
// gemc headers
// %%%%%%%%%%%%%
#include "detector.h"
#include "MBankdefs.h"


map<string, MBank> read_banks(gemc_opts gemcOpt, map<string, MPHB_Factory> Map)
{
 string hd_msg         = gemcOpt.args["LOG_MSG"].args + " Bank Map >> " ;
 double OUT_VERBOSITY  = gemcOpt.args["OUT_VERBOSITY"].arg;
 string database = gemcOpt.args["BANK_DATABASE"].args;

 map<string, MBank> banks;

 QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
 db.setHostName("clasdb.jlab.org");
 db.setDatabaseName(database.c_str());
 db.setUserName("clasuser");
 bool ok = db.open();

 if(!ok)
 {
    cout << hd_msg << " Database not connected. Exiting." << endl;
    exit(-1);
 }

 else
 for(map<string, MPHB_Factory>::iterator it=Map.begin(); it!=Map.end(); it++)
 {
    MBank mbank;
    string dbtable  = it->first;
    QSqlQuery q;
    string dbexecute = "select name,id, type, activated, description from " + dbtable ;
    q.exec(dbexecute.c_str());

    while (q.next())
    {
       mbank.name.push_back(TrimSpaces(q.value(0).toString().toStdString()));
       mbank.id.push_back(q.value(1).toInt());
       mbank.type.push_back(q.value(2).toInt());
       mbank.activated.push_back(q.value(3).toInt());
       mbank.description.push_back(q.value(4).toString().toStdString());  
    }
    banks[dbtable] = mbank;
 }

 if(OUT_VERBOSITY>2)
 {
    for(map<string, MBank>::iterator it=banks.begin(); it!=banks.end(); it++)
    {
       cout << hd_msg << " bank: <" << it->first << ">" << endl;
       for(int i=0; i<it->second.name.size(); i++)
       {
          cout << "      variable: " ;
          cout.width(12);
          cout << it->second.name[i];
          cout << " | id: " ;
          cout.width(2);
          cout << it->second.id[i] ;
          cout << " | " ;
          cout.width(8);
          cout << (it->second.type[i] ? "double |" : "int |");
          cout.width(13);
          cout << (it->second.activated[i] ? "present |" : "not present |");
          cout << it->second.description[i] << endl ;
       }
       cout << endl;
    }
 }
 db = QSqlDatabase(); 
 db.removeDatabase("qt_sql_default_connection");

 return banks;
}