NAME
   Xymon::DB::Schema - Group of Schemas for Xymon

SYNOPSIS
     use Xymon::DB::Schema;

DESCRIPTION
   Load DBIx::Class table classes for Xymon Database application.

USAGE
           use Xymon::DB::Schema;

           my $db = Xymon::DB::Schema->connect(
                           "DBI:Sybase:server=testsql2005;database=Hobbit", "hobbit", "hobpass",
                           {PrintError => 0}
                           );

           if($db) {

                   my $hosts = $db->resultset('host')->search(
                           {
                                   hobbit => 1,
                                   recordstatus => 'Complete',
                           },
                           {
                                   'join'  => 'LuLocation',
                                   '+select' => 'LuLocation.region',
                                   '+as' => 'region',
                                    order_by => 'hostname ASC'
                           },
                   )->hashref_pk;
           } else {
           die "Unable for connect to server $DBI::errstr";
           }

           print $hosts->{$hostname}->{location} . "\n";

   See DBIx::Class for more details on queries.

BUGS
SUPPORT
AUTHOR
       David Peters
       CPAN ID: DAVIDP
       [email protected]
       http://www.electronf.com

COPYRIGHT
   This program is free software; you can redistribute it and/or modify it
   under the same terms as Perl itself.

   The full text of the license can be found in the LICENSE file included
   with this module.

SEE ALSO
   DBIx::Class, perl(1).

You are viewing proxied material from ftp.icm.edu.pl. The copyright of proxied material belongs to its original authors. Any comments or complaints in relation to proxied material should be directed to the original authors of the content concerned. Please see the disclaimer for more details.