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()
