def process_maintain_basic_data(item): oil_usage = item.get('oil_usage', 0) brake_oil_usage = item.get('brake_oil_usage', 0) steering_oil_usage = item.get('steering_oil_usage', 0) transmission_oil_usage = item.get('transmission_oil_usage', 0) spark_plug_num = item.get('spark_plug_num', 0) if oil_usage != 0 or brake_oil_usage != 0 or steering_oil_usage != 0 or transmission_oil_usage != 0 or spark_plug_num != 0: sohu_type = session.query(SohuType).filter_by( id=item.get('sohu_vehicle_type_id')).first() maintain_basic_data = session.query(MaintainBasicData).filter_by( sohu_vehicle_type_id=item.get('sohu_vehicle_type_id')).first() if maintain_basic_data is None: maintain_basic_data = MaintainBasicData() maintain_basic_data.created_at = datetime.now() maintain_basic_data.updated_at = datetime.now() maintain_basic_data.oil_usage = oil_usage maintain_basic_data.brake_oil_usage = brake_oil_usage maintain_basic_data.steering_oil_usage = steering_oil_usage maintain_basic_data.transmission_oil_usage = transmission_oil_usage maintain_basic_data.spark_plug_num = spark_plug_num sohu_type.basic_data.append(maintain_basic_data) session.merge(sohu_type)
def process_maintenance_information(item): sohu_type = session.query(SohuType).filter_by( id=item.get('sohu_vehicle_type_id')).first() maintenance_information = session.query( SohuMaintenanceInformation).filter_by( sohu_vehicle_type_id=item.get('sohu_vehicle_type_id')).filter_by( mileage=item.get('mileage')).first() if maintenance_information is None: maintenance_information = SohuMaintenanceInformation() maintenance_information.created_at = datetime.now() maintenance_information.updated_at = datetime.now() maintenance_information.mileage = item.get('mileage', '') maintenance_information.oil = item.get('oil', 0) maintenance_information.oil_filter = item.get('oil_filter', 0) maintenance_information.air_filter = item.get('air_filter', 0) maintenance_information.cabin_filter = item.get('cabin_filter', 0) maintenance_information.fuel_filter = item.get('fuel_filter', 0) maintenance_information.brake_oil = item.get('brake_oil', 0) maintenance_information.transmission_oil = item.get( 'transmission_oil', 0) maintenance_information.steering_oil = item.get('steering_oil', 0) maintenance_information.spark_plug = item.get('spark_plug', 0) maintenance_information.timing_belt = item.get('timing_belt', 0) maintenance_information.reference_price = item.get( 'reference_price', '') maintenance_information.mounth = item.get('mounth', '') sohu_type.sohu_maintenance_informations.append(maintenance_information) session.merge(sohu_type)
def build_trait(player): t = Trait( uid = player.id tweet_count = player.tweet_count followers = player.follower_count verified = player.verified perc_retweets = execute_query([num_retweets, player.id]) / float(player.tweet_count) #TODO add/pick the rest of the fields ) session.merge(t)
def process_sohu_brand(item, sohu_id): sohu_brand = session.query(SohuBrand).filter_by(sohu_id=sohu_id).first() if sohu_brand is None: sohu_brand = SohuBrand() sohu_brand.sohu_id = sohu_id sohu_brand.created_at = datetime.now() sohu_brand.updated_at = datetime.now() sohu_brand.name = item.get('name', '') session.merge(sohu_brand)
def guide_commence_voyage(): trip_id = session['trip_id'] status = model.get_status_for_trip(trip_id) status.datetime_commenced = datetime.datetime.now() # Add the user object to the database db_session.merge(status) # Save the user in the database db_session.commit() return render_template("guide_complete_voyage.html")
def guide_complete_voyage(): trip_id = session['trip_id'] status = model.get_status_for_trip(trip_id) status.datetime_completed = datetime.datetime.now() # Add the user object to the database db_session.merge(status) # Save the user in the database db_session.commit() del session['trip_id'] return url_for("guide_rate_your_traveler")
def process_sohu_type(item, sohu_id): sohu_series = session.query(SohuSeries).filter_by( sohu_id=item.get('sohu_vehicle_series_id')).first() sohu_type = session.query(SohuType).filter_by(sohu_id=sohu_id).first() if sohu_type is None: sohu_type = SohuType() sohu_type.sohu_id = sohu_id sohu_type.created_at = datetime.now() sohu_type.updated_at = datetime.now() sohu_type.name = item.get('name', '') sohu_type.year = item.get('year', '') sohu_series.sohu_types.append(sohu_type) session.merge(sohu_series)
def process_sohu_company(item): sohu_brand = session.query(SohuBrand).filter_by( sohu_id=item.get('sohu_vehicle_brand_id')).first() sohu_company = session.query(SohuCompany).filter_by( link=item.get('link')).first() if sohu_company is None: sohu_company = SohuCompany() sohu_company.created_at = datetime.now() sohu_company.updated_at = datetime.now() sohu_company.name = item.get('name', '') sohu_company.link = item.get('link', '') sohu_brand.sohu_companies.append(sohu_company) session.merge(sohu_brand)
def process_sohu_series(item, sohu_id): sohu_brand = session.query(SohuBrand).filter_by( id=item.get('sohu_brand_id')).first() sohu_company = session.query(SohuCompany).filter_by( id=item.get('sohu_product_company_id')).first() sohu_series = session.query(SohuSeries).filter_by(sohu_id=sohu_id).first() if sohu_series is None: sohu_series = SohuSeries() sohu_series.sohu_id = sohu_id sohu_series.created_at = datetime.now() sohu_series.updated_at = datetime.now() sohu_series.name = item.get('name', '') sohu_brand.sohu_series.append(sohu_series) sohu_company.sohu_series.append(sohu_series) session.merge(sohu_brand) session.merge(sohu_company)