{pkgs}:

{ pkgs }:

[ perlPackages.CatalystDevel

[ perlPackages.CatalystAuthenticationStoreDBIxClass
  perlPackages.CatalystPluginAccessLog
  perlPackages.CatalystPluginAuthorizationRoles
  perlPackages.CatalystPluginSessionStateCookie

  perlPackages.CatalystPluginAuthorizationRoles
  perlPackages.CatalystPluginSessionStateCookie
  perlPackages.CatalystPluginAccessLog
  perlPackages.CatalystAuthenticationStoreDBIxClass
  perlPackages.CatalystViewTT

  perlPackages.CatalystViewTT

  perlPackages.XMLSimple
  perlPackages.IPCRun
  perlPackages.IOCompress
  perlPackages.Readonly

  perlPackages.CryptRandPasswd

  perlPackages.DataDump
  perlPackages.DateTime
  perlPackages.DigestSHA1

  perlPackages.TextTable
  perlPackages.TextDiff

  perlPackages.IOCompress
  perlPackages.IPCRun
  perlPackages.JSONXS

  perlPackages.DataDump
  perlPackages.JSONXS
  perlPackages.DateTime
  perlPackages.DigestSHA1
  perlPackages.CryptRandPasswd
  perlPackages.TestMore
  perlPackages.SysHostnameLong

  perlPackages.CatalystDevel
  perlPackages.Readonly
  perlPackages.SQLSplitStatement

  perlPackages.SysHostnameLong
  perlPackages.TestMore
  perlPackages.TextDiff
  perlPackages.TextTable
  perlPackages.XMLSimple

<!--

nix-env -Ai hydra -f /path/to/nixpkgs</screen>

nix-env -f /path/to/nixpkgs -iA hydra</screen>

-->

      Alternatively, the latest development snapshot can be installed

      The latest development snapshot of Hydra can be installed

      and use the one-click install available at one of the build

      and using the one-click install available at one of the build

hydra-build      hydra-evaluator     hydra-server
hydra-eval-jobs  hydra-queue-runner  hydra-update-gc-roots</screen>

hydra-build      hydra-init          hydra-update-gc-roots
hydra-eval-jobs  hydra-queue-runner  
hydra-evaluator  hydra-server
</screen>

      as database name and user name, issue the following commands:

      as database name and user name, issue the following commands on
      the PostgreSQL server:

createdb hydra
echo "CREATE USER hydra WITH PASSWORD '<your-password>' ;" | psql hydra
cat $prefix/share/hydra/sql/hydra-postgresql.sql | psql hydra
echo "GRANT ALL ON DATABASE hydra TO hydra;" | psql hydra</screen>

createuser -S -D -R -P hydra
createdb -O hydra hydra</screen>

      For SQLite, the following command is all it takes to create the
      database:

      Hydra uses an environment variable to know which database should
      be used, and a variable which point to a location that holds
      some state. To set these variables for a PostgreSQL database,
      add the following to the file <filename>~/.profile</filename> of
      the user running the Hydra services.

cat $prefix/share/hydra/sql/hydra-sqlite.sql | sqlite3 /path/to/hydra.sqlite</screen>

export HYDRA_DBI="dbi:Pg:dbname=hydra;host=dbserver.example.org;user=hydra;"
export HYDRA_DATA=/var/lib/hydra</screen>
      You can provide the username and password in the file
      <filename>~/.pgpass</filename>, e.g.
      <screen>
dbserver.example.org:*:hydra:hydra:password</screen>
      Make sure that the <emphasis>HYDRA_DATA</emphasis> directory
      exists and is writable for the user which will run the Hydra
      services.  For a SQLite database, the
      <varname>HYDRA_DBI</varname> should be set to something like
      <literal>dbi:SQLite:/path/to/hydra.sqlite</literal>

      Having set these environment variables, you can now initialise
      the database by doing:
      <screen>
hydra-init</screen>
    </para>
    <para>

    <para>
      Hydra uses an environment variable to know which database should
      be used, and a variable which point to a location that holds
      some state. To set these variables for a PostgreSQL database,
      add the following to the <filename>.profile</filename> of the
      user running the Hydra services.

  </section>
  <section>
    <title>Upgrading</title>

    <para>If you're upgrading Hydra from a previous version, you
    should do the following to perform any necessary database schema migrations:

export HYDRA_DBI="dbi:Pg:dbname=hydra;host=localhost;"
export HYDRA_DATA=/var/lib/hydra</screen> 

hydra-init</screen>
    </para>

      Make sure that the <emphasis>HYDRA_DATA</emphasis> directory
      exists and is writable for the user which will run the Hydra
      services.  For a SQLite database, the
      <varname>HYDRA_DBI</varname> should be set to something like
      <literal>dbi:SQLite:/path/to/hydra.sqlite</literal>
    </para>

    getHydraPath getHydraDBPath openHydraDB getHydraConf txn_do

    getHydraPath getHydraHome getHydraDBPath openHydraDB getHydraConf txn_do

sub getHydraHome {
    my $dir = $ENV{"HYDRA_HOME"} or die "The HYDRA_HOME directory does not exist!\n";
    return $dir;
}

#! /var/run/current-system/sw/bin/perl -w
use strict;
use Hydra::Schema;
use Hydra::Helper::Nix;
use File::Slurp;
use SQL::SplitStatement;
use List::Util qw(max);
my $db = openHydraDB;
my $dbh = $db->storage->dbh;
$dbh->{RaiseError} = 1;
my $home = getHydraHome;
my $sql_splitter = SQL::SplitStatement->new;
# Figure out the target schema version.
my $maxSchemaVersion = max (map { /.*\/upgrade-(\d.*)\.sql/; $1 } (glob "$home/sql/upgrade-[0-9]*.sql")) || 1;
# Check whether the database has been initialised.  If not, load the
# schema.
my @tables = $dbh->tables;
if (! grep { /SchemaVersion/i } @tables) {
    print STDERR "initialising the Hydra database schema...\n";
    my $schema = read_file(
	$dbh->{Driver}->{Name} eq 'SQLite' ? "$home/sql/hydra-sqlite.sql" :
	$dbh->{Driver}->{Name} eq 'Pg' ? "$home/sql/hydra-postgresql.sql" :
	die "unsupported database type\n");
    my @statements = $sql_splitter->split($schema);
    eval {
	$dbh->begin_work;
	$dbh->do($_) foreach @statements;
	$db->resultset('SchemaVersion')->create({version => $maxSchemaVersion});
	$dbh->commit;
    };
    die "schema initialisation failed: $@\n" if $@;
    exit 0;
}
# Get the current schema version.
my @versions = $db->resultset('SchemaVersion')->all;
die "couldn't get Hydra schema version!" if scalar @versions != 1;
my $schemaVersion = $versions[0]->version;
for (my $n = $schemaVersion; $n < $maxSchemaVersion; $n++) {
    my $m = $n + 1;
    print STDERR "upgrading Hydra schema from version $n to $m\n";
    my $schema = read_file("$home/sql/upgrade-$m.sql");
    my @statements = $sql_splitter->split($schema);
    eval {
	$dbh->begin_work;
	$dbh->do($_) foreach @statements;
	$db->resultset('SchemaVersion')->update({version => $m});
	$dbh->commit;
    };
    die "schema upgrade failed: $@\n" if $@;
}

sqldir = $(datadir)/hydra/sql

sqldir = $(libexecdir)/hydra/sql

insert into SchemaVersion (version) values (1);

	sqlite3 db.sqlite <  $(top_srcdir)/src/sql/hydra-sqlite.sql

	perl $(top_srcdir)/src/script/hydra-init