Add missing files

[?]
Feb 14, 2013, 10:53 AM
PHJF4FUTRWDFKS4RTYGT2PKASDZAPPA3JY3VF2YANHFI5AUTIZAQC

Dependencies

  • [2] D5QIOJGP * Move everything up one directory.

Change contents

  • file addition: BuildOutputs.pm (----------)
    [2.477]
    use utf8;
    package Hydra::Schema::BuildOutputs;
    # Created by DBIx::Class::Schema::Loader
    # DO NOT MODIFY THE FIRST PART OF THIS FILE
    =head1 NAME
    Hydra::Schema::BuildOutputs
    =cut
    use strict;
    use warnings;
    use base 'DBIx::Class::Core';
    =head1 TABLE: C<BuildOutputs>
    =cut
    __PACKAGE__->table("BuildOutputs");
    =head1 ACCESSORS
    =head2 build
    data_type: 'integer'
    is_foreign_key: 1
    is_nullable: 0
    =head2 name
    data_type: 'text'
    is_nullable: 0
    =head2 path
    data_type: 'text'
    is_nullable: 0
    =cut
    __PACKAGE__->add_columns(
    "build",
    { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
    "name",
    { data_type => "text", is_nullable => 0 },
    "path",
    { data_type => "text", is_nullable => 0 },
    );
    =head1 PRIMARY KEY
    =over 4
    =item * L</build>
    =item * L</name>
    =back
    =cut
    __PACKAGE__->set_primary_key("build", "name");
    =head1 RELATIONS
    =head2 build
    Type: belongs_to
    Related object: L<Hydra::Schema::Builds>
    =cut
    __PACKAGE__->belongs_to(
    "build",
    "Hydra::Schema::Builds",
    { id => "build" },
    { is_deferrable => 0, on_delete => "CASCADE", on_update => "NO ACTION" },
    );
    # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-01-30 16:22:11
    # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UpVoKdd3OwMvlvyMjcYNVA
    # You can replace this text with custom code or comments, and it will be preserved on regeneration
    1;
  • file addition: BuildStepOutputs.pm (----------)
    [2.477]
    use utf8;
    package Hydra::Schema::BuildStepOutputs;
    # Created by DBIx::Class::Schema::Loader
    # DO NOT MODIFY THE FIRST PART OF THIS FILE
    =head1 NAME
    Hydra::Schema::BuildStepOutputs
    =cut
    use strict;
    use warnings;
    use base 'DBIx::Class::Core';
    =head1 TABLE: C<BuildStepOutputs>
    =cut
    __PACKAGE__->table("BuildStepOutputs");
    =head1 ACCESSORS
    =head2 build
    data_type: 'integer'
    is_foreign_key: 1
    is_nullable: 0
    =head2 stepnr
    data_type: 'integer'
    is_foreign_key: 1
    is_nullable: 0
    =head2 name
    data_type: 'text'
    is_nullable: 0
    =head2 path
    data_type: 'text'
    is_nullable: 0
    =cut
    __PACKAGE__->add_columns(
    "build",
    { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
    "stepnr",
    { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
    "name",
    { data_type => "text", is_nullable => 0 },
    "path",
    { data_type => "text", is_nullable => 0 },
    );
    =head1 PRIMARY KEY
    =over 4
    =item * L</build>
    =item * L</stepnr>
    =item * L</name>
    =back
    =cut
    __PACKAGE__->set_primary_key("build", "stepnr", "name");
    =head1 RELATIONS
    =head2 build
    Type: belongs_to
    Related object: L<Hydra::Schema::Builds>
    =cut
    __PACKAGE__->belongs_to(
    "build",
    "Hydra::Schema::Builds",
    { id => "build" },
    { is_deferrable => 0, on_delete => "CASCADE", on_update => "NO ACTION" },
    );
    =head2 buildstep
    Type: belongs_to
    Related object: L<Hydra::Schema::BuildSteps>
    =cut
    __PACKAGE__->belongs_to(
    "buildstep",
    "Hydra::Schema::BuildSteps",
    { build => "build", stepnr => "stepnr" },
    { is_deferrable => 0, on_delete => "CASCADE", on_update => "NO ACTION" },
    );
    # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-01-30 16:22:11
    # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dC1yX7arRVu9K3wG9dAjCg
    # You can replace this text with custom code or comments, and it will be preserved on regeneration
    1;
  • file addition: upgrade-9.sql (----------)
    [2.3004]
    create table BuildOutputs (
    build integer not null,
    name text not null,
    path text not null,
    primary key (build, name),
    foreign key (build) references Builds(id) on delete cascade
    );
    insert into BuildOutputs (build, name, path)
    select id, 'out', outPath from Builds;
    alter table Builds drop column outPath;
    create table BuildStepOutputs (
    build integer not null,
    stepnr integer not null,
    name text not null,
    path text not null,
    primary key (build, stepnr, name),
    foreign key (build) references Builds(id) on delete cascade,
    foreign key (build, stepnr) references BuildSteps(build, stepnr) on delete cascade
    );
    insert into BuildStepOutputs (build, stepnr, name, path)
    select build, stepnr, 'out', outPath from BuildSteps where outPath is not null;
    drop index IndexBuildStepsOnBuild;
    drop index IndexBuildStepsOnOutpath;
    drop index IndexBuildStepsOnOutpathBuild;
    alter table BuildSteps drop column outPath;
    create index IndexBuildStepOutputsOnPath on BuildStepOutputs(path);