diff options
author | 2019-12-15 02:38:40 +1100 | |
---|---|---|
committer | 2019-12-15 02:38:40 +1100 | |
commit | 1fda8836a7ff2c26805eab8abc95d40ba5920237 (patch) | |
tree | 7465dd16cbf5043d69c790ff7de993bd610c64e2 /scripts/minimaws/lib/dbaccess.py | |
parent | 24d2b7a51d435c2be7f8e57886ccc4198392fc20 (diff) |
minimaws: add rudimentary listing of software lists to web UI and work around a python issue on loading; also fix up more software list issues (nw)
Diffstat (limited to 'scripts/minimaws/lib/dbaccess.py')
-rw-r--r-- | scripts/minimaws/lib/dbaccess.py | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/scripts/minimaws/lib/dbaccess.py b/scripts/minimaws/lib/dbaccess.py index f81dad66b83..d5fe557ff91 100644 --- a/scripts/minimaws/lib/dbaccess.py +++ b/scripts/minimaws/lib/dbaccess.py @@ -644,6 +644,20 @@ class QueryCursor(object): 'ORDER BY ramoption.size', (machine, )) + def get_softwarelists(self, pattern): + if pattern is not None: + return self.dbcurs.execute( + 'SELECT softwarelist.shortname AS shortname, softwarelist.description AS description, COUNT(*) AS total, COUNT(CASE software.supported WHEN 0 THEN 1 ELSE NULL END) AS supported, COUNT(CASE software.supported WHEN 1 THEN 1 ELSE NULL END) AS partiallysupported, COUNT(CASE software.supported WHEN 2 THEN 1 ELSE NULL END) AS unsupported ' \ + 'FROM softwarelist LEFT JOIN software ON softwarelist.id = software.softwarelist ' \ + 'WHERE softwarelist.shortname GLOB ? ' \ + 'GROUP BY softwarelist.id', + (pattern, )) + else: + return self.dbcurs.execute( + 'SELECT softwarelist.shortname AS shortname, softwarelist.description AS description, COUNT(*) AS total, COUNT(CASE software.supported WHEN 0 THEN 1 ELSE NULL END) AS supported, COUNT(CASE software.supported WHEN 1 THEN 1 ELSE NULL END) AS partiallysupported, COUNT(CASE software.supported WHEN 2 THEN 1 ELSE NULL END) AS unsupported ' \ + 'FROM softwarelist LEFT JOIN software ON softwarelist.id = software.softwarelist ' \ + 'GROUP BY softwarelist.id') + def get_rom_dumps(self, crc, sha1): return self.dbcurs.execute( 'SELECT machine.shortname AS shortname, machine.description AS description, romdump.name AS label, romdump.bad AS bad ' \ |