Changeset 12658

Timestamp:

11/27/11 18:36:07 (13 years ago)

Author:

tbretz

Message:

Implemented access to the CommentDB for commenting runs.

Location:

trunk/FACT++/gui

Files:

• FactGui.h (modified) (2 diffs)
• MainWindow.cc (modified) (1 diff)
• MainWindow.h (modified) (1 diff)
• fact.cc (modified) (1 diff)

trunk/FACT++/gui/FactGui.h

@@ -8 +8 @@
 
 #include <boost/bind.hpp>
+#include <boost/regex.hpp>
 
 #include <QTimer>
+#include <QtSql/QSqlError>
+#include <QtSql/QSqlTableModel>
 #include <QStandardItemModel>
 
@@ -4189 +4192 @@
 
         // --------------------------------------------------------------------------
+
+        fCommentsWidget->setEnabled(false);
+
+        static const boost::regex expr("(([[:word:].-]+)(:(.+))?@)?([[:word:].-]+)(:([[:digit:]]+))?(/([[:word:].-]+))");
+
+        const string database = conf.Get<string>("CommentDB");
+
+        if (!database.empty())
+        {
+            boost::smatch what;
+            if (!boost::regex_match(database, what, expr, boost::match_extra))
+                throw runtime_error("Couldn't parse '"+database+"'.");
+
+            if (what.size()!=10)
+                throw runtime_error("Error parsing '"+database+"'.");
+
+            const string user   = what[2];
+            const string passwd = what[4];
+            const string server = what[5];
+            const string db     = what[9];
+            const int port      = atoi(string(what[7]).c_str());
+
+            QSqlDatabase qdb = QSqlDatabase::addDatabase("QMYSQL");
+            qdb.setHostName(server.c_str());
+            qdb.setDatabaseName(db.c_str());
+            qdb.setUserName(user.c_str());
+            qdb.setPassword(passwd.c_str());
+            qdb.setPort(port);
+            qdb.setConnectOptions("CLIENT_SSL=1;MYSQL_OPT_RECONNECT=1");
+            if (qdb.open())
+            {
+                QSqlTableModel *model = new QSqlTableModel(fTableComments, qdb);
+                model->setTable("Configuration");
+                model->setEditStrategy(QSqlTableModel::OnManualSubmit);
+
+                const bool ok2 = model->select();
+
+                if (ok2)
+                {
+                    fTableComments->setModel(model);
+                    fTableComments->resizeColumnsToContents();
+                    fTableComments->resizeRowsToContents();
+
+                    connect(fCommentSubmit, SIGNAL(clicked()), model, SLOT(submitAll()));
+                    connect(fCommentRevert, SIGNAL(clicked()), model, SLOT(revertAll()));
+                    connect(fCommentUpdateLayout, SIGNAL(clicked()), fTableComments, SLOT(resizeColumnsToContents()));
+                    connect(fCommentUpdateLayout, SIGNAL(clicked()), fTableComments, SLOT(resizeRowsToContents()));
+
+                    fCommentsWidget->setEnabled(true);
+                }
+                else
+                    cout << "\n==> ERROR: Select on table failed.\n" << endl;
+            }
+            else
+                cout << "\n==> ERROR: Connection to database failed:\n           "
+                    << qdb.lastError().text().toStdString() << endl << endl;
+        }
+
+        // --------------------------------------------------------------------------
 #ifdef HAVE_ROOT
 

trunk/FACT++/gui/MainWindow.cc

@@ -108 +108 @@
 }
 
+void MainWindow::on_fCommentInsertRow_clicked()
+{
+    if (fTableComments->model())
+        fTableComments->model()->insertRow(fTableComments->model()->rowCount());
+}
+
 void MainWindow::on_fNoutof4Val_valueChanged(int val)
 {

trunk/FACT++/gui/MainWindow.h

@@ -46 +46 @@
     void on_fMcpStopRun_clicked();
     void on_fMcpReset_clicked();
+
+    // Comment Sql Table
+    void on_fCommentInsertRow_clicked();
 
     // System status

trunk/FACT++/gui/fact.cc

@@ -38 +38 @@
         ("host", var<string>(""),          "Address with which the Dim nameserver can connect to this host (overwites DIM_HOST_NODE environment variable)")
         ("pixel-map-file",  var<string>("FACTmap111030.txt"), "Pixel mapping file. Used here to get the default reference voltage.")
+        ("CommentDB",  var<string>(""), "")
         ;