1use utf8; 2package App::Netdisco::DB::Result::Topology; 3 4use strict; 5use warnings; 6 7use base 'App::Netdisco::DB::Result'; 8 9__PACKAGE__->table("topology"); 10 11__PACKAGE__->add_columns( 12 "dev1", 13 { data_type => "inet", is_nullable => 0 }, 14 "port1", 15 { data_type => "text", is_nullable => 0 }, 16 "dev2", 17 { data_type => "inet", is_nullable => 0 }, 18 "port2", 19 { data_type => "text", is_nullable => 0 }, 20); 21 22__PACKAGE__->add_unique_constraint(['dev1','port1']); 23__PACKAGE__->add_unique_constraint(['dev2','port2']); 24 25__PACKAGE__->belongs_to( 26 device1 => 'App::Netdisco::DB::Result::Device', 27 {'foreign.ip' => 'self.dev1'} 28); 29 30__PACKAGE__->belongs_to( 31 device2 => 'App::Netdisco::DB::Result::Device', 32 {'foreign.ip' => 'self.dev2'} 33); 34 351; 36