Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
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>

home | help