package DTA::Schema::Result::Clip;

# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE

use strict;
use warnings;

use Moose;
use MooseX::NonMoose;
use namespace::autoclean;
extends 'DBIx::Class::Core';

__PACKAGE__->load_components("InflateColumn::DateTime");

=head1 NAME

DTA::Schema::Result::Clip

=cut

__PACKAGE__->table("clip");

=head1 ACCESSORS

=head2 id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0
  sequence: 'clip_id_seq'

=head2 dirname

  data_type: 'text'
  is_nullable: 1

=head2 page

  data_type: 'integer'
  is_nullable: 1

=head2 name

  data_type: 'text'
  is_nullable: 1

=head2 xml

  data_type: 'text'
  is_nullable: 1

=head2 w

  data_type: 'integer'
  is_nullable: 1

=head2 h

  data_type: 'integer'
  is_nullable: 1

=head2 x1

  data_type: 'integer'
  is_nullable: 1

=head2 x2

  data_type: 'integer'
  is_nullable: 1

=head2 y1

  data_type: 'integer'
  is_nullable: 1

=head2 y2

  data_type: 'integer'
  is_nullable: 1

=head2 account

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

=head2 time

  data_type: 'timestamp'
  is_nullable: 1

=head2 tempname

  data_type: 'text'
  is_nullable: 1

=head2 userindent

  data_type: 'integer'
  is_nullable: 1

=cut

__PACKAGE__->add_columns(
  "id",
  {
    data_type         => "integer",
    is_auto_increment => 1,
    is_nullable       => 0,
    sequence          => "clip_id_seq",
  },
  "dirname",
  { data_type => "text", is_nullable => 1 },
  "page",
  { data_type => "integer", is_nullable => 1 },
  "name",
  { data_type => "text", is_nullable => 1 },
  "xml",
  { data_type => "text", is_nullable => 1 },
  "w",
  { data_type => "integer", is_nullable => 1 },
  "h",
  { data_type => "integer", is_nullable => 1 },
  "x1",
  { data_type => "integer", is_nullable => 1 },
  "x2",
  { data_type => "integer", is_nullable => 1 },
  "y1",
  { data_type => "integer", is_nullable => 1 },
  "y2",
  { data_type => "integer", is_nullable => 1 },
  "account",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  "time",
  { data_type => "timestamp", is_nullable => 1 },
  "tempname",
  { data_type => "text", is_nullable => 1 },
  "userindent",
  { data_type => "integer", is_nullable => 1 },
);
__PACKAGE__->set_primary_key("id");

=head1 RELATIONS

=head2 account

Type: belongs_to

Related object: L<DTA::Schema::Result::Account>

=cut

__PACKAGE__->belongs_to(
  "account",
  "DTA::Schema::Result::Account",
  { id => "account" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "CASCADE",
    on_update     => "CASCADE",
  },
);


# Created by DBIx::Class::Schema::Loader v0.07008 @ 2012-05-30 13:08:48
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:455KNq25IjyCOidBJhjEwg

use Image::Size 'html_imgsize';
sub size {
    my $self = shift;
    my $tempname = $self->get_column('tempname');
    return html_imgsize "/home/wiegand/mysource/git/DTAQ/var/doctool/$tempname.png";
}

# You can replace this text with custom code or comments, and it will be preserved on regeneration
__PACKAGE__->meta->make_immutable;
1;
