def on_mouse(event, x, y, flag, param): global usercount global demo_mode global saved_list if (event == cv.CV_EVENT_LBUTTONDOWN): #print x,y # runCapture = False # print imagefile + str(param) + '.jpg' if not demo_mode: apenom = get_guest("Introduzca nombre") else: apenom = "" if demo_mode or apenom: usercount = usercount + 1 user_id = user_id_base + str(usercount) if apenom: os.rename(imagefile + str(param) + '.jpg', user_id + '.jpg') with open(user_id + ".jpg", "rb") as handle: binary_data = xmlrpclib.Binary(handle.read()) handle.close() if server.put_file(USERNAME, PASSWORD, datastore_space, user_id + '.jpg', binary_data): #print "foto subida" #put in database try: # connect db = MySQLdb.connect(host=dbhost, user=dbuser, passwd=dbpass, db=dbname) cur = db.cursor() # try: cur.execute( "INSERT INTO fotos_jornadas (foto, user_id, nombre_comp) VALUES ('%s', '%s', '%s');" % (user_id + ".jpg", user_id, apenom)) db.commit() # except: # # Rollback in case there is any error # db.rollback() cur.close() db.close() info_dialog("Foto de " + apenom + " grabada correctamente") saved_list.append(user_id) except: #print dbhost+ " - "+ dbuser + " - "+ dbpass + " - "+ dbname error_dialog("Error grabando foto") else: error_dialog("Error mandando foto") else: os.rename(imagefile + str(param) + '.jpg', user_id + '.jpg') info_dialog("Foto Seleccionada") cv.DestroyWindow('crop' + str(param)) elif (event == cv.CV_EVENT_RBUTTONDOWN): cv.DestroyWindow('crop' + str(param))
def on_mouse(event, x, y, flag, param): global runCapture if(event == cv.CV_EVENT_LBUTTONDOWN): #print x,y runCapture = False #print imagefile + str(param) + '.jpg' os.rename( imagefile + str(param) + '.jpg', nia + '.jpg') with open(nia+".jpg", "rb") as handle: binary_data = xmlrpclib.Binary(handle.read()) handle.close() if server.put_file(USERNAME, PASSWORD, datastore_space, nia + '.jpg', binary_data): #put in database try: # connect db = MySQLdb.connect(host=dbhost, user=dbuser, passwd=dbpass, db=dbname) cur = db.cursor() try: if (NOT_IN_ADMITACA and NOT_IN_ALUMNOS and NOT_IN_PROFES): #cur.execute("INSERT INTO admitaca(foto_guardada, dni, nombre_comp) VALUES ('%s', '%s', '%s');" % ('1', nia, new_apenom)) #info_dialog(nia+".jpg - "+nia+" - "+new_apenom+ " - "+datetime.now().strftime('%Y%m%d')+ " - "+new_email) cur.execute("INSERT INTO excepciones_fotos(foto, DNI_NORM, nombre_comp, fecha_foto, email, tipo) VALUES ('%s', '%s', '%s', '%s', '%s', '%s' );" % (nia+".jpg", nia, new_apenom, datetime.now().strftime('%Y%m%d'), new_email, new_type)) elif (NOT_IN_ALUMNOS and NOT_IN_PROFESORES): # #cur.execute("UPDATE alumnos SET foto='%s' WHERE DNI_NORM='%s';" % (nia+".jpg", nia)) cur.execute("UPDATE admitaca SET email='%s' WHERE dni='%s';" % (new_email, nia)) elif (NOT_IN_ADMITACA and NOT_IN_PROFESORES): cur.execute("UPDATE alumnos SET foto='%s' WHERE DNI_NORM='%s';" % (nia+".jpg", nia)) # else: # cur.execute("UPDATE alumnos SET foto='%s' WHERE DNI_NORM='%s';" % (nia+".jpg", nia)) db.commit() except: # Rollback in case there is any error db.rollback() cur.close() db.close() info_dialog("Foto de " + nia + " grabada correctamente") except: error_dialog("Error grabando foto") else: error_dialog("Error grabando foto") clear_tmpfiles() draw_card(nia) elif(event == cv.CV_EVENT_RBUTTONDOWN): cv.DestroyWindow('crop' + str(param))
def on_mouse(event, x, y, flag, param): global runCapture if(event == cv.CV_EVENT_LBUTTONDOWN): #print x,y runCapture = False #print imagefile + str(param) + '.jpg' os.rename( imagefile + str(param) + '.jpg', nia + '.jpg') with open(nia+".jpg", "rb") as handle: binary_data = xmlrpclib.Binary(handle.read()) handle.close() if server.put_file(USERNAME, PASSWORD, datastore_space, nia + '.jpg', binary_data): #put in database try: # connect db = MySQLdb.connect(host=dbhost, user=dbuser, passwd=dbpass, db=dbname) cur = db.cursor() try: if NOT_IN_ADMITACA: cur.execute("INSERT INTO admitaca(foto_guardada, dni, nombre_comp) VALUES ('%s', '%s', '%s');" % ('1', nia, new_apenom)) else: cur.execute("UPDATE admitaca SET foto_guardada=1 WHERE dni='%s';" % (nia)) db.commit() except: # Rollback in case there is any error db.rollback() cur.close() db.close() info_dialog("Foto de " + nia + " grabada correctamente") except: error_dialog("Error grabando foto") else: error_dialog("Error grabando foto") clear_tmpfiles() draw_card(nia) elif(event == cv.CV_EVENT_RBUTTONDOWN): cv.DestroyWindow('crop' + str(param))
if (webcam == -1 ): try: webcam = int(parser.get('webcam', 'cam')) except: webcam = 0 # access datastore try: server = xmlrpclib.Server(datastore_uri) dbhost = server.get_value(USERNAME, PASSWORD, datastore_space, 'dbhost') dbname = server.get_value(USERNAME, PASSWORD, datastore_space, 'dbname') dbuser = server.get_value(USERNAME, PASSWORD, datastore_space, 'dbuser') dbpass = server.get_value(USERNAME, PASSWORD, datastore_space, 'dbpass') except: # usage('Error accessing datastore server') error_dialog('Error accessing datastore server') sys.exit if not dbhost or not dbname or not dbpass: # usage('Error retrieving mysql parameters') error_dialog('Error retrieving mysql parameters') sys.exit() #connect to database try: db = MySQLdb.connect(host=dbhost, user=dbuser, passwd=dbpass, db=dbname) except: usage('Error accessing database') sys.exit() while True: nia = get_text(None, 'Introduzca el NIF/NIE:', def_nia)
# avoid python 2.7.9 certificate validation if sys.version_info[0] * 100 + sys.version_info[ 1] * 10 + sys.version_info[2] >= 279: ssl._create_default_https_context = ssl._create_unverified_context server = xmlrpclib.Server(datastore_uri) dbhost = server.get_value(USERNAME, PASSWORD, datastore_space, 'dbhost') dbname = server.get_value(USERNAME, PASSWORD, datastore_space, 'dbname') dbuser = server.get_value(USERNAME, PASSWORD, datastore_space, 'dbuser') dbpass = server.get_value(USERNAME, PASSWORD, datastore_space, 'dbpass') except: # usage('Error accessing datastore server') error_dialog('Error accessing datastore server') sys.exit if not dbhost or not dbname or not dbpass: # usage('Error retrieving mysql parameters') error_dialog('Error retrieving mysql parameters') sys.exit() #connect to database try: db = MySQLdb.connect(host=dbhost, user=dbuser, passwd=dbpass, db=dbname) except: usage('Error accessing database')
def on_mouse(event, x, y, flag, param): global runCapture if (event == cv.CV_EVENT_LBUTTONDOWN): #print x,y runCapture = False #print imagefile + str(param) + '.jpg' os.rename(imagefile + str(param) + '.jpg', nia + '.jpg') with open(nia + ".jpg", "rb") as handle: binary_data = xmlrpclib.Binary(handle.read()) handle.close() if server.put_file(USERNAME, PASSWORD, datastore_space, nia + '.jpg', binary_data): #put in database try: # connect db = MySQLdb.connect(host=dbhost, user=dbuser, passwd=dbpass, db=dbname) cur = db.cursor() try: if (NOT_IN_ADMITACA and NOT_IN_ALUMNOS and NOT_IN_PROFES): #cur.execute("INSERT INTO admitaca(foto_guardada, dni, nombre_comp) VALUES ('%s', '%s', '%s');" % ('1', nia, new_apenom)) #info_dialog(nia+".jpg - "+nia+" - "+new_apenom+ " - "+datetime.now().strftime('%Y%m%d')+ " - "+new_email) cur.execute( "INSERT INTO excepciones_fotos(foto, DNI_NORM, nombre_comp, fecha_foto, email, tipo) VALUES ('%s', '%s', '%s', '%s', '%s', '%s' );" % (nia + ".jpg", nia, new_apenom, datetime.now().strftime('%Y%m%d'), new_email, new_type)) elif (NOT_IN_ALUMNOS and NOT_IN_PROFESORES): # #cur.execute("UPDATE alumnos SET foto='%s' WHERE DNI_NORM='%s';" % (nia+".jpg", nia)) cur.execute( "UPDATE admitaca SET email='%s' WHERE dni='%s';" % (new_email, nia)) elif (NOT_IN_ADMITACA and NOT_IN_PROFESORES): cur.execute( "UPDATE alumnos SET foto='%s' WHERE DNI_NORM='%s';" % (nia + ".jpg", nia)) # else: # cur.execute("UPDATE alumnos SET foto='%s' WHERE DNI_NORM='%s';" % (nia+".jpg", nia)) db.commit() except: # Rollback in case there is any error db.rollback() cur.close() db.close() info_dialog("Foto de " + nia + " grabada correctamente") except: error_dialog("Error grabando foto") else: error_dialog("Error grabando foto") clear_tmpfiles() draw_card(nia) elif (event == cv.CV_EVENT_RBUTTONDOWN): cv.DestroyWindow('crop' + str(param))
# avoid python 2.7.9 certificate validation if sys.version_info[0] * 100 + sys.version_info[ 1] * 10 + sys.version_info[2] >= 279: ssl._create_default_https_context = ssl._create_unverified_context server = xmlrpclib.Server(datastore_uri) dbhost = server.get_value(USERNAME, PASSWORD, datastore_space, 'dbhost') dbname = server.get_value(USERNAME, PASSWORD, datastore_space, 'dbname') dbuser = server.get_value(USERNAME, PASSWORD, datastore_space, 'dbuser') dbpass = server.get_value(USERNAME, PASSWORD, datastore_space, 'dbpass') except: # usage('Error accessing datastore server') error_dialog('Error accessing datastore server') sys.exit if not dbhost or not dbname or not dbpass: # usage('Error retrieving mysql parameters') error_dialog('Error retrieving mysql parameters') sys.exit() #connect to database try: db = MySQLdb.connect(host=dbhost, user=dbuser, passwd=dbpass, db=dbname) except: usage('Error accessing database')