def delete(cls, where=None, params=None): sql = 'DELETE FROM `%s`' % cls._tbl db = cls.getdb() if not where: return db.update(sql) sql += 'WHERE' + where return db.update(sql, params)
def update(cls, clause=None, where='', params=None): db = cls.getdb() sql = 'UPDATE `%s` SET %s' % (cls._tbl, clause) return db.update(sql, params)
def delete_one(cls, pk=None): db = cls.getdb() sql = 'DELETE FROM `%S` WHERE %s == %%s' % (cls._tbl, cls._id) return db.update(sql, [pk])