1use utf8; 2package App::Netdisco::DB::Result::Virtual::ActiveNodeWithAge; 3 4use strict; 5use warnings; 6 7use base 'App::Netdisco::DB::Result::Virtual::ActiveNode'; 8 9__PACKAGE__->load_components('Helper::Row::SubClass'); 10__PACKAGE__->subclass; 11 12__PACKAGE__->table_class('DBIx::Class::ResultSource::View'); 13__PACKAGE__->table("active_node_with_age"); 14__PACKAGE__->result_source_instance->is_virtual(1); 15__PACKAGE__->result_source_instance->view_definition(q{ 16 SELECT *, 17 replace( date_trunc( 'minute', age( now(), time_last + interval '30 second' ) ) ::text, 'mon', 'month') 18 AS time_last_age 19 FROM node WHERE active 20}); 21 22__PACKAGE__->add_columns( 23 "time_last_age", 24 { data_type => "text", is_nullable => 1 }, 25); 26 271; 28