def load_sample_trips(): """Create sample trip instances""" trip1 = Trip(trip_name="April Fishing Trip", creator_id=1) trip2 = Trip(trip_name="Climbing @ Mt. Diablo", creator_id=2) db.session.add_all([trip1, trip2]) db.session.commit()
def example_data(): """Create some sample data.""" SaffyTrip = Trip(trip_id=2, departure_address='Oakland', car_capacity=2) AnnaTrip = Trip(trip_id=11, departure_address='Berkeley', car_capacity=2) SamTrip = Trip(trip_id=6, departure_address='Oakland', car_capacity=3) Saffy = User(first_name='Saffy', ) Anna = User(first_name='Anna', ) Sam = User(name='Sam',) db.session.add_all([ SaffyTrip, AnnaTrip, SamTrip, Saffy, Anna, Sam]) db.session.commit()
def add_trip_process(): """Add a trip to the database.""" trip_date = request.form['date'] trip_time = request.form['time'] trip_origin = request.form['origin'] trip_destination = request.form['destination'] max_passengers = request.form['max_passengers'] trip_cost = request.form['cost'] willing_to_stop = request.form['newleg'] in ('True') user_id = session.get('user_id') distance_meters, display_distance = (distance_matrix.distance_matrix( trip_origin, trip_destination)) new_trip = Trip(date_of_trip=trip_date, time=trip_time, max_passengers=max_passengers, origin=trip_origin, destination=trip_destination, willing_to_stop=willing_to_stop, trip_cost=trip_cost, user_id=user_id, distance_meters=distance_meters, display_distance=display_distance, is_active=True) db.session.add(new_trip) db.session.commit() return redirect('/')
def create_trip(): """Create a new trip.""" if request.method == "POST": user_id = session["user_id"] trip_name = request.form["trip_name"] description = request.form["description"] trip = Trip(trip_name=trip_name, description=description, user_id=user_id) db.session.add(trip) db.session.commit() trip_id = trip.trip_id return redirect(f"/user_journal/{user_id}") else: return render_template("create_trip.html") if request.method == "GET": user_id = session["user_id"] return redirect(f"/create_trip/{trip_id}")
def make_new_trip_id(): """Produce new trip id.""" set_val_trip_id() user_id = session["user_id"] trip_name = request.form.get('trip').strip() #check the trip is existing or not trip = Trip.query.filter_by(name=trip_name, user_id=user_id).first() if not trip: #Add a new trip trip = Trip(name=trip_name, user_id=user_id) db.session.add(trip) db.session.commit() #Get the id of the trip trip = Trip.query.filter_by(name=trip_name, user_id=user_id).first() print "##### Developer msg ##### Added:", trip return redirect('/new-trip/' + str(trip.trip_id)) #If the trip is already in the database else: flash("You've already have the trip. Please create a new trip.") return redirect('/')
def trip(): date = request.form['date'] site_id = request.form['path'] message = request.form['message'] email_list = request.form.getlist('email_list[]') trip_date = datetime.datetime.strptime(date, "%m/%d/%Y") if trip_date.date() < datetime.datetime.today().date(): return "Trip must be in the future" else: new_trip = Trip(site_id=site_id, owner_id=session['user_id'], date=date) db.session.add(new_trip) attendees = [] if email_list: for email in email_list: attendee = User.query.filter_by(email=email).first() if attendee: attendees.append(attendee) send_trip_invite(new_trip, attendee, message) print "sent trip invite" else: print attendee + 'not found' db.session.commit() return "Successfully created a trip!"
def create_trip(trip_name): """create and return new trip""" trip = Trip(trip_name=trip_name) db.session.add(trip) db.session.commit() return trip
def write_distance_matrix_db(user_id, units='imperial'): """Get origin/destination pairs where trips don't already exist""" trips_leg_a = db.session.query( Location.place_id.label('origin_place_id'), Location.lat.label('origin_lat'), Location.lng.label('origin_lng'), Trip.origin_place_id.label('trip_origin_place_id'), loc_1.place_id.label('dest_place_id'), loc_1.lat.label('dest_lat'), loc_1.lng.label('dest_lng'), ).join(Attraction).outerjoin(Trip).join( loc_1, loc_1.place_id != Location.place_id).join( attrc_2, attrc_2.place_id == loc_1.place_id).filter( Attraction.user_id == user_id, attrc_2.user_id == user_id, Trip.origin_place_id.is_(None)).distinct() trips_leg_b_sub = trips_leg_a.subquery() trips_leg_b = db.session.query( trips_leg_b_sub.c.dest_place_id.label('origin_place_id'), trips_leg_b_sub.c.dest_lat.label('origin_lat'), trips_leg_b_sub.c.dest_lng.label('origin_lng'), trips_leg_b_sub.c.trip_origin_place_id.label('trip_origin_place_id'), trips_leg_b_sub.c.origin_place_id.label('dest_place_id'), trips_leg_b_sub.c.origin_lat.label('dest_lat'), trips_leg_b_sub.c.origin_lng.label('dest_lng'), ).distinct() trips = trips_leg_b.union(trips_leg_a).all() new_trips = [] for trip in trips: duration_dict = gmaps.distance_matrix( (trip.origin_lat + ',' + trip.origin_lng), (trip.dest_lat + ',' + trip.dest_lng), units=units) if duration_dict["rows"][0]['elements'][0].get('duration'): """Includes trips that can only be road trips. Travel mode is driving. Duration unit is seconds.""" duration_sec = duration_dict["rows"][0]['elements'][0]['duration'][ 'value'] new_trips.append( Trip(origin_place_id=trip.origin_place_id, origin_coords=(trip.origin_lat + ',' + trip.origin_lng), destination_place_id=trip.dest_place_id, destination_coords=(trip.dest_lat + ',' + trip.dest_lng), duration=duration_sec)) """Save new trips to db""" if new_trips: db.session.add_all(new_trips) db.session.commit()
def create_Trip(traveler_id, trip_name, trip_city, travel_date_from, travel_date_to): trip = Trip(traveler_id = traveler_id, trip_name = trip_name, trip_city = trip_city, travel_date_from = travel_date_from, travel_date_to = travel_date_to ) db.session.add(trip) db.session.commit() return trip
def update_data(): "Get all the details of batch processed data" session = boto3.session.Session( aws_access_key_id=ACCESS_KEY, aws_secret_access_key=SECRET_ACCESS_KEY ) s3 = session.resource("s3") bucket = s3.Bucket('citibikenycdataset') obj = bucket.Object('201307-201402-citibike-tripdata.zip') i=0 with io.BytesIO(obj.get()["Body"].read()) as tf: # rewind the file tf.seek(0) # Read the file as a zipfile and process the members zfile = zipfile.ZipFile(tf, mode='r') for finfo in zfile.infolist(): first = True ifile = zfile.open(finfo) trip = ifile.readlines() for line in trip: data = line.split(',') trip_duration=data[0].replace('"', '') start_lat = data[5].replace('"','') start_lon = data[6].replace('"', '') end_lat = data[9].replace('"','') end_lon = data[10].replace('"', '') #print(start_lat) if not trip_duration == 'tripduration': i = i+1 start_point = 'POINT(' + start_lat + ' ' + start_lon + ')' end_point = 'POINT(' + end_lat + ' ' + end_lon + ')' #print(start_point) new_trip = Trip( id = i, trip_duration = trip_duration, start_point = start_point, end_point = end_point) #print(new_trip) try: #print('Inside try') db.session.add(new_trip) #print('Added to db') db.session.commit() #print('Committed to database') except exc.IntegrityError: db.session.rollback()
def add_new_trip_to_db(destination, trip_name, start_date, end_date, notes): """Creates a new trip and stores in database.""" current_user = User.query.filter(User.email == session['logged_in']).first() user_id = current_user.user_id new_trip = Trip(user_id=user_id, destination=destination, trip_name=trip_name, start_date=start_date, end_date=end_date, notes=notes) db.session.add(new_trip) db.session.commit()
def load_trips(trips_filename): """Load trips from file into database.""" print("Trips") for i, row in enumerate(open(trips_filename)): row = row.rstrip() name, user_id, city_name = row.split("|") trip = Trip(name=name, user_id=int(user_id), city_name=city_name) # add user to the session db.session.add(trip) # commit session db.session.commit()
def get_trip_name(): """Create new trip in db, if one does not already exist.""" user_id = session['user_id'] if 'trip_name' in session: trip_name = session['trip_name'] new_trip = db.session.query(Trip).filter_by(trip_name=trip_name, user_id=user_id).one() else: # if not, get name from html and add to db trip_name = request.form.get('trip_name') new_trip = Trip(user_id=user_id, trip_name=trip_name) db.session.add(new_trip) session['trip_name'] = trip_name return new_trip
def save_places(): """Saves the places checked by the user.""" user_id = session["user_id"] user = User.query.get(user_id) saved_businesses = request.form.getlist("saved_businesses") city_id = request.form["city_id"] arrival_date = request.form["arrival_date"] departure_date = request.form["departure_date"] trip = Trip(user_id=user_id, city_id=city_id, arrival_date=arrival_date, departure_date=departure_date) db.session.add(trip) for business in saved_businesses: # get the name from the form business_name = request.form[business + '__name'] # get the label from the form business_label = request.form[business + '__label'] # get the date from the form business_date = request.form[business + '__date'] # get the url from the form business_url = request.form[business + '__url'] # check this place already exists in db place = Place.query.get(business) if place is None: place = Place(yelp_id=business, name=business_name, place_url=business_url) saved_place = SavedPlace(trip=trip, place=place, meal_datetime=business_date, meal_label=business_label) # save the place to the database db.session.add(place) db.session.add(saved_place) db.session.commit() session["user_id"] = user.user_id return redirect("/users/{}".format(user.user_id))
def add_trip(): """add trip details to database""" trip_name = request.form.get("trip_name") print("trip name:") print(trip_name) start_trip = request.form.get("start_trip") end_trip = request.form.get("end_trip") is_public = request.form.get("is_public") if (is_public == 'True'): is_public = True else: is_public = False is_admin = True new_trip = Trip(trip_name=trip_name, start_trip=start_trip, end_trip=end_trip, is_public=is_public) db.session.add(new_trip) db.session.commit() session["current_trip_id"] = new_trip.trip_id session["current_trip_name"] = new_trip.trip_name # connecting the new trip to the cuerrent user through user_trip tableS new_user_trip = UserTrip(user_id=session["current_user_id"], trip_id=session["current_trip_id"], is_admin=is_admin) db.session.add(new_user_trip) db.session.commit() # my_trip_ids=[] # current_user.trips = UserTrip.query.filter(UserTrip.user_id==session["current_user_id"]).all() # for user_trip in current_user.trips: # print("going over each trip") # # user_trip = UserTrip.query.filter(UserTrip.user_id==user_id, UserTrip.trip_id==trip.trip_id).first() # if user_trip.is_admin: # # my_trips.append(trip) # my_trip_ids.append(user_trip.trip_id) # # else: # # followed_trips.append(user_trip.trip_id) # my_trip_ids = tuple(my_trip_ids) # session["my_trip_ids"] = my_trip_ids # return redirect("/search/{}".format(trip_name)) return redirect("/search")
def add_trip(user_id): '''adds trip board for user for city from form input''' trip_name = request.form.get('name') city_name = request.form.get('city') # check if user input city is a valid city in the database if cityname_is_valid(city_name): # add trip to the database for current user city = city_name.strip().title() trip = Trip(name=trip_name, user_id=user_id, city_name=city) db.session.add(trip) db.session.commit() else: flash('Sorry, that city is not available in the database.') return redirect(url_for('userhome', user_id=user_id))
def create_trip(): """User creates a trip.""" if request.method == 'GET': activities = Activity.query.all() roles = Role.query.all() return render_template("createtrip_form.html", activities=activities, roles=roles) else: user_id = session["user_id"] current_user = User.query.filter_by(user_id=user_id).first() trip_name = request.form['trip_name'] departure_address = request.form['departure_address'] arrival_address = request.form['arrival_address'] trip_departure_at = request.form['trip_departure_at'] trip_arrival_at = request.form['trip_arrival_at'] car_capacity = request.form['car_capacity'] activity_id = request.form['recreation_activity'] role_id = request.form['role_id'] new_trip = Trip(trip_name=trip_name, departure_address=departure_address, arrival_address=arrival_address, trip_departure_at=trip_departure_at, trip_arrival_at=trip_arrival_at, car_capacity=car_capacity) db.session.add(new_trip) db.session.flush() new_user_trip = UserTrip(user_id=current_user.user_id, trip_id=new_trip.trip_id, role_id=role_id, activity_id=activity_id, request='active') db.session.add_all([new_trip, new_user_trip, current_user]) db.session.commit() return redirect("/userhome")
def create_trip(): """Route that will log new trip information to database""" if 'user' in session: username = session['user'] trip_name = request.form.get('tripname') date_created = datetime.datetime.now() date_start = request.form.get('datestart') num_days = int(request.form.get('numdays')) # Generate trip code here: trip_abbr = trip_name[:4].lower() print trip_abbr query_trips = Trip.query.all() for trip in query_trips: if trip.trip_code[:4] == trip_abbr: appx = int(trip.trip_code[4:]) print "appx is %i" % appx appx += 1 trip_code = trip_abbr + format(appx, "03") print trip_code break else: trip_code = trip_abbr + "000" # write new trip object to database: new_trip = Trip(trip_code=trip_code, trip_name=trip_name, date_created=date_created, date_start=date_start, num_days=num_days) new_trip_log = UserTrip(trip_code=trip_code, user_id=username) # add trip objects to database and commit db.session.add(new_trip) db.session.commit() db.session.add(new_trip_log) db.session.commit() return json.dumps({'status': 'ok', 'user': username, 'tripCode': trip_code}) else: flash("You are not logged in. Please do so.") return redirect('/')
def show_itinerary(genre_code): """Give an itinerary including trips to a museum and eatery.""" museum = Museum.query.filter_by(genre_code=genre_code).first() location = museum.address1 + museum.address2 resp = get_restaurant(location) if resp == None: return "An error has occurred." restaurant_id, restaurant_name, restaurant_location1, restaurant_location2, restaurant_coordinates, restaurant_image = resp print resp restaurant_latitude = float(restaurant_coordinates['latitude']) restaurant_longitude = float(restaurant_coordinates['longitude']) if None in list(resp): return "An error has occurred" if 'user_id' in session: user_id = session["user_id"] trip = Trip(user_id=user_id, museum_id=museum.museum_id, restaurant_id=restaurant_id, restaurant_name=restaurant_name, restaurant_longitude=restaurant_longitude, restaurant_latitude=restaurant_latitude) db.session.add(trip) db.session.commit() return render_template("itinerary.html", museum=museum, restaurant_name=restaurant_name, restaurant_location1=restaurant_location1, restaurant_location2=restaurant_location2, restaurant_image=restaurant_image, trip=trip)
def add_trip(): """Add a trip.""" if request.form: city = request.form.get("city") state = request.form.get("state") print city print state new_trip = Trip(city=city, state=state) db.session.add(new_trip) db.session.flush() user = User.query.get(session["user_id"]) user_trip = UserTrip(user_id=user.user_id, trip_id=new_trip.trip_id) db.session.add(user_trip) db.session.commit() # print "Trip has been committed to db", new_trip # flash("Trip has been committed to db!") return jsonify({"state": state, "city": city}, trip_id=trip_id)
def load_trips(trips_filename): print("Trips") Trip.query.delete() for row in open(trips_filename): row = row.rstrip() trip_name, start_trip, end_trip, is_public = row.split(",") if (is_public == 'True'): is_public = True else: is_public = False trip = Trip(trip_name=trip_name, start_trip=start_trip, end_trip=end_trip, is_public=is_public) # We need to add to the session or it won't ever be stored db.session.add(trip) # Once we're done, we should commit our work db.session.commit()
def create_new_trip(): """Create a new Trip instance""" if "user_id" in session: trip_name = request.form.get("trip-name") accommodations = request.form.get("accommodations") creator_id = session.get("user_id") # Create new trip instance new_trip = Trip(trip_name=trip_name, creator_id=creator_id, trip_accommodations=accommodations) # If accommodations field was filled in, find the lat/long # and add the values to new_trip if accommodations: lat_long = call_geocoding_api(accommodations) if lat_long != "Invalid search terms": accomm_long = lat_long["lng"] accomm_lat = lat_long["lat"] new_trip.accom_lat = accomm_lat new_trip.accom_long = accomm_long db.session.add(new_trip) db.session.commit() # Add Trip_User instance for creator of the trip upon creation of the trip user_id = session.get("user_id") new_tu = Trip_User(trip_id=new_trip.trip_id, user_id=user_id) db.session.add(new_tu) db.session.commit() return redirect(f"/trip/{new_trip.trip_id}") else: flash("You need to be logged in to access that page") return redirect("/login")
def add_trips(): """User adding a trip""" user = session['user'] trip_name = request.args.get('trip').title().strip() trip_query = Trip.query.filter_by(trip_name=trip_name, user_id=user).all() trips = [] i = 0 while i < len(trip_query): trips.append(trip_query[i].trip_name) i += 1 if trip_name not in trips: trip = Trip(trip_name=trip_name, user_id=user) else: return redirect('/trips') db.session.add(trip) db.session.commit() return redirect('/trips')
def seed_user_trip(db): user = User(fname='Lynda', lname='Phan', email='*****@*****.**', password='******') trip = Trip(trip_name='Hawaii') user_trip = User_trip(trip_id=1, user_id=1) event = Event(event_id=1, trip_id=1, event_name='Summer 2020', event_date='2020-12-01') db.session.add(user) db.session.add(trip) db.session.add(user_trip) db.session.add(event) db.session.commit() return user
def validate_trip(): """Allow user to create a new trip""" email = session.get('email') user = User.query.filter_by(email=email).first() trip_name = request.form.get('trip-name') start_date = request.form.get('start-date') end_date = request.form.get('end-date') new_trip = Trip(creator_id=user.user_id, trip_name=trip_name, start_date=start_date, end_date=end_date) db.session.add(new_trip) db.session.commit() return redirect( url_for('trip_itinerary', trip_name=new_trip.trip_name, trip_id=new_trip.trip_id))
def add_trips(): """Add trip data to the trips table.""" # t1 = Trip( # trip_zipcode= "94805", # user_id= 1, # wishlist = "Apples, berries, sweet potatoes", # item_progress= "En Route" # ) # db.session.add(t1) # db.session.commit() # print(f'created trips {t1}') """Load trip information from seed file into the database. working code. """ print("trips") # opening seed file with the csv library and csv reader. with open('seed_files/Trip_seed_v1.csv') as csv_file: csv_reader = csv.reader(csv_file, delimiter=',') line_count = 0 for row in csv_reader: if line_count == 0: # print(f'Column names are {", ".join(row)}') line_count += 1 else: trip = Trip(trip_zipcode=row[1], user_id=int(row[2]), wishlist=row[3], item_progress=row[4]) db.session.add(trip) line_count += 1 db.session.commit() print(f'created {line_count} trips')
def create_wishlist(): """Get asker's wishlist and zipcode to save in database.""" new_wishlist = request.args.get('wishlist') zipcode = request.args.get('zipcode') asker = session.get("user_id") status = "incomplete" # if not Trip.query.filter_by(trip=username).all(): new_trip = Trip(user_id=asker, wishlist=new_wishlist, trip_zipcode=zipcode, item_progress=status) db.session.add(new_trip) db.session.commit() session["trip_id"] = new_trip.trip_id flash("Successfully created a wishlist!") print("200") return redirect("/asker-homepage")
def store_trips(): """Add each trip search to the DB.""" user_id = session.get('username', 0) search = Search(user_id=user_id) db.session.add(search) db.session.flush() trip1 = json.loads(request.form['trip1']) trip2 = json.loads(request.form['trip2']) trips = [trip1, trip2] for trip in trips: trip = Trip(city_id=trip['cityId'], search_id=search.search_id, avg_temp=trip['weather'], wow_factor=trip['wow'], michelin_stars=trip['stars'], airfare=trip['airfare']) db.session.add(trip) db.session.commit() return 'success'
def seed_test_data(): "Seed the tests." f = "%Y-%m-%d %H:%M:%S" place1 = Place( yelp_id="Z0r83lDOA1mI8RpNccXtHw", name="The Fat Bear", place_url= "https://www.yelp.com/biz/the-fat-bear-london?adjust_creative=xRkF2ozLJzv0Tl0J-wOpZQ&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=xRkF2ozLJzv0Tl0J-wOpZQ" ) place2 = Place( yelp_id="7Pc6VXiWEqc4JbgrH4U3tA", name="Rocca", place_url= "https://www.yelp.com/biz/rocca-london?adjust_creative=xRkF2ozLJzv0Tl0J-wOpZQ&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=xRkF2ozLJzv0Tl0J-wOpZQ" ) place3 = Place( yelp_id="K_dDxWgagylIvuB2oQy1KQ", name="The Black Penny", place_url= "https://www.yelp.com/biz/the-black-penny-london?adjust_creative=xRkF2ozLJzv0Tl0J-wOpZQ&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=xRkF2ozLJzv0Tl0J-wOpZQ" ) place4 = Place( yelp_id="0B-ag3J18TatG9H9EQohGg", name="Hawksmoor Seven Dials", place_url= "https://www.yelp.com/biz/hawksmoor-seven-dials-london-4?adjust_creative=xRkF2ozLJzv0Tl0J-wOpZQ&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=xRkF2ozLJzv0Tl0J-wOpZQ" ) place5 = Place( yelp_id="BjPq77aiaKZAVUHIu2S3gA", name="The English Rose Cafe and Tea Shop", place_url= "https://www.yelp.com/biz/the-english-rose-cafe-and-tea-shop-london?adjust_creative=xRkF2ozLJzv0Tl0J-wOpZQ&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=xRkF2ozLJzv0Tl0J-wOpZQ" ) place6 = Place( yelp_id="5sEiM_Xw5jXbMhloNqSgYQ", name="Grumbles", place_url= "https://www.yelp.com/biz/grumbles-london?adjust_creative=xRkF2ozLJzv0Tl0J-wOpZQ&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=xRkF2ozLJzv0Tl0J-wOpZQ" ) place7 = Place( yelp_id="cgkDnzaQvP9q-JHXd-ECcA", name="Cambridge Street Kitchen", place_url= "https://www.yelp.com/biz/cambridge-street-kitchen-london?adjust_creative=xRkF2ozLJzv0Tl0J-wOpZQ&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=xRkF2ozLJzv0Tl0J-wOpZQ" ) place8 = Place( yelp_id="-ylzTrYtRJUJa2BuAInoyQ", name="Friends of Ours", place_url= "https://www.yelp.com/biz/friends-of-ours-london?adjust_creative=xRkF2ozLJzv0Tl0J-wOpZQ&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=xRkF2ozLJzv0Tl0J-wOpZQ" ) trip1 = Trip(user_id=1, city_id=2, arrival_date=datetime.strptime('2018-03-07 12:00:00', f), departure_date=datetime.strptime('2018-03-13 23:00:00', f)) trip2 = Trip(user_id=2, city_id=1, arrival_date=datetime.strptime('2018-04-10 10:00:00', f), departure_date=datetime.strptime('2018-04-15 15:00:00', f)) trip3 = Trip(user_id=1, city_id=3, arrival_date=datetime.strptime('2018-04-19 14:00:00', f), departure_date=datetime.strptime('2018-04-22 12:00:00', f)) saved_place1 = SavedPlace(place=place1, trip=trip1, meal_datetime=datetime.strptime( '2018-03-07 00:00:00', f), meal_label="lunch") saved_place2 = SavedPlace(place=place2, trip=trip1, meal_datetime=datetime.strptime( '2018-03-07 00:00:00', f), meal_label="dinner") saved_place3 = SavedPlace(place=place3, trip=trip1, meal_datetime=datetime.strptime( '2018-03-08 00:00:00', f), meal_label="lunch") saved_place4 = SavedPlace(place=place4, trip=trip1, meal_datetime=datetime.strptime( '2018-03-09 00:00:00', f), meal_label="breakfast") saved_place5 = SavedPlace(place=place5, trip=trip2, meal_datetime=datetime.strptime( '2018-04-12 00:00:00', f), meal_label="breakfast") saved_place6 = SavedPlace(place=place6, trip=trip2, meal_datetime=datetime.strptime( '2018-04-13 00:00:00', f), meal_label="lunch") saved_place7 = SavedPlace(place=place7, trip=trip3, meal_datetime=datetime.strptime( '2018-04-20 00:00:00', f), meal_label="dinner") saved_place8 = SavedPlace(place=place8, trip=trip3, meal_datetime=datetime.strptime( '2018-04-21 00:00:00', f), meal_label="lunch") db.session.add_all([ place1, place2, place3, place4, place5, place6, place7, place8, trip1, trip2, trip3, saved_place1, saved_place2, saved_place3, saved_place4, saved_place5, saved_place6, saved_place7, saved_place8 ]) db.session.commit()
last_name='Ouali', email='*****@*****.**', password='******', zipcode='94116', phone_number='12345678901') henry = User(user_id='hlin', first_name='Henry', last_name='Lin', email='*****@*****.**', password='******', zipcode='94117', phone_number='12345678901') # Add Trips yos = Trip(trip_code='yose000', trip_name='Yosemite Winter Backpacking', date_created=datetime.datetime.now(), date_start=datetime.datetime.now()) bv = Trip(trip_code='bear000', trip_name='Bear Valley Winter Backpacking', date_created=datetime.datetime.now(), date_start=datetime.datetime.now()) kc = Trip(trip_code='king000', trip_name='King Canyon Summer Backpacking', date_created=datetime.datetime.now(), date_start=datetime.datetime.now()) trip1 = UserTrip(trip_code='yose000', user_id='eagle5') trip2 = UserTrip(trip_code='bear000', user_id='eagle5') trip3 = UserTrip(trip_code='king000', user_id='eagle5') trip4 = UserTrip(trip_code='yose000', user_id='souali')