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