Rex::Commands::DB - Simple Database Access
This module gives you simple access to a database. Currently select, delete, insert and update is supported.
use Rex::Commands::DB { dsn => "DBI:mysql:database=test;host=dbhost", user => "username", password => "password", }; task "list", sub { my @data = db select => { fields => "*", from => "table", where => "enabled=1", }; db insert => "table", { field1 => "value1", field2 => "value2", field3 => 5, }; db update => "table", { set => { field1 => "newvalue", field2 => "newvalue2", }, where => "id=5", }; db delete => "table", { where => "id < 5", }; };
Do a database action.
my @data = db select => { fields => "*", from => "table", where => "host='myhost'", }; db insert => "table", { field1 => "value1", field2 => "value2", field3 => 5, }; db update => "table", { set => { field1 => "newvalue", field2 => "newvalue2", }, where => "id=5", }; db delete => "table", { where => "id < 5", };
To install Rex, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Rex
CPAN shell
perl -MCPAN -e shell install Rex
For more information on module installation, please visit the detailed CPAN module installation guide.