def getListAllQuery(self):
"""Query all media boxes in the system."""
sql = "SELECT p.id, p.deviceIP as ip, p.stationID, p.lastDateTime, s.name as stationName " \
"FROM publish as p INNER JOIN stationSet as s ON p.stationID = s.id"
out = DB.query(sql)
return out
def getListQuery(self, id):
"""Query the media box identified by parameter id."""
sql = "SELECT p.id, p.deviceIP as ip, p.stationID, p.speed, p.volume, p.pitch, p.lastDateTime, " \
"s.name as stationName FROM publish as p INNER JOIN stationSet as s " \
"ON p.stationID = s.id where p.id = %s" % id
out = DB.query(sql)
return out
def getListAllQuery(self):
sql = "SELECT c.id, c.deviceIP as ip, c.stationID, c.lastDateTime, s.name as stationName " \
"FROM checkinDev as c INNER JOIN stationSet as s ON c.stationID = s.id"
out = DB.query(sql)
return out