def __init__(self,mode):
self.path = os.path.dirname(__file__)
self.autoprocess = 'AUTOPROCESS'
self.cap = 'CAP'
self.ast = 'AST'
self.confObj = conf()
capDetails = self.confObj.readPath(self.cap)
self.capServerDetails = [capDetails['dbhost'],capDetails['dbport'],capDetails['dbuser'],capDetails['dbpasswd'],capDetails['dbname']]
astDetails = self.confObj.readPath(self.ast)
self.astServerDetails = [astDetails['dbhost'],astDetails['dbport'],astDetails['dbuser'],astDetails['dbpasswd'],astDetails['dbname']]
autoprocessDetails = self.confObj.readPath(self.autoprocess)
self.autoprocessServerDetails = [autoprocessDetails['dbhost'],autoprocessDetails['dbport'],autoprocessDetails['dbuser'],autoprocessDetails['dbpasswd'],autoprocessDetails['dbname']]
self.capDatabaseObj = database(*self.capServerDetails)
self.autoDatabaseObj = database(*self.autoprocessServerDetails)
self.ip = self.capServerDetails[0]
self.mode = mode
if mode == 'UDS':
if os.path.exists('udssettings.pyc'):
os.remove('udssettings.pyc')
settings = __import__('udssettings')
else:
if os.path.exists('fullsettings.pyc'):
os.remove('fullsettings.pyc')
settings = __import__('fullsettings')
self.GridSettings = settings.GridSettings
self.QualSettings = settings.QualSettings
self.QuantSettings = settings.QuantSettings
#sleep time
self.sleepTime = self.GridSettings.sleepTime
#self.qualDocsQuery = self.GridSettings.qualDocsQuery
#self.quantDocsQuery = self.GridSettings.quantDocsQuery
self.qualNodeProfileMap,self.quantNodeProfileMap = self.getNodes()
self.qualProfiles,self.quantProfiles = self.getProfiles()
# self.qualNodes,self.quantNodes = {},{}
self.qualDocsLimit = self.QualSettings.qualDocsLimit
self.quantDocsLimit = self.QuantSettings.quantDocsLimit
self.qualDocsQuery = self.GridSettings.qualDocsQuery
self.quantDocsQuery = self.GridSettings.quantDocsQuery
# self.qualNodes = self.__getQualNodes()
# self.quantNodes = self.__getQuantNodes()
#self.__modifyConfFile(self.qualNodes,self.quantNodes)
#self.path = __fi
self.startPoller()
def quote_bot():
global tweet
global quote
global author
# create a database for quotes
database()
# count nr of tweets
tweet_count = 0
# call function in every 3 hours
threading.Timer(10800, quote_bot).start()
get_quote()
# access twitter
twitter = Twython(consumer_key, consumer_secret, access_token,
access_token_secret)
# check if the tweet is no longer than 140 char and it has not been tweeted before
if len(tweet) <= 140 and check_quote(quote):
try:
twitter.update_status(status=tweet)
print("Tweeted: {}".format(tweet))
# increase tweet_count by one
tweet_count += 1
# add quote to the database
add_quote(quote, author)
#prints tweeted quote
print("quotebot has tweeted {} quotes".format(tweet_count))
# if quote already tweeted, pass
except Exception as e:
pass
else:
print("Already tweeted")
def initialize(self):
self.localCapDb = database(*self.capServerDetails)
self.localAstDb = database(*self.astServerDetails)
if self.mode == "DB":
self._nodeComponent = QuantDbComponent(self.localCapDb,self.localAstDb,self.nodeServerDetails,self.settings)
else:
self._nodeComponent = QuantFtpComponent(self.localCapDb,self.localAstDb,self.nodeServerDetails,self.settings)
def addMembers(self, board, members):
for n in members:
self.members.append(n)
database().addMembers(board, members)
def assignTasks(self, task):
return 0
def makeBoard(self):
return 0
def run(self):
while True:
username = self.typing("username")
if database().checkUsername(username):
password = self.typing("password")
if database().checkPassword(username, password):
break
else:
print("incorrect password")
else:
print("incorrect username")
def __init__ (self, itemID):
global q
q = Queue()
self.itemID = itemID
url = database().getWebsitePriceURL(itemID)
self.url_list = []
if url is not None and "." in url :
if not url.startswith("http"):
self.price_url = "http://" + url
else:
self.price_url = url
self.rawPriceURL = re.sub(r'^http(s)?://(www.)?',"", self.price_url)
self.url_list.append(self.price_url)
for i in range(19):
t = Thread(target = self.__getSnapshotLinks, args = (self.price_url,))
t.daemon = True
t.start()
for year in range(2014, 1995, -1):
q.put(year)
q.join()
else:
self.price_url = None
url = database().getWebsiteFeatureURL(itemID)
self.sameLink = False
if url is not None and "." in url:
if not url.startswith("http"):
self.feature_url = "http://" + url
else:
self.feature_url = url
self.rawFeatureURL = re.sub(r"^http(s)?://(www.)?","", self.feature_url)
if not (url == database().getWebsitePriceURL(itemID)):
self.url_list.append(self.feature_url)
for i in range(19):
t = Thread(target = self.__getSnapshotLinks, args = (self.feature_url,))
t.daemon = True
t.start()
for year in range(2014, 1995, -1):
q.put(year)
q.join()
else:
self.sameLink = True
else:
self.feature_url = None
self.url_list = sorted(set(self.url_list), reverse=True)
def __init__(self):
self.step = 1
logPath = './log/' + datetime.datetime.now().strftime('%Y%m%d%H%M%S') + '/'
os.makedirs(logPath)
self.initLog(logPath)
self.targetVersion = self.getConfig('image','targetVersion')
self.db = database()
root = Tk()
# 设置标题
root.title('Python GUI Learning')
# 获取屏幕尺寸以计算布局参数，使窗口居屏幕中央
screenwidth = root.winfo_screenwidth()
screenheight = root.winfo_screenheight()
alignstr = '%dx%d+%d+%d' % (width, height, (screenwidth - width) / 2, (screenheight - height) / 2)
root.geometry(alignstr)
# 设置窗口是否可变长、宽，True：可变，False：不可变
root.resizable(width=False, height=True)
self.sn = StringVar()
self.mac1 = StringVar()
self.version = StringVar()
self.isCheckRepeate = IntVar()
self.isCheckRepeate.set(1)
self.version.set('{}'.format(self.targetVersion))
self.stateLabels = []
frameRoot = Frame(root)
topF = Frame(frameRoot)
for i in range(1,stepCount + 1):
label = Label(topF, text="{}".format(i))
label.pack(side=LEFT)
self.stateLabels.append(label)
topF.pack(side=TOP,anchor=NW)
midF = Frame(frameRoot)
midLeftF = Frame(midF)
Label(midLeftF, text="参数:",width=labelWidth,justify=LEFT,anchor=W).pack(side=TOP,anchor=W)
buttonF = Frame(midLeftF)
self.connectCmB = Button(buttonF, text='连接CM',command=self.connectCm,state='normal')
self.connectCmB.pack(side=LEFT)
self.startB = Button(buttonF, text='开始测试',command=self.testStart,state='disabled')
self.startB.pack(side=LEFT)
self.ledTestSuccessB = Button(buttonF, text='LED全部点亮',command=self.ledSuccess,state='disabled')
self.ledTestSuccessB.pack(side=LEFT)
self.ledTestFailB = Button(buttonF, text='LED没有点亮',command=self.ledFail,state='disabled')
self.ledTestFailB.pack(side=LEFT)
self.resetTestB = Button(buttonF, text='Reset测试',command=self.resetTest,state='disabled')
self.resetTestB.pack(side=LEFT)
self.resetTestFailB = Button(buttonF, text='人工确认失败',command=self.resetTestFail,state='disabled')
self.resetTestFailB.pack(side=LEFT)
buttonF.pack(side=BOTTOM,anchor=E,expand=YES,fill=Y)
midLeftF.pack(side=LEFT,anchor=NW,expand=YES,fill=Y)
midRightF = Frame(midF)
Label(midRightF, text="日志:",width=labelWidth,justify=LEFT,anchor=W).pack(side=TOP,anchor=W)
self.logText = Text(midRightF,width=60,state=DISABLED)
self.logText.pack(side=TOP,anchor=W,expand=YES,fill=BOTH)
midRightF.pack(side=RIGHT,expand=YES,fill=Y)
midF.pack(side=TOP,anchor=NW,expand=YES,fill=Y)
frameRoot.pack(side=TOP,anchor=NW,expand=YES,fill=Y)
root.mainloop()
def __init__(self):
self.db = database()
self.db.initDataBase()
self.albumCol = albumCollection(self)
self.artistCol = artistCollection(self)
self.musicDirectoryCol = musicDirectoryCollection(self)
self.styleIDList = []
def __varification(self):
data = database()
if (data.validate(self.__entry_user_name.get(),
int(self.__entry_passwd.get()))):
print("sing in succussfully")
else:
print("unsuccessfull")
def go(self): setting['db'] = database(setting['home'], 'istock') setting['db'].install() self.fire_financial_keys() year = setting['years'][-1] total_elapsed = 0 for method in ['urllib2']: setting['crawler'].set_method(method) self.fire_market() self.fire_industry() elapsed = 0 beg_t = time.time() print '%s> year=%d %s go'%(get_time(beg_t), year, method) self.fire_stock(year) elapsed = time.time() - beg_t total_elapsed += elapsed print '%s> year=%d %s byebye, elapsed %ds'%(get_time(time.time()), year, method, elapsed) print 'total elapsed %ds'%(total_elapsed)
def init_database(dbName='USERDATA.db'):
db = database(dbName)
db.dropUSER()
db.dropDEVICE()
db.createUSER()
db.createDEVICE()
db.insertUSER(2013210131,
'210131',
2,
department='Technical',
position='CEO',
name='Reimu')
db.insertUSER(2013210132,
'210132',
2,
department='Sales',
position='COO',
name='Yuyuko')
db.insertUSER(2013210133,
'210133',
3,
department='Accounting',
position='CIO',
name='Cirno')
db.insertUSER(2013210134,
'210134',
2,
department='Operations',
position='CTO',
name='Flandre')
def find_search(self, b):
#try:
date = b.get_object("search_date").get_text()
if date != '':
date = datetime.datetime.now().strptime(date,"%d-%m-%Y").strftime("%Y-%m-%d")
code = b.get_object("search_cust_name").get_text()
bill_no = b.get_object("search_bill_no").get_text()
import string;code = string.lower(code)
try:bill_no = int(bill_no)
except ValueError: bill_no = 0
db = database()
c = db.crsr()
cur = c.cursor()
arr = cur.execute("SELECT bill_no, buyer_name FROM bill where bill_no = ? OR sell_date = ? OR buyer_code = ? ORDER BY bill_no",(bill_no, date, code))
ab = ""
i = ()
for a in arr:
i = i + a
cc = 0
k = len(i)/2
for j in range(k):
count = cc * 2
ab = ab + str(i[count]) + "\t " + str(i[count + 1]) + "\n"
cc = cc + 1
b.get_object("search_result").set_text(ab)
del ab
c.commit()
def loadDatabase(self):
try:
self.db = database()
except Exception,e:
QtGui.QMessageBox.about(self,"Notification","No Database Available!<br>Is Wamp Sever On?")
print "no database Available"
return
def viewrecord(self, b):
strtemp = b.get_object("entry12").get_text()
db = database()
con = db.crsr()
cur = con.cursor()
arra = cur.execute("SELECT pur_date, grand_total, paid FROM purchase where party_name = ?",(strtemp,))
date = ''
grndtotal = ''
gt = 0.0
paid = 0.0
arr = ()
for n in arra:
arr = arr + n
count = len(arr)/3
i = 0
for n in range(count):
i = i * 3
date = date + str(arr[i]) + '\n'
grndtotal = grndtotal + str(arr[i+1]) + '\n'
gt = gt + float(arr[i+1])
paid = paid + float(arr[i+2])
gt= str(gt)
paid = str(paid)
b.get_object("purdate").set_text(str(date))
b.get_object("billpur").set_text(str(grndtotal))
b.get_object("label91").set_text(str(gt))
b.get_object("label93").set_text(str(paid))
def __init__ (self, itemID):
self.itemID = itemID
self.db = database()
url = self.db.getWebsitePriceURL(itemID)
self.url_list = []
if url is not None and "." in url :
if not url.startswith("http"):
self.price_url = "http://" + url
else:
self.price_url = url
else:
self.price_url = None
url = self.db.getWebsiteFeatureURL(itemID)
self.sameLink = False
if url is not None and "." in url:
if not url.startswith("http"):
self.feature_url = "http://" + url
else:
self.feature_url = url
if (url == self.db.getWebsitePriceURL(itemID)):
self.sameLink = True
else:
self.feature_url = None
def itad(self, b):
db = database()
c = db.crsr()
i = c.cursor().execute("SELECT * FROM item_list ORDER BY item_no ")
arra = []
cc = 0
for arr in i:
if cc == 0:arra = arr; cc = cc + 1
else:arra = arra + arr
y = ""
zee = ""
x = ""
i = c.cursor().execute("SELECT * FROM item_list")
cc = 0
for countall in i:
count = cc * 3
y = y + str(arra[count]) + "\n\n"
zee = zee + str(arra[count + 1]) + "\n\n"
x = x + str(arra[count + 2]) + "\n\n"
cc = cc + 1
b.get_object('item_n').set_text(y)
b.get_object('item_nam').set_text(zee)
b.get_object('item_rate').set_text(x)
def purchase(self, b):
srno = b.get_object("entry3").get_text()
srno = int(srno)
date = b.get_object("entry4").get_text()
name = b.get_object("entry5").get_text()
total = float(b.get_object("entry6").get_text())
tax = float(b.get_object("entry7").get_text())
othrcharges = float(b.get_object("entry8").get_text())
paid = float(b.get_object("entry9").get_text())
cheque = b.get_object("entry10").get_text()
date = datetime.datetime.now().strptime(date,"%d-%m-%Y").strftime("%Y-%m-%d")
amnt = total + tax + othrcharges
db = database()
con = db.crsr()
cur = con.cursor()
arr = cur.execute("SELECT bill_no from purchase where bill_no = ?",(srno,))
at = ""
for i in arr:
at = at + str(i)
if at == "":
x = 0
else:
x = 1
if x == 0:
cur.execute("INSERT INTO purchase VALUES (?,?,?,?,?,?,?,?,?)",(srno, date, name, total, tax, othrcharges, amnt, paid, cheque))
if x == 1:
cur.execute("UPDATE purchase set pur_date = ?, party_name = ?, total = ?, tax = ?, othercharges = ?, grand_total = ?, paid = ?, cheque_no = ? WHERE bill_no = ?",(date, name, total, tax, othrcharges, amnt, paid, cheque, srno))
con.commit()
def run(self):
self.doStop = False
db = database()
db.initMemoryDB()
self.musicBase.db = db
self.musicBase.musicDirectoryCol.db = db
for mdir in self.musicBase.musicDirectoryCol.musicDirectories:
print("explore="+mdir.dirName)
self.directoryChanged.emit(mdir.dirName)
mdir.db = db
mdir.artistCol = self.musicBase.artistCol
mdir.albumCol = self.musicBase.albumCol
mdir.artistCol.db = db
mdir.albumCol.db = db
mdir.exploreDirectory(self.progressChanged)
if self.doStop: break
self.directoryChanged.emit("Saving datas..")
self.musicBase.db.saveMemoryToDisc()
#self.musicBase.artistCol.sortArtists()
self.exploreCompleted.emit(1)
self.quit()
def sav_bill_db(self, b, x):
db = database()
c = db.crsr()
cur = c.cursor()
amount = self.show(b, 1)
bill_no = int(b.get_object('invoice_no').get_text())
sell_date = str(b.get_object('sell_date').get_text())
sell_date = datetime.datetime.now().strptime(sell_date,"%d-%m-%Y").strftime("%Y-%m-%d")
vat = float(b.get_object('vat').get_text())
vat = amount * (vat / float(100))
othr_chrgs = float(b.get_object('other_charges').get_text())
round_off = ((amount + vat)*100)/100
round_off = int(round_off)
grand_total = round_off + othr_chrgs
grand_total = math.ceil(grand_total)
buyer_name = str(b.get_object("name").get_text())
buyer_addr = str(b.get_object("address").get_text())
buyer_code = str(b.get_object("code").get_text())
vat = float(b.get_object('vat').get_text())
import string; buyer_code = string.lower(buyer_code)
if x == 1:
cur.execute("UPDATE bill set sell_date = ?, amount = ?, vat = ?, other_charges = ?, buyer_name = ?, buyer_addr = ?, buyer_code =? WHERE bill_no = ?",(sell_date, amount, vat, othr_chrgs, buyer_name, buyer_addr, buyer_code, bill_no))
else:
cur.execute("INSERT INTO bill VALUES (?,?,?,?,?,?,?,?)",(bill_no, sell_date, amount, vat, othr_chrgs, buyer_name, buyer_addr, buyer_code))
c.commit()
grand_total = str(grand_total)
b.get_object("grand_total").set_text(grand_total)
def Message(msg):
defaultMsg = "정보통신공학과 공지사항 알림봇 입니다.\n공지사항에 새로운글이 업로드되면 알림이 전송됩니다!" # default message
helpmsg = "!등록: 알림시작\n!종료: 알림종료\n!최근글: 최근에 등록된 게시글(2개)"
content, chat, id = telepot.glance(msg) # 메시지를 수신하면 내용, chat, id로 반환
try:
if database('check', id=id) is False: # 사용자 정보가 등록되지 않은 경우
if msg['text'] == '/start' or msg['text'] == '!등록': # 등록
bot.sendMessage(id, defaultMsg)
bot.sendMessage(id, '이제부터 알림서비스가 제공됩니다.')
database('register', id=id)
else:
bot.sendMessage(id,
'등록되지 않았습니다.\n알림을 수신하려면 !등록 명령어를 먼저 입력해주세요!')
print('등록되지 않았습니다. 사용자 ID: ', id)
else: # 사용자 정보가 등록된 경우
if content == 'text':
print('수신한 메시지: ', msg['text'], ' 사용자 ID: ', id)
if msg['text'] == '!종료': # 삭제
bot.sendMessage(id, '알림 종료!')
database('delete', id=id)
elif msg['text'] == '/start' or msg['text'] == '!등록': # 등록
bot.sendMessage(id, '이미 등록된 계정입니다!')
elif msg['text'] == '!최근글': # 최근글
bot.sendMessage(id, '최근글 2개 불러오는중...')
# WEB crawling
crawling()
feed = feedparser.parse('rssList.xml')
for i in range(param.message_num):
bot.sendMessage(id, feed['entries'][i]['title'])
bot.sendMessage(id, feed['entries'][i]['link'])
else:
bot.sendMessage(id, '무슨 말인지 모르겠어요')
bot.sendMessage(id, helpmsg)
print('unknown message')
else:
bot.sendMessage(id, defaultMsg)
bot.sendMessage(id, helpmsg)
except Exception as e: # 예외처리
bot.sendMessage(857044101, 'error!: ' + str(e))
def del_description(self, no, b):
db = database()
c = db.crsr()
cur = c.cursor()
bno = int(b.get_object('invoice_no').get_text())
cur.execute("DELETE FROM description where sr_no = ? AND bill_no = ?", (no, bno))
c.commit()
self.show(b, 0)
def __init__(self, game):
self.db = database("leaderboard")
self.game = game
if self.db.check_table_exists(game):
self.db.create_table(
self.game,
"(username VARCHAR(255), score INT(255), score_date DATETIME DEFAULT NOW())"
)
def __init__(self,srcDb,destDb,mode,workflow):
if workflow == "QL":
self.tablesToCompare = self.qlTablesToCompare
else:
self.tablesToCompare = self.qtTablesToCompare
self.workflow = workflow
self.srcDb = database(srcDb,srcDb)
self.destDb = self.srcDb #database(destDb,destDb)
self.reg = re.compile('[\s]+')
def init_database(dbName='USERDATA.db'):
db = database(dbName)
db.dropUSER()
db.dropDEVICE()
db.createUSER()
db.createDEVICE()
db.insertUSER(2013210131,'210131',2,department='Technical',position='CEO',name='Reimu')
db.insertUSER(2013210132,'210132',2,department='Sales',position='COO',name='Yuyuko')
db.insertUSER(2013210133,'210133',3,department='Accounting',position='CIO',name='Cirno')
db.insertUSER(2013210134,'210134',2,department='Operations',position='CTO',name='Flandre')
def singupdestroy():
if entry_passwd.get()==entry_repasswd.get():
data = database()
data.insert_data(entry_user_name.get(),entry_passwd.get())
singup_frame.destroy()
singup_message()
else:
singup_frame.destroy()
singup()
def __init__(self, params):
print "Initializing Module..."
self.params = params
self.sess = tf.Session()
self.DB = database(self.params["db_size"], self.params["input_dims_proc"])
self.engine = emulator(rom_name="breakout.bin", vis=True)
self.params["num_act"] = len(self.engine.legal_actions)
self.build_nets()
self.Q_global = 0
self.cost_disp = 0
def update_town_register(self, cache, iter_num,N):
pigs_info=[]
for item in cache.items():
pigs_info.append(list(item))
d=database(N)
for pig in pigs_info:
d.update_location(pig[0],pig[1][1][0], pig[1][1][1]);
for pig in pigs_info:
d.update_Status(pig[0],pig[1][0],iter_num);
def scan_full(r_file, r_name=None):
d_rules = database()
ruleset = []
if r_name:
for rule in d_rules.list_rules():
if rule[0] == r_name:
ruleset.append([rule[0], rule[1]])
else:
ruleset = d_rules.list_rules()
scan = ISD_Scanner(r_file, ruleset)
scan.start()
def i_num(self):
db = database()
c = db.crsr()
i = c.execute("SELECT item_no FROM item_list")
array = []
for arr in i: array = arr
try:
no = array[-1] + 1
except:
no = 1
return no
def __init__(self, params):
print 'Initializing Module...'
self.params = params
self.sess = tf.Session()
self.DB = database(self.params['db_size'],
self.params['input_dims_proc'])
self.engine = emulator(rom_name='breakout.bin', vis=True)
self.params['num_act'] = len(self.engine.legal_actions)
self.build_nets()
self.Q_global = 0
self.cost_disp = 0
def scan_full(r_file, r_name = None):
d_rules = database()
ruleset = []
if r_name:
for rule in d_rules.list_rules():
if rule[0] == r_name:
ruleset.append([rule[0],rule[1]])
else:
ruleset = d_rules.list_rules()
scan = ISD_Scanner(r_file, ruleset)
scan.start()
def invoice_num(self):
db = database()
c = db.crsr()
i = c.execute("SELECT MAX(bill_no) FROM bill")
array = ()
for arr in i: array = arr
if array[0] is not None :
no = array[-1] + 1
else:
no = 1
return no
def show_db():
db = database()
print 'TABLE_GATEWAY:'
printDataSet(db.selectGATEWAY())
print '\nTABLE_DEVICE:'
printDataSet(db.selectDEVICE())
dpid_list = db.getDPIDLIST()
for dpid in dpid_list:
print '\nTABLE_DPID{dpid}'.format(dpid=dpid)
printDataSet(db.selectDPID(dpid))
def crawler_tb(self,depth, goods):
url_start = 'https://s.taobao.com/search?q=' + goods
for i in range(depth):
try:
url_each = url_start + '&s=' + str(44*i)
html = self.getHTMLText(url_each)
lst_tb = self.parser_tb(html)
d = database()
d.saveInfo(lst_tb,goods,'tb')
d.closeConn()
except:
print('tb出现异常')
def __init__(self, path):
zip = ZipFile(path)
with zip.open("plugin.yml") as pluginInfo:
yaml = pluginInfo.read().decode()
self.path = path
self.origin = dirname(path)
self.name = sub("\r|\n", "", findall("name: (.*)", yaml)[0])
self.version = sub("\r|\n", "", findall("version: (.*)", yaml)[0])
self.packageName = sub("\r|\n", "", findall("main: (.*)", yaml)[0])
self.hash = md5(bytes("{0}{1}".format(self.origin, yaml), "utf-8")).hexdigest()
self.fileHash = self.__getMD5()
self.database = database()
def crawler_am(self,depth, goods):
url_start = 'https://list.tmall.com/search_product.htm?q='+goods
for i in range(depth):
try:
url_each = url_start +'&s='+str((i-1)*60)
html = self.getHTMLText(url_each)
lst_am = self.parser_am(html)
d = database()
d.saveInfo(lst_am,goods,'am')
d.closeConn()
except:
print('TMALL出现异常')
def crawler_jd(self,depth, goods):
url_start = 'https://search.jd.com/Search?keyword='+goods+'&enc=utf8&page='
for i in range(depth):
try:
url_each = url_start + str(i*2+1)
html = self.getHTMLText(url_each)
lst_jd = self.parser_jd(html)
d = database()
d.saveInfo(lst_jd,goods,'jd')
d.closeConn()
except:
print('jd出现异常')
def __init__(self,params): print 'Initializing Module...' self.params = params self.gpu_config = tf.ConfigProto(gpu_options = tf.GPUOptions(per_process_gpu_memory_fraction=self.params['gpu_fraction'])) self.sess = tf.Session(config=self.gpu_config) self.DB = database(self.params) self.engine = emulator(rom_name='breakout.bin', vis=self.params['visualize'],windowname=self.params['network_type']+'_preview') self.params['num_act'] = len(self.engine.legal_actions) self.build_net() self.training = True
def __init__(self,params):
print('Initializing Module...')
self.params = params
self.gpu_config = tf.ConfigProto(gpu_options = tf.GPUOptions(per_process_gpu_memory_fraction=self.params['gpu_fraction']))
self.sess = tf.Session(config=self.gpu_config)
self.DB = database(self.params)
self.engine = emulator(rom_name='breakout.bin', vis=self.params['visualize'],windowname=self.params['network_type']+'_preview')
self.params['num_act'] = len(self.engine.legal_actions)
self.build_net()
self.training = True
self.lock = _thread.allocate_lock()
def item_add(self, re, name, rate):
name = name
rate = rate
db = database()
c = db.crsr()
na = c.cursor().execute("SELECT item_name FROM item_list")
for arr in na:
if name in arr:
import easygui
easygui.msgbox("Item Exist")
return 0
c.cursor().execute("INSERT INTO item_list(item_no, item_name, item_rate) VALUES (?, ?, ?)", (re, name , rate))
c.commit()
def main():
db = database('F:\Dropbox\My Dropbox\programming\python\db')
add =[input("---Add---\nWebsite:"), input("\nPassword:"******"Search: ")])
self.debug ('Data:', data)
self.debug ("Trying to wrap")
#w = wrapper("SuperSecretPassword")
self.debug ('done')
def crawl(self, index_list): #list of indexes of url_list[]
noThreads = min(self.getNumberOfSnapshots(), 20) + 1
for i in range(noThreads):
t = Thread(target = self.__crawlOne)
t.daemon = True
t.start()
for index in index_list:
if (index < 0 or index >= len(self.url_list)):
continue
temp_url = self.url_list[index]
if self.feature_url is not None and self.rawFeatureURL in temp_url:
if database().isFeatureSnapshotInDB(self.itemID, index) == False:
q.put((index, temp_url))
elif self.price_url is not None and self.rawPriceURL in temp_url:
if database().isPriceSnapshotInDB(self.itemID, index) == False:
q.put((index, temp_url))
time.sleep(5) # make sure q.get timeout before join unblocks
q.join()
if self.sameLink:
database().copyFromFeatureToPrice(self.itemID)
def __crawlOne(self):
driver = self.__getPhantomJSDriverWithRetry(5)
while True:
try:
(index, link) = q.get(True, 2) #2 sec timeout
except Exception as e:
print "Queue empty, all task done. %s" %e
if driver is not None:
driver.quit()
return
else:
try:
if link.startswith(self.wm):
date = link[27:35]
else:
date = time.strftime("%Y%m%d")
data = self.__getDataFromPhantomBrowser(driver, link)
if data is None:
data = self.__getDataFromURLLIB(link)
if data is not None:
if self.feature_url is not None and self.rawFeatureURL in link:
database().storeFeatureSnapshot(self.itemID, index, date, link, data)
elif self.price_url is not None and self.rawPriceURL in link:
database().storePriceSnapshot(self.itemID, index, date, link, data)
else:
print "Price or Feature??? URL: %s. Date: %s" % (link, date)
else:
print "Crawl-error: %s" % link
q.task_done()
except Exception as e:
print "Crawling error %s" % e
if driver is not None:
driver.quit()
driver = self.__getPhantomJSDriverWithRetry(5)
q.task_done()
def __init__(self, device=None, init_options=None, game=nature_params['game']):
super(DeepQ,self).__init__(device=device, init_options=init_options)
assert game in ["breakout", "space_invaders", "seaquest"]
self.G = tf.Graph()
# NOTE: moved tf.Graph construction to setup
self.params = nature_params
self.DB = database(self.params)
self.engine = emulator(rom_name='{}.bin'.format(game), vis=self.params['visualize'], frameskip=self.params['frameskip'], windowname=self.params['window_name'])
#self.engine = emulator(rom_name='{}.bin'.format(game), vis=self.params['visualize'], frameskip=self.params['frameskip'], windowname=self.params['window_name'])
self.params['num_act'] = len(self.engine.legal_actions)
with self.G.device(device):
self.build_inference()
def show(self, b, x):
db = database()
c = db.crsr()
bno = b.get_object('invoice_no').get_text()
if bno == '':
bno = b.get_object('entry2').get_text()
bno = int(bno)
i = c.cursor().execute("SELECT * FROM description where bill_no = ? ORDER BY sr_no",(bno,))
arra = ()
cc = 0
for arr in i:
if cc == 0:arra = arr; cc = cc + 1
else:arra = arra + arr
sr_no = ""
item_name = ""
quantity = ""
i = c.cursor().execute("SELECT * FROM description where bill_no = ? ORDER BY sr_no",(bno,))
cc = 0
amt = ""
weigh = ""
amount_total = 0.0
for countall in i:
count = cc * 5
sr_no = sr_no + str(arra[count]) + "\n"
no = int(arra[count + 2])
nn = c.cursor().execute("SELECT item_name FROM item_list where item_no = ?",(no,))
amnt = c.cursor().execute("SELECT item_rate FROM item_list where item_no = ?",(no,))
for i in nn:
nam = i
for i in amnt:
amount = i
amount = float(amount[0]) * arra[count + 3]
item_name = item_name + str(nam[0]) + "\n"
amt = amt + str(amount) + "\n"
amount_total = amount_total + float(amount)
quantity = quantity + str(arra[count + 3]) + "\n"
weigh = weigh + str(arra[count + 4]) + "\n"
cc = cc + 1
b.get_object('item_no').set_text(sr_no)
b.get_object('item_name').set_text(item_name)
b.get_object('quantity').set_text(quantity)
b.get_object('price').set_text(amt)
b.get_object('weight').set_text(weigh)
if x == 1:
return (float(amount_total))
def get_target(self,N,pigs):
d=database(N)
status=[]
for i in range(len(pigs)):
status.append(d.get_status(pigs[i]));
not_hit=[]
for i in range(len(status)):
if status[i]==0:
not_hit.append(pigs[i]);
if not_hit==[]:
target=choice(pigs)
else:
target=choice(not_hit);
return target
def __init__(self, par):
print 'Initializing Module...'
self.par = par #to hold the parameters
self.sess = tf.Session() #starting the session
self.DB = database(self.par['db_size'], self.par['input_dims_proc'])
# self.engine = featureExtractor()
# self.maze = MAZE()
# self.pac = Pacman()
# self.blinky = Blinky()
# self.inky = Inky()
self.par['num_act'] = 5 #number of possible actions
self.build_nets()
self.Q_global = 0
self.Q_temp = np.zeros(4) #to store Q_temp for every action
self.state_temp = np.zeros(5)
self.cost_disp = 0
self.validactions = [
] #if validactions[index] = 1, action corresponding to that index can't be taken
def detect(request):
image_b64 = request.input
# generate file name for image
file = generateImageName()
file += '.jpeg'
print(file)
# origin, taged and result path
origin_image_path = 'database/origins/' + file
taged_image_path = 'database/tagged/' + file
result_image_path = 'database/results/' + file
print(len(result_image_path))
# origin image transfrom format from base64 to jpeg
imgdata = base64.b64decode(image_b64)
img_np = np.fromstring(imgdata, np.uint8)
img = cv2.imdecode(img_np, cv2.IMREAD_COLOR)
# save jpeg image
cv2.imwrite(origin_image_path, img)
cv2.imwrite(taged_image_path, img)
print('Cloud server has successfully received image')
# object detection
image_b64 = object_detection(origin_image_path)
print('Cloud server has completed object detection')
# result image transform format from base64 to jpeg
imgdata = base64.b64decode(image_b64)
img_np = np.fromstring(imgdata, np.uint8)
img = cv2.imdecode(img_np, cv2.IMREAD_COLOR)
cv2.imwrite(result_image_path, img)
# insert database table origins, taged and results
# connect to the database
mydb = database()
mydb.createTable()
mydb.insert("origins", "'" + origin_image_path + "'")
mydb.insert("tagged", "'" + taged_image_path + "', FALSE")
mydb.insert("results", "'" + result_image_path + "'")
print('Cloud server has inserted records into database!')
return image_b64
def high_score():
"""
Show high score
"""
for event in pygame.event.get():
if event.type == pygame.QUIT:
pygame.quit()
sys.exit
images = load_images();
#Scrolling background declaration
back = Background(images['background'], images['background'].get_size(), height)
screen.fill((255, 231, 181))
#Draw background
screen.blit(back.image, back.rect)
screen.blit(back.image, back.rect2)
screen.blit(back.image, back.rect3)
#Make background scroll
back.scroll()
message_to_screen("High Score",
blue,
-100,
"large")
rows = database().printTable()
for index,row in enumerate(rows):
message_to_screen(str(row[0]),
blue,
-50 + index * 20,
"medium")
if(index > 7):
break
pygame.display.update()
clock.tick(FPS)
choose = option_menu(screen, [
'Back'], 250, 400, None, 32,1.4,blue,red)
if choose == 0:
print "Back"
start_menu()
