NAME

       textql - execute queries on structured text

SYNOPSIS

       textql   [-save-to  path]  [-output-file  path]  [-output-dlm  delimter]  [-output-header]
       [-header] [-dlm delimter] [-source path] [-sql sql_statements] [-quiet] [path...]
       textql -console path...

DESCRIPTION

       textql executes given statements in SQL on structured texts and returns  the  result.  SQL
       statements  accepted  by textql are ANSI SQL compatible, and are executed against the data
       in the order provided. No transformations are applied to the text files  but  are  instead
       applied  to  a  temporary  view  of  the  data.  Statements that insert data or modify the
       existing data will only have their effects visible in the output.

       The argument list of the end is expected to be a list of paths which may  or  may  not  be
       specific  files.  Each  path  is  traversed  for files that are then loaded as part of the
       database that textql creates internally, and files are  loaded  without  traversal.  Paths
       provided are not recursed.

       Each statement is then executed against textql´s internal database and the result, if any,
       is printed. INSERT, UPDATE, DELETE or other side effecting statements do  not  effect  the
       text  files  given  as  input,  but  instead modify the database internal to textql. Their
       result may be viewed via the output, presisting the database as is with -save-to or  in  a
       SQLite REPL with --console

       With no arguements, textql will print a brief overview of it´s usage.

FILES

       Structured  text accepted by textql is any text file in a tabular format where each row of
       the table is on a single line, and each column is a section of the  line  delimited  by  a
       single  character which is consistent throughout the file. A common structured text format
       is CSV (RFC4180).

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  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, -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 "stdout")

       -output-header
              Display column names in output

       -quiet Surpress logging

       -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

       textql is Copyright (C) 2015, 2016 Paul Bergeron http://pauldbergeron.com/

                                          December 2015                                 TEXTQL(1)