FreeBSD Manual Pages
Rex::Commands::DB(3) User Contributed Perl Documentation Rex::Commands::DB(3) 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.24.1 2016-07-16 Rex::Commands::DB(3)
NAME | DESCRIPTION | SYNOPSIS | EXPORTED FUNCTIONS
Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Rex::Commands::DB&sektion=3&manpath=FreeBSD+12.0-RELEASE+and+Ports>