Changes between Version 11 and Version 12 of DatabaseBasedAnalysis

Timestamp:

08/03/18 20:10:06 (7 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis

@@ -151 +151 @@
 This can later be '''JOIN'''ed with the following queries.
 
+Let's write the list of runs into a file. There are plenty of options. Here are a few (assuming the query is in a file query.sql)
+{{{
+mysql -N [...] < query.sql > Crab.txt
+cat query.sql | mysql -N [...] > Crab.txt
+rootifysql [...] -n -v0 -d query.sql > Crab.txt
+rootifysql [...] -n -w Crab.txt query.sql
+}}}
+
+The [...] is placeholder for additional options, in particular the login credentials (ideally they are kept in a file which can not be read by everyone).
+
+An alternative is to put 
+{{{
+#!/path/to/rootifysql --config=/path/to/resources.rc
+}}}
+in the first line of your query.sql. Make it executable "{{{chmod u+x query.sql}}}" and put your credentials (uri=) into resources.rc. Now you can call it directly
+{{{
+query.sql -n -w Crab.txt
+}}}
+
+
 
 == Data retrieval ==