Jan-25-2020, 10:52 AM
Hi
Just wondering if its possible to make this sqlite3 code to sqlalchemy?
Just wondering if its possible to make this sqlite3 code to sqlalchemy?
@app.route("/addToCart") def addToCart(): if 'email' not in session: return redirect(url_for('loginForm')) else: productId = int(request.args.get('productId')) with sqlite3.connect('database.db') as conn: cur = conn.cursor() cur.execute("SELECT userId FROM users WHERE email = '" + session['email'] + "'") userId = cur.fetchone()[0] try: cur.execute("INSERT INTO kart (userId, productId) VALUES (?, ?)", (userId, productId)) conn.commit() msg = "Added successfully" except: conn.rollback() msg = "Error occured" conn.close() return redirect(url_for('root')) @app.route("/cart") def cart(): if 'email' not in session: return redirect(url_for('loginForm')) loggedIn, firstName, noOfItems = getLoginDetails() email = session['email'] with sqlite3.connect('database.db') as conn: cur = conn.cursor() cur.execute("SELECT userId FROM users WHERE email = '" + email + "'") userId = cur.fetchone()[0] cur.execute("SELECT products.productId, products.name, products.price, products.image FROM products, kart WHERE products.productId = kart.productId AND kart.userId = " + str(userId)) products = cur.fetchall() totalPrice = 0 for row in products: totalPrice += row[2] return render_template("cart.html", products = products, totalPrice=totalPrice, loggedIn=loggedIn, firstName=firstName, noOfItems=noOfItems) @app.route("/removeFromCart") def removeFromCart(): if 'email' not in session: return redirect(url_for('loginForm')) email = session['email'] productId = int(request.args.get('productId')) with sqlite3.connect('database.db') as conn: cur = conn.cursor() cur.execute("SELECT userId FROM users WHERE email = '" + email + "'") userId = cur.fetchone()[0] try: cur.execute("DELETE FROM kart WHERE userId = " + str(userId) + " AND productId = " + str(productId)) conn.commit() msg = "removed successfully" except: conn.rollback() msg = "error occured" conn.close() return redirect(url_for('root')) @app.route("/logout") def logout(): session.pop('email', None) return redirect(url_for('root')) def is_valid(email, password): con = sqlite3.connect('database.db') cur = con.cursor() cur.execute('SELECT email, password FROM users') data = cur.fetchall() for row in data: if row[0] == email and row[1] == hashlib.md5(password.encode()).hexdigest(): return True return False