Revert "Remove now-unused SystemTypes table"

[?]

Mar 5, 2013, 4:42 PM

4HPT4SDDNU24OX2P4FDP2KXKINDCJLZEBN2VIEEKWFEVT4TNWXZAC

Dependencies

[2] JD7AWXQG Remove now-unused SystemTypes table
[3] 5SMQ2PLK Fix tests
[4] D6EL7KR6 Fix broken test
[5] 2NGV7NYN Drop unused "tag" column
[6] G2T4WAHI Store the inputs of each evaluation in the database
[7] AK66K4KY Fix the test
[8] H7HGWODE * Remove an empty file.
[9] RJNMYHJF Add missing file
[10] FV2M6MOT hydra: use autoconf/-make
[11] E7FID72S Remove the BuildMachines and BuildMachinesSystemTypes tables
[12] KN3VYE5P * Cleaned up the foreign key constraints.
[13] RXVJFQ5A Evaluator cleanups
[14] D5QIOJGP * Move everything up one directory.
[15] G2ZB6464 first test, not yet in buildprocess
[16] 2JGYLIEC Speed up the listing of jobset evals by caching some info in the DB
[17] KJQWSRCC Speed up hydra-update-gc-roots
[18] P43FHUUV there are 43 tests
[19] YDW2NUIW Fix "make check"
[20] PHJF4FUT Add missing files
[21] PCKLFRT5 Support push notification of repository changes
[22] 3XM2QEGW Fix query-all-tables test count, there are more tables now
[23] MOX7XJ2E Merge the BuildSchedulingInfo table into the Builds table
[24] DES4PSRL add basic query tests for JobStatus/LatestSucceeded/ActiveJobs
[*] UUGBVEGY * Development notes.
[*] N22GPKYT * Put info about logs / build products in the DB.
[*] JTRG7RDQ add support for git as jobinput
[*] RU7AQO7U * Role-based access control. Only admins can create projects. Only

Change contents

edit in doc/dev-notes.txt at line 8

[26.411]

[26.579]

* Setting the maximum number of concurrent builds per system type:

$ sqlite3 hydra.sqlite "insert into SystemTypes(system, maxConcurrent) values('i686-linux', 3);"
file addition: SystemTypes.pm (----------)

[3.477]

use utf8;
package Hydra::Schema::SystemTypes;

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

=head1 NAME

Hydra::Schema::SystemTypes

=cut

use strict;
use warnings;

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

=head1 TABLE: C<SystemTypes>

=cut

__PACKAGE__->table("SystemTypes");

=head1 ACCESSORS

=head2 system

data_type: 'text'
is_nullable: 0

=head2 maxconcurrent

data_type: 'integer'
default_value: 2
is_nullable: 0

=cut

__PACKAGE__->add_columns(
"system",
{ data_type => "text", is_nullable => 0 },
"maxconcurrent",
{ data_type => "integer", default_value => 2, is_nullable => 0 },
);

=head1 PRIMARY KEY

=over 4

=item * L</system>

=back

=cut

__PACKAGE__->set_primary_key("system");

# Created by DBIx::Class::Schema::Loader v0.07014 @ 2011-12-05 14:15:43
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zg8db3Cbi0QOv+gLJqH8cQ

1;
file deletion: upgrade-12.sql (----------)

[3.3004]→[2.27:65](∅→∅),[2.65]→[2.1:1](∅→∅)

drop table SystemTypes;
edit in src/sql/hydra.sql at line 341

[28.6669]

[29.5737]

);

create table SystemTypes (
system text primary key not null,
maxConcurrent integer not null default 2
replacement in tests/query-all-tables.pl at line 10

[3.497]→[2.66:96](∅→∅)

use Test::Simple tests => 42;

[3.497]

[3.527]

use Test::Simple tests => 43;