Python Pysql.modify Exemples

Exemple #1

def shippedOrder(id):
    id = int(id)

    db = Pysql()

    res = db.modify(sql="""
        update `order` set status=40, updated_time=now() where id=%s;
    """,
                    params=(id, ))

    if res["success"] == True:
        return jsonify(success=True)
    else:
        return jsonify(success=False)

Exemple #2

def deleteProduct(id):
    id = int(id)

    db = Pysql()

    res = db.modify(sql="""
        update product set status=3 where id=%s;
    """,
                    params=(id, ))

    if res["success"] == True:
        return jsonify(success=True)
    else:
        return jsonify(success=False, reason="Internal Wrong!")

Exemple #3

def reuseCat(id):
    id = int(id)
    uid = int(request.cookies.get("uid"))

    db = Pysql()

    res = db.modify(sql="""
        update category set status=1, updated_time=now(), updated_user=%s where id=%s;
    """,
                    params=(uid, id))

    if res["success"] == True:
        return jsonify(success=True)
    else:
        return jsonify(success=False, reason="Internal Wrong!")

Exemple #4

def inProduct():
    id = int(request.form["id"])
    in_stock = int(request.form["in_stock"])
    uid = int(request.cookies.get("uid"))

    db = Pysql()

    res = db.modify(sql="""
        update product set stock=stock+%s, updated_time=now(), updated_user=%s where id=%s;
    """,
                    params=(in_stock, uid, id))

    if res["success"] == True:
        return jsonify(success=True)
    else:
        return jsonify(success=False, reason="Internal Wrong!")

Exemple #5

def editCat():
    id = request.form["id"]
    name = request.form["name"]
    status = int(request.form["status"])
    uid = int(request.cookies.get("uid"))

    db = Pysql()

    res = db.modify(sql="""
        update category set name=%s, status=%s, updated_time=now(), updated_user=%s where id=%s;
    """,
                    params=(name, status, uid, id))

    if res["success"] == True:
        return jsonify(success=True)
    else:
        return jsonify(success=False, reason="Internal Wrong!")

Exemple #6

def editProduct():
    id = int(request.form["id"])
    name = request.form["name"]
    category_id = int(request.form["category_id"])
    price = float(request.form["price"])
    stock = int(request.form["stock"])
    status = int(request.form["status"])
    uid = int(request.cookies.get("uid"))

    db = Pysql()

    res = db.modify(sql="""
        update product set name=%s, category_id=%s, price=%s, stock=%s, status=%s, updated_time=now(), updated_user=%s where id=%s;
    """,
                    params=(name, category_id, price, stock, status, uid, id))

    if res["success"] == True:
        return jsonify(success=True)
    else:
        return jsonify(success=False, reason="Internal Wrong!")