def api_delete(city_id) -> str:
cursor = mysql.get_db().cursor()
sql_delete_query = """DELETE FROM tblCitiesImport WHERE id = %s """
cursor.execute(sql_delete_query, city_id)
mysql.get_db().commit()
resp = Response(status=200, mimetype='application/json')
return resp
def form_insert_post():
cursor = mysql.get_db().cursor()
inputData = (request.form.get('fldName'), request.form.get('fldLat'),
request.form.get('fldLong'), request.form.get('fldCountry'),
request.form.get('fldAbbreviation'),
request.form.get('fldCapitalStatus'),
request.form.get('fldPopulation'))
sql_insert_query = """INSERT INTO tblCitiesImport (fldName,fldLat,fldLong,fldCountry,fldAbbreviation,fldCapitalStatus,fldPopulation) VALUES (%s, %s,%s, %s,%s, %s,%s) """
cursor.execute(sql_insert_query, inputData)
mysql.get_db().commit()
return redirect("/", code=302)
def form_update_post(city_id):
cursor = mysql.get_db().cursor()
inputData = (request.form.get('fldName'), request.form.get('fldLat'),
request.form.get('fldLong'), request.form.get('fldCountry'),
request.form.get('fldAbbreviation'),
request.form.get('fldCapitalStatus'),
request.form.get('fldPopulation'), city_id)
sql_update_query = """UPDATE tblCitiesImport t SET t.fldName = %s, t.fldLat = %s, t.fldLong = %s, t.fldCountry =
%s, t.fldAbbreviation = %s, t.fldCapitalStatus = %s, t.fldPopulation = %s WHERE t.id = %s """
cursor.execute(sql_update_query, inputData)
mysql.get_db().commit()
return redirect("/", code=302)
def api_edit(city_id) -> str:
cursor = mysql.get_db().cursor()
content = request.json
inputData = (content['fldName'], content['fldLat'], content['fldLong'],
content['fldCountry'], content['fldAbbreviation'],
content['fldCapitalStatus'], content['fldPopulation'],
city_id)
sql_update_query = """UPDATE tblCitiesImport t SET t.fldName = %s, t.fldLat = %s, t.fldLong = %s, t.fldCountry =
%s, t.fldAbbreviation = %s, t.fldCapitalStatus = %s, t.fldPopulation = %s WHERE t.id = %s """
cursor.execute(sql_update_query, inputData)
mysql.get_db().commit()
resp = Response(status=200, mimetype='application/json')
return resp
def api_add() -> str:
content = request.json
cursor = mysql.get_db().cursor()
inputData = (content['fldName'], content['fldLat'], content['fldLong'],
content['fldCountry'],
content['fldAbbreviation'], content['fldCapitalStatus'],
request.form.get('fldPopulation'))
sql_insert_query = """INSERT INTO tblCitiesImport (fldName,fldLat,fldLong,fldCountry,fldAbbreviation,fldCapitalStatus,fldPopulation) VALUES (%s, %s,%s, %s,%s, %s,%s) """
cursor.execute(sql_insert_query, inputData)
mysql.get_db().commit()
resp = Response(status=201, mimetype='application/json')
return resp
def api_retrieve(city_id) -> str:
cursor = mysql.get_db().cursor()
cursor.execute('SELECT * FROM tblCitiesImport WHERE id=%s', city_id)
result = cursor.fetchall()
json_result = json.dumps(result)
resp = Response(json_result, status=200, mimetype='application/json')
return resp
def index():
user = {'username': '******'}
cursor = mysql.get_db().cursor()
cursor.execute('SELECT * FROM tblCitiesImport')
result = cursor.fetchall()
return render_template('index.html',
title='Home',
user=user,
cities=result)
def form_delete_post(city_id):
cursor = mysql.get_db().cursor()
sql_delete_query = """DELETE FROM tblCitiesImport WHERE id = %s """
cursor.execute(sql_delete_query, city_id)
mysql.get_db().commit()
return redirect("/", code=302)
def form_edit_get(city_id):
cursor = mysql.get_db().cursor()
cursor.execute('SELECT * FROM tblCitiesImport WHERE id=%s', city_id)
result = cursor.fetchall()
return render_template('edit.html', title='Edit Form', city=result[0])
def record_view(city_id):
cursor = mysql.get_db().cursor()
cursor.execute('SELECT * FROM tblCitiesImport WHERE id=%s', city_id)
result = cursor.fetchall()
return render_template('view.html', title='View Form', city=result[0])
