def add_all(cls, moods): session = DBSession() session.add_all(moods) try: session.flush() session.commit() except SQLAlchemyError: session.rollback() raise(SQLAlchemyError) finally: session.close()
def add(cls, **kwds): session = DBSession() session.add(cls(**kwds)) try: session.flush() session.commit() except SQLAlchemyError: session.rollback() raise(SQLAlchemyError) finally: session.close()
def add(cls, **kwds): session = DBSession() session.add(cls(**kwds)) try: session.flush() session.commit() except SQLAlchemyError: session.rollback() raise (SQLAlchemyError) finally: session.close()
def update(cls, **kwds): session = DBSession() session.query(cls).filter(cls.name == kwds['name'], cls.platform == kwds['platform'], cls.type == kwds['type']).update(kwds) # noqa try: session.flush() session.commit() except SQLAlchemyError: session.rollback() raise(SQLAlchemyError) finally: session.close()
def update(cls, **kwds): session = DBSession() session.query(cls).filter(cls.tv_id == kwds['tv_id']). \ update(kwds) try: session.flush() session.commit() except SQLAlchemyError: session.rollback() raise(SQLAlchemyError) finally: session.close()
def update(cls, **kwds): session = DBSession() session.query(cls).filter(cls.tv_id == kwds['tv_id']). \ update(kwds) try: session.flush() session.commit() except SQLAlchemyError: session.rollback() raise (SQLAlchemyError) finally: session.close()
def add_all(cls, articles): if not articles: return session = DBSession() session.add_all(articles) try: session.flush() session.commit() except SQLAlchemyError: session.rollback() raise(SQLAlchemyError) finally: session.close()
def update(cls, **kwds): session = DBSession() session.query(cls).filter( cls.name == kwds['name'], cls.platform == kwds['platform'], cls.type == kwds['type']).update(kwds) # noqa try: session.flush() session.commit() except SQLAlchemyError: session.rollback() raise (SQLAlchemyError) finally: session.close()
def add_all(cls, hot_words): if not hot_words: return session = DBSession() session.add_all(hot_words) try: session.flush() session.commit() except SQLAlchemyError: session.rollback() # raise(SQLAlchemyError) finally: session.close()
def update(cls, city_id, time_at, word, times): session = DBSession() session.query(cls). \ filter(cls.time_at == time_at). \ filter(cls.city_id == city_id). \ filter(cls.word == word). \ update({ cls.times: times, }) try: session.flush() session.commit() except SQLAlchemyError: session.rollback() raise(SQLAlchemyError) finally: session.close()
def register(cls, **kwds): session = DBSession() user = cls(**kwds) session.add(user) user_id = None try: session.flush() session.commit() user_id = user.id except SQLAlchemyError: session.rollback() raise(ttypes.UserException)( code=2, message='数据增加失败' ) finally: session.close() return user_id
def update_all(cls, moods): session = DBSession() for mood in moods: session.query(cls). \ filter(cls.time_at == mood.time_at). \ filter(cls.city_id == mood.city_id). \ update({ cls.happy: mood.happy, cls.good: mood.good, cls.anger: mood.anger, cls.sorrow: mood.sorrow, cls.fear: mood.fear, cls.evil: mood.evil, cls.surprise: mood.surprise, cls.cps: mood.cps, }) try: session.flush() session.commit() except SQLAlchemyError: session.rollback() raise(SQLAlchemyError) finally: session.close()