Пример #1
0
def get_product_detail(id):
    if (id<1):
        return
    try:
        cursor=productConn.cursor()
        sql=("select Value as price from Productdb.productdetail where ProductID=%(pid)s")
        data={"pid":id}
        cursor.execute(sql,data)
        result=cursor.fetchall()
        cursor.close()
        return result
    except:
        print (exc_info())
        cursor.close()
Пример #2
0
def get_product_brand(id):
    if (id<1):
        return
    try:
        cursor=productConn.cursor()
        sql=("select brandname from productdb.brands where brand_id=%(bid)s")
        data ={"bid":id}
        cursor.execute(sql,data)
        result=cursor.fetchall()
        cursor.close()
        return result
    except:
        print (exc_info())
        cursor.close()
Пример #3
0
def get_product_link(id):

    if (id<1):
        return
    try:
        cursor=productConn.cursor()
        sql=("select Url from Productdb.links where ProductID=%(pid)s")
        data={"pid":id}
        cursor.execute(sql,data)
        result=cursor.fetchall()
        cursor.close()
        return result;
    except:
        print (exc_info())
        cursor.close()
Пример #4
0
def searchProduct(keyword):
    try:
        cursor=productConn.cursor()
        sql=("select ID, Brand_id, ProductType_id, Name from productdb.Products where Brand_ID in (select Brand_ID from productdb.Brands where BrandName like CONCAT('%', %(key)s, '%'))"
						"or	ProductType_ID in (select ProductType_ID from productdb.productTypes where TypeName like concat('%',%(key)s,'%')"
                        "or  Name like concat('%',%(key)s,'%'))")
        data={"key":keyword}
        cursor.execute(sql,data)
        result=cursor.fetchall()
        cursor.close()
        if (result is not None):
            return result
    except:
        print(exc_info())
        cursor.close()