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:
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]
