def t_get_product(): db = MysqlHelper() products = db.get_products() for p in products: images = p['images'] s = images.replace("\\", "").replace("\'", "\"") s = json.loads(s) print(s[1]['sku'])
def get_property_keys(): db = MysqlHelper() products = db.get_products() all_keys = set() for p in products: try: properties = format_data(p['properties']) properties = json.loads(properties) keys = properties.keys() for k in keys: all_keys.add(k) except Exception as e: print(p['id']) print(p['properties']) return all_keys