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