def __init__(self):
# This sets up a variable for every component on this form.
# For example, if we've drawn a button called "send_button", we can
# refer to it as self.send_button:
self.init_components()
#self.mouse = physics.vector3(0,0)
self.slits = slits()
# self.slits.txt_N.set_event_handler("pressed_enter", self.change)
# self.slits.txt_d.set_event_handler("pressed_enter", self.change)
self.grid_opt.add_component(self.slits)
self.aperture = "slits"
self.grating = grating()
self.single = single()
#self.single.txt_a.set_event_handler("pressed_enter", self.change)
#self.grating.txt_n.set_event_handler("pressed_enter", self.change)
# Any code you write here will run when the form opens.
#Uncomment as required.
#self.running= False
self.reset = True
self.dt = self.timer.interval
self.first = True
#self.t = 0
#SET SCALE (pixels per m, or unit used in code)
self.xu = 1
self.ang_range = 2 * math.asin(float(self.W) / (2 * self.R))
def __init__(self):
# This sets up a variable for every component on this form.
# For example, if we've drawn a button called "send_button", we can
# refer to it as self.send_button:
self.init_components()
#self.mouse = physics.vector3(0,0)
self.slits = slits()
# self.slits.txt_N.set_event_handler("pressed_enter", self.change)
# self.slits.txt_d.set_event_handler("pressed_enter", self.change)
self.grid_opt.add_component(self.slits)
self.aperture = "slits"
self.grating = grating()
self.single = single()
#self.single.txt_a.set_event_handler("pressed_enter", self.change)
#self.grating.txt_n.set_event_handler("pressed_enter", self.change)
# Any code you write here will run when the form opens.
#Uncomment as required.
#self.running= False
self.reset = True
self.dt = self.timer.interval
self.first = True
#self.t = 0
#SET SCALE (pixels per m, or unit used in code)
self.xu = 1
self.ang_range = 2*math.asin(float(self.W)/(2*self.R))
def btn_single_click(self, **event_args):
self.grid_opt.clear()
self.single = single()
self.grid_opt.add_component(self.single)
self.aperture = "single"
self.rad_int.enabled = True
self.change()
def btn_single_click(self, **event_args):
self.grid_opt.clear()
self.single = single()
self.grid_opt.add_component(self.single)
self.aperture = "single"
self.rad_int.enabled = True
self.change()
from single import single
import paramiko
import os
'''
ssh = paramiko.SSHClient()
ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
ssh.connect(hostname="120.108.205.165",port="3389",username="******",password="******")
'''
db = pymysql.connect(host="",port=,user="******",passwd="max",db="project") # 連線至data server
cursor = db.cursor()
cursor.execute("select ID , done from RoadInfo");
results = cursor.fetchall()
print(results)
count = 0
for cols in results:
if(cols[1]==None):
path = '/home/user/GraduationProject/models/' + cols[0] + '.h5'
if(os.path.isfile(path)):
print(cols[0],'is exist')
else:
count += 1
single(cols[0])
cursor.execute("UPDATE RoadInfo set done = '1' where ID = '%s'"%(cols[0]))
db.commit()
#if(count%10==0):
# ssh_stdin, ssh_stdout, ssh_stderr = ssh.exec_command('sudo sh /GraduationProject/restart.sh')
#single(cols[0])
db.close()
cursor.close()
def book_single(self):
driver = webdriver.Firefox()
self.message = single(driver, self)
driver.close()
clock.tick(FPS)
for event in pygame.event.get():
if event.type == pygame.QUIT:
rep_loop = False
if event.type == pygame.KEYDOWN:
if event.key == pygame.K_ESCAPE:
rep_loop = False
if event.key == pygame.K_r:
rep_loop = False
repeat = True
screen.fill((255, 255, 255))
screen.blit(text, (x, y))
screen.blit(text_r, (x1, y1))
pygame.display.flip()
########################################## Game launch ##########################################
while repeat:
repeat = False
gamemode = ''
game_over = False
menu()
if gamemode == 's': game_over, winner, lost, kicked = single()
elif gamemode == 'm': game_over, winner, lost, kicked = multi()
elif gamemode == 'a': game_over, winner, lost, kicked = autoplay()
if game_over: again(winner, lost, kicked)
pygame.quit()
def on_chat_message(self, msg):
content_type, chat_type, chat_id = telepot.glance(msg)
msgtext = msg['text']
# print(chat_id)
# check if guest is on the list
current_guest = None
for person in guestList:
if person.check_chat_id(chat_id):
current_guest = person
break # stop iteration when guest is found
# when it is a new guest
if current_guest is None: # completely new
current_guest = guest(chat_id)
guestList.append(current_guest)
self.sender.sendMessage('What\'s you first name?')
return
if current_guest.state == 10: # new guest, he send his name now
current_guest.set_first_name(msg['text'])
print(
str(chat_id) + ":\t" + "New guest " + msg["text"] +
" added to guestList")
current_guest.set_state(0) # user is inactive now
self.sender.sendMessage('Hello ' + current_guest.first_name)
return
# checking the setter commands (adress, name, etc.)
# since this bot is for a german institution the commands are in German
if msgtext.startswith('/vorname'):
new_first_name = msgtext[9:]
current_guest.set_first_name(new_first_name)
self.sender.sendMessage('First name set to ' + new_first_name)
return
if msgtext.startswith('/nachname'):
new_last_name = msgtext[10:]
current_guest.set_last_name(new_last_name)
self.sender.sendMessage('Last name set to ' + new_last_name)
return
if msgtext.startswith('/strasse'):
new_street = msgtext[9:]
current_guest.set_street(new_street)
self.sender.sendMessage('Street set to ' + new_street)
return
if msgtext.startswith('/hausnummer'):
new_hn = msgtext[12:]
current_guest.set_house_number(new_hn)
self.sender.sendMessage('Housenumber set to ' + new_hn)
return
if msgtext.startswith('/stadt'):
new_city = msgtext[7:]
current_guest.set_city(new_city)
self.sender.sendMessage('City set to ' + new_city)
return
if msgtext.startswith('/plz'):
new_plz = msgtext[5:]
current_guest.set_plz(new_plz)
self.sender.sendMessage('New PLZ set to ' + new_plz)
return
if msgtext.startswith('/code'):
if len(msgtext) != 10:
self.sender.sendMessage(
'Für den Code formatiere deine Nachricht so:\n /code 1234')
return
tmp = msgtext[6:]
current_guest.set_code(tmp)
self.sender.sendMessage('Sicherheits-Code geändert')
return
# giving back all the information the bot has about a user
if msgtext.startswith('/info'):
print(
str(chat_id) + ":\t" + current_guest.first_name + ' ' +
' asked for his info')
message = 'The Information I currently have about you:\n'
message = message + current_guest.first_name
if current_guest.last_name is not None:
message = message + ' ' + current_guest.last_name
if current_guest.street is not None and current_guest.house_number is not None:
message = message + '\n'
message = message + current_guest.street + ' ' + \
current_guest.house_number
if current_guest.city is not None and current_guest.plz is not None:
message = message + '\n'
message = message + current_guest.plz + ' ' + \
current_guest.city
self.sender.sendMessage(message)
return
# booking a seat for your self
if msgtext.startswith('/alleine'):
self.sender.sendMessage('Ok, ich reserviere dir einen Platz')
driver = webdriver.Firefox()
single(driver, current_guest)
time.sleep(3)
driver.save_screenshot('screenshot.png')
self.sender.sendPhoto(open('screenshot.png', 'rb'))
driver.close()
return
# booking a chair for 2 people
if msgtext.startswith('/zwei'):
self.sender.sendMessage('Function not implemented yet!')
return
# when he did not understand
self.sender.sendMessage('Das habe ich nicht verstanden.')
if __name__ == "__main__":
# p=[]
# a=[]
# h=[]
# floor=[]
# t=[]
# s=[]
# l=[]
f = pd.read_csv(r"C:\Users\Administrator\Desktop\lianjie.csv",
encoding='ISO-8859-1',
sep=',',
header=None)
#断了之后直接将后面的值改一下，跟着断点之后继续下载
for link in f[1][1098:]:
p1, a1, h1, f1, t1, s1, l1 = single.single(link)
print(link)
p.append(p1)
a.append(a1)
h.append(h1)
floor.append(f1)
t.append(t1)
s.append(s1)
l.append(l1)
# lianjie=[]
# timu=[]
# for i in range(1,101):
# firsturl=r"https://bj.lianjia.com/zufang/pg%d/"%i
## list.append(firsturl)
# title,l=frist(firsturl)
