You can list as many files / directories as you like.Directories are read by reading each file inside, and this is non-recursive.Added join support! Multiple files / directories can be loaded by listing them at the end of the command.
See Time Strings for a list for accepted formats, and how to convert from other formats. Date / Time / DateTime values are automatically recognized in reasonable formats.Numeric values are automatically recognized in more cases.There've also been additional performance tweaks and added functionality, but this comes at the cost of breaking the original command-line flags and changing the install command. In the time since the initial release of textql, I've made some improvements as well as made the project much more modular. Visit the GSP FreeBSD Man Page Interface.Allows you to easily execute SQL against structured text like CSV or TSV. Textql is Copyright (C) 2015, 2016 Paul Bergeron "stdout") -output-header Display column names in output -quiet Surpress logging -pretty Pretty print output -save-to file SQLite3 db is left on disk at this file -sql string SQL Statement(s) to run on the data -version Print version and exit COPYRIGHT dlm=0x# to specify a character code in hex (default ",") -output-file file Filename to write output to, if empty no output is written (default Specify a character code in hex (default ",") -header Treat input files as having the first row as a header row -output-dlm string Output delimiter character between fields -output-dlm=tab for tab, OPTIONS -console After all statements are run, open SQLite3 REPL with this data -dlm string Input delimiter character between fields -dlm=tab for tab, -dlm=0x# to Line delimited by a single character which is consistent throughout the file.Ī common structured text format is CSV (RFC4180). Structured text accepted by textql is any text file in a tabular format whereĮach row of the table is on a single line, and each column is a section of the With no arguements, textql will print a brief overview of Presisting the database as is with -save-to or in a SQLite REPL with Their result may be viewed via the output, UPDATE, DELETE or other side effecting statements do notĮffect the text files given as input, but instead modify the database Internal database and the result, if any, is printed. Paths provided are notĮach statement is then executed against textql´s Internally, and files are loaded without traversal. That are then loaded as part of the database that textql creates The argument list of the end is expected to be a list of paths Have their effects visible in the output. Statements that insert data or modify the existing data will only No transformationsĪre applied to the text files but are instead applied to a temporary view of SQL statements accepted by textql are ANSI SQL compatible,Īnd are executed against the data in the order provided. ĭESCRIPTION textql executes given statements in SQL on structured texts and returns NAME textql - execute queries on structured text