Changeset 19126 for trunk/FACT++/src/root2sql.cc

Timestamp:

08/03/18 13:46:37 (6 years ago)

Author:

tbretz

Message:

Implemented the possibility to print basic connection informations.

File:

• trunk/FACT++/src/root2sql.cc (modified) (3 diffs)

trunk/FACT++/src/root2sql.cc

@@ -74 +74 @@
         ("no-insert",      po_switch(),               "Does not insert any data into the table")
         ("dry-run",        po_switch(),               "Skip any query which changes the databse (might result in consecutive failures)")
+        ("print-connection", po_switch(),             "Print database connection information")
         ("print-branches", po_switch(),               "Print the branches found in the tree")
         ("print-leaves",   po_switch(),               "Print the leaves found in the tree (this is what is processed)")
@@ -316 +317 @@
     const bool ignore_errors     = conf.Get<bool>("ignore-errors");
 
+    const bool print_connection  = conf.Get<bool>("print-connection");
     const bool print_branches    = conf.Get<bool>("print-branches");
     const bool print_leaves      = conf.Get<bool>("print-leaves");
@@ -478 +480 @@
         cerr << "SQL connection failed: " << e.what() << '\n' << endl;
         return 3;
+    }
+
+    if (print_connection)
+    {
+        try
+        {
+            const auto &res1 = connection.query("SHOW STATUS LIKE 'Compression'").store();
+            cout << "Compression of databse connection is " << string(res1[0][1]) << endl;
+
+            const auto &res2 = connection.query("SHOW STATUS LIKE 'Ssl_cipher'").store();
+            cout << "Connection to databases is " << (string(res2[0][1]).empty()?"UNENCRYPTED":"ENCRYPTED ("+string(res2[0][1])+")") << endl;
+        }
+        catch (const exception &e)
+        {
+            cerr << "\nSHOW STATUS LIKE COMPRESSION\n\n";
+            cerr << "SQL query failed:\n" << e.what() << endl;
+            return 6;
+        }
     }