def test():
#connection = DBConnection()
#connection.connectToDB()
localdbConnection = SQLLite("Resources/WideAwakeCoordinates.db")
localdbConnection.establishConnection()
car = Car()
while(car.next()):
if(car.ABS):
try:
#Should eventually change query to something else
date = datetime.datetime.now()
print(type(car.long[1]))
#inserts a testuserID, testcarID, weather_condition, coordinates as a timestamp and the current date and time. This is a temporary query and may be subject to change
queryToDB = "(INSERT INTO Coordinates(Latitude, longitude, timestamp) VALUES ( + n\
%s, %s, %s )) "
(car.lat[0] ,car.long[0] , date.strftime( "%m/%d/%y/%H/%M/%S"))
localdbConnection.executeInsertStatement(queryToDB)
print("Complete query")
except Exception as e:
print(str(e))
raise e
class OfflineMode:
def __init__(self,path):
# self.interFace = LEDcontrols.LEDcontrols()
self.handler = GPSHandler()
self.sqlite = SQLLite(path)
self.clat = 0
self.clong = 0
def notifyDriverOffline(self):
#self.interFace.setUpLeds(self.interFace.leds)
#self.interFace.safe(False)
print("offline")
def compareCoordinates(self,carLat,carLong,carSpeed):
rs = self.sqlite.executeQueryStatement()
gpsState = self.handler.compareCoordinates(carLat,carLong)
if(gpsState[0] == 'A' or gpsState[0] == 'C' and self.clat != carLat or self.clong != carLong ):
self.clat = carLat
self.clong = carLong
self.handler.validateCoordinates(carLat,carLong,gpsState[1],carSpeed)
def main():
'''
WideAwake main process.
'''
#Variables to testuser to Database
testuserID = "69"
testcarID = "80085"
testWeather = "DET REGNER :( "
#set global variables gshHandler and connection. This will be tried to initialized, if successfull wideawake is online, else offline-mode.
gsmHandler = None
connection = None
offlineConnection = None
#Create a controller/object to controll the interface. Uncomment this when LED interface is connected
#ledKontroll = LEDcontrols.LEDcontrols()
#ledKontroll.setUpLeds(ledKontroll.leds)
# data to calc acceleration
currentTime = 0
currentSpeed = 0
# Data to check emergencies
emergency = False
emergencyTime = 0
try:
try:
#gsmHandler = GSMHandler()
#connect to database
connection = DBConnection()
connection.connectToDB()
#ledKontroll.safe(True)
except UnusableSystemException as e:
print(str(e))
#Since this exception occured, it means that there is something wrong with the gsmHandler. It could not
#connect to the gsm module, or the connection did not connect correctly. Notify user that in offline mode.
#ledKontroll.safe(False)
raise e # rais this to exit the try online, and go to expect offline
except Exception as e:
print(str(e))
#ledKontroll.safe(False)
raise e # rais this to exit the try online, and go to expect offline
#Uploads latest verson of database (retrived data) to the local database
localdbConnection = SQLLite("Resources/WideAwakeCoordinates.db")
localdbConnection.establishConnection()
RefreshCacheLocal(connection, localdbConnection).start()
#Initialize a GPSHandler, and set the connection to the external/cloud database, GPShandler also calculates the distance between car and slippery spot.
handler = GPSHandler()
handler.setConnection(connection)
#Creates a testobject with the testdata
car = Car()
#Iterates through the testdata, when connected to cloud database
while(car.next()):
if(car.ABS):
try:
"""Takes the coordinates of the car and current timestamp and pushes it to the database """
#Should eventually change query to something else
date = datetime.datetime.now()
print(type(car.long[1]))
#inserts a testuserID, testcarID, weather_condition, coordinates as a timestamp and the current date and time. This is a temporary query and may be subject to change
queryToDB = "(INSERT INTO Coordinates(Latitude, longitude, timestamp) VALUES ( + n\
%s, %s, %s )) "
(car.lat[0] ,car.long[0] , date.strftime( "%m/%d/%y/%H/%M/%S"))
localdbConnection.executeInsertStatement(queryToDB)
print("Complete query")
except Exception as e:
print(str(e))
raise e
#Checks if the car is in a state of emergency
if emergency:
"""
if emergencyButton.isPressed():
emergency = False
else if emergencyTime = car.timestamp[0] + 30:
gsmHandler.sendThatShit("Collision at longditude: ", car.long[0],", latitude: ", car.lat[0], ".")
"""
pass
#Every 300 line of testdate, check if the car has accelerated more the halv the current speed
#if so, put it in a state of emergency(a crash might have happened)
if car.tripCounter%300 == 0: #This is just under 2 seconds time
prevTime = currentTime
currentTime = car.timestamp[0]
prevSpeed = currentSpeed
currentSpeed = car.speed[0]
try:
acc = (currentSpeed - prevSpeed)/(currentTime - prevTime)
if abs(acc) > abs(currentSpeed/2) and abs(currentSpeed) > 15:
emergency = True
except ZeroDivisionError:
pass
#every 50 line of testdata, check if the car is close to a slippery road
if(car.tripCounter % 50 == 0):
carSpeed = car.speed[0]
if(carSpeed > 5):
#Detect if there is dangerous road condition ahead
gpsState = handler.compareCoordinates(car.lat[0], car.long[0])
if (gpsState[0] == 'A'):
print("DANGER")
# ledKontroll.dangerMode(True)
elif(gpsState[0] == 'C'):
print("Warning")
# ledKontroll.warningMode()
elif(gpsState[0] == 'N'):
print("Carry on")
# ledKontroll.safe(True)
except:
print("Kunne ikke koble til database")
#Creates a testobject with thestData
offlineCar = Car()
#Connects to local dataabase
offlineConnection = SQLLite("Resources/WideAwakeCoordinates.db")
offlineConnection.establishConnection()
#Initialize a offline GPShandler, that connects to the local database, and calculates distance between car and slippery spot.
offlineHandler = GPSHandler()
offlineHandler.setConnection(offlineConnection)
#iterates through testdata, when connected to local database
while(offlineCar.next()):
if emergency:
"""
if emergencyButton.isPressed():
emergency = False
else if emergencyTime = car.timestamp[0] + 30:
gsmHandler.sendThatShit("Collision at longditude: ", car.long[0],", latitude: ", car.lat[0], ".")
"""
pass
if offlineCar.tripCounter % 300 == 0: # This is just under 2 seconds time
prevTime = currentTime
currentTime = offlineCar.timestamp[0]
prevSpeed = currentSpeed
currentSpeed = offlineCar.speed[0]
try:
acc = (currentSpeed - prevSpeed) / (currentTime - prevTime)
if abs(acc) > abs(currentSpeed / 2) and abs(currentSpeed) > 15:
emergency = True
except ZeroDivisionError:
pass
if(offlineCar.tripCounter % 50 == 0):
carSpeed = offlineCar.speed[0]
if(carSpeed > 5):
#Detect if there is's a dangerous road condition ahead.
gpsState = offlineHandler.offlineCompareCoordinates(offlineCar.lat[0], offlineCar.long[0])
if (gpsState[0] == 'A'):
print("DANGER")
# ledKontroll.dangerMode(True)
elif(gpsState[0] == 'C'):
print("Warning")
# ledKontroll.warningMode()
elif(gpsState[0] == 'N'):
print("Carry on")
# ledKontroll.safe(True)
finally:
#closes connection to cloud-database
if(not connection == None):
connection.closeConnection()
#closes the gsmHandler
if(not gsmHandler == None):
gsmHandler.closeModem()
#closes the offlineConnetion to the local database
if(not offlineConnection == None):
offlineConnection.closeConnection()
def __init__(self,path):
# self.interFace = LEDcontrols.LEDcontrols()
self.handler = GPSHandler()
self.sqlite = SQLLite(path)
self.clat = 0
self.clong = 0
