def insertProductsToOrders(p_name, quantity): query1 = dbManager.fetch("SELECT * FROM orders") order_id = len(query1) + 1 dbManager.commit( "INSERT INTO products_in_order (p_name,order_id, quantity) VALUES ('%s', '%s', '%s')" % (p_name, order_id, quantity)) return True
def addAppointment(full_name, phone, email, description, date): query2 = dbManager.fetch("SELECT * FROM appointments") app_id = len(query2) + 1 query_result = dbManager.commit( "insert into appointments(app_id,full_name, phone, email, description) VALUES ('%s', '%s', '%s', '%s', '%s')" % (app_id, full_name, phone, email, description)) return query_result
def insertCart(p_name, user_name, quantity): price = dbManager.fetch( "SELECT price FROM products WHERE p_name='%s'" % p_name)[0][0] dbManager.commit( "INSERT INTO cart (p_name, user_name, quantity, price) VALUES ('%s', '%s', '%s', '%s')" % (p_name, user_name, quantity, int(price))) return True
def checkProductInCart(p_name, user_name): query_result = dbManager.fetch( "SELECT p_name FROM cart WHERE p_name='%s' AND user_name='%s'" % (p_name, user_name)) if len(query_result) > 0: return True return False
def moveFromCartToOrder(user_name, order_id): cart = dbManager.fetch("SELECT * FROM cart WHERE user_name='%s'" % user_name) for c in cart: dbManager.commit( "INSERT INTO products_in_order (p_name,order_id, quantity, price) VALUES ('%s', '%s', '%s', '%s')" % (c.p_name, order_id, c.quantity, c.price)) return True
def checkCartExists(email): order = dbManager.fetch( "SELECT order_id FROM orders WHERE email='%s' AND finished=0" % email) if len(order) == 0: # there is no open order (current cart) return False print(order[0].order_id) return order[0].order_id # there is an open order for the user
def createNewCart(user_name, datetime): user_email = UserManager.getUserEmail(user_name) dbManager.commit( "INSERT INTO orders (email, date) VALUES ('%s', '%s')" % (user_email, datetime.now())) order_id = dbManager.fetch( "SELECT order_id FROM orders WHERE email='%s' AND finished=0" % user_email) return order_id
def createNewOrder(user_name, first_name, last_name, email, cc, cvv): amount = ShopManager.calculateAmount(user_name) query1 = dbManager.fetch("SELECT * FROM orders") order_id = 1 if len(query1) > 0: order_id = len(query1) + 1 dbManager.commit( "INSERT INTO orders (order_id, first_name, last_name, email, cc, cvv , amount) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s')" % (order_id, first_name, last_name, email, cc, cvv, amount)) return order_id
def getApps(email): return dbManager.fetch("SELECT * FROM appointments WHERE email='%s'" % email)
def getOrdersproducts(email): return dbManager.fetch("SELECT * FROM orders WHERE email='%s'" % email)
def getUserbyEmail(email): return dbManager.fetch("SELECT * FROM users WHERE email='%s'" % email)
def getUser(user_name): return dbManager.fetch("SELECT * FROM users WHERE user_name='%s'" % user_name)
def getUserLastName(user_name): return dbManager.fetch("SELECT last_name FROM users WHERE user_name='%s'" % user_name)[0][0]
def getUserName(email): return dbManager.fetch("SELECT user_name FROM users WHERE email='%s'" % email)[0][0]
def getUserEmail(user_name): return dbManager.fetch("SELECT email FROM users WHERE user_name='%s'" % user_name)[0][0]
def checkIfUserExists(email): query_result = dbManager.fetch("SELECT * FROM users where email='%s'" % email) if len(query_result) == 0: return False return True
def calculateAmount(user_name): return dbManager.fetch( "SELECT SUM(price*quantity) as orderTotal FROM cart WHERE user_name='%s'" % user_name)[0][0]
def getCart(user_name): return dbManager.fetch("SELECT * FROM cart WHERE user_name='%s'" % user_name)
def getProducts(p_name: str): query_result = dbManager.fetch( 'SELECT * FROM products WHERE p_name=%s', p_name) return query_result