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
