def packages(package_name=None, runtime_id=None):
if package_name is None:
packages = Package.query.filter_by(active=True).order_by(
Package.package_name).all()
return render_template("packages.html",
packages=packages,
admin=usermanagement.check_perms('admin'),
loggedinuser=current_user)
# Get package data
package = db.session.query(Package,
PackageGroup
).filter(Package.package_name == package_name
).outerjoin(PackageGroup).first()
def get_pconditions():
return {}
# Publisher conditions have been removed in favour
# of organisation conditions. need to consider how to
# possibly include this again here.
"""if p is None:
p = db.session.query(Package).\
filter(Package.package_name == id).first()
return {}
else:
# Get publisher-specific conditions.
return PublisherCondition.query.filter_by(
publisher_id=p[1].id).all()"""
#pconditions = get_pconditions()
pconditions = {}
# Get list of runtimes
try:
runtimes = db.session.query(AggregateResult.runtime_id,
Runtime.runtime_datetime
).filter(AggregateResult.package_id==package.Package.id
).distinct(
).join(Runtime
).all()
except Exception:
return abort(404)
def get_latest_runtime():
if runtime_id:
# If a runtime is specified in the request, get the data
return (db.session.query(Runtime
).filter(Runtime.id==runtime_id
).first(), False)
else:
# Select the highest runtime; then get data for that one
runtime = db.session.query(Runtime,
func.max(Runtime.id)
).join(AggregateResult
).group_by(Runtime.id
).filter(AggregateResult.package_id==package.Package.id
).first()
return runtime.Runtime, True
try:
latest_runtime, latest = get_latest_runtime()
except Exception:
latest_runtime = None
latest = None
aggregation_type=integerise(request.args.get('aggregation_type', 2))
all_aggregation_types = dqaggregationtypes.aggregationTypes()
if latest_runtime:
aggregate_results = package_aggregation(package, latest_runtime, aggregation_type)
aggregate_results = summary.agr_results(aggregate_results,
pconditions,
mode="publisher")
else:
aggregate_results = None
pconditions = None
flat_results = None
latest_runtime = None
organisations = dqpackages.packageOrganisations(package.Package.id)
return render_template("package.html", package=package, runtimes=runtimes,
results=aggregate_results,
latest_runtime=latest_runtime, latest=latest,
pconditions=pconditions,
organisations=organisations,
all_aggregation_types=all_aggregation_types,
aggregation_type=aggregation_type,
admin=usermanagement.check_perms('admin'),
loggedinuser=current_user)
def get_organisation_ids():
return [ o.Organisation.id for o in
dqpackages.packageOrganisations(package_id) ]
