def register_process(): """Process registration.""" # Get form variables from reg form first_name = request.form.get("firstname") last_name = request.form.get("lastname") email = request.form.get("email") password = request.form.get("password") phone = request.form.get("phone") #hash the password and store this in DB password_hash = sha256_crypt.encrypt(password) new_user = User(first_name=first_name, last_name=last_name, email=email, password=password_hash, phone=phone) # handles registration duplicate, flashes message try: db.session.add(new_user) db.session.commit() flash("Welcome %s %s! \ Your username is %s." % (first_name, last_name, email)) except exc.IntegrityError: flash("User already exists. Please login") db.session().rollback() return redirect("/")
def register_process(): """Process registration.""" # Get form variables from reg form first_name = request.form.get("firstname") last_name = request.form.get("lastname") email = request.form.get("email") password = request.form.get("password") address1 = request.form.get("address1") address2 = request.form.get("address2") city = request.form.get("city") state = request.form.get("state") zipcode = request.form.get("zipcode") phone = request.form.get("phone") new_user = User(first_name=first_name, last_name=last_name, email=email, password=password, address1=address1, address2=address2, city=city, state=state, zipcode=zipcode, phone=phone) # handles registration duplicate, flashes message try: db.session.add(new_user) db.session.commit() except exc.IntegrityError: flash("User already exists. Please login") db.session().rollback() flash("Welcome %s %s! You now have an account with Paws Finder. \ Your username is your email address, %s." % (first_name, last_name, email)) return redirect("/register")
def init_values(): from model.Rate import RateModel from model import db a_rate = RateModel(rate=20, jid=1) b_rate = RateModel(rate=30, jid=2) session = db.session() try: session.add(a_rate) session.add(b_rate) session.commit() except Exception as e: logger.error(e) session.rollback() finally: db.session.remove()
def deleteProduct(rowid): user = db.session.query(User).filter(User.id == user_id).first() if user: db.session.query(User).filter(User.id==user_id).delete() db.session().commit()
from model import db, Product, Accounts def deleteUser(rowid) user = db.session.query(User).filter(User.id == user_id).first() if user: db.session.query(User).filter(User.id==user_id).delete() db.session().commit() def deleteProduct(rowid): user = db.session.query(User).filter(User.id == user_id).first() if user: db.session.query(User).filter(User.id==user_id).delete() db.session().commit()
def NewPrice(idProduto, price): prod = Product.query.filter_by(id=idProduto).first() if prod: prod.price = price db.session().commit()