Guest User

Untitled

a guest
Jul 18th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.55 KB | None | 0 0
  1. import sqlite3
  2. mydatabase="F:\Labelmaker\skudb.db"
  3. connection = sqlite3.connect(mydatabase)
  4.  
  5. with connection:
  6.     connection.row_factory = sqlite3.Row
  7.     cursor = connection.cursor()
  8.     listofskus = ("ZI01","WT405","WL011")
  9.     sql = 'select * from products where SKU in %s' % str(tuple(listofskus))
  10.     cursor.execute(sql)
  11.     allresults = cursor.fetchall()
  12.    
  13. for x in allresults:
  14.     print "SKU: " + str(x["SKU"]) + " VENDOR: " + str(x["vendor"]) + " MSRP: " + str(x["MSRP"]) + " Retail: " + str(x["Retail"]) + " Barcode: " + str(x["barcode"])
Add Comment
Please, Sign In to add comment