#coding:utf-8
    import connect
    
    mydb = connect.getDB()
    mycursor = mydb.cursor()
    
    #クエリーを作成
    tablename = input("wineか、wineSetか：　")
    
    if tablename in ["wine","wineSet"]:
        prilo = int(input("探したい値段の下限何円か："))
        prihi = int(input("探したい値段の上限何円か："))
    
        if tablename == "wine":
            sql1 = "select wineID,name,color,price from {} where price between {} and {}"
            #print(sql1.format(tablename,prilo,prihi))
            sql = sql1.format(tablename,prilo,prihi)
            
        elif tablename == "wineSet":
            sql2 = "select wineSet.setID, wineSet.name, sum(price*quantity) as 'setPrice' from wineSet inner join setDetail using(setID) inner join wine using(wineID) group by setDetail.setID having setPrice between {} and {}"
            sql = sql2.format(prilo,prihi)
    
        #query実行と結果表示
        mycursor.execute(sql)
        myresult = mycursor.fetchall()
        for x in myresult:
            print(x)
    else:
        print("入力ミス")
    
    mydb.close()