if choice == "A" or choice == "a": objBluetooth = BluetoothID() print("Performing Inquiry") #Looking for nearby devices nearby_devices = discover_devices(lookup_names = True) print ("found %d devices" %len(nearby_devices)) #Print out all the nearby devices for name in nearby_devices: print( "%s -%s" % (name)) #Fetching the mac address registered in the database obj = DatabaseUtil() phone = obj.getDeviceID("Altis") #split tuple so we get just the mac addr (addr, ownder) = name objBluetooth.Verify(addr, phone) elif choice == "B" or choice == "b": """ Main entry point of the program """ obj = QRCodeScanner() arguments = obj.argumentParser() # initialize the camera
from databaseUtil import DatabaseUtil from sessionUtil import SessionUtil from logUtil import LogUtil from dictUtil import DictUtil import traceback import json def handleData(returnStr): jsonData=json.loads(returnStr) dateList=jsonData.get('date') dataList=jsonData.get('data1') return dateList,dataList def storeData(dateStr,dataStr,conn,cur,wdzjPlatId): sql='insert into platIncomeRate (date,incomeRate,wdzjPlatId) values ("'+dateStr+'","'+dataStr+'","'+wdzjPlatId+'")' cur.execute(sql) conn.commit() conn,cur=DatabaseUtil().getConn() session=SessionUtil() logUtil=LogUtil("platIncomeRate.log") cur.execute('select wdzjPlatId from platData where month="2017-06"') data=cur.fetchall() print(data) mylist=list() print(data) for i in range(0,len(data)): platId=str(data[i].get('wdzjPlatId')) mylist.append(platId) print mylist for i in mylist: url='http://shuju.wdzj.com/plat-info-target.html'
def __init__(self): # 初始化一个数据库对象 self.dbUtil = DatabaseUtil()