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
davidp@electronf.com
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).