Rex::Commands::DB - Online Linux Manual Page

Section : 3
Updated : 2021-03-06
Source : perl v5.32.1
Note : User Contributed Perl Documentation

NAMERex::Commands::DB − Simple Database Access

DESCRIPTIONThis 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

dbDo 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", ​ };
0
Johanes Gumabo
Data Size   :   7,565 byte
man-Rex::Commands::DB.3pmBuild   :   2025-03-22, 13:26   :  
Visitor Screen   :   x
Visitor Counter ( page / site )   :   27 / 2,329,281
Visitor ID   :     :  
Visitor IP   :   216.73.216.66   :  
Visitor Provider   :   AMAZON-02   :  
Provider Position ( lat x lon )   :   39.962500 x -83.006100   :   x
Provider Accuracy Radius ( km )   :   20   :  
Provider City   :   Columbus   :  
Provider Province   :   Ohio ,   :   ,
Provider Country   :   United States   :  
Provider Continent   :   North America   :  
Visitor Recorder   :   Version   :  
Visitor Recorder   :   Library   :  
Online Linux Manual Page   :   Version   :   Online Linux Manual Page - Fedora.40 - march=x86-64 - mtune=generic - 25.03.22
Online Linux Manual Page   :   Library   :   lib_c - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Online Linux Manual Page   :   Library   :   lib_m - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Data Base   :   Version   :   Online Linux Manual Page Database - 24.04.13 - march=x86-64 - mtune=generic - fedora-38
Data Base   :   Library   :   lib_c - 23.02.07 - march=x86-64 - mtune=generic - fedora.36


Very long time ago, I have the best tutor, Wenzel Svojanovsky. If someone knows the email address of Wenzel Svojanovsky, please send an email to johanesgumabo@gmail.com.
Help me, linux0001.com will expire on July 16, 2025. I have no money to renew it. View detail

If error, please print screen and send to johanes_gumabo@yahoo.co.id
Under development. Support me via PayPal.

ERROR : Need New Coding :         (parse_manual_page_|254|Rex::Commands::DB.3pm|36/37|el══─{─══.|.el══─{─══. ds -- \|\(em\| )         (htmlprn|160|Rex::Commands::DB.3pm|36/37|.el══─{─══. ds --  —  |.el══─{─══. ds -- \|\(em\| )         (parse_manual_page_|254|Rex::Commands::DB.3pm|43|br══─}─══|'br══─}─══ )         (htmlprn|160|Rex::Commands::DB.3pm|43|'br══─}─══ |'br══─}─══ )