Rex::Group::Lookup::DBI(3pm) | User Contributed Perl Documentation | Rex::Group::Lookup::DBI(3pm) |
Rex::Group::Lookup::DBI - read hostnames and groups from a DBI source
With this module you can define hostgroups out of an DBI source.
use Rex::Group::Lookup::DBI; groups_dbi "dsn", "user", "password", "SQL request";
With this function you can read groups from DBI source. Example:
groups_dbi( 'DBI:mysql:rex;host=db01', user => 'username', password => 'password', sql => "SELECT * FROM HOST", create_all_group => TRUE);
CREATE TABLE IF NOT EXISTS `HOST` ( `ID` int(11) NOT NULL, `GROUP` varchar(255) DEFAULT NULL, `HOST` varchar(255) NOT NULL, PRIMARY KEY (`ID`) );
INSERT INTO `HOST` (`ID`, `GROUP`, `HOST`) VALUES (1, 'db', 'db01'), (2, 'db', 'db02'), (3, 'was', 'was01'), (4, 'was', 'was02');
2023-03-06 | perl v5.36.0 |