NAME

recs-fromdb

recs-fromdb --help-all

Must define --table or --sql

   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
   user  - User to connect as
   type  - Type of database to connect to - Default: sqlite

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

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

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

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

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

RecordStream(3) - Overview of the scripts and the system

recs-examples(3) - A set of simple recs examples

recs-story(3) - A humorous introduction to RecordStream

SCRIPT --help - every script has a --help option, like the output above