#!/usr/bin/env python
-# Microscopic modification and query tool for overrides in projectb
+""" Microscopic modification and query tool for overrides in projectb """
# Copyright (C) 2004, 2006 Daniel Silverstone <dsilvers@digital-scurf.org>
# This program is free software; you can redistribute it and/or modify
################################################################################
import pg, sys
-import dak.lib.utils, dak.lib.database
-import apt_pkg, dak.lib.logging
+import apt_pkg
+from daklib import logging
+from daklib import database
+from daklib import utils
################################################################################
################################################################################
-# Shamelessly stolen from 'dak rm'. Should probably end up in dak.lib.utils.py
+# Shamelessly stolen from 'dak rm'. Should probably end up in utils.py
def game_over():
- answer = dak.lib.utils.our_raw_input("Continue (y/N)? ").lower()
+ answer = utils.our_raw_input("Continue (y/N)? ").lower()
if answer != "y":
print "Aborted."
sys.exit(1)
def usage (exit_code=0):
print """Usage: dak override [OPTIONS] package [section] [priority]
-Make microchanges or microqueries of the overrides
+Make microchanges or microqueries of the binary overrides
-h, --help show this help and exit
-d, --done=BUG# send priority/section change as closure to bug#
def main ():
global Cnf, projectB
- Cnf = dak.lib.utils.get_conf()
+ Cnf = utils.get_conf()
Arguments = [('h',"help","Override::Options::Help"),
('d',"done","Override::Options::Done", "HasArg"),
('s',"suite","Override::Options::Suite", "HasArg"),
]
for i in ["help", "no-action"]:
- if not Cnf.has_key("Override::Options::%s" % (i)):
- Cnf["Override::Options::%s" % (i)] = ""
+ if not Cnf.has_key("Override::Options::%s" % (i)):
+ Cnf["Override::Options::%s" % (i)] = ""
if not Cnf.has_key("Override::Options::Suite"):
- Cnf["Override::Options::Suite"] = "unstable"
+ Cnf["Override::Options::Suite"] = "unstable"
arguments = apt_pkg.ParseCommandLine(Cnf,Arguments,sys.argv)
Options = Cnf.SubTree("Override::Options")
if Options["Help"]:
- usage()
+ usage()
projectB = pg.connect(Cnf["DB::Name"], Cnf["DB::Host"], int(Cnf["DB::Port"]))
- dak.lib.database.init(Cnf, projectB)
+ database.init(Cnf, projectB)
if not arguments:
- dak.lib.utils.fubar("package name is a required argument.")
+ utils.fubar("package name is a required argument.")
package = arguments.pop(0)
suite = Options["Suite"]
if arguments and len(arguments) > 2:
- dak.lib.utils.fubar("Too many arguments")
+ utils.fubar("Too many arguments")
if arguments and len(arguments) == 1:
# Determine if the argument is a priority or a section...
elif r[0][1] == 1:
arguments = (".",arg)
else:
- dak.lib.utils.fubar("%s is not a valid section or priority" % (arg))
-
+ utils.fubar("%s is not a valid section or priority" % (arg))
# Retrieve current section/priority...
- q = projectB.query("""
- SELECT priority.priority AS prio, section.section AS sect
- FROM override, priority, section, suite
+ oldsection, oldsourcesection, oldpriority = None, None, None
+ for packagetype in ['source', 'binary']:
+ eqdsc = '!='
+ if packagetype == 'source':
+ eqdsc = '='
+ q = projectB.query("""
+ SELECT priority.priority AS prio, section.section AS sect, override_type.type AS type
+ FROM override, priority, section, suite, override_type
WHERE override.priority = priority.id
+ AND override.type = override_type.id
+ AND override_type.type %s 'dsc'
AND override.section = section.id
AND override.package = %s
AND override.suite = suite.id
AND suite.suite_name = %s
- """ % (pg._quote(package,"str"), pg._quote(suite,"str")))
+ """ % (eqdsc, pg._quote(package,"str"), pg._quote(suite,"str")))
- if q.ntuples() == 0:
- dak.lib.utils.fubar("Unable to find package %s" % (package))
- if q.ntuples() > 1:
- dak.lib.utils.fubar("%s is ambiguous. Matches %d packages" % (package,q.ntuples()))
+ if q.ntuples() == 0:
+ continue
+ if q.ntuples() > 1:
+ utils.fubar("%s is ambiguous. Matches %d packages" % (package,q.ntuples()))
+
+ r = q.getresult()
+ if packagetype == 'binary':
+ oldsection = r[0][1]
+ oldpriority = r[0][0]
+ else:
+ oldsourcesection = r[0][1]
+ oldpriority = 'source'
- r = q.getresult()
- oldsection = r[0][1]
- oldpriority = r[0][0]
+ if not oldpriority and not oldsourcesection:
+ utils.fubar("Unable to find package %s" % (package))
+ if oldsection and oldsourcesection and oldsection != oldsourcesection:
+ # When setting overrides, both source & binary will become the same section
+ utils.warn("Source is in section '%s' instead of '%s'" % (oldsourcesection, oldsection))
+ if not oldsection:
+ oldsection = oldsourcesection
if not arguments:
print "%s is in section '%s' at priority '%s'" % (
pg._quote(newsection,"str")))
if q.ntuples() == 0:
- dak.lib.utils.fubar("Supplied section %s is invalid" % (newsection))
+ utils.fubar("Supplied section %s is invalid" % (newsection))
newsecid = q.getresult()[0][0]
q = projectB.query("SELECT id FROM priority WHERE priority=%s" % (
pg._quote(newpriority,"str")))
if q.ntuples() == 0:
- dak.lib.utils.fubar("Supplied priority %s is invalid" % (newpriority))
+ utils.fubar("Supplied priority %s is invalid" % (newpriority))
newprioid = q.getresult()[0][0]
if newpriority == oldpriority and newsection == oldsection:
print "I: Doing nothing"
sys.exit(0)
+ if oldpriority == 'source' and newpriority != 'source':
+ utils.fubar("Trying to change priority of a source-only package")
+
# If we're in no-action mode
if Options["No-Action"]:
if newpriority != oldpriority:
if not Options.has_key("Done"):
pass
- #dak.lib.utils.warn("No bugs to close have been specified. Noone will know you have done this.")
+ #utils.warn("No bugs to close have been specified. Noone will know you have done this.")
else:
print "I: Will close bug(s): %s" % (Options["Done"])
game_over()
- Logger = dak.lib.logging.Logger(Cnf, "override")
+ Logger = logging.Logger(Cnf, "override")
projectB.query("BEGIN WORK")
# We're in "do it" mode, we have something to do... do it
UPDATE override
SET priority=%d
WHERE package=%s
+ AND override.type != %d
AND suite = (SELECT id FROM suite WHERE suite_name=%s)""" % (
newprioid,
- pg._quote(package,"str"),
+ pg._quote(package,"str"), database.get_override_type_id("dsc"),
pg._quote(suite,"str") ))
Logger.log(["changed priority",package,oldpriority,newpriority])
newsecid,
pg._quote(package,"str"),
pg._quote(suite,"str") ))
- Logger.log(["changed priority",package,oldsection,newsection])
+ Logger.log(["changed section",package,oldsection,newsection])
projectB.query("COMMIT WORK")
if Options.has_key("Done"):
Subst["__BCC__"] = "Bcc: " + ", ".join(bcc)
else:
Subst["__BCC__"] = "X-Filler: 42"
- Subst["__CC__"] = "X-DAK: dak override"
+ Subst["__CC__"] = "X-DAK: dak override\nX-Katie: alicia"
Subst["__ADMIN_ADDRESS__"] = Cnf["Dinstall::MyAdminAddress"]
Subst["__DISTRO__"] = Cnf["Dinstall::MyDistribution"]
- Subst["__WHOAMI__"] = dak.lib.utils.whoami()
+ Subst["__WHOAMI__"] = utils.whoami()
+ Subst["__SOURCE__"] = package
summary = "Concerning package %s...\n" % (package)
summary += "Operating on the %s suite\n" % (suite)
summary += "Changed section from %s to %s\n" % (oldsection,newsection)
Subst["__SUMMARY__"] = summary
- for bug in dak.lib.utils.split_args(Options["Done"]):
+ for bug in utils.split_args(Options["Done"]):
Subst["__BUG_NUMBER__"] = bug
- mail_message = dak.lib.utils.TemplateSubst(
+ mail_message = utils.TemplateSubst(
Subst,Cnf["Dir::Templates"]+"/override.bug-close")
- dak.lib.utils.send_mail(mail_message)
+ utils.send_mail(mail_message)
Logger.log(["closed bug",bug])
Logger.close()