def find(keywords, SearchIndex='DVD'):
config = ConfigParser.ConfigParser()
config.read('settings.conf')
actors = set()
api = amazonproduct.API(config.get('Amazon', 'AccessKeyID'),
config.get('Amazon', 'SecretAccessKey'))
#~ node = api.item_search('Books', Publisher='Terminator')
node = api.item_search(SearchIndex, Title=sys.argv[1])
print "Idx\tASIN\t\tTitle"
for index, item in enumerate(node.Items.Item):
print "%s:\t%s:\t%s" % (index,
item.ASIN,
unicode(item.ItemAttributes.Title)[:70])
#~ raw_input("Get Details...")
details = api.item_lookup(item.ASIN, ResponseGroup='Images,ItemAttributes')
item_detail = details.Items.Item[0]
print item_detail.LargeImage.URL
try:
for sub_item in item_detail.ItemAttributes.Actor:
print sub_item #, link_item.URL
actors.add(str(sub_item))
except AttributeError:
print "Could not list actors"
h.ipython()()
#~ break
print actors
def variant007():
medium_id = 317
item = session.query(model.Medium)\
.filter(model.Medium.id == medium_id)\
.first()
#~ print query
h.ipython()()
def orphaned_tags():
query = session.query(model.Tag)
query = query.filter(not_(model.Tag.media_id.in_(session.query(model.Medium.id))))
for item in query.all():
try:
print item
except:
h.ipython()()
def variant010():
medium = session.query(model.Medium).get(250)
record = model.MediaToAsin()
h.ipython()()
def variant004():
t = model.media_table
foo = model.media_table.c.created_ts
t.update(values={'created_ts':datetime.now()})
h.ipython()()
