q = session.query(Suite)
q = q.join(SuiteArchitecture)
q = q.join(Architecture).filter_by(arch_string=architecture).order_by('suite_name')
q = session.query(Suite)
q = q.join(SuiteArchitecture)
q = q.join(Architecture).filter_by(arch_string=architecture).order_by('suite_name')
architecture = [architecture]
q = q.join(Architecture).filter(Architecture.arch_string.in_(architecture))
architecture = [architecture]
q = q.join(Architecture).filter(Architecture.arch_string.in_(architecture))
def get_binary_from_name_suite(package, suitename, session=None):
### For dak examine-package
### XXX: Doesn't use object API yet
def get_binary_from_name_suite(package, suitename, session=None):
### For dak examine-package
### XXX: Doesn't use object API yet
sql = """SELECT DISTINCT(b.package), b.version, c.name, su.suite_name
FROM binaries b, files fi, location l, component c, bin_associations ba, suite su
sql = """SELECT DISTINCT(b.package), b.version, c.name, su.suite_name
FROM binaries b, files fi, location l, component c, bin_associations ba, suite su
__all__.append('get_binary_from_name_suite')
def get_binary_components(package, suitename, arch, session=None):
__all__.append('get_binary_from_name_suite')
def get_binary_components(package, suitename, arch, session=None):
query = """SELECT c.name FROM binaries b, bin_associations ba, suite s, location l, component c, architecture a, files f
WHERE b.package=:package AND s.suite_name=:suitename
AND (a.arch_string = :arch OR a.arch_string = 'all')
query = """SELECT c.name FROM binaries b, bin_associations ba, suite s, location l, component c, architecture a, files f
WHERE b.package=:package AND s.suite_name=:suitename
AND (a.arch_string = :arch OR a.arch_string = 'all')
# find me all of the contents for a given suite
contents_q = """SELECT (p.path||'/'||n.file) AS fn,
# find me all of the contents for a given suite
contents_q = """SELECT (p.path||'/'||n.file) AS fn,
q = session.query(PoolFile).filter_by(filename=filename)
q = q.join(Location).filter_by(location_id=location_id)
q = session.query(PoolFile).filter_by(filename=filename)
q = q.join(Location).filter_by(location_id=location_id)
q = session.query(PoolFile).filter_by(filename=filename)
if location_id is not None:
q = q.join(Location).filter_by(location_id=location_id)
q = session.query(PoolFile).filter_by(filename=filename)
if location_id is not None:
q = q.join(Location).filter_by(location_id=location_id)
# TODO: There must be a way of properly using bind parameters with %FOO%
q = session.query(PoolFile).filter(PoolFile.filename.like('%%%s%%' % filename))
# TODO: There must be a way of properly using bind parameters with %FOO%
q = session.query(PoolFile).filter(PoolFile.filename.like('%%%s%%' % filename))
- try:
- q = session.query(Fingerprint).filter_by(fingerprint=fpr)
- if q.count() < 1:
- fingerprint = Fingerprint()
- fingerprint.fingerprint = fpr
- session.add(fingerprint)
- if privatetrans:
- session.commit()
- else:
- session.flush()
- return fingerprint
+ q = session.query(Fingerprint).filter_by(fingerprint=fpr)
+ if q.count() < 1:
+ fingerprint = Fingerprint()
+ fingerprint.fingerprint = fpr
+ session.add(fingerprint)
+ if privatetrans:
+ session.commit()
- try:
- q = session.query(Maintainer).filter_by(name=name)
- if q.count() < 1:
- maintainer = Maintainer()
- maintainer.name = name
- session.add(maintainer)
- if privatetrans:
- session.commit()
- else:
- session.flush()
- return maintainer
+ q = session.query(Maintainer).filter_by(name=name)
+ if q.count() < 1:
+ maintainer = Maintainer()
+ maintainer.name = name
+ session.add(maintainer)
+ if privatetrans:
+ session.commit()
q = session.query(NewComment)
q = q.filter_by(package=package)
q = q.filter_by(version=version)
q = session.query(NewComment)
q = q.filter_by(package=package)
q = q.filter_by(version=version)
q = session.query(NewComment)
if package is not None: q = q.filter_by(package=package)
if version is not None: q = q.filter_by(version=version)
if comment_id is not None: q = q.filter_by(comment_id=comment_id)
q = session.query(NewComment)
if package is not None: q = q.filter_by(package=package)
if version is not None: q = q.filter_by(version=version)
if comment_id is not None: q = q.filter_by(comment_id=comment_id)
if not isinstance(overridetype, list): overridetype = [overridetype]
q = q.join(OverrideType).filter(OverrideType.overridetype.in_(overridetype))
if not isinstance(overridetype, list): overridetype = [overridetype]
q = q.join(OverrideType).filter(OverrideType.overridetype.in_(overridetype))
if isinstance(suite, int):
q = session.query(QueueBuild).filter_by(filename=filename).filter_by(suite_id=suite)
else:
if isinstance(suite, int):
q = session.query(QueueBuild).filter_by(filename=filename).filter_by(suite_id=suite)
else:
q = session.query(SrcAssociation)
q = q.join('source').filter_by(source=source)
q = q.join('suite').filter_by(suite_name=suite)
q = session.query(SrcAssociation)
q = q.join('source').filter_by(source=source)
q = q.join('suite').filter_by(suite_name=suite)
q = session.query(SuiteArchitecture)
q = q.join(Architecture).filter_by(arch_string=architecture)
q = q.join(Suite).filter_by(suite_name=suite)
q = session.query(SuiteArchitecture)
q = q.join(Architecture).filter_by(arch_string=architecture)
q = q.join(Suite).filter_by(suite_name=suite)
q = session.query(Architecture)
q = q.join(SuiteArchitecture)
q = q.join(Suite).filter_by(suite_name=suite)
q = session.query(Architecture)
q = q.join(SuiteArchitecture)
q = q.join(Suite).filter_by(suite_name=suite)
__all__.append('get_or_set_uid')
def get_uid_from_fingerprint(fpr, session=None):
__all__.append('get_or_set_uid')
def get_uid_from_fingerprint(fpr, session=None):