def fill_db():
form = LocationForm()
print(form.user_id.data)
if form.validate_on_submit():
location = Location(lat=form.lat.data,
lan=form.lan.data,
timestamp=form.timestamp.data,
user_id=form.user_id.data)
session.add(location)
session.flush()
return redirect("/")
# if request.method == 'POST':
# lat = request.form['lat']
# lan = request.form['lan']
# timestamp = request.form['timestamp']
# user_id = request.form['user_id']
# print(timestamp)
# ts = datetime.strptime(timestamp, "%Y-%m-%d")
# location = Location(lat, lan, ts, user_id)
# session.add(location)
# session.flush()
# return redirect("/")
else:
users = session.query(User).all()
return render_template('add_location.html', users=users, form=form)
def location():
form = LocationForm()
location_data = db.session.query(Location)
location_data = [str(row).split('|') for row in location_data]
if form.validate_on_submit():
location = Location(location_name=form.location_name.data,\
city=form.city.data,\
lat_long=form.lat_long.data,\
address=form.address.data)
try:
obj = db.session.query(Location).filter(
Location.location_name == form.location_name.data).first()
if obj == None:
db.session.add(location)
db.session.commit()
flash('Your location data has been saved successfully!')
else:
obj.update({"city" : form.city.data,\
"lat_long" : form.lat_long.data,\
"address" : form.address.data})
db.session.commit()
return redirect(url_for('location'))
except IntegrityError as e:
flash('Integrity error')
return render_template('location.html', form=form, location_data=location_data,\
is_authenticated=current_user.is_authenticated)
def index():
form = LocationForm()
data = []
if form.validate_on_submit():
print("success")
url = "https://www.pythonprogramming.in/media/wysiwyg/matplotlib/mat-7.png"
data.append(url)
print(data)
return render_template('index.html', title='Teacher Home', form=form)
def location_create():
form = LocationForm()
if form.validate_on_submit():
db.session.add(Location(name=form.name.data, address=form.address.data))
db.session.commit()
flash("Successfully created Location: {}".format(form.name.data), 'info')
app.logger.info('Location {} created by Admin ID {} at {}'.format(form.name.data, current_user.id, datetime.now()))
return redirect(url_for('admin_panel.alldata_stype', sub_type='locations'))
return render_template('/location_create.html', form=form) if validation(current_user)==True else redirect(url_for('main_panel.index'))
def create_location():
"""Creates a location for a drop list item"""
form = LocationForm()
if form.validate_on_submit():
location = Location(name=form.name.data)
db.session.add(location)
db.session.commit()
flash("Location has been successfully created", "success")
return redirect(f"/locations/{location.id}")
return render_template("locations_new.html", form=form)
def fill_db():
form = LocationForm()
print(form.user_id.data)
if form.validate_on_submit():
location = Location(lat=form.lat.data, lan=form.lan.data, timestamp=form.timestamp.data, user_id=form.user_id.data)
session.add(location)
session.flush()
return redirect("/")
else:
users = session.query(User).all()
return render_template("add_location.html", users=users, form=form)
def location():
form = LocationForm()
if form.validate_on_submit():
location = Location(id_location=form.id_location.data, continent=form.continent.data, country=form.country.data, province=form.province.data, city=form.city.data)
#save the model to the database
db.session.add(location)
db.session.commit()
flash('Congratulations, you are now a registered location!')
return redirect(url_for('index'))
return render_template('location.html', title='validate', form=form)
def edit_location(location_id):
"""edit a location"""
location = Location.query.get_or_404(location_id)
form = LocationForm(obj=location)
if form.validate_on_submit():
location.name = form.name.data
db.session.commit()
flash("Location successfully updated", "success")
return redirect(f"/locations/{location.id}")
return render_template("/locations_edit.html", form=form)
def edit(location_id=None):
"""FRONTEND, Create, view or edit a location."""
if not ModuleAPI.can_write('location'):
return abort(403)
# Select location..
if location_id:
location = Location.query.get(location_id)
else:
location = Location()
form = LocationForm(request.form, location)
if form.validate_on_submit():
form.populate_obj(location)
db.session.add(location)
db.session.commit()
flash(_('Location saved.'), 'success')
return redirect(url_for('location.edit', location_id=location.id))
else:
flash_form_errors(form)
return render_template('location/edit.htm', location=location, form=form)
