def unescokind():
json_data = request.get_json()
operation = operationmysql()
sql = 'select UNESCOname from UNESCOkind where UNESOkind = %s'
values = (json_data["kind"], )
data = operation.search(sql=sql, values=values)
data = {"code": 4, "data": data}
return jsonify(data)
def search():
json_data = request.get_json()
opration = operationmysql()
sql = 'select UNESCOname, detail, img_src from UNESCOlist where UNESCOname = %s'
values = (json_data["UNESCOname"], )
result = opration.search(sql=sql, values=values)
data = {"code": 2, "data": result}
return jsonify(data)
def list():
sql = 'select name,time, img_src,sdetail from UNESCOnews where year = 2020;'
opration = operationmysql()
result = opration.search(sql=sql)
data = {
"code": 1,
"data": result
}
return jsonify(data)
def datail():
json_data = request.form.to_dict()
result = []
if json_data != {}:
operation = operationmysql()
sql = 'select UNESCOname, detail, img_src, utime,country_name from UNESCOlist,countrylist where UNESCOname = %s and UNESCOlist.country_number = countrylist.country_number'
values = (json_data["name"], )
result = operation.search(sql=sql, values=values)
data = {"data": result}
return jsonify(data)
def search():
json_data = request.get_json()
operation = operationmysql()
sql = 'select name,detail,img,aera from UNESCOpreminary where name = %s'
values = (json_data['name'],)
result = operation.search(sql=sql, values=values)
data = {
"code": 3,
"data": result
}
return jsonify(data)
def detail():
json_data = request.form.to_dict()
sql = 'select name,time, Detail,dsrc,year from UNESCOnews where name = %s'
operation = operationmysql()
values = (json_data["name"],)
result = operation.search(sql=sql, values=values)
data = {
"code": 3,
"data": result
}
return jsonify(data)
def year():
json_data = request.get_json()
sql = 'select name,time, img_src,sdetail from UNESCOnews where year = %s'
opration = operationmysql()
values = (json_data['year'],)
result = opration.search(sql=sql, values=values)
data = {
"code": 2,
"data": result
}
return jsonify(data)
def contrylist():
json_data = request.form.to_dict()
result = []
if json_data != None:
operation = operationmysql()
sql = 'select UNESCOnumber,UNESCOname, country_name,utime from UNESCOlist, countrylist where UNESCOlist.country_number = countrylist.country_number and countrylist.country_name= %s;'
values = (json_data["countryname"], )
result = operation.search(sql=sql, values=values)
print(result)
data = {"code": 3, "data": result}
return jsonify(data)
def landing():
json_data = request.get_json()
opration = operationmysql()
sql = 'select pwd from user where username = %s'
values = (json_data["username"], )
result = opration.search(sql=sql, values=values)
data = {
"code": 0,
}
if result != None:
if result[0]["pwd"] == json_data['pwd']:
data["code"] = 1
return jsonify(data)
def get_UNESCO_list():
json_data = request.form.to_dict()
print(json_data)
opration = operationmysql()
if json_data["countryname"] != 'undefined':
sql = 'select UNESCOnumber,UNESCOname, country_name,utime from UNESCOlist, countrylist where UNESCOlist.country_number = countrylist.country_number and countrylist.country_name= %s;'
values = (json_data["countryname"], )
result = opration.search(sql=sql, values=values)
else:
sql = 'select UNESCOnumber,UNESCOname, country_name,utime from UNESCOlist, countrylist where UNESCOlist.country_number = countrylist.country_number;'
result = opration.search(sql=sql)
data = {"code": 1, "data": result}
return jsonify(data)
def List():
operation = operationmysql()
sql = 'select kind, name, time, province from successUNESCO'
result = operation.search(sql=sql)
List = []
for j in result:
i = list(j)
if i[0] == 1:
i[0] = '文化遗产'
elif i[0] == 2:
i[0] = '文化景观遗产'
elif i[0] == 3:
i[0] = '自然遗产'
elif i[0] == 4:
i[0] = '文化与自然双重遗产'
List.append(i)
data = {
"code": 1,
"data": List
}
return jsonify(data)
def pre_list():
operation = operationmysql()
sql = 'select number, kind, name, aera from UNESCOpreminary'
result = operation.search(sql=sql)
List = []
for i in result:
if i['kind'] == 1:
i['kind'] = '中国世界遗产预备名录确定申请世界遗产项目'
elif i['kind'] == 2:
i['kind'] = '中国文化遗产预备名录'
elif i['kind'] == 3:
i['kind'] = '中国文化景观遗产预备名录'
elif i['kind'] == 4:
i['kind'] = '中国自然遗产预备名录'
elif i['kind'] == 5:
i['kind'] = '中国文化与自然双重遗产预备名录'
List.append(i)
data = {
"code": 2,
"data": List
}
return jsonify(data)