option = session.query(Option).filter_by(des=opt_nm).first() if option is None: last_option = session.query(Option).filter_by( p_id=p_option.id).order_by(desc(Option.order)).first() order = last_option.order if last_option else 0 option = Option({ 'level': p_option.level + 1, 'order': order + 10, 'des': opt_nm, 'p_id': p_option.id }) session.add(option) session.flush() now_restaurant = Restaurant.get_by_place_id(session, r['id']) if now_restaurant is None: now_restaurant = Restaurant({ 'name': r['name'], 'road_address': r['roadAddress'], 'address': r['address'], 'option_id': option.id, 'phone': r['telDisplay'] if r['telDisplay'] else r['tel'], 'lng': r['x'],