- id = int(id)
- if id in [r.id for r in self.db.query("SELECT id FROM releases")]:
- return Release(id)
-
- def get_latest(self, stable=1):
- query = "SELECT id FROM releases WHERE published='Y' AND"
- if stable:
- query += " stable='Y'"
- else:
- query += " stable='N'"
+ ret = self.db.get("SELECT * FROM releases WHERE id = %s", id)
+
+ if ret:
+ return Release(self.backend, ret.id, data=ret)
+
+ def get_by_sname(self, sname):
+ ret = self.db.get("SELECT * FROM releases WHERE sname = %s", sname)
+
+ if ret:
+ return Release(self.backend, ret.id, data=ret)