def delete(self, id):
value = self.get(id)
cursor = self.cursor
cursor.execute("DELETE FROM %s WHERE id=%%s" % self.table, id)
print cursor._last_executed
mc.delete(self.prefix % id)
_key = hashlib.md5(self.prefix_v % value).hexdigest()
mc.delete(_key)
def _update(self):
query = [
'UPDATE %s SET ' % self.__table__,
','.join(['`%s`=%%s'%f for f in self._updated]),
' WHERE id=%s '
]
values = [getattr(self, f) for f in self._updated]
values.append(self.id)
mc.delete(self.MC_KEY % self.id)
self._query(" ".join(query), values)
def _insert(self):
'Uses SQL INSERT to create new record'
id = self.id
fields = [
'`%s`'%f for f in self.__column__
if id is not None or f != 'id'
]
values = [getattr(self, f, None) for f in self.__column__ if id is not None or f != 'id']
query = 'INSERT INTO %s (%s) VALUES (%s)' % (
self.__table__,
','.join(fields),
','.join(['%s'] * len(fields) )
)
id = self._query(query, values)
if self.id is None:
self.id = id
mc.delete(self.MC_KEY % self.id)
return True
def delete(self):
mc.delete(self.MC_KEY % self.id)
cur = connection.cursor()
cur.execute('DELETE FROM %s WHERE id=%s', (self.__table__, self.id))
print cur._last_executed
def delete(self, id):
mc_key = self.prefix % id
mc.delete(mc_key)
db.execute("delete from %s where id=%%s" % self.table_name, id)
