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.