| 76 | self.gui = GUI('real-time-local') |
| 77 | |
| 78 | def createDatabase(self): |
| 79 | # if database exist then delete it |
| 80 | if os.path.exists(self.dataBase): |
| 81 | os.remove(self.dataBase) |
| 82 | conn = sqlite3.connect(self.dataBase) |
| 83 | cur = conn.cursor() |
| 84 | |
| 85 | cur.execute('''CREATE TABLE IF NOT EXISTS simINFO( |
| 86 | startTime TIMESTAMP PRIMARY KEY, |
| 87 | localPosx REAL, |
| 88 | localPosy REAL, |
| 89 | radius REAL, |
| 90 | egoID TEXT, |
| 91 | netBoundary TEXT, |
| 92 | description TEXT, |
| 93 | note TEXT);''') |
| 94 | |
| 95 | cur.execute('''CREATE TABLE IF NOT EXISTS frameINFO( |
| 96 | frame INT NOT NULL, |
| 97 | vid TEXT NOT NULL, |
| 98 | vtag TEXT NOT NULL, |
| 99 | x REAL NOT NULL, |
| 100 | y REAL NOT NULL, |
| 101 | yaw REAL NOT NULL, |
| 102 | speed REAL NOT NULL, |
| 103 | accel REAL NOT NULL, |
| 104 | laneID TEXT NOT NULL, |
| 105 | lanePos REAL NOT NULL, |
| 106 | routeIdx INT NOT NULL, |
| 107 | PRIMARY KEY (frame, vid));''') |
| 108 | |
| 109 | cur.execute('''CREATE TABLE IF NOT EXISTS vehicleINFO( |
| 110 | vid TEXT PRIMARY KEY, |
| 111 | length REAL NOT NULL, |
| 112 | width REAL NOT NULL, |
| 113 | maxAccel REAL, |
| 114 | maxDecel REAL, |
| 115 | maxSpeed REAL, |
| 116 | vTypeID TEXT NOT NULL, |
| 117 | routes TEXT NOT NULL);''') |
| 118 | |
| 119 | cur.execute('''CREATE TABLE IF NOT EXISTS edgeINFO( |
| 120 | id TEXT RRIMARY KEY, |
| 121 | laneNumber INT NOT NULL, |
| 122 | from_junction TEXT, |
| 123 | to_junction TEXT);''') |
| 124 | |
| 125 | cur.execute('''CREATE TABLE IF NOT EXISTS laneINFO( |
| 126 | id TEXT PRIMARY KEY, |
| 127 | rawShape TEXT, |
| 128 | width REAL, |
| 129 | maxSpeed REAL, |
| 130 | edgeID TEXT, |
| 131 | length REAL);''') |
| 132 | |
| 133 | cur.execute('''CREATE TABLE IF NOT EXISTS junctionLaneINFO( |
| 134 | id TEXT PRIMARY KEY, |
| 135 | width REAL, |