def databaseStuff():
#db = Database("localhost", "bfguser", "bfg123", "bfg")
while(1):
#super slow
db = Database("localhost", "bfguser", "bfg123", "bfg")
result = db.pullCount()
if( result != None ):
#order is black, green, blue, grey
#todo: check if result length is = 4
globalVars.blackCount = int(result[0])
globalVars.greenCount = int(result[1])
globalVars.blueCount = int(result[2])
globalVars.greyCount = int(result[3])
#globalVars.greyCount += 1
else:
print("nothing in the db")
db.turnOff()
time.sleep(0.15)
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]) )
print("-----------------------------------")
print("TEST3.1 - Update, then PullCount")
print("-----------------------------------")
db.updateDatabase(testInput1,1,1,1,1)
result = db.pullCount()
print("PullCount1: " + str(result[0]) + "," + str(result[1]) + "," + str(result[2]) + "," + str(result[3]) )
