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')
