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