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.

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