def __init__(self, tag): self.rfidTag = tag try: with conf.db: c = conf.db.cursor() c.execute("SELECT * FROM %s WHERE (tarjeta_RFID=:x)" % conf.permisoTable, {"x": self.rfidTag}) row = c.fetchone() if row is None: self.tagRecognized = conf.NO self.doorNumber = None self.permission = conf.PERMISSION_NO self.personID = None self.personName = None self.personPIN = None self.personPhoto = None self.startHour = "00:00:00" self.endHour = "24:00:00" self.sundayPermission = "0" self.endDate = "2100-01-01" else: self.tagRecognized = conf.YES self.doorNumber = row[1] self.personID = row[3] self.personName = row[4] self.personPIN = int(row[5]) self.permission = row[6] self.sundayPermission = row[7] self.startHour = row[8] self.endHour = row[9] self.endDate = row[10] except: errorLog.classErrorLog(sys.exc_info())
def postSQLite(self): try: with conf.db: if len(self.rfidData) == 12: cur = conf.db.cursor() queryString = "INSERT INTO seguridad_entrada(puerta_num, tarjeta_RFID, persona_SEQ, persona, fecha_hora, permiso) VALUES (?,?,?,?,?,?)" cur.execute(queryString, (self.doorNumber, self.rfidData, self.personID, self.personName, self.curDT, self.permission)) conf.db.commit() print "successful SQLite insert" else: print "SQLite insert error" except: errorLog.classErrorLog(sys.exc_info())
def __init__(self, tag): self.rfidTag = tag try: with conf.db: c = conf.db.cursor() c.execute( "SELECT * FROM %s WHERE (tarjeta_RFID=:x)" % conf.permisoTable, {"x": self.rfidTag}) row = c.fetchone() if row is None: self.tagRecognized = conf.NO self.doorNumber = None self.permission = conf.PERMISSION_NO self.personID = None self.personName = None self.personPIN = None self.personPhoto = None self.startHour = "00:00:00" self.endHour = "24:00:00" self.sundayPermission = "0" self.endDate = "2100-01-01" else: self.tagRecognized = conf.YES self.doorNumber = row[1] self.personID = row[3] self.personName = row[4] self.personPIN = int(row[5]) self.permission = row[6] self.sundayPermission = row[7] self.startHour = row[8] self.endHour = row[9] self.endDate = row[10] except: errorLog.classErrorLog(sys.exc_info())