import json
import os
import ebaysdk
from ebaysdk.finding import Connection as finding

api = finding(config_file=None,siteid='EBAY-GB', appid='MartinBr-appTitle-PRD-5f8fe589d-2b47192b')

api.execute('findItemsAdvanced',{'categoryId':'11450',
                                      'paginationInput':{'entriesPerPage':'1','pageNumber':'1'},
                                      'sortOrder': 'EndTimeSoonest',
                                      'itemFilter': [{'name': 'ListingType', 'value': 'Auction'},
                                                     {'name': 'Condition', 'value': '1000'},

                                                      'HideDuplicateItems'],
                                      'aspectFilter':[{'aspectName': 'Brand', 'aspectValueName': ['Gucci','Jimmy Choo','Chanel','Hermes','Prada','Louis Vuitton']}],
                                     'aspectFilter':[{'aspectName': 'Brand Type','aspectValueName':'Luxury'}]
})

#{'categoryId': '11450'},'paginationInput',{'entriesPerPage':'1','pageNumber':'1'})
maxPage = api.response.dict()['paginationOutput']['totalPages']
#print(maxPage)
maxPage=100
pages=[str(i) for i in range(1,int(maxPage) + 1)]

os.remove("results.json")
for i in pages:
    api=finding(config_file=None,siteid='EBAY-GB', appid='MartinBr-appTitle-PRD-5f8fe589d-2b47192b')
    api.execute('findItemsAdvanced',{'categoryId':'11450',
                                      'paginationInput':{'entriesPerPage':'100','pageNumber':str(i)},
                                      'sortOrder': 'StartTimeNewest',
                                      'itemFilter': [{'name': 'ListingType', 'value': 'Auction'},
				     {'name': 'Condition', 'value': '1000'}
],
                                      'aspectFilter':[{'aspectName': 'Brand', 'aspectValueName': ['Gucci','Jimmy Choo','Chanel','Hermes','Prada','Louis Vuitton']}]
})
    open('results.json', 'a').write(json.dumps(api.response.dict()['searchResult']['item']))
    open('results.json', 'a').close()
#    print(api.response.dict()['searchResult']['item'])

import os
os.system("cat results.json | jq '.[] .itemId' > itemIds.csv")
#with open('results2.json') as json_data:
#    d = json.load(json_data)

import csv
with open("itemIds.csv") as f:
    reader = csv.reader(f)
    data = [r for r in reader]

#print(data[1][0])
#print(len(data))

import os
import json
import pyjq
import ebaysdk
from ebaysdk.shopping import Connection as Shopping

for i in range(0,len(data)):
  #  appID = Shopping(appid='MartinBr-hello-PRD-f820bcb98-0c2e8b6c')
    appID=Shopping(config_file=None,siteid='EBAY-GB', appid='MartinBr-appTitle-PRD-5f8fe589d-2b47192b')
    appID.execute('GetSingleItem', {'ItemID': str(data[i][0]), 
                                    'IncludeSelector': ['Variations'],
#                                    'IncludeSelector': ['Details',
#                                    "IncludeSelector": "Variations"
    })
    x=appID.response.dict()
    os.remove("item.json")
    f = open('item.json','w')
    f.write(json.dumps(x))
    f.close()

    os.system("cat item.json | jq > item2.json") 

    with open('item2.json') as json_data:
        d = json.load(json_data)

    v = pyjq.all('.Item[]', d)
    print(str(v[0])+','+str(len(v[6])))



#import csv
#with open('itemIds.csv', 'rb') as f:
#    reader = csv.reader(f)
#    your_list = list(reader)

#x=api.response.dict()['searchResult']['item']
#y=api.response.dict()
#print(x)

#f = open('ebay.txt','w')
#f.write(json.dumps(x))
#f.close()


#    for q in api.response.dict()['searchResult']['item']:
#         print(q['itemId']+","+\
##               q['title']+","+\
#               q['primaryCategory']['categoryId']+","+\
#               q['sellingStatus']['currentPrice']['value']+","+\
#               q['shippingInfo']['shippingServiceCost']['value']+","+\
#               q['sellingStatus']['bidCount']+","+\
#               q['sellingStatus']['sellingState']+","+\
#               q['sellingStatus']['timeLeft']+","+\
##               q['viewItemURL']+","+\
#               q['listingInfo']['bestOfferEnabled']+","+\
#               q['listingInfo']['listingType']+","+\
 #              q['condition']['conditionId'])