Remove the BuildMachines and BuildMachinesSystemTypes tables

[?]

Mar 4, 2013, 9:32 PM

E7FID72SS23PZ7RJ6DD65APXCRIYHTHT6SB24MKPLZZ7WM7NUB3QC

Dependencies

[2] 4MBKR4XM Gratuitous whitespace.
[3] PMNWRTGJ Add multiple output support
[4] 3XM2QEGW Fix query-all-tables test count, there are more tables now
[5] YDW2NUIW Fix "make check"
[6] NABL63FI * hydra: project members can do stuff that the owner can do
[7] 2M7J26V4 inital version of links to diff in scm
[8] KXGOUX7P * Creating releases.
[9] RBNQKATL * Adding persistant releases. A release is a named set of builds.
[10] FD76WVTQ missing file
[11] PP4LPADG hydra: buildmachine disabled by default, add some default constraints
[12] DHMTPGST * Ran update-dbix.
[13] MOX7XJ2E Merge the BuildSchedulingInfo table into the Builds table
[14] 5SMQ2PLK Fix tests
[15] S5PV6IIM * Represent jobs explicitly in the DB.
[16] G2T4WAHI Store the inputs of each evaluation in the database
[17] Y6AHH4TH Remove the logfile and logSize columns from the database
[18] P5X4P6VK * Renaming "release sets" to "views" (not finished yet). Having
[19] 5O6E5SU5 hydra: store logfile/output path/closure size
[20] ZWCTAZGL added newsitems, added some admin options to clear various caches.
[21] PHJF4FUT Add missing files
[22] JJT5QG3K remove revision from cached cvs inputs, and added missing files
[23] DES4PSRL add basic query tests for JobStatus/LatestSucceeded/ActiveJobs
[24] SB2V735V Keep track of the database schema version
[25] 7Z7HOZQ3 * Remove the triggers to simulate foreign key constraints on SQLite,
[26] QQ4STW3S missing file
[27] D6EL7KR6 Fix broken test
[28] D5QIOJGP * Move everything up one directory.
[29] SMCOU72F hydra: add some admin for adding/enabling/etc build machines
[30] P43FHUUV there are 43 tests
[31] 5SHCWE7X * Prevent repeated evaluation of a jobset with the same inputs. This
[32] G2ZB6464 first test, not yet in buildprocess
[33] AK66K4KY Fix the test
[34] T2232OBS * Add some DB indices to make the /releases page much faster.
[35] RFE6T5LG * Store jobset evaluations in the database explicitly. This includes
[36] HPEG2RHV Merge the BuildResultInfo table into the Builds table
[*] N22GPKYT * Put info about logs / build products in the DB.

Change contents

file deletion: BuildMachineSystemTypes.pm (----------)

[5.477]→[5.7079:7129](∅→∅),[5.7129]→[5.5756:5756](∅→∅)

package Hydra::Schema::BuildMachineSystemTypes;

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

use strict;
use warnings;

use base 'DBIx::Class::Core';

=head1 TABLE: C<BuildMachineSystemTypes>

=cut

__PACKAGE__->table("BuildMachineSystemTypes");

=head1 ACCESSORS

=head2 hostname

data_type: 'text'
is_foreign_key: 1
is_nullable: 0

=head2 system

data_type: 'text'
is_nullable: 0

=cut

__PACKAGE__->add_columns(
"hostname",
{ data_type => "text", is_foreign_key => 1, is_nullable => 0 },
"system",
{ data_type => "text", is_nullable => 0 },
);
__PACKAGE__->set_primary_key("hostname", "system");

=head1 RELATIONS

=head2 hostname

Type: belongs_to

Related object: L<Hydra::Schema::BuildMachines>

=cut

__PACKAGE__->belongs_to(
"hostname",
"Hydra::Schema::BuildMachines",
{ hostname => "hostname" },
);

# You can replace this text with custom content, and it will be preserved on regeneration
1;
# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-01-22 13:29:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:im3sfvrv5YY3i1IAOozeiA
{ is_deferrable => 0, on_delete => "CASCADE", on_update => "NO ACTION" },

=head1 PRIMARY KEY

=over 4

=item * L</hostname>

=item * L</system>

=back

=cut

