, enableemail => trim($c->request->params->{enableemail}) eq "1" ? 1 : 0
        , emailoverride => trim($c->request->params->{emailoverride})

  { data_type => "integer", default_value => 1, is_nullable => 0, size => undef },
  "enableemail",

  "emailoverride",
  {
    data_type => "text",
    default_value => undef,
    is_nullable => 0,
    size => undef,
  },

# Created by DBIx::Class::Schema::Loader v0.04999_09 @ 2010-01-06 10:15:26
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:buO0P7XQexj6YEwEAsq3EQ
# These lines were loaded from '/home/rbvermaa/src/hydra/src/lib/Hydra/Schema/Jobsets.pm' found in @INC.
# They are now part of the custom portion of this file
# for you to hand-edit.  If you do not either delete
# this section or remove that file from @INC, this section
# will be repeated redundantly when you re-create this
# file again via Loader!
package Hydra::Schema::Jobsets;
# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE
use strict;
use warnings;
use base 'DBIx::Class';
__PACKAGE__->load_components("Core");
__PACKAGE__->table("Jobsets");
__PACKAGE__->add_columns(
  "name",
  {
    data_type => "text",
    default_value => undef,
    is_foreign_key => 1,
    is_nullable => 0,
    size => undef,
  },
  "project",
  {
    data_type => "text",
    default_value => undef,
    is_foreign_key => 1,
    is_nullable => 0,
    size => undef,
  },
  "description",
  {
    data_type => "text",
    default_value => undef,
    is_nullable => 1,
    size => undef,
  },
  "nixexprinput",
  {
    data_type => "text",
    default_value => undef,
    is_foreign_key => 1,
    is_nullable => 0,
    size => undef,
  },
  "nixexprpath",
  {
    data_type => "text",
    default_value => undef,
    is_nullable => 0,
    size => undef,
  },
  "errormsg",
  {
    data_type => "text",
    default_value => undef,
    is_nullable => 1,
    size => undef,
  },
  "errortime",
  {
    data_type => "integer",
    default_value => undef,
    is_nullable => 1,
    size => undef,
  },
  "lastcheckedtime",
  {
    data_type => "integer",
    default_value => undef,
    is_nullable => 1,
    size => undef,
  },
  "enabled",
  { data_type => "integer", default_value => 1, is_nullable => 0, size => undef },
);
__PACKAGE__->set_primary_key("project", "name");
__PACKAGE__->belongs_to("project", "Hydra::Schema::Projects", { name => "project" });
__PACKAGE__->belongs_to(
  "jobsetinput",
  "Hydra::Schema::JobsetInputs",
  { jobset => "name", name => "nixexprinput", project => "project" },
);
__PACKAGE__->has_many(
  "jobsetinputs",
  "Hydra::Schema::JobsetInputs",
  {
    "foreign.jobset"  => "self.name",
    "foreign.project" => "self.project",
  },
);
__PACKAGE__->has_many(
  "jobs",
  "Hydra::Schema::Jobs",
  {
    "foreign.jobset"  => "self.name",
    "foreign.project" => "self.project",
  },
);
__PACKAGE__->has_many(
  "builds",
  "Hydra::Schema::Builds",
  {
    "foreign.jobset"  => "self.name",
    "foreign.project" => "self.project",
  },
);
__PACKAGE__->has_many(
  "jobsetinputhashes",
  "Hydra::Schema::JobsetInputHashes",
  {
    "foreign.jobset"  => "self.name",
    "foreign.project" => "self.project",
  },
);

# You can replace this text with custom content, and it will be preserved on regeneration
1;
# End of lines loaded from '/home/rbvermaa/src/hydra/src/lib/Hydra/Schema/Jobsets.pm' 

    </td>
  </tr>
  <tr>
    <th>Enable email notification:</th>
    <td>
      [% INCLUDE renderSelection param="enableemail" curValue=jobset.enableemail options={"1" = "Yes", "0" = "No"} %]
    </td>
  </tr>
  <tr>
    <th>Email override:</th>
    <td>
      [% INCLUDE maybeEditString param="emailoverride" value=jobset.emailoverride %]

    return if !$build->maintainers;

    return if !($build->maintainers || $build->jobset->enableemail);

    if ($build->resultInfo->buildstatus == 0) {
        # Build succeeded.  Only send mail if the previous build for
        # the same platform failed.
        return; # TODO

    my $prevBuild;
    ($prevBuild) = $db->resultset('Builds')->search(
	{ project => $build->project->name
        , jobset => $build->jobset->name
        , job => $build->job->name
        , system => $build->system 
        , finished => 1
        , id => { '!=', $build->id } 
	}, { order_by => ["timestamp DESC"] }
        );
    if (defined $prevBuild && ($build->resultInfo->buildstatus == $prevBuild->resultInfo->buildstatus)) {
        return; 

    my $status =
        $build->resultInfo->buildstatus == 0 ? "SUCCEEDED" : "FAILED";

    my $status =  $build->resultInfo->buildstatus == 0 ? "SUCCEEDED" : "FAILED";
    my $statusMsg;
    if(defined $prevBuild) {
      my $prevStatus =  $prevBuild->resultInfo->buildstatus == 0 ? "SUCCEEDED" : "FAILED";
      $statusMsg = "changed from $prevStatus to $status";
    } else {
      $statusMsg = $status;
    }

        . "This is to let you know that Hydra build " . $build->id
        . " of job " . $jobName . " has $status.\n"

        . "This is to let you know that Hydra build" . $build->id
        . " of job " . $jobName . " has $statusMsg.\n"

    # stripping trailing spaces from lines
    $body =~ s/[\ ]+$//gm;

    my $to = (!$build->jobset->emailoverride eq "") ? $build->jobset->emailoverride : $build->maintainers;

            To      => $build->maintainers,

            To      => $to,

print STDERR $cmd;

    setJobsetError($jobset, $msg);

    if( !($msg eq "") ) {
      setJobsetError($jobset, $msg);
    }

            setJobsetError($jobset, $msg);

            if( !($msg eq "") ) {
              setJobsetError($jobset, $msg);
            }

    enableEmail   integer not null default 1,
    emailOverride text not null,