def init_from_user_id(user_id): """从ID中初始化一个district对象 :rtype : District """ try: return Dao.mysql_session.query(FFAdmin).filter(FFAdmin.user_id == user_id).first() except SQLAlchemyError: FFLogger.error(exc_info=True) return None
def init_from_district_id(district_id): """从ID中初始化一个district对象 :rtype : District """ try: return Dao.mysql_session.query(District).filter(District.district_id == district_id).first() except SQLAlchemyError: FFLogger.error(exc_info=True) return None
def init_from_category_id(category_id): """从分类对象ID中初始化一个分类对象 :rtype : Category """ try: return Dao.mysql_session.query(Category).filter(Category.category_id == category_id).first() except SQLAlchemyError: FFLogger.error(exc_info=True) return None
def init_from_venue_id(venue_id): """从场地对象ID中初始化一个分类对象 :rtype : Venue """ try: return Dao.mysql_session.query(Venue).filter(Venue.venue_id == venue_id).first() except SQLAlchemyError: FFLogger.error(exc_info=True) return None
def init_from_section_id(section_id): """从自定义分类分组对象ID中初始化一个实例 :rtype : Category """ try: return Dao.mysql_session.query(CategorySection).filter(CategorySection.section_id == section_id).first() except SQLAlchemyError: FFLogger.error(exc_info=True) return None
def init_from_action_id(action_id): """从分类对象ID中初始化一个分类对象 :rtype : ActionType """ try: return Dao.mysql_session.query(ActionType).filter(ActionType.action_id == action_id).first() except SQLAlchemyError: FFLogger.error(exc_info=True) return None
def add(father_district_id, district_name): """新建行政区划""" district = District(father_district_id=father_district_id, district_name=district_name) try: Dao.mysql_session.add(district) Dao.mysql_session.commit() except SQLAlchemyError: FFLogger.error(exc_info=True) return False return district
def add(category_name): """新增分类""" category = Category(category_name=category_name, category_ranking=time.time()) try: Dao.mysql_session.add(category) Dao.mysql_session.commit() except SQLAlchemyError: FFLogger.error(exc_info=True) return False return category
def add(user_name, password): """新增一个用户""" ff_admin = FFAdmin(user_name=user_name, password=password) try: Dao.mysql_session.add(ff_admin) Dao.mysql_session.commit() except SQLAlchemyError: FFLogger.error(exc_info=True) return False return ff_admin
def add(venue_name): """新增""" venue = Venue(venue_name=venue_name, venue_ranking=time.time()) try: Dao.mysql_session.add(venue) Dao.mysql_session.commit() except SQLAlchemyError: FFLogger.error(exc_info=True) return False return venue
def add(category_name): """新增分组""" section = CategorySection(section_name=category_name, section_ranking=time.time()) try: Dao.mysql_session.add(section) Dao.mysql_session.commit() except SQLAlchemyError: FFLogger.error(exc_info=True) return False return section
def add(action_name): """新增分类""" action = ActionType(action_name=action_name, action_ranking=time.time()) try: Dao.mysql_session.add(action) Dao.mysql_session.commit() except SQLAlchemyError: FFLogger.error(exc_info=True) return False return action