Advertisement
Guest User

Solved RFID Tag problem

a guest
Jun 7th, 2019
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.53 KB | None | 0 0
  1. # Before
  2.  
  3. def id_exists( id_tag ):
  4.     scan = hex(id_tag)
  5.     cursor.execute("SELECT COUNT(idTag) FROM prezenta p INNER JOIN studenti s ON p.matricol=s.matricol WHERE idTag= %s",(scan))
  6.     print ("I am here")
  7.     val_rows = cursor.fetchall()[0][0]
  8.     print (val_rows)
  9.     return val_rows
  10.  
  11. # After
  12.  
  13. def id_exists( id_tag ):
  14.     scan_result = id_tag
  15.     cursor.execute("""SELECT COUNT(idTag) FROM prezenta p INNER JOIN studenti s ON p.matricol=s.matricol WHERE idTag= %s""",[scan_result])
  16.     print (val_rows)
  17.     return val_rows
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement