Mercurial > repos > sem4j > sql_tools
changeset 0:9e9da6cf492b draft
Uploaded
| author | sem4j |
|---|---|
| date | Wed, 25 Sep 2013 01:28:55 -0400 |
| parents | |
| children | 86c92a1d55fa |
| files | sqlite.xml |
| diffstat | 1 files changed, 27 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/sqlite.xml Wed Sep 25 01:28:55 2013 -0400 @@ -0,0 +1,27 @@ +<tool id="sqlite" name="SQL" version="0.4"> + <description>Runner (SQLite)</description> + <command interpreter="python"> + sqlite.py $output_file $explain_plan $header "$sql" + #for $i in $files + ${i.file} ${i.header} '${i.index}' + #end for + </command> + <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="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="sql" type="text" area="true" size="10x50" label="SQL"> + <sanitizer sanitize="False"/> + </param> + <param name="explain_plan" type="boolean" truevalue="1" falsevalue="0" checked="False" label="Explain SQL execution plan. (Ignore if you are not a developer)" /> + </inputs> + <outputs> + <data name="output_file" format="tabular" label="${tool.name} on ${on_string}"/> + </outputs> + <help> +**What it does** + </help> +</tool>