def myaccount():
# Don't show this page if we're not logged in
if USERNM.name == None:
redirect(url_for('board'))
c, conn = get_db()
# get the team members
c.execute('SELECT name, age, origin_town, ep_no \
FROM Team t, Contestant c, Based_on b \
Where b.team_nm = t.team_nm AND \
b.contestant_id = c.contestant_id AND user_nm = "{0}"'.format(USERNM.name))
results = c.fetchall()
# get the team name
team_nm=None
if USERNM.status=='participating':
c.execute('Select team_nm from team where user_nm=?', [USERNM.name])
team_nm = c.fetchall()[0]['team_nm']
# print(team_nm)
form = DelForm()
if form.validate_on_submit():
print("pressed")
return redirect(url_for('myaccount_delete'))
return render_template('myaccount.html', results=results, form=form, team_nm=team_nm, user_nm=USERNM.name)
def myaccount_delete(username):
# get the form with the buttons
form = DelForm()
if form.validate_on_submit():
if 'delete_btn' in request.form:
print('Delete request')
# delete the post
c, conn = get_db()
c.execute('DELETE FROM CompUser \
WHERE user_nm="{}"'.format(username))
conn.commit()
# reset the username and tell the layout
USERNM.logout()
# print log
print_log()
return redirect(url_for('login'))
elif 'cancel_btn' in request.form:
print('Cancel request')
# if cancelled, then just redirect
return redirect(url_for('myaccount'))
else:
print("That didn't work!")
return render_template('delete.html', form=form)
def delete_pup():
form = DelForm()
# if form.validate_on_submit():
# pup_id = form.id.data
# del_pup = Puppy.query.get(pup_id)
# db.session.delete(del_pup)
# db.session.commit()
if form.validate_on_submit():
#! NOTE: del_name is imported from forms.py
pup_name = form.del_name.data
print(pup_name)
#! NOTE: The name variable is from our MODELS above. We select the first occurance by filter_by(name=etc).first()
del_pup = Puppy.query.filter_by(
name=pup_name).first() # name is from model variable
print(del_pup)
db.session.delete(del_pup)
db.session.commit()
return redirect(url_for('list_pups'))
return render_template('delete.html', form=form)
def del_ticket():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
ticket = Ticket.query.get(id)
db.session.delete(ticket)
db.session.commit()
return redirect(url_for('ticketDeleted'))
return render_template('deleteTicket.html')
def del_item():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
del_item = Market.query.get(id)
db.session.delete(del_item)
db.session.commit()
return redirect(url_for('list_item'))
return render_template('delete.html',form=form)
def del_cat():
form = DelForm()
if form.validate_on_submit():
cat_id = form.cat_id.data
cat_to_del = Cat.query.get(cat_id)
db.session.delete(cat_to_del)
db.session.commit()
return redirect(url_for('list'))
return render_template('delete.html', form=form)
def delete():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
ponny = Ponny.query.get(id)
db.session.delete(ponny)
db.session.commit()
return redirect(url_for('liste'))
return render_template('delete.html', form=form)
def del_pup():
form = DelForm()
if form.validate_on_submit():
pup_id = form.id.data
pup = Puppy.query.get(pup_id)
db.session.delete(pup)
db.session.commit()
return redirect(url_for('list_pup'))
return render_template('delete.html', form=form)
def del_pupp():
del_form = DelForm()
if del_form.validate_on_submit():
id = del_form.id.data
pup = Puppy.query.get(id)
db.session.delete(pup)
db.session.commit()
return redirect(url_for('list_pup'))
return render_template("delete.html", del_form=del_form)
def del_dog():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
dog = Dog.query.get(id)
db.session.delete(dog)
db.session.commit()
return redirect(url_for('list_dog'))
return render_template('delete.html', form=form)
def test():
addForm = ItemForm()
delForm = DelForm()
editForm = EditForm()
itemsOfInterest = Item.query()
#makes database if it doesn't exist...
if len(itemsOfInterest.fetch(None)) == 0:
mower = Item(id=str(uuid.uuid1()), item='Lawn Mower')
eater = Item(id=str(uuid.uuid1()), item='Weed Eater')
mower.addModel('Honda')
mower.addModel('Black & Decker')
eater.addModel('Torro')
eater.addModel('Echo')
print mower.item
print eater.item
mower.put()
eater.put()
itemsOfInterest = Item.query()
print "The query length is " + str(len(itemsOfInterest.fetch(None)))
if request.form.has_key("edit") and editForm.validate_on_submit(
): # If edit button press & something in edit box then...
myItems = Item.query() # get item list
for item in myItems: # find correct item
print item
print item.id
if str(item.id) == str(editForm.id.data):
# Get item
item = item.key.get()
# Change item to edit box data
item.item = editForm.editItem.data
# Save item
item.put()
flash('Item Edited!')
return redirect(url_for('index'))
elif request.form.has_key("delete") and delForm.validate_on_submit():
myItems = Item.query()
for item in myItems:
print item
print item.id
if str(item.id) == str(delForm.id.data):
ndb.delete_multi([item.key])
flash('Item deleted!')
return redirect(url_for('index'))
elif request.form.has_key("add") and addForm.validate_on_submit():
newItem = Item(id=str(uuid.uuid1()), item=addForm.item.data)
print("myUUID is " + newItem.id)
newItem.put()
flash('New item added!')
return redirect(url_for('index'))
return render_template('index.html',
title='USI Help System',
itemsOfInterest=itemsOfInterest,
addForm=addForm,
delForm=delForm,
editForm=editForm)
def del_data():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
data_point = Hypothyroid.query.get(id)
db.session.delete(data_point)
db.session.commit()
return redirect(url_for('list_data'))
return render_template('delete.html', form=form)
def del_emp():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
emp_d = Emp.query.get(id)
db.session.delete(emp_d)
db.session.commit()
return redirect(url_for('list_emp'))
return render_template('delete.html', form=form)
def del_sale():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
sale = TractortekSales.query.get(id)
db.session.delete(sale)
db.session.commit()
return redirect(url_for('list_sale'))
return render_template('delete.html', form=form)
def delete_unicorn():
form=DelForm()
if form.validate_on_submit():
id=form.id.data
unicorn=Unicorn.query.get(id)
if unicorn == None:
flash("This unicorn doesn't exist! Please Type another ID.")
else:
db.session.delete(unicorn)
db.session.commit()
return redirect(url_for('list_unicorn'))
return render_template('delete.html',form=form)
def del_stud():
form = DelForm()
if form.validate_on_submit():
usn = form.usn.data
stud = students.query.get(usn)
db.session.delete(stud)
db.session.commit()
return redirect(url_for('list_stud'))
return render_template('delete.html', form=form)
def delete_book():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
book = Books.query.get(id)
db.session.delete(book)
db.session.commit()
return redirect(url_for('book_list'))
return render_template('delete_book.html', form=form)
def del_todo():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
todo_del = Todo.query.get(id)
db.session.delete(todo_del)
db.session.commit()
return redirect(url_for('add_todo'))
else:
return render_template('delete.html', form=form)
def del_tractor():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
tractor = Tractor.query.get(id)
db.session.delete(tractor)
db.session.commit()
return redirect(url_for('list_tractor'))
return render_template('delete.html',form=form)
def del_student():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
student = Student.query.get(id)
db.session.delete(student)
db.session.commit()
return redirect(url_for('list_student'))
return render_template('delete.html', form=form)
def del_pup():
form = DelForm()
#Delete puppy from database
if form.validate_on_submit():
id = form.id.data
pup = Puppy.query.get(id)
print(pup)
db.session.delete(pup)
db.session.commit()
print("redirecting now...")
return redirect(url_for('list_pup'))
return render_template('delete.html',form=form)
def del_kit():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
kitten = Kitten.query.get(id)
db.session.delete(kitten)
db.session.commit()
return redirect(url_for('list_kit'))
return render_template('delete.html', form = form)
def del_pup():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
pup = Puppy.query.get(id)
if pup != None: # new code as recommended in supplemental lecture
db.session.delete(pup)
db.session.commit()
return redirect(url_for('list_pup'))
return render_template('delete.html', form=form)
def delete_person():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
person = Person.query.get(id)
db.session.delete(person)
db.session.commit()
return redirect(url_for('list_person'))
return render_template('delete.html', form=form)
def del_center():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
center = Center.query.get(id)
db.session.delete(center)
db.session.commit()
return redirect(url_for('list_centers'))
return render_template('delete.html', form=form)
def del_pup():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
pup = Puppy.query.get(id)
db.session.delete(pup)
db.session.commit()
return redirect(url_for("list_pup"))
return render_template("delete_puppies.html", form=form)
def del_movie():
movie_list = get_movies()
form = DelForm()
if form.validate_on_submit():
movie_id = request.form.get('delete')
movie = Movie.query.get(movie_id)
database.session.delete(movie)
database.session.commit()
return redirect(url_for('list_movies'))
return render_template('delete.html', form=form, movies=movie_list)
def delete_pup():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
pup = Puppy.query.get(id)
if pup != None:
db.session.delete(pup)
db.session.commit()
return redirect(url_for('list_pups'))
else:
return render_template("error.html",
error="Id you provided is not valid.")
return render_template("delete.html", form=form)
def delete_pup():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
pup = Puppy.query.get(id)
flash(
f"Puppy_Id: {pup.id} Name: {pup.name} has been removed from the database!"
)
db.session.delete(pup)
db.session.commit()
return redirect(url_for('list_pup'))
return render_template('delete.html', form=form)
def del_puppy():
form = DelForm()
if form.validate_on_submit():
id = form.id.data
# Get the name of the puppy.
puppy = Puppy.query.get(id)
db.session.delete(puppy)
db.session.commit()
return redirect(url_for('list_puppy'))
return render_template('delete.html', form=form)
def item_delete(request, item_id, curr_user):
"Delete Item (item_id)"
item_id = int(item_id)
try:
item = items.objects.get(id=item_id, is_sold=False)
except items.DoesNotExist:
return render(request, 'error.html', {'error': 'Item Does Not Exist or You don\'t have permission to be here!'})
# if the curr_user has no rights
if curr_user.user_obj != item.user and not curr_user.is_admin:
return render(request, 'error.html', {'error': 'Item Does Not Exist or You don\'t have permission to be here!'})
# User has rights, Perform Delete operations
if request.method == 'POST':
form = DelForm(request.POST)
if form.is_valid() and form.cleaned_data['confirm']:
item.delete()
return render(request, 'msg.html', {'msg': 'Item Deleted!'})
else:
return HttpResponseRedirect('/item/?id=%d' % item.id)
else:
return render(request, 'item_delete.html', {'form': DelForm(), 'item': item})
def del_profile(request, curr_user):
"Delete Profile of currently logged in user"
if request.method == 'POST':
form = DelForm(request.POST)
if form.is_valid():
if form.cleaned_data['confirm']:
# remove all comm and messages
comms = Comm.objects.filter(buyer=curr_user.user_obj)
for comm in comms:
Messages.objects.filter(comm=comm).delete()
comms.delete()
# remove all items
_items = items.objects.filter(user=curr_user.user_obj)
for item in _items:
comms = Comm.objects.filter(item=item)
for comm in comms:
Messages.objects.filter(comm=comm).delete()
comms.delete()
# remove admin entries
try:
tmp = admins.objects.get(email=curr_user.user_obj.email)
tmp.delete()
except admins.DoesNotExist:
pass
# remove user
curr_user.user_obj.delete()
return HttpResponseRedirect(users.create_logout_url('/'))
else:
return HttpResponseRedirect('/')
else:
return HttpResponseRedirect('/')
else:
return render(request, 'user_delete.html', {'form': DelForm()})
