recs-fromdb
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 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: 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'
To install App::RecordStream, copy and paste the appropriate command in to your terminal.
cpanm
cpanm App::RecordStream
CPAN shell
perl -MCPAN -e shell install App::RecordStream
For more information on module installation, please visit the detailed CPAN module installation guide.