NAME

Rex::Commands::DB - Simple Database Access

DESCRIPTION

This module gives you simple access to a database. Currently select, delete, insert and update is supported.

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",
           };