Miscellaneous |
Version lineage of this tool (guids ordered most recent to oldest) |
toolshed.g2.bx.psu.edu/repos/jjohnson/query_tabular/query_tabular/3.1.0 |
toolshed.g2.bx.psu.edu/repos/jjohnson/query_tabular/query_tabular/3.0.0 (this tool) |
toolshed.g2.bx.psu.edu/repos/jjohnson/query_tabular/query_tabular/2.0.0 |
toolshed.g2.bx.psu.edu/repos/jjohnson/query_tabular/query_tabular/0.1.3 |
toolshed.g2.bx.psu.edu/repos/jjohnson/query_tabular/query_tabular/0.1.2 |
toolshed.g2.bx.psu.edu/repos/jjohnson/query_tabular/query_tabular/0.1.1 |
toolshed.g2.bx.psu.edu/repos/jjohnson/query_tabular/query_tabular/0.1.0 |
query_tabular |
Requirements (dependencies defined in the <requirements> tag set) |
Functional tests |
name | inputs | outputs | required files |
Test-1 |
sqlquery: SELECT FirstName,LastName,sum(SaleAmount) as "TotalSales" FROM customers join sales on customers.CustomerID = sales.CustomerID GROUP BY customers.CustomerID ORDER BY TotalSales DESC tables_1|table: sales.tsv tables_0|table: customers.tsv |
output: sales_results.tsv |
customers.tsv sales.tsv sales_results.tsv |
Test-2 |
sqlquery: SELECT FirstName,LastName,sum(t2.c3) as "TotalSales" FROM t1 join t2 on t1.c1 = t2.c1 GROUP BY t1.c1 ORDER BY TotalSales DESC; tables_1|table: sales.tsv tables_0|table: customers.tsv |
output: sales_results.tsv |
customers.tsv sales.tsv sales_results.tsv |
Test-3 |
sqlquery: select FirstName,LastName,re_sub('^\d{2}(\d{2})-(\d\d)-(\d\d)','\3/\2/\1',BirthDate) as "DOB" from t1 WHERE re_search('[hp]er',c4) tables_0|table: customers.tsv |
output: regex_results.tsv |
customers.tsv regex_results.tsv |
Test-4 |
sqlquery: select iedb.ID,iedb.peptide,iedb.start,iedb.end,iedb.percentile_rank,mhc_summary.logscore,mhc_summary.affinity,mhc_summary.Bind_Level from iedb left outer join mhc_summary on iedb.peptide = mhc_summary.peptide order by affinity,Bind_Level tables_1|table: netMHC_summary.tsv tables_0|table: IEDB.tsv |
output: query_results.tsv |
IEDB.tsv netMHC_summary.tsv query_results.tsv |