def lender_dashboard(lender_email): """Lender profile to view their posted gear and upload equipment""" lender = Lender.query.filter_by(lender_email=lender_email).first() camper_email = session.get("camper_email") if camper_email: raise Exception( "Hey there, camper! If you want to lend gear out, please log in separately." ) if request.method == 'GET': return render_template("lender.html", lender=lender) else: category = request.form.get('category_type') brand = request.form.get('brand_type') gear_name = request.form.get('gear_name') zipcode = request.form.get('zipcode') gear_photo = request.form.get('photo') filename = photos.save(request.files['photo']) gear_photo = str(photos.path(filename)) gear_photo_url = photos.url(filename) gear = Equipment(gear_name=gear_name, category=category, brand=brand, lender_email=lender_email, zipcode=zipcode, gear_photo=gear_photo, gear_photo_url=gear_photo_url) db.session.add(gear) db.session.commit() flash('You successfully uploaded your gear!') return redirect("/equipment/%s" % lender.lender_email)
def load_equipment(): equipment_result_list = call_api('equipment') for result_dict in equipment_result_list: equipment_id = result_dict['id'] equipment_name = result_dict['name'] equipment = Equipment(equipment_id=equipment_id, equipment_name=equipment_name) db.session.add(equipment) db.session.commit()
def add_equipment(recipe, equipment): """Add recipe's equipment, one by one, to database.""" # Instantiate a recipe's equipment equipment = Equipment(recipe_id=recipe, equipment=equipment) # add to database db.session.add(equipment) db.session.commit() return
def load_equips(): """Load equipments from equip_data into database.""" for line in open("seed_data/equip_data"): line = line.rstrip() equip_id, user_id, name, ein, eq_type = line.split(",") equip = Equipment(equip_id=equip_id, user_id=user_id, name=name, ein=ein, eq_type=eq_type) db.session.add(equip) db.session.commit()
def add_equip(): """Add equipment to database.""" name = request.form.get("name") ein = request.form.get("ein") eq_type = request.form.get("type") existing_equip = Equipment.query.filter_by(name=name).first() new_equip = Equipment(user_id=g.user_id, name=name, ein=ein, eq_type=eq_type) check_and_add(existing_equip, new_equip) return redirect(request.referrer)
def load_equipment(): """ Load equipment into database. """ for row in open("static/equipment.csv"): row = row.rstrip() gear_name, category, brand, lender_email, zipcode, gear_photo, gear_photo_url = row.split( ",") equipment = Equipment(gear_name=gear_name, category=category, brand=brand, lender_email=lender_email, zipcode=zipcode, gear_photo=gear_photo, gear_photo_url=gear_photo_url) db.session.add(equipment) db.session.commit()