def fetchItemProperties(self, item, custom_keys):
item['isbn_10'] = []
item['isbn_13'] = []
item['in_stock'] = 0
cursor = mysql.connect().cursor()
cursor.execute(
"""SELECT isbn_10, isbn_13 FROM item_isbn WHERE item_id = %s""",
(item['item_id'], ))
isbn_data = cursor.fetchall()
for prop in isbn_data:
if prop[0] is not None:
item['isbn_10'].append(prop[0])
if prop[1] is not None:
item['isbn_13'].append(prop[1])
if Item.checkStock(item['item_id']):
item['in_stock'] = 1
cursor.execute(
"""SELECT c.collection_id, name FROM collections c
INNER JOIN collections_items ci ON c.collection_id=ci.collection_id
WHERE ci.item_id = %s""", (item['item_id'], ))
c_names = cursor.fetchall()
c_ids = []
if c_names:
item['in_collections'] = []
for c_name in c_names:
item['in_collections'].append(c_name[1])
c_ids.append(c_name[0])
item.update(Item.getCustomProperties([item]))
if custom_keys:
for key in custom_keys.keys():
item[key] = custom_keys[key]
return item
