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()})