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 _get_ids(cls): rs = store.execute("select id from card order by id desc") return [r[0] for r in rs if r]
def get(cls, id): rs = store.execute( "select id, title, content, author_uid, creation_time, " "update_time from card where id=%s", (id,) ) if rs: return cls(*rs[0])
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 get_by_uid(cls, uid): rs = store.execute("select id, uid, name, type, subtype, birthday from user " "where uid=%s", uid) if rs: return cls(*rs[0])
def delete(self): store.execute('delete from user where id=%s', self.id) store.commit()