#############################################################################
_translations_query = """
+WITH
+ override_suite AS
+ (SELECT
+ s.id AS id,
+ COALESCE(os.id, s.id) AS overridesuite_id
+ FROM suite AS s LEFT JOIN suite AS os ON s.overridesuite = os.suite_name)
+
SELECT
'Package\: ' || b.package
|| E'\nDescription-md5\: ' || bm_description_md5.value
FROM binaries b
-- join tables for suite and component
JOIN bin_associations ba ON b.id = ba.bin
- JOIN override o ON b.package = o.package AND o.suite = :suite AND o.type = (SELECT id FROM override_type WHERE type = 'deb')
+ JOIN override_suite os ON os.id = ba.suite
+ JOIN override o ON b.package = o.package AND o.suite = os.overridesuite_id AND o.type = (SELECT id FROM override_type WHERE type = 'deb')
-- join tables for Description and Description-md5
JOIN binaries_metadata bm_description ON b.id = bm_description.bin_id AND bm_description.key_id = (SELECT key_id FROM metadata_keys WHERE key = 'Description')
#############################################################################
def main():
- from daklib.dakmultiprocessing import DakProcessPool, PROC_STATUS_SUCCESS, PROC_STATUS_SIGNALRAISED
- pool = DakProcessPool()
-
- from daklib.dbconn import Component, DBConn, get_suite, Suite
from daklib.config import Config
from daklib import daklog
Arguments = [('h',"help","Generate-Packages-Sources::Options::Help"),
('5','description-md5',"Generate-Packages-Sources::Options::Description-md5"),
('s',"suite","Generate-Packages-Sources::Options::Suite"),
- ('f',"force","Generate-Packages-Sources::Options::Force")]
+ ('f',"force","Generate-Packages-Sources::Options::Force"),
+ ('o','option','','ArbItem')]
suite_names = apt_pkg.ParseCommandLine(cnf.Cnf, Arguments, sys.argv)
try:
if Options.has_key("Help"):
usage()
+ from daklib.dakmultiprocessing import DakProcessPool, PROC_STATUS_SUCCESS, PROC_STATUS_SIGNALRAISED
+ pool = DakProcessPool()
+
logger = daklog.Logger('generate-packages-sources2')
+ from daklib.dbconn import Component, DBConn, get_suite, Suite
session = DBConn().session()
session.execute("SELECT add_missing_description_md5()")
session.commit()