def setUp(self): self.asia = Continent("Asia", 1) self.europe = Continent("Europe", 2) self.scotland = Country("Scotland", self.europe, 1) self.singapore = Country("Singapore", self.asia, 2) self.iceland = Country("Iceland", self.europe, 3) self.no_id = Country("No Id", self.europe)
def setUp(self): self.europe = Continent("Europe", 2) self.scotland = Country("Scotland", self.europe, 1) self.iceland = Country("Iceland", self.europe, 3) self.glencoe = Location("Glencoe", "This is stunning location, i need to see it", False, self.scotland, 1) self.godafoss = Location("Godafoss", "The most amazing waterfall i have ever seen", True, self.iceland, 2) self.no_id = Location("No id", "locaiton without id", True,self.scotland)
def select(id): sql = "SELECT * FROM countries WHERE id = %s" values = [id] result = run_sql(sql, values)[0] if result is not None: country = Country(result['name'], result['id']) return country
def create_country(): name = request.form["name"] continent = request.form["continent"] country = Country(name, continent) country_repository.save(country) return redirect("/countries")
def update_country(id): name = request.form["name"] continent = request.form["continent"] country = Country(name, continent, id) country_repository.update(country) return redirect(f"/countries/{id}")
def getPieData(): countryName = request.form["name"] print(countryName) country_info = Country().one(name=countryName) APIType = country_info.APIType level = country_info.level names = [] results = [] if APIType == 'basic': if level == 'country': # 国内各省 result = ChinaStatus.all(city='all') for item in result: if item.nowConfirm == 0: continue names.append(item.province) results.append({"name": item.province, "value": item.nowConfirm}) elif level == 'province': # 省内各市 result = ChinaStatus.all(province=countryName) for city_info in result: if city_info.name != 'all': names.append(city_info.name) results.append({"name": city_info.city, "value": city_info.nowConfirm}) elif APIType == 'foreign': if level == 'country': result = GlobalStatus.all(country=countryName) for pro_info in result: if pro_info.province != 'all' and pro_info.nowConfirm >= 0: names.append(pro_info.province) results.append({"name": pro_info.province, "value": pro_info.nowConfirm}) else: print("error province search name.") return jsonify({"data": results, "name": names})
def setUp(self): self.europe = Continent("Europe", 2) self.scotland = Country("Scotland", self.europe, 1) self.iceland = Country("Iceland", self.europe, 3) self.glencoe = Location("Glencoe", "This is stunning location, i need to see it", False, self.scotland, 1) self.godafoss = Location( "Godafoss", "The most amazing waterfall i have ever seen", True, self.iceland, 2) self.glencoe_photo = Photo("devils_pulpit.jpg", True, self.glencoe, 1) self.godafoss_photo_01 = Photo("marina_sands01.jpg", True, self.godafoss, 2) self.godafoss_photo_02 = Photo("marina_sands01.jpg", True, self.godafoss)
def select_all(): countries = [] sql = "SELECT * FROM countries" results = run_sql(sql) for row in results: country = Country(row['name'], row['id']) countries.append(country) return countries
def my_account_settings(): user_data_admin = session.get('user_data_admin', None) return render_template( "module_admin/settings.html", countries=Country.select_countries(connection), logged_in=True, user=json.loads(user_data_admin) if user_data_admin else None)
def create_city(): name = request.form["new_city_name"] country = request.form["new_city_country"] new_country = Country(country) persistent_country = country_repo.save(new_country) new_city = City(name, persistent_country) city_repo.save(new_city) return redirect("/cities")
class EditStateForm(FlaskForm): id = TextField("Id", [validators.Required("Please enter id of state.")]) name = TextField("Name", [validators.Required("Please enter state name.")]) country = SelectField("Country", choices=[(data['id'], data['name']) for data in Country.list()]) country_id = TextField( "Country Id", [validators.Required("Please enter id of country.")])
def select_all(): # working countries = [] sql = "SELECT * FROM countries" results = run_sql(sql) for row in results: # taking entries from database and attaching to a new country instance (arguments based on class parameters) country = Country(row['name'], row['visited'], row['id']) countries.append(country) return countries
def create_country(): continent_id = request.form['continent_id'] name = request.form["name"] continent = continent_repository.select(continent_id) visited = False new_country = Country(name, continent, visited) country_repository.save(new_country) country_id = new_country.id return redirect(f"/countries/{country_id}")
def create_country(): country_name = request.form['country_name'] country_population = request.form['country_population'] country_visited = False if 'country_visited' in request.form: country_visited = True country = Country(country_name, country_population, country_visited) country_repository.save(country) return redirect('/countries')
def get_country(): country_data = Country.list() if len(country_data) > 0: return jsonify({"country": country_data}), 200 else: return jsonify({ "error": True, "message": "No data present for countries" }), 200
def select(id): country = None sql = "SELECT * FROM countries WHERE id = %s" values = [id] result = run_sql(sql, values)[0] if result is not None: country = Country(result['country_name'], result['country_population'],result['country_visited'], result['id']) return country
def select_all(): countries_list = [] sql = "SELECT * FROM countries" results = run_sql(sql) for row in results: country = Country(row["name"], row["continent"], row['id']) countries_list.append(country) return countries_list
def select_all(): countries = [] # when I list countries I want them to be alphabetical order each time sql = "SELECT * FROM countries ORDER BY name ASC" results = run_sql(sql) for row in results: country = Country(row['name'], row['continent'], row['id']) countries.append(country) return 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 update_country(id): country_name = request.form['country_name'] country_population = request.form['country_population'] country_visited = False print(request.form) if 'visited' in request.form: country_visited = True print(request.form) country = Country(country_name, country_population, country_visited, id) country_repository.update(country) return redirect("/countries")
def select_all(): countries = [] sql = "SELECT * FROM countries" results = run_sql(sql) for row in results: continent = continent_repository.select(row['continent_id']) country = Country(row['name'], continent, row['visited'], row['id']) countries.append(country) return countries
def select(id): country = None sql = "SELECT * FROM countries WHERE id = %s" values = [id] result = run_sql(sql, values)[0] if result is not None: continent = continent_repository.select(result['continent_id']) country = Country(result['name'], continent, result['visited'], result['id']) return country
def create_trip(): city_id = request.form["city_id"] country_id = request.form["country_id"] sight_id = request.form["sight_id"] to_visit = request.form["to_visit"] new_city = City("name", city_id) new_country = Country("country", country_id) new_sight = Sight("sight", sight_id) trip = Visit(new_city, new_country, new_sight, to_visit) visit_repository.save(trip) return redirect("/trips")
def view_country(id): country = country_repository.select(id) all_vu_points = country_repository.vu_points(country) for vu_point in all_vu_points: # by doing on this route, it takes account of edits and new vu's if vu_point.visited == True: country = Country(country.name, True, id) country_repository.update(country) return render_template("countries/view.html", country=country, all_vu_points=all_vu_points)
def select(id): country = None sql = "SELECT * FROM countries WHERE id = %s" values = [id] result = run_sql(sql, values)[0] if result is not None: name = result['name'] continent = result['continent'] country_id = result['id'] country = Country(name, continent, country_id) return country
def select(id): country = None sql = "SELECT * FROM countries WHERE id = %s" values = [id] result = run_sql(sql, values)[0] if result is not None: country = Country(result["name"], result["population"], result["language_spoken"], result["currency_used"], result["average_temperature"], result["id"], result["visited"]) return country
def select(id): # create sql query without values sql = "SELECT * FROM countries 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 country = Country(result["name"], continent_repository.select(result['continent_id']), result["id"]) # return the result return country
def create_country(): print(request.form) name = request.form["name"] population = request.form["population"] language_spoken = request.form["language_spoken"] currency_used = request.form["currency_used"] average_temperature = request.form["average_temperature"] visited = request.form["visited"] country = Country(name, population, language_spoken, currency_used, average_temperature, visited) print(vars(country)) country_repository.save(country) return redirect("/countries")
def update_country(id): print(request.form) name = request.form["name"] population = request.form["population"] language_spoken = request.form["language_spoken"] currency_used = request.form["currency"] average_temperature = request.form["temperature"] visited = request.form["visited"] country = Country(name, population, language_spoken, currency_used, average_temperature, id, visited) print(vars(country)) country_repository.update(country) return redirect("/bucketlist")
def statis(name): # 提供国内的省级/国外的国家级数据查询 typename = Country.one(name=name) typename = typename.APIType if typename == 'basic': data = ChinaStatus.one(province=name) elif typename == 'foreign': data = GlobalStatus.one(country=name) time = data.updateTime statis_data = data u = current_user() return render_template('./dashboard/statis.html', l='p', n=name, t=time, sd=statis_data, u=u, cd=statis_data)