1use utf8; 2package App::Netdisco::DB::Result::Virtual::PortMacs; 3 4use strict; 5use warnings; 6 7use base 'DBIx::Class::Core'; 8 9__PACKAGE__->table_class('DBIx::Class::ResultSource::View'); 10 11__PACKAGE__->table("port_macs"); 12__PACKAGE__->result_source_instance->is_virtual(1); 13__PACKAGE__->result_source_instance->view_definition(<<ENDSQL 14 SELECT ip, mac FROM device where mac = any (?::macaddr[]) 15 UNION 16 SELECT ip, mac FROM device_port dp where mac = any (?::macaddr[]) 17ENDSQL 18); 19 20__PACKAGE__->add_columns( 21 'mac' => { data_type => 'macaddr' }, 22 'ip' => { data_type => 'inet' }, 23); 24 251; 26