grahamc/hydra2 - Change YTZOC7C5N3JI3AOFPLT2UM7567XIKPSCMFKSESB6J4LNVVW3DOCAC

* Editing of jobset inputs.

Created by Eelco Dolstra on November 17, 2008

YTZOC7C5N3JI3AOFPLT2UM7567XIKPSCMFKSESB6J4LNVVW3DOCAC

Dependencies

In channels

main

Change contents

Insertion in src/HydraFrontend/lib/HydraFrontend/Controller/Root.pm at line 90 [4.804]
[3.790]
[3.790]
```
        my $jobset;
```

Replacement in src/HydraFrontend/lib/HydraFrontend/Controller/Root.pm at line 94 [4.804]

B:BD[3.883] → [3.883:1024]

            my $jobset = $c->model('DB::Jobsets')->create(
                { project => $project->name
                , name => $jobsetName

[3.883]

[3.1024]

            $jobset = $project->jobsets->create(
                { name => $jobsetName

Replacement in src/HydraFrontend/lib/HydraFrontend/Controller/Root.pm at line 101 [4.804]

B:BD[3.1268] → [3.1268:1343]

            (my $jobset) = $project->jobsets->search({name => $baseName});

[3.1268]

[3.1343]

            $jobset = ($project->jobsets->search({name => $baseName}))[0];

Insertion in src/HydraFrontend/lib/HydraFrontend/Controller/Root.pm at line 108 [4.804]

[3.1639]

        }
        
        # Process the inputs of this jobset.
        foreach my $param (keys %{$c->request->params}) {
            next unless $param =~ /^jobset-$baseName-input-(\w+)-name$/;
            my $baseName2 = $1;
            next if $baseName2 eq "template";
            print STDERR "GOT INPUT: $baseName2\n";
            my $inputName = $c->request->params->{"jobset-$baseName-input-$baseName2-name"};
            die "Invalid input name: $inputName" unless $inputName =~ /^[[:alpha:]]\w*$/;
            my $inputType = $c->request->params->{"jobset-$baseName-input-$baseName2-type"};
            die "Invalid input type: $inputType" unless
                $inputType eq "svn" || $inputType eq "cvs" || $inputType eq "tarball" ||
                $inputType eq "string" || $inputType eq "path";
            my $input;
            if ($baseName2 =~ /^\d+$/) { # numeric base name is auto-generated, i.e. a new entry
            } else { # it's an existing jobset
                $input = ($jobset->jobsetinputs->search({name => $baseName2}))[0];
                die unless defined $input;
                $input->name($inputName);
                $input->type($inputType);
                $input->update;
            }
            # Update the values for this input.  Just delete all the
            # current ones, then create the new values.
            $input->jobsetinputalts->delete_all;
            my $values = $c->request->params->{"jobset-$baseName-input-$baseName2-values"};
            $values = [$values] unless ref($values) eq 'ARRAY';
            my $altnr = 0;
            foreach my $value (@{$values}) {
                print STDERR "VALUE: $value\n";
                $input->jobsetinputalts->create({altnr => $altnr++, value => $value});
            }

Replacement in src/HydraFrontend/lib/HydraFrontend/Schema/Buildinputs.pm at line 43 [5.1]

B:BD[5.782] → [6.99:241]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-13 00:41:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fClAPzHpXV7YT8eHUeU4zw

[5.782]

[5.924]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-17 12:36:40
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:wkxzzlIrlNAnzUlBQMkx/A

Replacement in src/HydraFrontend/lib/HydraFrontend/Schema/Buildlogs.pm at line 24 [4.3352]

B:BD[4.3992] → [6.242:384]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-13 00:41:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lW6yq7QOyzpa+zM/J/7VFQ

[4.3992]

[4.4134]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-17 12:36:40
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:q7krNxyxcF4PlLGT8dmkLQ

Replacement in src/HydraFrontend/lib/HydraFrontend/Schema/Buildproducts.pm at line 36 [4.4268]

B:BD[4.4922] → [6.385:527]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-13 00:41:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2qyh04FF7LrOgo+/Ixap2A

[4.4922]

[4.5064]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-17 12:36:40
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:60iPYEFvRtct6aHFChM8Eg

Replacement in src/HydraFrontend/lib/HydraFrontend/Schema/Buildresultinfo.pm at line 28 [7.1594]

B:BD[7.2382] → [6.528:670]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-13 00:41:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ko+bQKdwDzow15p/aTdgYw

[7.2382]

[7.2524]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-17 12:36:40
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:twJAkSC32lJGcGItKegomg

Replacement in src/HydraFrontend/lib/HydraFrontend/Schema/Builds.pm at line 82 [4.5202]

B:BD[4.6194] → [6.671:813]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-13 00:41:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9VXVDomeYpjysKc8NxWogw

[4.6194]

[7.3377]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-17 12:36:40
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kTvNLSNfUxIbzFQ82v+AHg

Replacement in src/HydraFrontend/lib/HydraFrontend/Schema/Buildschedulinginfo.pm at line 26 [7.3773]

B:BD[7.4473] → [6.814:956]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-13 00:41:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:v2j9A4bXqe96Qy1zz/C+VQ

[7.4473]

[7.4615]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-17 12:36:40
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:a9oTOE0Aw1nHAamSOf+AVw

Replacement in src/HydraFrontend/lib/HydraFrontend/Schema/Buildsteps.pm at line 38 [8.1675]

B:BD[8.2816] → [6.957:1099]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-13 00:41:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tCirOuLYfhBxoEkH5HAQlQ

[8.2816]

[8.2958]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-17 12:36:40
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8JPNCq31oRo9w3tQGPpwMw

Replacement in src/HydraFrontend/lib/HydraFrontend/Schema/Jobsetinputalts.pm at line 19 [9.825]
B:BD[9.1320] → [9.1320:1329]
```
  "uri",
```
[9.1320]
[9.1329]
```
  "value",
```
Deletion in src/HydraFrontend/lib/HydraFrontend/Schema/Jobsetinputalts.pm at line 24 [9.825]
B:BD[9.1475] → [9.1475:1546]
```
  { data_type => "text", is_nullable => 0, size => undef },
  "value",
```

Replacement in src/HydraFrontend/lib/HydraFrontend/Schema/Jobsetinputalts.pm at line 34 [9.825]

B:BD[9.1831] → [6.1100:1242]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-13 00:41:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GgHinSVpD7x20xFqfvau0Q

[9.1831]

[9.1973]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-17 12:36:40
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EVQbKQiSBV7xXLVym+lUxQ

Replacement in src/HydraFrontend/lib/HydraFrontend/Schema/Jobsetinputs.pm at line 46 [10.590]

B:BD[10.1681] → [6.1243:1385]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-13 00:41:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:F9AunJfDCrzuCOBHjNaurw

[10.1681]

[10.1823]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-17 12:36:40
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DcDEOgQY24GPqdhDlleLsQ

Replacement in src/HydraFrontend/lib/HydraFrontend/Schema/Jobsets.pm at line 51 [10.1960]

B:BD[10.2992] → [6.1386:1528]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-13 00:41:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oQnTi5ALlqDF0gP9P/hTeg

[10.2992]

[10.3134]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-17 12:36:40
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nsVTqxR1wQaamEpy5nNOTQ

Replacement in src/HydraFrontend/lib/HydraFrontend/Schema/Projects.pm at line 31 [10.3266]

B:BD[10.3685] → [6.1688:1830]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-13 00:41:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:z7XJulBG7643ilgAj1hDwg

[10.3685]

[10.3827]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-17 12:36:40
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TNoQBA0pY/OwfunCJ+/9Gw

Replacement in src/HydraFrontend/lib/HydraFrontend/Schema.pm at line 11 [4.6376]

B:BD[4.6498] → [6.1831:1973]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-13 00:41:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UDG/z2SeOSq/K7iVpzF0mw

[4.6498]

[4.6640]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-11-17 12:36:40
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KEl9aBHuDTOb+pkc2Wde0A

Replacement in src/HydraFrontend/root/hydra.css at line 1 [4.8691]
B:BD[4.8691] → [4.8692:8699]
```
body
{
```
[4.8691]
[4.8699]
```
body {
```
Insertion in src/HydraFrontend/root/hydra.css at line 363 [4.8691]
[11.2755]
```
input.shortString {
    width: 10em;
}
```

Replacement in src/HydraFrontend/root/project.tt at line 7 [12.1667]

B:BD[11.3099] → [3.2027:2134]

    <input type="text" class="string" [% HTML.attributes(id => param, name => param, value => value) %] />

[11.3099]

[11.3193]

    <input type="text" class="string [% extraClass %]" [% HTML.attributes(id => param, name => param, value => value) %] />

Insertion in src/HydraFrontend/root/project.tt at line 10 [12.1667]

[11.3235]

  [% END %]
[% END %]
[% BLOCK renderInputType %]
  [% SWITCH type %]
    [% CASE "svn" %]Subversion checkout
    [% CASE "cvs" %]CVS checkout
    [% CASE "tarball" %]Download of a tarball
    [% CASE "string" %]String value
    [% CASE "path" %]Local path

Insertion in src/HydraFrontend/root/project.tt at line 22 [12.1667]

[11.3247]

[% END %]
[% BLOCK renderInputTypeOption %]
  <option value="[% type %]" [% IF value == type %]selected="selected"[%END %]>[% INCLUDE renderInputType %]</option>

Replacement in src/HydraFrontend/root/project.tt at line 52 [12.1667]

B:BD[3.2443] → [3.2443:2672]

        <tt>[% INCLUDE maybeEditString param="jobset-$baseName-nixexprpath" value=jobset.nixexprpath %]</tt> in input
        <tt>[% INCLUDE maybeEditString param="jobset-$baseName-nixexprinput" value=jobset.nixexprinput %]</tt>

[3.2443]

[3.2672]

        <tt>[% INCLUDE maybeEditString param="jobset-$baseName-nixexprpath" value=jobset.nixexprpath extraClass="shortString" %]</tt> in input
        <tt>[% INCLUDE maybeEditString param="jobset-$baseName-nixexprinput" value=jobset.nixexprinput extraClass="shortString" %]</tt>

Replacement in src/HydraFrontend/root/project.tt at line 67 [12.1667]

B:BD[12.2230] → [11.4402:4496]

          <td><tt>[% INCLUDE maybeEditString value=input.name %]</tt></td>
          <td><tt>

[12.2230]

[11.4496]

          <td><tt>[% INCLUDE maybeEditString param="jobset-$baseName-input-$input.name-name" value=input.name extraClass="shortString" %]</tt></td>
          <td>

Replacement in src/HydraFrontend/root/project.tt at line 70 [12.1667]

B:BD[11.4522] → [11.4522:4734]

              <select>
                <option>svn</option>
                <option>cvs</option>
                <option>uri</option>
                <option>string</option>
                <option>path</option>

[11.4522]

[11.4734]

              <select name="[% "jobset-$baseName-input-$input.name-type" %]">
                [% INCLUDE renderInputTypeOption value=input.type type="svn" %]
                [% INCLUDE renderInputTypeOption value=input.type type="cvs" %]
                [% INCLUDE renderInputTypeOption value=input.type type="tarball" %]
                [% INCLUDE renderInputTypeOption value=input.type type="string" %]
                [% INCLUDE renderInputTypeOption value=input.type type="path" %]

Replacement in src/HydraFrontend/root/project.tt at line 78 [12.1667]
B:BD[11.4781] → [11.4781:4812]
```
              [% input.type %]
```
[11.4781]
[11.4812]
```
              [% INCLUDE renderInputType type=input.type %]
```
Replacement in src/HydraFrontend/root/project.tt at line 80 [12.1667]
B:BD[11.4834] → [11.4834:4855]
```
          </tt></td>
```
[11.4834]
[12.2320]
```
          </td>
```

Replacement in src/HydraFrontend/root/project.tt at line 83 [12.1667]

B:BD[12.2391] → [12.2391:2437]

B:BD[12.2437] → [11.4856:5134]

∅:D[11.5134] → [12.2480:2505]

B:BD[12.2480] → [12.2480:2505]

B:BD[12.2505] → [11.5135:5204]

∅:D[11.5204] → [12.2544:2568]

B:BD[12.2544] → [12.2544:2568]

              [% IF input.type == "string" %]
                <tt>
                  [% IF edit %]
                    <input type='text' class='string' value='[% alt.value %]' />
                    <br />
                  [% ELSE %]
                    "[% alt.value %]"
                  [% END %]
                </tt>
              [% ELSE %]
                <tt>[% INCLUDE maybeEditString value=alt.uri %]</tt>
              [% END %]

[12.2391]

[12.2568]

              <tt>
                [% IF input.type == "string" && !edit %]
                  "[% HTML.escape(alt.value) %]"
                [% ELSE %]
                  [% INCLUDE maybeEditString param="jobset-$baseName-input-$input.name-values" value=alt.value %]
                [% END %]
              </tt>

Replacement in src/HydraFrontend/root/project.tt at line 154 [12.1667]

B:BD[3.4143] → [2.400:505]

        $("#jobset-template-name", $("#" + newid)).attr("name", newid + "-name").attr("value", "trunk");

[3.4143]

[3.4246]

        $("#jobset-template-name", $("#" + newid)).attr("name", newid + "-name");

Replacement in src/hydra.sql at line 141 [13.1]
B:BD[13.1122] → [13.1122:1148]
```
  before delete on builds
```
[13.1122]
[13.1148]
```
  before delete on Builds
```
Replacement in src/hydra.sql at line 184 [13.1]
B:BD[2.921] → [2.921:949]
```
  update of name on jobsets
```
[2.921]
[2.949]
```
  update of name on Jobsets
```

Replacement in src/hydra.sql at line 186 [13.1]

B:BD[2.970] → [2.970:1180]

    update JobsetInputs set jobset = new.name where jobset = old.name;
    update JobsetInputAlts set jobset = new.name where jobset = old.name;
    update Builds set jobset = new.name where jobset = old.name;

[2.970]

[2.1180]

    update JobsetInputs set jobset = new.name where project = old.project and jobset = old.name;
    update JobsetInputAlts set jobset = new.name where project = old.project and jobset = old.name;
    update Builds set jobset = new.name where project = old.project and jobset = old.name;

Insertion in src/hydra.sql at line 202 [13.1]

[9.4168]

[7.11196]

create trigger cascadeJobsetInputUpdate
  update of name on JobsetInputs
  for each row begin
    update JobsetInputAlts set input = new.name where project = old.project and jobset = old.jobset and input = old.name;
  end;
create trigger cascadeJobsetInputDelete
  before delete on JobsetInputs
  for each row begin
    delete from JobsetInputAlts where project = old.project and jobset = old.jobset and input = old.name;
  end;

Replacement in src/hydra.sql at line 220 [13.1]
B:BD[9.4298] → [9.4298:4325]
```
    altnr         integer,
```
[9.4298]
[9.4325]
```
    altnr         integer not null,
```

Replacement in src/hydra.sql at line 223 [13.1]

∅:D[9.4338] → [10.5399:5423]

B:BD[10.5399] → [10.5399:5423]

    uri           text,

[9.4338]

[9.4339]

    value         text, -- for most types, a URI; for 'path', an absolute path; for 'string', an arbitrary value

Deletion in src/hydra.sql at line 226 [13.1]
B:BD[9.4432] → [9.4432:4480]
```
    value         text, -- for type == 'string'
```

Replacement in src/test.sql at line 4 [10.10197]

B:BD[9.7909] → [9.7909:8051]

insert into jobSetInputAlts(project, jobset, input, altnr, uri) values('patchelf', 'trunk', 'patchelfSrc', 0, '/home/eelco/Dev/patchelf-wc');

[9.7909]

[9.8051]

insert into jobSetInputAlts(project, jobset, input, altnr, value) values('patchelf', 'trunk', 'patchelfSrc', 0, '/home/eelco/Dev/patchelf-wc');

Replacement in src/test.sql at line 6 [10.10197]

B:BD[9.8153] → [9.8153:8290]

insert into jobSetInputAlts(project, jobset, input, altnr, uri) values('patchelf', 'trunk', 'nixpkgs', 0, '/home/eelco/Dev/nixpkgs-wc');

[9.8153]

[9.8290]

insert into jobSetInputAlts(project, jobset, input, altnr, value) values('patchelf', 'trunk', 'nixpkgs', 0, '/home/eelco/Dev/nixpkgs-wc');

Replacement in src/test.sql at line 8 [10.10197]

B:BD[9.8392] → [9.8392:8526]

insert into jobSetInputAlts(project, jobset, input, altnr, uri) values('patchelf', 'trunk', 'release', 0, '/home/eelco/Dev/release');

[9.8392]

[9.8526]

insert into jobSetInputAlts(project, jobset, input, altnr, value) values('patchelf', 'trunk', 'release', 0, '/home/eelco/Dev/release');