def sql_insert_sighting():
from sqlquery import sql_query, insert_sighting
if request.method == 'POST':
name = request.form['name']
person = request.form['person']
location = request.form['location']
sighted = request.form['sighted']
insert_sighting(name, person, location, sighted)
tuples = sql_query("SELECT * FROM SIGHTINGS")
return render_template('sightings.html', tuples=tuples)
def sql_update_flower():
from sqlquery import update_flower, sql_query
if request.method == 'POST':
oldComname = request.form['oldComname']
newComname = request.form['newComname']
newGenus = request.form['newGenus']
newSpecies = request.form['newSpecies']
update_flower(oldComname, newComname, newGenus, newSpecies)
tuples = sql_query("SELECT * FROM FLOWERS")
return render_template('flowers.html', tuples=tuples)
def sql_members_database():
from sqlquery import sql_query
tuples = sql_query("SELECT * FROM MEMBERS")
return render_template('members.html', tuples=tuples)
def sql_features_database():
from sqlquery import sql_query
tuples = sql_query("SELECT * FROM FEATURES")
return render_template('features.html', tuples=tuples)
def sql_flowers_database():
from sqlquery import sql_query
tuples = sql_query("SELECT * FROM FLOWERS")
return render_template('flowers.html', tuples=tuples)
def sql_sighting_database():
from sqlquery import sql_query
tuples = sql_query("SELECT * FROM SIGHTINGS")
return render_template('sightings.html', tuples=tuples)