DESCRIPTION
This module gives you simple access to a database. Currently select, delete, insert and update is supported.Version <= 1.0: All these functions will not be reported.
SYNOPSIS
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",
};
};
EXPORTED FUNCTIONS
db
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", };