Exemplo n.º 1
0
def getShoppingCart(userId):
    result = None

    if userId is not None:
        try:
            conn = mysql.connector.connect(**config)
            cursor = conn.cursor()

            query = "SELECT product_id, count FROM shopcarts WHERE user_id = %s"

            cursor.execute(query, [userId])

            #Build Cart object from results
            for (product_id, count) in cursor:
                if result is None:
                    result = Cart(userId)
                result.products[product_id] = count


        except mysql.connector.Error as e:
              print("Error in product update: {}".format(e))

        finally:
            if cursor:
                cursor.close()
            if conn:
                conn.close()

    return result
Exemplo n.º 2
0
def test_cart_add():
    print("Testing cart add..")

    cart = Cart(79)

    cart.addProduct(1)
    cart.addProduct(1)
    db.updateShoppingCart(cart)

    cart2 = db.getShoppingCart(79)
    assert(cart2 is not None)

    bl.setShoppingCart(cart)
Exemplo n.º 3
0
    def on_put(self, req, resp, userId):
        try:
            userId = int(userId)

            """Skip the validations because we dont have yet way of adding user
            accounts to the system.."""
            
            doc = req.context['doc']
            newCart = Cart.from_json(doc)

            if newCart.userId is None:
                newCart.userId = userId

            elif newCart.userId != userId:
                resp.status = falcon.HTTP_403
                return

            #update product
            bl.setShoppingCart(newCart)

            resp.status = falcon.HTTP_200 #Status Ok

        except:
            #Return 500 - internal error
            resp.status = falcon.HTTP_500
Exemplo n.º 4
0
def main():
    products = db.get_products()

    cart = Cart()
    while True:
        command = input("Command: ")
        if command == "cart":
            show_cart(cart)
        elif command == "add":
            add_item(cart, products)
        elif command == "del":
            remove_item(cart)
        elif command == "exit":
            print("Bye!")
            break
        else:
            print("Not a valid command. Please try again.\n")
Exemplo n.º 5
0
def ram_page():
    from objects import Ram, UserAccount, Cart
    username = session['username']
    if request.method == 'POST':
        ramId = request.form['id']
        username = request.form['username']
        ram = Ram.query.filter_by(id=ramId).first()
        user = UserAccount.query.filter_by(username=username).first()
        if user != None:
            cart = Cart.query.filter_by(userid=user.id).first()
            if cart == None:
                userCart = Cart(user.id, user.id, None, None, None, ramId)
                database.session.add(userCart)
                database.session.commit()
            else:
                cart.ramid = ram.id
                database.session.commit()
    return render_template('productTemplate.html',
                           table=Ram,
                           username=username)
Exemplo n.º 6
0
def mobo_page():
    from objects import MotherBoard, UserAccount, Cart
    username = session['username']
    if request.method == 'POST':
        moboId = request.form['id']
        username = request.form['username']
        mobo = MotherBoard.query.filter_by(id=moboId).first()
        user = UserAccount.query.filter_by(username=username).first()
        if user != None:
            cart = Cart.query.filter_by(userid=user.id).first()
            if cart == None:
                userCart = Cart(user.id, user.id, None, None, None, None,
                                moboId, None)
                database.session.add(userCart)
                database.session.commit()
            else:
                cart.motherboardid = mobo.id
                database.session.commit()
    return render_template('productTemplate.html',
                           table=MotherBoard,
                           username=username)
Exemplo n.º 7
0
def hardDive_page():
    from objects import HardDrive, UserAccount, Cart
    username = session['username']
    if request.method == 'POST':
        harddriveId = request.form['id']
        username = request.form['username']
        hardDrive = HardDrive.query.filter_by(id=harddriveId).first()
        user = UserAccount.query.filter_by(username=username).first()
        if user != None:
            cart = Cart.query.filter_by(userid=user.id).first()
            if cart == None:
                userCart = Cart(user.id, user.id, None, None, None, None, None,
                                harddriveId)
                database.session.add(userCart)
                database.session.commit()
            else:
                cart.harddriveid = hardDrive.id
                database.session.commit()
    return render_template('productTemplate.html',
                           table=HardDrive,
                           username=username)
Exemplo n.º 8
0
def gpu_page():
    from objects import GPU, UserAccount, Cart
    username = session['username']
    if request.method == 'POST':
        gpuId = request.form['id']
        username = request.form['username']
        gpu = GPU.query.filter_by(id=gpuId).first()
        user = UserAccount.query.filter_by(username=username).first()
        if user != None:
            cart = Cart.query.filter_by(userid=user.id).first()
            if cart == None:
                userCart = Cart(user.id, user.id, gpuId, None, None, None,
                                None, None)
                database.session.add(userCart)
                database.session.commit()
            else:
                cart.gpuid = gpu.id
                database.session.commit()
    return render_template('productTemplate.html',
                           table=GPU,
                           username=username)
Exemplo n.º 9
0
def psu_page():
    from objects import Powersupply, UserAccount, Cart
    username = session['username']
    if request.method == 'POST':
        psuId = request.form['id']
        username = request.form['username']
        psu = Powersupply.query.filter_by(id=psuId).first()
        user = UserAccount.query.filter_by(username=username).first()
        if user != None:
            cart = Cart.query.filter_by(userid=user.id).first()
            if cart == None:
                userCart = Cart(user.id, user.id, None, None, psuId, None,
                                None, None)
                database.session.add(userCart)
                database.session.commit()
            else:
                cart.powersupplyid = psu.id
                database.session.commit()
    return render_template('productTemplate.html',
                           table=Powersupply,
                           username=username)
Exemplo n.º 10
0
def cpu_page():
    from objects import CPU, UserAccount, Cart
    username = session['username']
    if request.method == 'POST':
        cpuId = request.form['id']  # from productsPage
        username = request.form['username']
        cpu = CPU.query.filter_by(id=cpuId).first()
        user = UserAccount.query.filter_by(username=username).first()
        if user != None:
            cart = Cart.query.filter_by(userid=user.id).first()
            if cart == None:  # if cart exist does not, then exist it you and add item to it.
                userCart = Cart(user.id, user.id, None, cpu.id, None, None,
                                None, None)
                database.session.add(userCart)
                database.session.commit()
            else:
                cart.cpuid = cpu.id
                database.session.commit()
    return render_template('productTemplate.html',
                           table=CPU,
                           username=username)
Exemplo n.º 11
0
def test_cart_serialize():
    p = db.getShoppingCart(userId=49)
    
    print(p)

    print(json.dumps(Cart.serialize(p), sort_keys=True))