Skip to content

Instantly share code, notes, and snippets.

@ayang10

ayang10/display_item py

Created January 7, 2019 14:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save ayang10/44ae677d996d715dcd850e295a5f6a52 to your computer and use it in GitHub Desktop.
Save ayang10/44ae677d996d715dcd850e295a5f6a52 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