Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def tagValidation(tag,idUser):
- print("entramos a validacion")
- conn = pymysql.connect(user='user', password='pass',
- host='localhost',
- database='database',
- charset='utf8mb4',
- cursorclass=pymysql.cursors.DictCursor)
- cursor = conn.cursor()
- sql = "SELECT idCr FROM Player WHERE idTelegram = %s "
- cursor.execute(sql,(idUser))
- row = cursor.fetchone()
- bdTag = str(row["idCr"])
- arrayBDTag = list(bdTag)
- arrayPhotoTag = list(tag)
- count = 0
- respuesta = ""
- for i in range(len(arrayBDTag)):
- if arrayBDTag[i] == arrayPhotoTag[i]:
- count= count+1
- print(str(arrayBDTag[i]) + " " + str(arrayPhotoTag[i]))
- porcentaje = len(arrayBDTag) - count
- print(str(porcentaje) + " " + str(len(arrayBDTag)))
- if porcentaje < len(arrayBDTag)/2 :
- sql = "UPDATE Player SET validado=1 WHERE idTelegram= %s AND idCr = %s"
- cursor.execute(sql,(idUser,bdTag))
- respuesta = "validado"
- else:
- respuesta = "no validado"
- print(respuesta)
- return respuesta
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement