| 105 | # self.graphics_items: list[graphicsItem] = [] |
| 106 | |
| 107 | def createDatabase(self): |
| 108 | # if database exist then delete it |
| 109 | if os.path.exists(self.dataBase): |
| 110 | os.remove(self.dataBase) |
| 111 | conn = sqlite3.connect(self.dataBase) |
| 112 | cur = conn.cursor() |
| 113 | |
| 114 | cur.execute('''CREATE TABLE IF NOT EXISTS simINFO( |
| 115 | startTime TIMESTAMP PRIMARY KEY, |
| 116 | localPosx REAL, |
| 117 | localPosy REAL, |
| 118 | radius REAL, |
| 119 | egoID TEXT, |
| 120 | netBoundary TEXT, |
| 121 | description TEXT, |
| 122 | note TEXT);''') |
| 123 | |
| 124 | cur.execute('''CREATE TABLE IF NOT EXISTS frameINFO( |
| 125 | frame INT NOT NULL, |
| 126 | vid TEXT NOT NULL, |
| 127 | vtag TEXT NOT NULL, |
| 128 | x REAL NOT NULL, |
| 129 | y REAL NOT NULL, |
| 130 | yaw REAL NOT NULL, |
| 131 | speed REAL NOT NULL, |
| 132 | accel REAL NOT NULL, |
| 133 | laneID TEXT NOT NULL, |
| 134 | lanePos REAL NOT NULL, |
| 135 | routeIdx INT NOT NULL, |
| 136 | PRIMARY KEY (frame, vid));''') |
| 137 | |
| 138 | cur.execute('''CREATE TABLE IF NOT EXISTS vehicleINFO( |
| 139 | vid TEXT PRIMARY KEY, |
| 140 | length REAL NOT NULL, |
| 141 | width REAL NOT NULL, |
| 142 | maxAccel REAL, |
| 143 | maxDecel REAL, |
| 144 | maxSpeed REAL, |
| 145 | vTypeID TEXT NOT NULL, |
| 146 | routes TEXT NOT NULL);''') |
| 147 | |
| 148 | cur.execute('''CREATE TABLE IF NOT EXISTS edgeINFO( |
| 149 | id TEXT RRIMARY KEY, |
| 150 | laneNumber INT NOT NULL, |
| 151 | from_junction TEXT, |
| 152 | to_junction TEXT);''') |
| 153 | |
| 154 | cur.execute('''CREATE TABLE IF NOT EXISTS laneINFO( |
| 155 | id TEXT PRIMARY KEY, |
| 156 | rawShape TEXT, |
| 157 | width REAL, |
| 158 | maxSpeed REAL, |
| 159 | edgeID TEXT, |
| 160 | length REAL);''') |
| 161 | |
| 162 | cur.execute('''CREATE TABLE IF NOT EXISTS junctionLaneINFO( |
| 163 | id TEXT PRIMARY KEY, |
| 164 | width REAL, |