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