def updateSQLite(): try: jsonRequest = urllib2.urlopen( "http://www.desa-net.com/TOTAI/dbm/seguridad_permios/").read() JSONs = json.loads(jsonRequest) db = sqlite3.connect(DBpath) with db: cur = db.cursor() print "DB was modified 1" #cur.execute("DELETE FROM seguridad_permisos") for item in JSONs: i1 = item["SEQ"] i2 = item["puerta_SEQ"] i3 = item["tarjeta_RFID"] i4 = item["persona_SEQ"] i5 = item["persona"] i6 = item["persona_PIN"] i7 = item["permiso"] i8 = item["domingo"] i9 = item["noche_inicio"] i10 = item["noche_fin"] i11 = item["fecha_vencida"] all = [i1, i2, i3, i4, i5, i6, i7, i8, i9, i10, i11] print "DB was modified" if i2 == '002': cur.execute( "INSERT INTO seguridad_permisos values(?,?,?,?,?,?,?,?,?,?,?)", all) print "SUCESS: " + str(len(JSONs)) + " records" except Exception: classErrorLog(sys.exc_info())
def updateSQLite(): try: jsonRequest = urllib2.urlopen("http://www.desa-net.com/TOTAI/dbm/seguridad_permios/").read() JSONs = json.loads(jsonRequest) db = sqlite3.connect(DBpath) with db: cur = db.cursor() print "DB was modified 1" #cur.execute("DELETE FROM seguridad_permisos") for item in JSONs: i1 = item["SEQ"] i2 = item["puerta_SEQ"] i3 = item["tarjeta_RFID"] i4 = item["persona_SEQ"] i5 = item["persona"] i6 = item["persona_PIN"] i7 = item["permiso"] i8 = item["domingo"] i9 = item["noche_inicio"] i10 = item["noche_fin"] i11 = item["fecha_vencida"] all = [i1, i2, i3, i4, i5, i6, i7, i8, i9, i10, i11] print "DB was modified" if i2 == '002': cur.execute("INSERT INTO seguridad_permisos values(?,?,?,?,?,?,?,?,?,?,?)", all) print "SUCESS: " + str(len(JSONs)) + " records" except Exception: classErrorLog(sys.exc_info())
def readCard(): global errorCount try: LED("blue") while True: conf.ser.flushInput() LED("blue") rfidData = conf.ser.readline().strip() print "Line: " if len(rfidData) > 0: rfidData = rfidData[1:13] print "Card Scanned: ", rfidData print findTag(rfidData) except: errorLog.classErrorLog(sys.exc_info()) finally: conf.ser.close() conf.db.close() RPIO.cleanup()
def readCard(): global errorCount try: # LED("blue") while True: # Scan for cards (status,TagType) = MIFAREReader.MFRC522_Request(MIFAREReader.PICC_REQIDL) # If a card is found if status == MIFAREReader.MI_OK: print "Card detected" # Get the UID of the card (status,uid) = MIFAREReader.MFRC522_Anticoll() # If we have the UID, continue if status == MIFAREReader.MI_OK: # conf.ser.flushInput() LED("blue") # rfidData = conf.ser.readline().strip() #print "Line: " if len(rfidData) > 0: #rfidData = rfidData[1:13] rfidData = uid print "Card read UID: "+str(uid[0])+","+str(uid[1])+","+str(uid[2])+","+str(uid[3]) print "Card Scanned: ", rfidData print findTag(rfidData) except: errorLog.classErrorLog(sys.exc_info()) finally: # conf.ser.close() conf.db.close() RPIO.cleanup()
ser.baudrate = 9600 ser.port = rfidPort ser.timeout = 0.1 GREEN = 4 RED = 17 BLUE = 22 RPIO.setwarnings(False) RPIO.setup(GREEN, RPIO.OUT) RPIO.setup(RED, RPIO.OUT) RPIO.setup(BLUE, RPIO.OUT) try: db = sqlite3.connect(dbPath) with db: cur = db.cursor() cur.execute('SELECT codigo_puerta FROM %s' % puertaTable) doorNumber = cur.fetchone() cur.execute('SELECT SEQ FROM %s' % puertaTable) SEQ = cur.fetchone() except: errorLog.classErrorLog(sys.exc_info()) print rootPath print classesPath print dbPath print doorNumber[0] print SEQ[0]
GREEN = 4 RED = 17 BLUE = 22 RPIO.setwarnings(False) RPIO.setup(GREEN, RPIO.OUT) RPIO.setup(RED, RPIO.OUT) RPIO.setup(BLUE, RPIO.OUT) try: db = sqlite3.connect(dbPath) with db: cur = db.cursor() cur.execute('SELECT codigo_puerta FROM %s' % puertaTable) doorNumber = cur.fetchone() cur.execute('SELECT SEQ FROM %s' % puertaTable) SEQ = cur.fetchone() except: errorLog.classErrorLog(sys.exc_info()) print rootPath print classesPath print dbPath print doorNumber[0] print SEQ[0]