import connect

    mydb = connect.getDB()
    mycursor = mydb.cursor()
    
    print ("ワインの値段を更新する。")
    wineID = input('wineID: ')
    newprice = input('newprice: ')
    
    sql = "UPDATE wine SET price = %s  WHERE wineID = %s"
    val = (newprice, wineID)
    mycursor.execute(sql, val)
    
    mydb.commit()
    
    print(mycursor.rowcount, "price is updated.")
    
    mydb.close()