def add_members(trip_code):
"""Add members to trip """
user_id = request.form.get("memberid")
print "user ID: %s" % user_id
new_member = UserTrip(trip_code=trip_code, user_id=user_id)
db.session.add(new_member)
db.session.commit()
session['changes'] = session.get('changes', '') + trip_code + ','
return redirect("/trip_detail/"+trip_code)
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 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 join_trip():
"""User joins a trip."""
current_user = User.query.filter_by(user_id=session['user_id']).first()
trip_id = request.form['trip_id']
trip = Trip.query.filter_by(trip_id=trip_id).first()
user_trip = UserTrip.query.filter_by(trip_id=trip.trip_id).first()
passenger_role = Role.query.filter_by(role='Passenger').first()
new_user_trip = UserTrip(user_id=current_user.user_id,
trip_id=trip.trip_id,
role_id=passenger_role.role_id,
activity_id=user_trip.activity_id,
request='pending')
db.session.add_all([new_user_trip, current_user])
db.session.commit()
return redirect("/requestconfirmation")
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 create_user_trip():
"""Add user to ride in the database."""
trip_id = request.form['trip']
user_id = session.get('user_id')
trip = Trip.query.filter(Trip.trip_id == trip_id).one()
# Ensure there is still space before adding to current passengers
if trip.num_passengers < trip.max_passengers:
trip.num_passengers += 1
new_user_trip = UserTrip(trip_id=trip_id, user_id=user_id)
db.session.add(new_user_trip)
db.session.commit()
flash("Ride joined!")
return redirect('/')
else:
flash("Sorry, ride is already full!")
return redirect('/')
def make_follower():
"""makes user a follower of trip"""
#make request to get information about trip and user from form
# make query to get row in user-trips table
# change is_admin in that row
# add and commit to database
# redirect to followers route
current_trip_id = session["current_trip_id"]
# user_id = session["current_user_id"]
# get user_id from form
user_id = request.form.get("user_id")
# print("making query to db")
new_user_trip = UserTrip(user_id=user_id,
trip_id=current_trip_id,
is_admin=False)
db.session.add(new_user_trip)
db.session.commit()
return redirect("/followers")
def load_user_trips(user_trips_filename):
print("UserTrips")
UserTrip.query.delete()
for row in open(user_trips_filename):
row = row.rstrip()
user_id, trip_id, is_admin = row.split(",")
if (is_admin == '1'):
is_admin = True
else:
is_admin = False
user_trip = UserTrip(user_id=user_id,
trip_id=trip_id,
is_admin=is_admin)
# We need to add to the session or it won't ever be stored
db.session.add(user_trip)
# Once we're done, we should commit our work
db.session.commit()
# 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')
trip5 = UserTrip(trip_code='bear000', user_id='souali')
trip6 = UserTrip(trip_code='king000', user_id='souali')
trip7 = UserTrip(trip_code='yose000', user_id='hlin')
trip8 = UserTrip(trip_code='bear000', user_id='hlin')
trip9 = UserTrip(trip_code='king000', user_id='hlin')
mess1 = Comment(trip_code='yose000',
user_id='eagle5',
comment="We should take my car",
time=datetime.datetime.now())