Skip to content

Instantly share code, notes, and snippets.

def get_collections(skuNo):
db = Database.Database('rugsystem_new')
db.local.execute("SELECT * FROM rugsystem_new.ul_skus US LEFT JOIN rugsystem_new.ul_designs UD ON US.design_id = UD.id LEFT JOIN rugsystem.ul_collections UC ON UD.collection_id = UC.id WHERE US.SkuNo = {}".format(int(skuNo)))
collect = {}
return collect