NAME

recs-fromdb

recs-fromdb --help-all

   Recs from DB will execute a select statement on a database of your choice,
   and create a record stream from the results. The keys of the record will be
   the column names and the values the row values.

   --table                      Name of the table to dump, this is a shortcut
                                for --sql 'SELECT * from tableName'
   --sql                        SQL select statement to run
   --filename-key|fk <keyspec>  Add a key with the source filename (if no
                                filename is applicable will put NONE)

  Help Options:
      --help  This help screen

Database Options
   password  - Password to connect as
   type  - Type of database to connect to - Default: sqlite
   user  - User to connect as

Datbase types:
   mysql - Connect to a remote mysql database
   oracle - Connect to a remote Oracle database
   pg - Connect to a remote PostgreSQL database
   sqlite - A simple local file based db

Database Options for type: mysql
   dbname  - Database to connect to
   host  - Mysql Host

Database Options for type: oracle
   db  - Database name (tnsname) to connect to

Database Options for type: pg
   db  - Database to connect to
   host  - Hostname to connect to

Database Options for type: sqlite
   dbfile  - Local file for database - Default: testDb

Examples:
   # Dump a table
   recs-fromdb --type sqlite --dbfile testDb --table recs

   # Run a select statement
   recs-fromdb --dbfile testDb --sql 'SELECT * FROM recs WHERE id > 9'

SEE ALSO

• See App::RecordStream for an overview of the scripts and the system

• Run recs examples or see App::RecordStream::Manual::Examples for a set of simple recs examples

• Run recs story or see App::RecordStream::Manual::Story for a humorous introduction to RecordStream

• Every command has a --help mode available to print out usage and examples for the particular command, just like the output above.