Rex::Commands::DB - Online Linux Manual PageSection : 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,323 byte
man-Rex::Commands::DB.3pmBuild   :   2024-12-05, 20:55   :  
Visitor Screen   :   x
Visitor Counter ( page / site )   :   3 / 171,307
Visitor ID   :     :  
Visitor IP   :   18.118.24.176   :  
Visitor Provider   :   AMAZON-02   :  
Provider Position ( lat x lon )   :   39.962500 x -83.006100   :   x
Provider Accuracy Radius ( km )   :   1000   :  
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 - 24.12.05
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 johanes_gumabo@yahoo.co.id .
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_|249|Rex::Commands::DB.3pm|36/37|el══─{─══.|.el══─{─══. ds -- \|\(em\| )         (htmlprn|149|Rex::Commands::DB.3pm|36/37|.el══─{─══. ds --  —  |.el══─{─══. ds -- \|\(em\| )         (parse_manual_page_|249|Rex::Commands::DB.3pm|43|br══─}─══|'br══─}─══ )         (htmlprn|149|Rex::Commands::DB.3pm|43|'br══─}─══ |'br══─}─══ )