mainDeque = binBuffer.flushBuffer()
#Buffer queue should be empty
#print "Sending signal to Display "
#Update global count values
#print binBuffer.getCount("black")
globalVars.blackCount = 0
#print binBuffer.getCount("green")
globalVars.greenCount = 2
#print binBuffer.getCount("blue")
globalVars.blueCount = 4
#print binBuffer.getCount("grey")
globalVars.greyCount = 6
#print "Sending signal to SD to save "
sdFile.quickAppendBuffer(mainDeque)
#inserts the buffer to database, and the count values to update the display
print "calling update database"
db.updateDatabase(mainDeque, globalVars.blackCount, globalVars.greenCount, globalVars.blueCount, globalVars.greyCount)
#date = time.strftime("%d_%m_%Y") #get current date
#filePath = relativePath + date + "_" + location + "_" + color + ".csv"
#print "quickRead: " + str(sdFile.quickRead(filePath))
#Test buffer
#test = raw_input ("Enter stuff in deque: ")
#color = raw_input ("Enter color: ")
#binBuffer.simulateQueue(test,color)
sleep(3)
globalVars.blackCount += 1
binBuffer.setEmptyFlag(false)
'
db.createCountTable("TEST1")
print("-----------------------------------")
print("TEST2.1 - mimic updateDatabse")
print("-----------------------------------")
date = str(time.strftime("%d_%m_%Y"))
print("DATE (note period at the end): " + date + ".")
db.createCountTable(date)
date = time.strftime("%d_%m_%Y")
print("DATE (note period at the end): " + date + ".")
db.createCountTable(date)
print("-----------------------------------")
print("TEST2.2 - updateDatabase")
print("-----------------------------------")
db.updateDatabase(testInput1,66,77,88,99)
db.updateDatabase(testInput1,1,2,3,4)
print("-----------------------------------")
print("TEST3.0 - PullCount")
print("-----------------------------------")
result = db.pullCount()
print("PullCount1: " + str(result[0]) + "," + str(result[1]) + "," + str(result[2]) + "," + str(result[3]) )
try:
db.insertCount(16,None,13,0)
except:
print "Insert didnt work"
else:
result = db.pullCount()
print("PullCount2: " + str(result[0]) + "," + str(result[1]) + "," + str(result[2]) + "," + str(result[3]) )
#import mysql.connector
#from mysql.connector import errorcode
#db = MySQLdb.connect(host="localhost", # your host, usually localhost
# user="******", # your username
# passwd="bfg123", # your password
# db="bfg") # name of the data base
db = Database("54.218.32.132", "bfguser", "bfg123", "bfg")
testInput1 = ["green,TEST1,05:26:25"]
testInput2 = ["black,nest,03:59:26"]
testInput3 = ["black,nest,05:12:01"]
testInput4 = ["black,nest,11:33:56"]
testInput5 = ["black,nest,01:09:22"]
testInput6 = ["black,nest,04:44:34"]
#print("Inserting: testInput1")
#db.insertBuffer(testInput1)
#print("Inserting: testInput2")
#db.insertBuffer(testInput2)
db.updateDatabase(testInput2,1,1,1,1)
db.updateDatabase(testInput4,1,1,1,1)
db.updateDatabase(testInput3,1,1,1,1)
db.updateDatabase(testInput5,1,1,1,1)
db.updateDatabase(testInput6,1,1,1,1)
#db.updateDatabase(testInput1,2,2,2,2)
