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)
