def insertBuffer(self, target):
for line in target:
color = Signal.parseSignal(line)[0]
if not color:
return;
location = Signal.parseSignal(line)[1]
theTime = str(Signal.parseSignal(line)[2])
#SQL Date format: YYYY-MM-DD
splitResult = self.currentDate.split("_")
theDate = splitResult[2] + "-" + splitResult[1] + "-" + splitResult[0]
query = "INSERT INTO " + self.currentDate + " VALUES ( " + "'" + color + "'" + " ," + "'" + location + "'" + " ," + "'" + theDate + "'" + " ," + "'" + theTime + "'" + ");"
self.cursor.execute(query)
# Commit your changes in the database
self.db.commit()
def quickAppendBuffer(self, target):
date = time.strftime("%d_%m_%Y") #get current date
if not self.isCurrentDate(date): #check if the date has changed
self.setCurrentDate(date);
#create file according to date, location and bin color
filePathBlack = self.relfilePath + self.__currentDate + "_" + self.__locationID + "_" + "black" + self.__fileExtension;
filePathGreen = self.relfilePath + self.__currentDate + "_" + self.__locationID + "_" + "green" + self.__fileExtension;
filePathBlue = self.relfilePath + self.__currentDate + "_" + self.__locationID + "_" + "blue" + self.__fileExtension;
filePathGrey = self.relfilePath + self.__currentDate + "_" + self.__locationID + "_" + "grey" + self.__fileExtension;
if not os.path.isfile(filePathBlack): #create a new file if new date
self.quickInit(filePathBlack);
if not os.path.isfile(filePathGreen): #create a new file if new date
self.quickInit(filePathGreen);
if not os.path.isfile(filePathBlue): #create a new file if new date
self.quickInit(filePathBlue);
if not os.path.isfile(filePathGrey): #create a new file if new date
self.quickInit(filePathGrey);
currentFileBlack = open(filePathBlack, 'a');
currentFileGreen = open(filePathGreen, 'a');
currentFileBlue = open(filePathBlue, 'a');
currentFileGrey = open(filePathGrey, 'a');
for line in target:
color = Signal.parseSignal(line)[0];
if not color:
return;
if color == "black":
print("TEST... Printing color: " + color + " to the filepath: " + filePathBlack);
currentFileBlack.write(line + '\n');
if color == "green":
print("TEST... Printing color: " + color + " to the filepath: " + filePathGreen);
currentFileGreen.write(line + '\n');
if color == "blue":
print("TEST... Printing color: " + color + " to the filepath: " + filePathBlue);
currentFileGreen.write(line + '\n');
if color == "grey":
print("TEST... Printing color: " + color + " to the filepath: " + filePathGrey);
currentFileGreen.write(line + '\n');
currentFileBlack.close();
currentFileGreen.close();
currentFileBlue.close();
currentFileGrey.close();
def test_parseSignal():
dateTime = datetime.datetime.utcnow()
testSignal = Signal.initializeSignal("green","Nest",dateTime)
expectedSignal = ("green,Nest," + str(dateTime)).split(Signal.delim)
assert Signal.parseSignal(testSignal) == expectedSignal
