def select(id):
sql = "SELECT * FROM cities WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
country = country_repository.select(result["country_id"])
city = City(result["name"], country, result["visited"], result["id"])
return city
def locations_add():
new_location = Location(
request.form['name'], request.form['description'],
request.form['visited'],
country_repository.select(request.form['country_id']))
location_repository.save(new_location)
return redirect('/locations/view')
def create_destination():
destination_name = request.form['destination_name']
country_id = request.form['country_id']
country = country_repository.select(country_id)
destination = Destination(destination_name, country)
destination_repository.save(destination)
return redirect('/destinations')
def update_country(id):
name = request.form["name"]
continent = request.form["continent"]
country_visited = country_repository.select(id)
country = Country(name, continent, country_visited.visited, id)
country_repository.update(country)
return redirect("/countries")
def locations_update():
country = country_repository.select(request.form['country_id'])
updated_location = Location(request.form['location_name'],
request.form['location_description'],
request.form['location_visited'], country,
request.form['location_id'])
location_repository.update(updated_location)
return redirect('/locations/view')
def update_city(id):
name = request.form['name']
country_id = request.form['country_id']
visited = request.form['visited']
country = country_repository.select(country_id)
city = City(name, country, visited, id)
city_repository.update(city)
return redirect('/list-destinations')
def create_city():
name = request.form["name"]
country_id = request.form["country_id"]
visited = request.form["visited"]
country = country_repository.select(country_id)
new_city = City(name, country, visited)
city_repository.save(new_city)
return redirect("/cities")
def update_city(id):
name = request.form["name"]
country_id = request.form["country_id"]
visited = request.form["visited"]
country = country_repository.select(country_id)
city = City(name, country, visited, id)
city_repository.update(city)
return redirect("/cities")
def edit_country(id):
continents = continent_repository.select_all()
country = country_repository.select(id)
sel_continent = country.continent.id
return render_template("countries/edit.html",
country=country,
sel_continent=sel_continent,
continents=continents)
def show_country(id):
sights = sight_repository.sights(id)
cities = city_repository.cities(id)
country = country_repository.select(id)
return render_template("countries/show.html",
country=country,
cities=cities,
sights=sights)
def create_city():
new_city = request.form['name']
country_id = request.form['country_id']
visited = request.form['visited']
country = country_repository.select(country_id)
city = City(new_city, country, visited)
city_repository.save(city)
return redirect('/list-destinations')
def create_city():
city_name = request.form['city_name']
# visited = request.form['visited']
country_id = request.form['country_id']
country = country_repository.select(country_id)
city = City(city_name, country)
city_repository.save(city)
return redirect('/countries')
def update_city(id):
name = request.form["name"]
city_type = request.form["city_type"]
visited = request.form["visited"]
country = country_repository.select(request.form["country_id"])
city = City(name, city_type, country, id, visited)
city_repository.update(city)
return redirect('/bucketlist')
def create_city():
name = request.form["name"]
city_type = request.form["city_type"]
visited = request.form["visited"]
country = country_repository.select(request.form["country_id"])
city = City(name, city_type, country, id, visited)
city_repository.save(city)
return redirect('/cities')
def select(id): # working
locations = None
sql = "SELECT * FROM locations WHERE id = (%s)"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
country = country_repository.select(result['country_id'])
location = Location(result['name'], country, result['id'])
return location
def select_all():
cities = []
sql = "SELECT * FROM cities"
results = run_sql(sql)
for result in results:
country = country_repository.select(result["country_id"])
city = City(result["name"], country, result["visited"], result["id"])
cities.append(city)
return cities
def create_city():
name = request.form['name']
country_id = request.form['country_id']
country = country_repository.select(country_id)
visited = False
comment = request.form['comment']
new_city = City(name, country, visited, comment)
city_repository.save(new_city)
return redirect(f"/countries/{country_id}")
def select_all(): # working
locations = []
sql = "SELECT * FROM locations"
results = run_sql(sql)
for row in results:
country = country_repository.select(row['country_id'])
location = Location(row['name'], country, row['id'])
locations.append(location)
return locations
def add_city_to_country():
city_name = request.form['city_name']
country_id = request.form['country']
country = country_repository.select(country_id)
city = City(city_name, country)
city_repository.save(city)
return redirect('/countries')
def update_country(id):
name = request.form['name']
continent_id = request.form['continent_id']
continent = continent_repository.select(continent_id)
country = country_repository.select(id)
visited = country.visited
updated_country = Country(name, continent, visited, id)
country_repository.update(updated_country)
country_id = country.id
return redirect(f"/countries/{country_id}")
def edit_vu(id, id2):
# id2 is being passed the vu_point.id
# so we can pass that in to the select(id) to get the vu_point we're looking at
country = country_repository.select(id)
vu_point = vu_point_repository.select(id2)
# all_locations = location_repository.select_all()
# all_vu_points = country_repository.vu_points(country)
return render_template("vu_points/edit.html",
country=country,
vu_point=vu_point)
def select(id):
city = None
sql = "SELECT * FROM cities WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
country = country_repository.select(result["country_id"])
city = City(result['name'], country, result['visited'], result['id'])
return city
def select(id):
city = None
sql = "SELECT * FROM cities WHERE id = %s"
values = [id]
result = run_sql(sql, values)
for row in result:
country = country_repository.select(row["country_id"])
city = City(row["name"], country, row['visited'], row["id"])
return city
def select(id):
# create sql query without values
sql = "SELECT * FROM locations WHERE id = %s"
# create list with values required by sql query
values = [id]
# execute sql query
result = run_sql(sql, values)[0]
# convert return which is a single element list of dictionaries into a continent object
location = Location(result["name"], result["description"], result["visited"], country_repository.select(result['country_id']),result["id"])
# return the result
return location
def select_all():
city_list = []
sql = "SELECT * FROM cities"
results = run_sql(sql)
for row in results:
country = country_repository.select(row["country_id"])
city = City(row["name"], country, row['visited'], row['id'])
city_list.append(city)
return city_list
def select(id):
place = None
sql = "SELECT * FROM places where id = %s"
values = [id]
result = run_sql(sql,values)[0]
if result is not None:
country = country_repository.select(result['country_id'])
place_type = place_type_repository.select(result['place_type_id'])
place=Place(result['place_name'],result['description'],place_type,country,result['visited'],result['rating'], result['id'])
return place
def select_all():
places = []
sql = "SELECT places.* FROM places inner join countries on places.country_id = countries.id order by countries.name, places.place_name"
results = run_sql(sql)
for row in results:
country = country_repository.select(row["country_id"])
place_type = place_type_repository.select(row["place_type_id"])
place=Place(row['place_name'],row['description'],place_type,country,row['visited'],row['rating'], row['id'])
places.append(place)
return places
def create_destination_from_id(country_id):
country = country_repository.select(country_id)
destination = destination_repository.select_all()
# destination_name = request.form['destination']
# country = destination_repository.select(destination.country.id)
# visited = request.form['visited']
# destination = Destination(destination_name, country, visited)
# destination_repository.save(destination)
return render_template('destination/index.html',
country=country,
destinations=destination)
def view_vu(id, id2):
# id2 is being passed the vu_point.id
# so we can pass that in to the select(id) to get the vu_point we're looking at
country = country_repository.select(id)
vu_point = vu_point_repository.select(id2)
all_vu_points = country_repository.vu_points(country)
return render_template("vu_points/view.html",
country=country,
vu_point=vu_point,
all_vu_points=all_vu_points)
def select_all_unvisited():
sql = "SELECT * FROM cities WHERE visited = 'f'"
results = run_sql(sql)
cities = []
for row in results:
country = country_repository.select(row['country_id'])
city = City(row['city_name'], country, row['date_of_travel'],
row['visited'], row['id'])
cities.append(city)
return cities
