From d96933356cda8f865a80245f17dd79a527d267b2 Mon Sep 17 00:00:00 2001 From: Vas Crabb Date: Fri, 4 Aug 2017 17:13:34 +1000 Subject: minimaws: demonstrate slot card BIOS selection, requires exposing device BIOS sets in XML output --- scripts/minimaws/lib/dbaccess.py | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) (limited to 'scripts/minimaws/lib/dbaccess.py') diff --git a/scripts/minimaws/lib/dbaccess.py b/scripts/minimaws/lib/dbaccess.py index 147986e0039..59b22dfad5e 100644 --- a/scripts/minimaws/lib/dbaccess.py +++ b/scripts/minimaws/lib/dbaccess.py @@ -55,6 +55,8 @@ class UpdateQueries(object): ADD_SYSTEM = 'INSERT INTO system (id, year, manufacturer) VALUES (?, ?, ?)' ADD_CLONEOF = 'INSERT INTO cloneof (id, parent) VALUES (?, ?)' ADD_ROMOF = 'INSERT INTO romof (id, parent) VALUES (?, ?)' + ADD_BIOSSET = 'INSERT INTO biosset (machine, name, description) VALUES (?, ?, ?)' + ADD_BIOSSETDEFAULT = 'INSERT INTO biossetdefault (id) VALUES (?)' ADD_DIPSWITCH = 'INSERT INTO dipswitch (machine, isconfig, name, tag, mask) VALUES (?, ?, ?, ?, ?)' ADD_DIPLOCATION = 'INSERT INTO diplocation (dipswitch, bit, name, num, inverted) VALUES (?, ?, ?, ?, ?)' ADD_DIPVALUE = 'INSERT INTO dipvalue (dipswitch, name, value, isdefault) VALUES (?, ?, ?, ?)' @@ -184,6 +186,14 @@ class QueryCursor(object): 'WHERE machine.shortname = ?', (machine, )) + def get_biossets(self, machine): + return self.dbcurs.execute( + 'SELECT biosset.name AS name, biosset.description AS description, COUNT(biossetdefault.id) AS isdefault ' \ + 'FROM biosset LEFT JOIN biossetdefault USING (id) ' \ + 'WHERE biosset.machine = ? ' \ + 'GROUP BY biosset.id', + (machine, )) + def get_devices_referenced(self, machine): return self.dbcurs.execute( 'SELECT machine.shortname AS shortname, machine.description AS description, sourcefile.filename AS sourcefile ' \ @@ -291,6 +301,14 @@ class UpdateCursor(object): self.dbcurs.execute(UpdateQueries.ADD_ROMOF, (machine, parent)) return self.dbcurs.lastrowid + def add_biosset(self, machine, name, description): + self.dbcurs.execute(UpdateQueries.ADD_BIOSSET, (machine, name, description)) + return self.dbcurs.lastrowid + + def add_biossetdefault(self, biosset): + self.dbcurs.execute(UpdateQueries.ADD_BIOSSETDEFAULT, (biosset, )) + return self.dbcurs.lastrowid + def add_devicereference(self, machine, device): self.dbcurs.execute(UpdateQueries.ADD_TEMPORARY_DEVICEREFERENCE, (machine, device)) -- cgit v1.2.3-70-g09d2