[807] | 1 | |
---|
| 2 | |
---|
| 3 | |
---|
| 4 | |
---|
| 5 | |
---|
| 6 | |
---|
| 7 | |
---|
| 8 | // %%%%%%%%%% |
---|
| 9 | // Qt headers |
---|
| 10 | // %%%%%%%%%% |
---|
| 11 | #include <QtSql> |
---|
| 12 | |
---|
| 13 | // %%%%%%%%%%%%% |
---|
| 14 | // gemc headers |
---|
| 15 | // %%%%%%%%%%%%% |
---|
| 16 | #include "detector.h" |
---|
| 17 | #include "MBankdefs.h" |
---|
| 18 | |
---|
| 19 | |
---|
| 20 | map<string, MBank> read_banks(gemc_opts gemcOpt, map<string, MPHB_Factory> Map) |
---|
| 21 | { |
---|
| 22 | string hd_msg = gemcOpt.args["LOG_MSG"].args + " Bank Map >> " ; |
---|
| 23 | double OUT_VERBOSITY = gemcOpt.args["OUT_VERBOSITY"].arg; |
---|
| 24 | string database = gemcOpt.args["BANK_DATABASE"].args; |
---|
| 25 | |
---|
| 26 | map<string, MBank> banks; |
---|
| 27 | |
---|
| 28 | QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL"); |
---|
| 29 | db.setHostName("clasdb.jlab.org"); |
---|
| 30 | db.setDatabaseName(database.c_str()); |
---|
| 31 | db.setUserName("clasuser"); |
---|
| 32 | bool ok = db.open(); |
---|
| 33 | |
---|
| 34 | if(!ok) |
---|
| 35 | { |
---|
| 36 | cout << hd_msg << " Database not connected. Exiting." << endl; |
---|
| 37 | exit(-1); |
---|
| 38 | } |
---|
| 39 | |
---|
| 40 | else |
---|
| 41 | for(map<string, MPHB_Factory>::iterator it=Map.begin(); it!=Map.end(); it++) |
---|
| 42 | { |
---|
| 43 | MBank mbank; |
---|
| 44 | string dbtable = it->first; |
---|
| 45 | QSqlQuery q; |
---|
| 46 | string dbexecute = "select name,id, type, activated, description from " + dbtable ; |
---|
| 47 | q.exec(dbexecute.c_str()); |
---|
| 48 | |
---|
| 49 | while (q.next()) |
---|
| 50 | { |
---|
| 51 | mbank.name.push_back(TrimSpaces(q.value(0).toString().toStdString())); |
---|
| 52 | mbank.id.push_back(q.value(1).toInt()); |
---|
| 53 | mbank.type.push_back(q.value(2).toInt()); |
---|
| 54 | mbank.activated.push_back(q.value(3).toInt()); |
---|
| 55 | mbank.description.push_back(q.value(4).toString().toStdString()); |
---|
| 56 | } |
---|
| 57 | banks[dbtable] = mbank; |
---|
| 58 | } |
---|
| 59 | |
---|
| 60 | if(OUT_VERBOSITY>2) |
---|
| 61 | { |
---|
| 62 | for(map<string, MBank>::iterator it=banks.begin(); it!=banks.end(); it++) |
---|
| 63 | { |
---|
| 64 | cout << hd_msg << " bank: <" << it->first << ">" << endl; |
---|
| 65 | for(int i=0; i<it->second.name.size(); i++) |
---|
| 66 | { |
---|
| 67 | cout << " variable: " ; |
---|
| 68 | cout.width(12); |
---|
| 69 | cout << it->second.name[i]; |
---|
| 70 | cout << " | id: " ; |
---|
| 71 | cout.width(2); |
---|
| 72 | cout << it->second.id[i] ; |
---|
| 73 | cout << " | " ; |
---|
| 74 | cout.width(8); |
---|
| 75 | cout << (it->second.type[i] ? "double |" : "int |"); |
---|
| 76 | cout.width(13); |
---|
| 77 | cout << (it->second.activated[i] ? "present |" : "not present |"); |
---|
| 78 | cout << it->second.description[i] << endl ; |
---|
| 79 | } |
---|
| 80 | cout << endl; |
---|
| 81 | } |
---|
| 82 | } |
---|
| 83 | db = QSqlDatabase(); |
---|
| 84 | db.removeDatabase("qt_sql_default_connection"); |
---|
| 85 | |
---|
| 86 | return banks; |
---|
| 87 | } |
---|
| 88 | |
---|
| 89 | |
---|
| 90 | |
---|
| 91 | |
---|
| 92 | |
---|