def ModifyAddresses():
conn = dbconn()
# retrieve all addresses
# addresses = conn.execute_read_query("SELECT * FROM addresses")
# address = addresses[0]
# retrieve isp plan and occupant
# isp = conn.execute_read_query("SELECT * FROM ISPs")[0][0]
# occupant = conn.execute_read_query("SELECT * FROM people")[0][0]
if request.method == 'POST':
address_street = request.form['street']
address_city = request.form['city']
address_state = request.form['state']
address_postal_code = request.form['postal_code']
address_country = request.form['country']
isp = request.form['plan_id'] # hidden ISP Plan
occupant = request.form['Occupant']
address = Address(conn) # Address object
address.add_address(address_street, address_city, address_state,
address_postal_code, address_country, isp,
occupant)
# addresses = conn.execute_read_query("SELECT * FROM addresses")
return redirect("/addresses/list")
return render_template('address.html')
