Skip to content

Instantly share code, notes, and snippets.

@invalidusrname

invalidusrname/display_item py

Forked from ayang10/display_item py
Created January 7, 2019 14:30
Show Gist options
  • Save invalidusrname/5347c87ba54326fec061282728d11b35 to your computer and use it in GitHub Desktop.
Save invalidusrname/5347c87ba54326fec061282728d11b35 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
display_item py
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment