NORSQL¶
The NORSQL command allows you to run arbitrary SQL commands against “the database” (the database here being defined by the content of a file called gor.sql.credentials in the config directory).
NORSQL can be run against any database table.
SQL statements need to be encapsulated between curly brackets, e.g. norsql {sql_query}.
Usage¶
norsql {<sql_query>} | ...
Examples¶
norsql {select * from Case_Controls order by PN} | ...
norsql {select * from Case_Controls WHERE PN = 'ABC' } | ...
gorsql -f AAA,TTT {select * from Case_Controls WHERE PN in (#{TAGS}) } | ...