* Script for initialising the database.

Dependencies

• [2] AFTXA575 * $HYDRA_DATA environment variable.
• [3] J5UVLXOK * Start of a basic Catalyst web interface.
• [4] 2GK5DOU7 * Downloading closures.
• [5] US27ZTX5 * HydraFrontend -> Hydra.
• [6] JK2QWPH6
• [7] L2E6EVE2 * Merged the Build and Job tables.
• [8] CLXEECMF * Start putting build results in a database.
• [9] IK53RV4V
• [10] 7YBYT2LQ
• [11] X27GNHDV * Basic job info in the database.
• [12] N22GPKYT * Put info about logs / build products in the DB.
• [13] TQKGQ5R3
• [14] RU7AQO7U * Role-based access control. Only admins can create projects. Only

Change contents

• replacement in src/Hydra/lib/Hydra/Helper/Nix.pm at line 18
  [2.321]→[2.321:353](∅→∅)
  − my $dir = $ENV{HYDRA_DATA};
  [2.321]

  [2.353]
  + my $dir = $ENV{"HYDRA_DATA"};
• file addition: hydra_init.pl (---r------)
  [3.1560]
  + #!/var/run/current-system/sw/bin/perl -w

  +

  + use strict;

  + use Hydra::Helper::Nix;

  +

  + my $hydraHome = $ENV{"HYDRA_HOME"};

  + die "The HYDRA_HOME environment variable is not set!\n" unless defined $hydraHome;

  +

  + my $hydraData = $ENV{"HYDRA_DATA"};

  + mkdir $hydraData unless -d $hydraData;

  +

  + my $dbPath = getHydraPath . "/hydra.sqlite";

  +

  + system("sqlite3 $dbPath < $hydraHome/sql/hydra.sql") == 0

  + or warn "Cannot initialise database in $dbPath";
• file addition: sql (d--r------)
  [3.1]
• file move: hydra.sql (----------) → hydra.sql (----------)
  [0.509]

  [3.1]
• replacement in src/Hydra/sql/hydra.sql at line 158
  [3.14952]→[3.14952:14997](∅→∅)
  − enabled integer not null default 1
  [3.14952]

  [3.5423]
  + enabled integer not null default 1,