def add_images(asin, images):
if not dbapi.listing_exists(asin):
add_listing(asin)
if not dbapi.image_exists(asin):
try:
image = Image(tiny_image=images['tiny_image_url'],
small_image=images['small_image_url'],
medium_image=images['medium_image_url'],
large_image=images['large_image_url'],
listing_asin=asin)
dbapi.add(image)
except:
print('Unable to add {0} to db'.format(asin))
else:
print('{0} already exists in db'.format(asin))
def add_images(asin, images):
if not dbapi.listing_exists(asin):
add_listing(asin)
if not dbapi.image_exists(asin):
try:
image = Image(
tiny_image = images['tiny_image_url'],
small_image = images['small_image_url'],
medium_image = images['medium_image_url'],
large_image = images['large_image_url'],
listing_asin = asin
)
dbapi.add(image)
except:
print('Unable to add {0} to db'.format(asin))
else:
print('{0} already exists in db'.format(asin))
def add_listing(asin, listing={}):
# We may need to add a listing with just an asin.
listing_exists = dbapi.listing_exists(asin)
if not (listing_exists or listing):
dbapi.add(Listing(asin=asin))
elif not listing_exists:
try:
fprice = float(listing['lowest_price'])
except:
fprice = None
try:
l = Listing(asin=asin,
manufacturer=listing['manufacturer'],
title=listing['title'],
part_number=listing['part_number'],
price=fprice,
upc=listing['upc'])
dbapi.add(l)
except:
print('Unable to add listing to db')
else:
print('{0} already exists in db'.format(asin))
def add_listing(asin, listing={}):
# We may need to add a listing with just an asin.
listing_exists = dbapi.listing_exists(asin)
if not (listing_exists or listing):
dbapi.add(Listing(asin=asin))
elif not listing_exists:
try:
fprice = float(listing['lowest_price'])
except:
fprice = None
try:
l = Listing(
asin = asin,
manufacturer = listing['manufacturer'],
title = listing['title'],
part_number = listing['part_number'],
price = fprice,
upc = listing['upc']
)
dbapi.add(l)
except:
print('Unable to add listing to db')
else:
print('{0} already exists in db'.format(asin))
