Add option to sort by project

Change-Id: Icb6cd5cd9d00f166c492abfec75854e16950274e
This commit is contained in:
James E. Blair 2016-11-29 11:23:04 -08:00
parent fca4d23465
commit 14758b1665
2 changed files with 4 additions and 1 deletions

View File

@ -54,7 +54,7 @@ class ConfigSchema(object):
servers = [server]
_sort_by = v.Any('number', 'updated', 'last-seen')
_sort_by = v.Any('number', 'updated', 'last-seen', 'project')
sort_by = v.Any(_sort_by, [_sort_by])
text_replacement = {'text': v.Any(str,

View File

@ -892,6 +892,9 @@ class DatabaseSession(object):
q = q.order_by(change_table.c.last_seen)
elif s == 'number':
q = q.order_by(change_table.c.number)
elif s == 'project':
q = q.filter(project_table.c.key == change_table.c.project_key)
q = q.order_by(project_table.c.name)
self.database.log.debug("Search SQL: %s" % q)
try:
return q.all()