SIMPLE SOLUTIONS

REX::COMMANDS::DB(3PM) - Linux man page online | Library functions

Simple Database Access.

Chapter
2018-02-01
Rex::Commands::DB(3pm) User Contributed Perl Documentation Rex::Commands::DB(3pm)

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", };
perl v5.26.1 2018-02-01 Rex::Commands::DB(3pm)
Download raw manual
Index User Contributed Perl Documentation (+23303) perl v5.26.1 (+10548) № 3 (+68044)
Go top