WHERE
sa.suite = :suite
- AND o.suite = :suite AND o.component = :component AND o.type = :dsc_type
+ AND o.suite = :overridesuite AND o.component = :component AND o.type = :dsc_type
ORDER BY
s.source, s.version
suite = session.query(Suite).get(suite_id)
component = session.query(Component).get(component_id)
+ overridesuite_id = suite.get_overridesuite().suite_id
+
writer = SourcesFileWriter(suite=suite.suite_name, component=component.component_name)
output = writer.open()
# run query and write Sources
- r = session.execute(_sources_query, {"suite": suite_id, "component": component_id, "dsc_type": dsc_type})
+ r = session.execute(_sources_query, {"suite": suite_id, "component": component_id, "dsc_type": dsc_type, "overridesuite": overridesuite_id})
for (stanza,) in r:
print >>output, stanza
print >>output, ""
bm.bin_id = tmp.binary_id
AND key != 'Section' AND key != 'Priority'
)
+ || COALESCE(E'\n' || (SELECT
+ STRING_AGG(key || '\: ' || value, E'\n' ORDER BY key)
+ FROM external_overrides eo
+ WHERE eo.package = tmp.package
+ ), '')
|| E'\nSection\: ' || sec.section
|| E'\nPriority\: ' || pri.priority
|| E'\nFilename\: pool/' || tmp.filename
(architecture = :arch_all AND source NOT IN (SELECT DISTINCT source FROM tmp WHERE architecture <> :arch_all))
)
AND
- o.type = :type_id AND o.suite = :suite AND o.component = :component
+ o.type = :type_id AND o.suite = :overridesuite AND o.component = :component
ORDER BY tmp.package, tmp.version
"""
component = session.query(Component).get(component_id)
architecture = session.query(Architecture).get(architecture_id)
+ overridesuite_id = suite.get_overridesuite().suite_id
+
writer = PackagesFileWriter(suite=suite.suite_name, component=component.component_name,
architecture=architecture.arch_string, debtype=type_name)
output = writer.open()
r = session.execute(_packages_query, {"suite": suite_id, "component": component_id,
- "arch": architecture_id, "type_id": type_id, "type_name": type_name, "arch_all": arch_all_id})
+ "arch": architecture_id, "type_id": type_id, "type_name": type_name, "arch_all": arch_all_id,
+ "overridesuite": overridesuite_id})
for (stanza,) in r:
print >>output, stanza
print >>output, ""