Changes between Version 1 and Version 2 of DatabaseBasedAnalysis/rootifysql

Timestamp:

08/05/18 17:04:21 (6 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis/rootifysql

@@ -63 +63 @@
 {{{
 user@machine> echo "SELECT 'Hello World\!'" > query.sql
-user@machine> rootifysql -d -n --query="SELECT 'Hello World\!'"
+user@machine> rootifysql -d -n query.sql
 Reading global  options from 'fact++.rc'.
 Reading default options from 'rootifysql.rc'.
@@ -91 +91 @@
 --------------------------------------------------------------
 }}}
+
+== Connection information ==
+
+To get more information on the connection to the database, use {{{--print-connection}}}, for example
+{{{
+user@machine> user@machine> rootifysql -d -n --print-connection query.sql
+[...]
+------------------------ Rootify SQL -------------------------
+[...]
+Compression of database connection is ON
+Connection to databases is ENCRYPTED (DHE-RSA-AES256-SHA)
+[...]
+--------------------------------------------------------------
+
+Bytes_sent       398 
+Bytes_received   546 
+}}}
+
+Note that this data is retrieved through additional requests, which in principle slow down the execution time and add additional traffic to the connection.
+
+== Writing to an ASCII file ==
+
+We can redirect the result of the query to an ASCII file by
+{{{
+rootifysql -v 0 -d -n query.sql > output.txt
+}}}
+
+A verbosity level of 0 ({{{-v 0}}}) is required to turn off all the other output to standard out.
+
+If you want to keep it you can directly write to a file by
+
+{{{
+rootifysql -n query.sql -w output.txt
+}}}
+
+Here {{{-w}}} is a shortcut to {{{--write}}}. 
+
+== Writing to a root-file ==