def add(cls, uid, name, type):
try:
id = store.execute("insert into user (uid, name, type) values "
"(%s, %s, %s)", (uid, name, type))
store.commit()
except IntegrityError:
store.rollback()
return
return cls.get(id)
def add(cls, title, content, author_uid):
try:
id = store.execute(
"insert into card (title, content, author_uid, creation_time) " "values(%s, %s, %s, null)",
(title, content, author_uid),
)
store.commit()
except IntegrityError:
store.rollback()
return
return cls.get(id)
def delete(self):
store.execute("delete from card where id=%s", self.id)
store.commit()
def update(self, title, content):
store.execute("update card set title=%s, content=%s where id=%s", (title, content, self.id))
store.commit()
self.title = title
self.content = content
def delete(self):
store.execute('delete from user where id=%s', self.id)
store.commit()