Mercurial > repos > sem4j > sql_tools
changeset 8:51847f1c0acb draft default tip
Uploaded
author | sem4j |
---|---|
date | Mon, 30 Sep 2013 04:09:36 -0400 |
parents | dc54d40d4748 |
children | |
files | sqlite.xml |
diffstat | 1 files changed, 56 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/sqlite.xml Mon Sep 30 04:09:00 2013 -0400 +++ b/sqlite.xml Mon Sep 30 04:09:36 2013 -0400 @@ -9,10 +9,10 @@ <inputs> <repeat name="files" title="Table"> <param name="file" type="data" format="tabular" label="File (tabular)"/> - <param name="header" type="boolean" truevalue="1" falsevalue="0" checked="False" label="Use the first row as column names. (If unchecked, use c1 c2 c3 ...)" /> + <param name="header" type="boolean" truevalue="1" falsevalue="0" checked="False" label="Use the first row as column names (If unchecked, use c1 c2 c3 ...)" /> <param name="index" type="text" size='20' value="" label="Index" /> </repeat> - <param name="header" type="boolean" truevalue="1" falsevalue="0" checked="False" label="Print column names in the first row." /> + <param name="header" type="boolean" truevalue="1" falsevalue="0" checked="False" label="Print column names in the first row" /> <param name="sql" type="text" area="true" size="10x50" label="SQL"> <sanitizer sanitize="False"/> </param> @@ -22,6 +22,59 @@ <data name="output_file" format="tabular" label="${tool.name} on ${on_string}"/> </outputs> <help> -**What it does** + +**Tables** + +Select all table to be joined. + +---- + +**Use the first line as column names** + +When the input file has column header:: + + id name + 101 John + 102 Mary + +Check this box and use column names ('id' and 'name') to write queries: + + SELECT * FROM t1 WHERE c2 = 'John'; + +When the input file does not have column header:: + + 101 John + 102 Mary + +Uncheck this box and use c1, c2, c3, ... to write queries: + + SELECT * FROM t1 WHERE name = 'John'; + +---- + +**Index** + +Comma-delimited list of column numbers. + +Example: + + 2,3 + +This creates NOT a composite index BUT two different indices on column 2 and on column 3. + +---- + +**Print column names in the first row** + +Example:: + + col1 col2 col3 + aaaa bbbb cccc + aaaa dddd eeee + +---- + +**SQL** + </help> </tool>