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])