Hydra::Schema::BuildMachineSystemTypes

=cut

=head1 NAME
use utf8;
file deletion: BuildMachines.pm (----------)

[5.477]→[5.9410:9450](∅→∅),[5.9450]→[5.7131:7131](∅→∅)

package Hydra::Schema::BuildMachines;

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

use strict;
use warnings;

use base 'DBIx::Class::Core';

=cut

__PACKAGE__->table("BuildMachines");

=head1 ACCESSORS

=head2 hostname

data_type: 'text'
is_nullable: 0

=head2 username

data_type: 'text'
default_value: (empty string)
is_nullable: 0

=head2 ssh_key

data_type: 'text'
default_value: (empty string)
is_nullable: 0

=head2 options

data_type: 'text'
default_value: (empty string)
is_nullable: 0

=head2 maxconcurrent

data_type: 'integer'
default_value: 2
is_nullable: 0

=head2 speedfactor

data_type: 'integer'
default_value: 1
is_nullable: 0

=head2 enabled

data_type: 'integer'
default_value: 0
is_nullable: 0

=cut

__PACKAGE__->add_columns(
"hostname",
{ data_type => "text", is_nullable => 0 },
"username",
{ data_type => "text", default_value => "", is_nullable => 0 },
"ssh_key",
{ data_type => "text", default_value => "", is_nullable => 0 },
"options",
{ data_type => "text", default_value => "", is_nullable => 0 },
"maxconcurrent",
{ data_type => "integer", default_value => 2, is_nullable => 0 },
"speedfactor",
{ data_type => "integer", default_value => 1, is_nullable => 0 },
"enabled",
{ data_type => "integer", default_value => 0, is_nullable => 0 },
);
__PACKAGE__->set_primary_key("hostname");

=head1 RELATIONS

=head2 buildmachinesystemtypes

Type: has_many

Related object: L<Hydra::Schema::BuildMachineSystemTypes>

=cut

__PACKAGE__->has_many(
"buildmachinesystemtypes",
"Hydra::Schema::BuildMachineSystemTypes",
{ "foreign.hostname" => "self.hostname" },
);

# You can replace this text with custom content, and it will be preserved on regeneration
1;
# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-01-22 13:29:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OST5IMcvHKsXlNMCRazXhg
undef,

=head1 PRIMARY KEY

=over 4

=item * L</hostname>

=back

=cut

=head1 TABLE: C<BuildMachines>

=head1 NAME

Hydra::Schema::BuildMachines

=cut
use utf8;
edit in src/sql/hydra.sql at line 514

[5.12398]→[5.12398:12399](∅→∅)
edit in src/sql/hydra.sql at line 515

[2.5]→[5.12399:12428](∅→∅),[5.12399]→[5.12399:12428](∅→∅),[5.12428]→[3.20347:20631](∅→∅),[5.279]→[5.864:867](∅→∅),[5.11975]→[5.864:867](∅→∅),[5.12679]→[5.864:867](∅→∅),[3.20631]→[5.864:867](∅→∅),[5.864]→[5.864:867](∅→∅)

create table BuildMachines (
hostname text primary key not null,
username text default '' not null,
ssh_key text default '' not null,
options text default '' not null,
maxconcurrent integer default 2 not null,
speedfactor integer default 1 not null,
enabled integer default 0 not null
);
edit in src/sql/hydra.sql at line 516

[5.5025]→[2.6:7](∅→∅),[2.7]→[5.12680:12892](∅→∅),[5.5025]→[5.12680:12892](∅→∅),[5.12892]→[5.2:3](∅→∅),[5.5025]→[5.2:3](∅→∅),[5.3]→[2.8:9](∅→∅)

create table BuildMachineSystemTypes (
hostname text NOT NULL,
system text NOT NULL,
primary key (hostname, system),
foreign key (hostname) references BuildMachines(hostname) on delete cascade
);
file addition: upgrade-11.sql (----------)

[5.3004]

drop table BuildMachineSystemTypes;
drop table BuildMachines;
replacement in tests/query-all-tables.pl at line 10

[5.497]→[4.0:30](∅→∅)

use Test::Simple tests => 45;

[5.497]

[5.527]

use Test::Simple tests => 43;