# Populate the DB
# Copyright (C) 2000, 2001 James Troup <james@nocrew.org>
-# $Id: neve,v 1.5 2001-09-14 17:15:39 troup Exp $
+# $Id: neve,v 1.7 2001-11-18 19:57:58 rmurray Exp $
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
projectB.query("DELETE FROM suite")
for suite in Cnf.SubTree("Suite").List():
SubSec = Cnf.SubTree("Suite::%s" %(suite))
- projectB.query("INSERT INTO suite (suite_name, version, origin, description) VALUES ('%s', '%s', '%s', '%s')"
- % (string.lower(suite), SubSec["Version"], SubSec["Origin"], SubSec["Description"]))
+ projectB.query("INSERT INTO suite (suite_name) VALUES ('%s')" % string.lower(suite));
+ for i in ("Version", "Origin", "Description"):
+ if SubSec.has_key(i):
+ projectB.query("UPDATE suite SET %s = '%s' WHERE suite_name = '%s'" % (string.lower(i), SubSec[i], string.lower(suite)))
for architecture in Cnf.SubTree("Suite::%s::Architectures" % (suite)).List():
architecture_id = db_access.get_architecture_id (architecture);
projectB.query("INSERT INTO suite_architectures (suite, architecture) VALUES (currval('suite_id_seq'), %d)" % (architecture_id));
if suite == 'stable':
testing_id = db_access.get_suite_id("testing");
try:
- file = utils.open_file (filename, "r")
+ file = utils.open_file (filename);
except utils.cant_open_exc:
print "WARNING: can't open '%s'" % (filename);
return;
if suite == "stable":
testing_id = db_access.get_suite_id("testing");
try:
- file = utils.open_file (filename, "r")
+ file = utils.open_file (filename);
except utils.cant_open_exc:
print "WARNING: can't open '%s'" % (filename);
return;
def main ():
global Cnf, projectB, query_cache, files_query_cache, source_query_cache, src_associations_query_cache, dsc_files_query_cache, bin_associations_query_cache, binaries_query_cache;
- apt_pkg.init();
-
- Cnf = apt_pkg.newConfiguration();
- apt_pkg.ReadConfigFileISC(Cnf,utils.which_conf_file());
+ Cnf = utils.get_conf()
print "Re-Creating DB..."
(result, output) = commands.getstatusoutput("psql -f init_pool.sql")
if (result != 0):
- sys.exit(2)
+ utils.fubar("psql invocation failed!\n", result);
print output
projectB = pg.connect(Cnf["DB::Name"], Cnf["DB::Host"], int(Cnf["DB::Port"]), None, None, 'postgres')