X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fgenerate_filelist.py;h=c8d51a54632f326eeeb68fa1e00190a772728fae;hb=b43634b6faf221ee10fc63116baead379f68f92f;hp=02f5f18518b7985e31ddcb2e0099837e6db54b6f;hpb=27c600ec14ca7b2d864d458cdf9b5079467188a3;p=dak.git diff --git a/dak/generate_filelist.py b/dak/generate_filelist.py index 02f5f185..c8d51a54 100755 --- a/dak/generate_filelist.py +++ b/dak/generate_filelist.py @@ -22,39 +22,112 @@ Generate file lists for apt-ftparchive. # along with this program; if not, write to the Free Software # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA +################################################################################ + +# Ganneff> Please go and try to lock mhy now. After than try to lock NEW. +# twerner> !lock mhy +# dak> twerner: You suck, this is already locked by Ganneff +# Ganneff> now try with NEW +# twerner> !lock NEW +# dak> twerner: also locked NEW +# mhy> Ganneff: oy, stop using me for locks and highlighting me you tall muppet +# Ganneff> hehe :) + +################################################################################ + from daklib.dbconn import * from daklib.config import Config +from daklib.threadpool import ThreadPool from daklib import utils -import apt_pkg, os, sys +import apt_pkg, os, stat, sys def fetch(query, args, session): return [path + filename for (path, filename) in \ session.execute(query, args).fetchall()] -def getSources(suite, component, session): +def getSources(suite, component, session, timestamp): + extra_cond = "" + if timestamp: + extra_cond = "AND extract(epoch from sa.created) > %d" % timestamp query = """ - SELECT path, filename - FROM srcfiles_suite_component - WHERE suite = :suite AND component = :component - """ + SELECT l.path, f.filename + FROM source s + JOIN src_associations sa + ON s.id = sa.source AND sa.suite = :suite %s + JOIN files f + ON s.file = f.id + JOIN location l + ON f.location = l.id AND l.component = :component + ORDER BY filename + """ % extra_cond args = { 'suite': suite.suite_id, 'component': component.component_id } return fetch(query, args, session) -def getBinaries(suite, component, architecture, type, session): +def getBinaries(suite, component, architecture, type, session, timestamp): + extra_cond = "" + if timestamp: + extra_cond = "AND extract(epoch from ba.created) > %d" % timestamp query = """ - SELECT path, filename - FROM binfiles_suite_component_arch - WHERE suite = :suite AND component = :component AND type = :type AND - (architecture = :architecture OR architecture = 2) - """ +CREATE TEMP TABLE b_candidates ( + source integer, + file integer, + architecture integer); + +INSERT INTO b_candidates (source, file, architecture) + SELECT b.source, b.file, b.architecture + FROM binaries b + JOIN bin_associations ba ON b.id = ba.bin + WHERE b.type = :type AND ba.suite = :suite AND + b.architecture IN (2, :architecture) %s; + +CREATE TEMP TABLE gf_candidates ( + filename text, + path text, + architecture integer, + src integer, + source text); + +INSERT INTO gf_candidates (filename, path, architecture, src, source) + SELECT f.filename, l.path, bc.architecture, bc.source as src, s.source + FROM b_candidates bc + JOIN source s ON bc.source = s.id + JOIN files f ON bc.file = f.id + JOIN location l ON f.location = l.id + WHERE l.component = :component; + +WITH arch_any AS + + (SELECT path, filename FROM gf_candidates + WHERE architecture > 2), + + arch_all_with_any AS + (SELECT path, filename FROM gf_candidates + WHERE architecture = 2 AND + src IN (SELECT src FROM gf_candidates WHERE architecture > 2)), + + arch_all_without_any AS + (SELECT path, filename FROM gf_candidates + WHERE architecture = 2 AND + source NOT IN (SELECT DISTINCT source FROM gf_candidates WHERE architecture > 2)), + + filelist AS + (SELECT * FROM arch_any + UNION + SELECT * FROM arch_all_with_any + UNION + SELECT * FROM arch_all_without_any) + + SELECT * FROM filelist ORDER BY filename + """ % extra_cond args = { 'suite': suite.suite_id, 'component': component.component_id, 'architecture': architecture.arch_id, 'type': type } return fetch(query, args, session) -def listPath(suite, component, architecture = None, type = None): +def listPath(suite, component, architecture = None, type = None, + incremental_mode = False): """returns full path to the list file""" suffixMap = { 'deb': "binary-", 'udeb': "debian-installer_binary-" } @@ -65,31 +138,50 @@ def listPath(suite, component, architecture = None, type = None): filename = "%s_%s_%s.list" % \ (suite.suite_name, component.component_name, suffix) pathname = os.path.join(Config()["Dir::Lists"], filename) - return utils.open_file(pathname, "w") - -def writeSourceList(suite, component, session): - file = listPath(suite, component) - for filename in getSources(suite, component, session): + file = utils.open_file(pathname, "a") + timestamp = None + if incremental_mode: + timestamp = os.fstat(file.fileno())[stat.ST_MTIME] + else: + file.seek(0) + file.truncate() + return (file, timestamp) + +def writeSourceList(args): + (suite, component, incremental_mode) = args + (file, timestamp) = listPath(suite, component, + incremental_mode = incremental_mode) + session = DBConn().session() + for filename in getSources(suite, component, session, timestamp): file.write(filename + '\n') + session.close() file.close() -def writeBinaryList(suite, component, architecture, type, session): - file = listPath(suite, component, architecture, type) - for filename in getBinaries(suite, component, architecture, type, session): +def writeBinaryList(args): + (suite, component, architecture, type, incremental_mode) = args + (file, timestamp) = listPath(suite, component, architecture, type, + incremental_mode) + session = DBConn().session() + for filename in getBinaries(suite, component, architecture, type, + session, timestamp): file.write(filename + '\n') + session.close() file.close() def usage(): print """Usage: dak generate_filelist [OPTIONS] Create filename lists for apt-ftparchive. - -s, --suite=SUITE act on this suite + -s, --suite=SUITE act on this suite -c, --component=COMPONENT act on this component - -a, --architecture=ARCH act on this architecture - -h, --help show this help and exit + -a, --architecture=ARCH act on this architecture + -h, --help show this help and exit + -i, --incremental activate incremental mode ARCH, COMPONENT and SUITE can be comma (or space) separated list, e.g. - --suite=testing,unstable""" + --suite=testing,unstable + +Incremental mode appends only newer files to existing lists.""" sys.exit() def main(): @@ -97,46 +189,54 @@ def main(): Arguments = [('h', "help", "Filelist::Options::Help"), ('s', "suite", "Filelist::Options::Suite", "HasArg"), ('c', "component", "Filelist::Options::Component", "HasArg"), - ('a', "architecture", "Filelist::Options::Architecture", "HasArg")] - query_suites = DBConn().session().query(Suite) - suites = [suite.suite_name for suite in query_suites.all()] + ('a', "architecture", "Filelist::Options::Architecture", "HasArg"), + ('i', "incremental", "Filelist::Options::Incremental")] + session = DBConn().session() + query_suites = session.query(Suite) + suites = [suite.suite_name for suite in query_suites] if not cnf.has_key('Filelist::Options::Suite'): - cnf['Filelist::Options::Suite'] = ','.join(suites) - # we can ask the database for components if 'mixed' is gone + cnf['Filelist::Options::Suite'] = ','.join(suites).encode() + query_components = session.query(Component) + components = \ + [component.component_name for component in query_components] if not cnf.has_key('Filelist::Options::Component'): - cnf['Filelist::Options::Component'] = 'main,contrib,non-free' - query_architectures = DBConn().session().query(Architecture) + cnf['Filelist::Options::Component'] = ','.join(components).encode() + query_architectures = session.query(Architecture) architectures = \ - [architecture.arch_string for architecture in query_architectures.all()] + [architecture.arch_string for architecture in query_architectures] if not cnf.has_key('Filelist::Options::Architecture'): - cnf['Filelist::Options::Architecture'] = ','.join(architectures) + cnf['Filelist::Options::Architecture'] = ','.join(architectures).encode() cnf['Filelist::Options::Help'] = '' + cnf['Filelist::Options::Incremental'] = '' apt_pkg.ParseCommandLine(cnf.Cnf, Arguments, sys.argv) Options = cnf.SubTree("Filelist::Options") if Options['Help']: usage() - session = DBConn().session() - suite_arch = session.query(SuiteArchitecture) - for suite_name in utils.split_args(Options['Suite']): - suite = query_suites.filter_by(suite_name = suite_name).one() - join = suite_arch.filter_by(suite_id = suite.suite_id) - for component_name in utils.split_args(Options['Component']): - component = session.query(Component).\ - filter_by(component_name = component_name).one() - for architecture_name in utils.split_args(Options['Architecture']): - architecture = query_architectures.\ - filter_by(arch_string = architecture_name).one() - try: - join.filter_by(arch_id = architecture.arch_id).one() - if architecture_name == 'source': - writeSourceList(suite, component, session) - elif architecture_name != 'all': - writeBinaryList(suite, component, architecture, 'deb', session) - writeBinaryList(suite, component, architecture, 'udeb', session) - except: + threadpool = ThreadPool() + query_suites = query_suites. \ + filter(Suite.suite_name.in_(utils.split_args(Options['Suite']))) + query_components = query_components. \ + filter(Component.component_name.in_(utils.split_args(Options['Component']))) + query_architectures = query_architectures. \ + filter(Architecture.arch_string.in_(utils.split_args(Options['Architecture']))) + for suite in query_suites: + for component in query_components: + for architecture in query_architectures: + if architecture not in suite.architectures: pass + elif architecture.arch_string == 'source': + threadpool.queueTask(writeSourceList, + (suite, component, Options['Incremental'])) + elif architecture.arch_string != 'all': + threadpool.queueTask(writeBinaryList, + (suite, component, architecture, 'deb', + Options['Incremental'])) + threadpool.queueTask(writeBinaryList, + (suite, component, architecture, 'udeb', + Options['Incremental'])) + threadpool.joinAll() # this script doesn't change the database - session.rollback() + session.close() if __name__ == '__main__': main()