File: TrackNumberFives.pm

package info (click to toggle)
libdbix-class-perl 0.082810-2
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 6,012 kB
  • ctags: 2,157
  • sloc: perl: 26,390; sql: 322; makefile: 10
file content (26 lines) | stat: -rw-r--r-- 744 bytes parent folder | download | duplicates (6)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
package    # hide from PAUSE
    ViewDeps::Result::TrackNumberFives;

use strict;
use warnings;
use base 'ViewDeps::Result::Track';

__PACKAGE__->table_class('DBIx::Class::ResultSource::View');
__PACKAGE__->table('track_number_fives');
__PACKAGE__->result_source_instance->view_definition(
    "SELECT id,title,cd,track_number FROM track WHERE track_number = '5'");

__PACKAGE__->add_columns(
    id           => { data_type => 'integer', is_auto_increment => 1 },
    title        => { data_type => 'text' },
    cd           => { data_type => 'integer' },
    track_number => { data_type => 'integer' },
);

__PACKAGE__->set_primary_key('id');

__PACKAGE__->belongs_to( 'cd', 'ViewDeps::Result::CD',
    { "foreign.id" => "self.cd" },
);

1;