Changeset 19126

Timestamp:

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

Author:

tbretz

Message:

Implemented the possibility to print basic connection informations.

Location:

trunk/FACT++/src

Files:

• fits2sql.cc (modified) (3 diffs)
• root2sql.cc (modified) (3 diffs)
• rootifysql.cc (modified) (4 diffs)

trunk/FACT++/src/fits2sql.cc

@@ -72 +72 @@
         ("dry-run",        po_switch(),               "Skip any query which changes the databse (might result in consecutive failures)")
         ("print-extensions", po_switch(),             "Print extensions (tables) from fits file")
+        ("print-connection", po_switch(),             "Print database connection information")
         ("print-columns",  po_switch(),               "Print columns in fits table")
         ("print-insert",   po_switch(),               "Print the INSERT query (note that it contains all data)")
@@ -300 +301 @@
     const bool ignore_errors     = conf.Get<bool>("ignore-errors");
 
+    const bool print_connection  = conf.Get<bool>("print-connection");
     const bool print_extensions  = conf.Get<bool>("print-extensions");
     const bool print_columns     = conf.Get<bool>("print-columns");
@@ -461 +463 @@
     Database connection(uri);
 
+    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;
+        }
+    }
+
     try
     {

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;
+        }
     }
 

trunk/FACT++/src/rootifysql.cc

@@ -24 +24 @@
     po::options_description control("Rootify SQL");
     control.add_options()
-        ("uri,u",         var<string>()->required(),   "Database link as in\n\tuser:password@server[:port]/database.")
+        ("uri,u",         var<string>()->required(),   "Database link as in\n\tuser:password@server[:port]/database[/comp].")
         ("query,q",       var<string>(""),             "MySQL query (overwrites --file)")
         ("file",          var<string>("rootify.sql"),  "An ASCII file with the MySQL query (overwrites --query)")
@@ -44 +44 @@
         ("env.*",         vars<string>(),              "Predefined environment for substitutions in the query ($ENV)")
         ("list.*",        var<string>(),               "Predefined environment for substitutions in the query ($ENV). The list is read from the given file (one list entry per line)")
+        ("print-connection", po_switch(),              "Print database connection information")
         ("verbose,v",     var<uint16_t>(1),            "Verbosity (0: quiet, 1: default, 2: more, 3, ...)")
         ;
@@ -384 +385 @@
     const string   delimiter   = conf.Get<string>("delimiter");
     const vector<string> _ignore = conf.Vec<string>("ignore");
+    const bool  print_connection = conf.Get<bool>("print-connection");
     //const vector<Map> mymap    = conf.Vec<Map>("map");
 
@@ -494 +496 @@
 
     Database connection(uri); // Keep alive while fetching rows
+
+    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;
+        }
+    }
 
     try