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