Changeset 626 in tmcsimulator
- Timestamp:
- 08/30/2020 01:49:28 PM (6 years ago)
- Location:
- branches/LCSv2
- Files:
-
- 1 added
- 10 edited
-
controllers/default.py (modified) (2 diffs)
-
controllers/default.py.bak (modified) (10 diffs)
-
databases/sql.log (modified) (1 diff)
-
databases/storage.sqlite (modified) (previous)
-
errors (modified) (1 prop)
-
progress.log (modified) (1 diff)
-
sessions (modified) (1 prop)
-
views/default/help.html (modified) (1 diff)
-
views/default/help.html.bak (modified) (1 diff)
-
views/default/home.html.bak (modified) (1 diff)
-
views/default/resetdb.html (added)
Legend:
- Unmodified
- Added
- Removed
-
branches/LCSv2/controllers/default.py
r624 r626 299 299 return dict(form=form) 300 300 301 # An unlinked page to allow admin to reset the database to simulation start state 302 def resetdb(): 303 form = FORM("Press this button to reset the closure database to its original state at the start of a simulation.",BR(), 304 "Warning: this will delete all the current closures.",BR(), 305 "Import filename is 'db_closures_start.csv'.",BR(), 306 INPUT(_value="Reset Database", _type='submit', _class="btn btn-primary btn-default")) 307 if form.process().accepted: 308 db(db.closures.id > 0).delete() # remove all current records 309 with open('db_closures_start.csv', 'rb') as dumpfile: 310 db.closures.import_from_csv_file(dumpfile) # import from starting state 311 session.flash = 'Closure database has been reset' 312 redirect(URL('search.html')) 313 return dict(form=form) 314 301 315 # Validation for existing closure button 302 316 # If user selected Yes (it's existing incident) then they must select a closure ID … … 347 361 result = result + "#"+item + " " 348 362 result = result + "of " + lanecount 349 return result 363 return result -
branches/LCSv2/controllers/default.py.bak
r622 r626 3 3 hwys = ['','1','5', '22', '55', '57', '73', '74', '91', '133', '142', '241', '261', '405', '605'] 4 4 hwyDirections = ['','NB', 'SB', 'NB/SB','EB','WB','EB/WB'] 5 # Names to appeaer in the username dropdown box 6 users = [] 5 7 # Show the login page 6 8 def index(): 7 form = FORM(LABEL('Username:',_for='username', _class="label username-label"), 8 INPUT(_name='username', _size='15', _style="font-size: 18px;"), BR(), 9 userfile = open('student_names.txt','r') 10 users = [line.strip() for line in userfile.readlines()] 11 users.insert(0,'') 12 form = FORM(LABEL('User:',_for='username', _class="label username-label"), 13 #INPUT(_name='username', _size='15', _style="font-size: 18px;"), BR(), 14 SELECT(users,_name='username',requires=IS_LENGTH(minsize=1,error_message='Must select a user from the list.')),BR(), 9 15 INPUT(_type='submit',_value="Log in", _class=" btn btn-primary", _style="margin-top: 3%;")) 10 16 if form.process().accepted: … … 92 98 count = len(hwy) 93 99 # Show the results in table format. Get the radio call number from supervisor name lookup 94 header = THEAD(TR(TH(''), TH('DTM',BR(),'Area'), TH('Closure ID/',BR(),'Log No.'),TH('Route & Dir/',BR(),'Type of Closure'),TH('Start Date/',BR(),'End Date/',BR(),'Est. Delay'),TH('Facility '),TH('Limits'),TH('Work'), TH('TMP:',BR(),'Cozeep/',BR(),'Detour'),TH('Requestor/',BR(),'Radio Call No.')))100 header = THEAD(TR(TH(''), TH('DTM',BR(),'Area'), TH('Closure ID/',BR(),'Log No.'),TH('Route & Dir/',BR(),'Type of Closure'),TH('Start Date/',BR(),'End Date/',BR(),'Est. Delay'),TH('Facility/Lanes'),TH('Limits'),TH('Work'), TH('TMP:',BR(),'Cozeep/',BR(),'Detour'),TH('Requestor/',BR(),'Radio Call No.'))) 95 101 multiform = [] 96 102 # Iterates over all search results … … 103 109 INPUT(_type='submit',_name='btn2',_value='Show Status Form',_class="submit-button" ), 104 110 INPUT(_type='hidden',_name='row',_value=row.closureid))), 105 TD(row.closureid[0]),TD(row.closureid,HR(),row.lognum), TD(row.route,' ',row.direction,HR(),row.closuretype), TD(row.startdate,' ',formatTime(row.starttime),HR(),row.enddate,' ',formatTime(row.endtime),HR(),row.estdelay), TD(row.facility),TD(row.startlocation,HR(),row.endlocation), TD(row.worktype), TD(row.tmpcozeep,BR(),row.tmpdetour), TD(row.supervisor,HR(),db(db.supervisors.name == row.supervisor).select().first().radiocallnum) )) 111 TD(row.closureid[0]),TD(row.closureid,HR(),row.lognum), TD(row.route,' ',row.direction,HR(),row.closuretype), TD(row.startdate,' ',formatTime(row.starttime),HR(),row.enddate,' ',formatTime(row.endtime),HR(),row.estdelay), TD(row.facility,HR(),row.closedlanes), 112 TD(row.startlocation,HR(),row.endlocation), TD(row.worktype), TD(row.tmpcozeep,BR(),row.tmpdetour), TD(row.supervisor,HR(),db(db.supervisors.name == row.supervisor).select().first().radiocallnum) )) 106 113 107 114 session.chosenid = request.vars.row #Pass the hidden field containing the closure ID … … 207 214 supervisors.append(row.radiocallnum + ' ' + row.name) 208 215 crew = [''] # List of names for the dropdown box 216 crewlookup = [] 209 217 # Obtain all the crew names from the database 210 218 for row in db().select(db.crew.ALL): 211 219 crew.append(row.radiocallnum + ' ' + row.name) 220 crewlookup.append(row.radiocallnum + ' ' + row.name) 212 221 # Build the list of street locations and a hidden cross street lookup table 213 222 streets = [''] … … 248 257 TD(INPUT(_type='checkbox',_name='cozeep'),'CoZeep MaZeep/CHP',BR(), 249 258 INPUT(_type='checkbox', _name='detour'),'Detour Available')), 250 TR(TD(DIV(LABEL("Lanes closed"),DIV( _id='boxes'),_id='lanechooser',_style='display:none')),259 TR(TD(DIV(LABEL("Lanes closed"),DIV(INPUT(_type='checkbox', _name='lanes', _id='lanes', _value=' '), _id='boxes'),_id='lanechooser',_style='display:none')), 251 260 TD(INPUT(_type='hidden', _name='lanecount', _id='lanecount', _value='4')), 252 261 TD(), … … 256 265 TD(LABEL('Field Rep')) 257 266 ), 258 TR(TD(SELECT(supervisors,_name='supervisor', requires=IS_LENGTH(minsize=1,error_message='supervisor cannot be empty'))),259 TD(SELECT(crew,_name='fieldrep' )),267 TR(TD(SELECT(supervisors,_name='supervisor', _id='supervisorcombo', _onchange='supervisorchanged()', requires=IS_LENGTH(minsize=1,error_message='supervisor cannot be empty'))), 268 TD(SELECT(crew,_name='fieldrep',_id='fieldrep')), 260 269 TD(XML(" ")), 261 270 TD('Is this an existing incident?', … … 272 281 TR(TD(INPUT(_name='meeting', _size='25')),TD(INPUT(_name='reason',_size='25')),TD(INPUT(_name='remarks',_size='25'))) ), BR(), 273 282 INPUT(_type='submit',_value='Submit Closure', _class="btn btn-primary btn-default", _style="margin: 2% 45% 2% 40%;"), 274 XML('\n'),SELECT(streetlookup,_name='stlookup', _id='stlookup', _class='hideme')) 283 XML('\n'),SELECT(streetlookup,_name='stlookup', _id='stlookup', _class='hideme'), 284 SELECT(crewlookup,_name='crewlookup', _id='crewlookup', _class='hideme')) 275 285 276 286 if form.process(onvalidation=validate_existing_id).accepted: … … 282 292 supervisor_name = form.vars.supervisor[3:] 283 293 fieldrep_name = form.vars.fieldrep[5:] 294 selectedlanes = buildLanesClosedString(form.vars.lanes,form.vars.lanecount) 284 295 # Insert the record into the database 285 newrec = db.closures.insert(closureid=newID, lognum=newLognum, route=form.vars.route, direction=form.vars.direction, facility=form.vars.facility, startcounty=form.vars.startcounty, endcounty=form.vars.endcounty, startlocation=form.vars.startlocation, endlocation=form.vars.endlocation, startdate=form.vars.startdate, enddate=form.vars.enddate, starttime=form.vars.starttime+form.vars.starttimemin, endtime=form.vars.endtime+form.vars.endtimemin, closuretype=form.vars.closuretype, worktype=form.vars.worktype, estdelay=form.vars.estdelay, tmpcozeep=getCheckbox(form.vars.cozeep), tmpdetour=getCheckbox(form.vars.detour), supervisor=supervisor_name, fieldrep=fieldrep_name, s1097date='', s1098date='', s1022date='' ) 286 session.flash = 'New lane closure added: ' + newID + ' ' + newLognum + ', ' + buildLanesClosedString(form.vars.lanes) + ':' + form.vars.lanecount 296 newrec = db.closures.insert(closureid=newID, lognum=newLognum, route=form.vars.route, direction=form.vars.direction, facility=form.vars.facility, startcounty=form.vars.startcounty, endcounty=form.vars.endcounty, startlocation=form.vars.startlocation, endlocation=form.vars.endlocation, startdate=form.vars.startdate, enddate=form.vars.enddate, starttime=form.vars.starttime+form.vars.starttimemin, endtime=form.vars.endtime+form.vars.endtimemin, closuretype=form.vars.closuretype, closedlanes=selectedlanes, worktype=form.vars.worktype, estdelay=form.vars.estdelay, tmpcozeep=getCheckbox(form.vars.cozeep), tmpdetour=getCheckbox(form.vars.detour), supervisor=supervisor_name, fieldrep=fieldrep_name, s1097date='', s1098date='', s1022date='' ) 297 session.flash = 'New lane closure added: ' + newID + ' ' + newLognum + ': ' + selectedlanes 298 redirect(URL('search.html')) 299 return dict(form=form) 300 301 # An unlinked page to allow admin to reset the database to simulation start state 302 def resetdb(): 303 form = FORM("Press this button to reset the closure database to its original state at the start of a simulation.",BR(), 304 "Warning: this will delete all the current closures.",BR(), 305 INPUT(_value="Reset Database", _type='submit', _class="btn btn-primary btn-default")) 306 if form.process().accepted: 307 db(db.closures.id > 0).delete() # remove all current records 308 with open('db_closures_start.csv', 'rb') as dumpfile: 309 db.closures.import_from_csv_file(dumpfile) # import from starting state 287 310 redirect(URL('search.html')) 288 311 return dict(form=form) … … 296 319 # Calculate the closure id to assign to the new closure 297 320 def calcNextClosureID(routeNum): 298 # Retrieve any existing closures on this route 299 item = db(db.closures.closureid.startswith('T'+routeNum)).select().last() # Might need to sort these 321 # Retrieve the last existing closure on this route 322 #item = db(db.closures.closureid.startswith('T'+routeNum)).select().last() # defective 323 item = db(db.closures.route == routeNum).select().last() 300 324 if (item != None): 301 325 currID = item.closureid … … 328 352 # E.g. #1 #3 of 4 329 353 # Note: ckBoxGroup parameter contains only checked items 330 def buildLanesClosedString(ckBoxGroup ):331 result = " >"354 def buildLanesClosedString(ckBoxGroup,lanecount): 355 result = "" 332 356 if ckBoxGroup is not None: 333 357 # Append each checked value to a string 334 358 for item in ckBoxGroup: 335 result = result + item + " " 359 result = result + "#"+item + " " 360 result = result + "of " + lanecount 336 361 return result -
branches/LCSv2/databases/sql.log
r624 r626 48236 48236 DELETE FROM sqlite_sequence WHERE name='crew' 48237 48237 success! 48238 DELETE FROM "supervisors"; 48239 DELETE FROM sqlite_sequence WHERE name='supervisors' 48240 success! 48241 DELETE FROM "streets"; 48242 DELETE FROM sqlite_sequence WHERE name='streets' 48243 success! 48244 DELETE FROM "crew"; 48245 DELETE FROM sqlite_sequence WHERE name='crew' 48246 success! 48247 DELETE FROM "supervisors"; 48248 DELETE FROM sqlite_sequence WHERE name='supervisors' 48249 success! 48250 DELETE FROM "streets"; 48251 DELETE FROM sqlite_sequence WHERE name='streets' 48252 success! 48253 DELETE FROM "crew"; 48254 DELETE FROM sqlite_sequence WHERE name='crew' 48255 success! 48256 DELETE FROM "supervisors"; 48257 DELETE FROM sqlite_sequence WHERE name='supervisors' 48258 success! 48259 DELETE FROM "streets"; 48260 DELETE FROM sqlite_sequence WHERE name='streets' 48261 success! 48262 DELETE FROM "crew"; 48263 DELETE FROM sqlite_sequence WHERE name='crew' 48264 success! 48265 DELETE FROM "supervisors"; 48266 DELETE FROM sqlite_sequence WHERE name='supervisors' 48267 success! 48268 DELETE FROM "streets"; 48269 DELETE FROM sqlite_sequence WHERE name='streets' 48270 success! 48271 DELETE FROM "crew"; 48272 DELETE FROM sqlite_sequence WHERE name='crew' 48273 success! 48274 DELETE FROM "supervisors"; 48275 DELETE FROM sqlite_sequence WHERE name='supervisors' 48276 success! 48277 DELETE FROM "streets"; 48278 DELETE FROM sqlite_sequence WHERE name='streets' 48279 success! 48280 DELETE FROM "crew"; 48281 DELETE FROM sqlite_sequence WHERE name='crew' 48282 success! 48283 DELETE FROM "supervisors"; 48284 DELETE FROM sqlite_sequence WHERE name='supervisors' 48285 success! 48286 DELETE FROM "streets"; 48287 DELETE FROM sqlite_sequence WHERE name='streets' 48288 success! 48289 DELETE FROM "crew"; 48290 DELETE FROM sqlite_sequence WHERE name='crew' 48291 success! 48292 DELETE FROM "supervisors"; 48293 DELETE FROM sqlite_sequence WHERE name='supervisors' 48294 success! 48295 DELETE FROM "streets"; 48296 DELETE FROM sqlite_sequence WHERE name='streets' 48297 success! 48298 DELETE FROM "crew"; 48299 DELETE FROM sqlite_sequence WHERE name='crew' 48300 success! 48301 DELETE FROM "supervisors"; 48302 DELETE FROM sqlite_sequence WHERE name='supervisors' 48303 success! 48304 DELETE FROM "streets"; 48305 DELETE FROM sqlite_sequence WHERE name='streets' 48306 success! 48307 DELETE FROM "crew"; 48308 DELETE FROM sqlite_sequence WHERE name='crew' 48309 success! 48310 DELETE FROM "supervisors"; 48311 DELETE FROM sqlite_sequence WHERE name='supervisors' 48312 success! 48313 DELETE FROM "streets"; 48314 DELETE FROM sqlite_sequence WHERE name='streets' 48315 success! 48316 DELETE FROM "crew"; 48317 DELETE FROM sqlite_sequence WHERE name='crew' 48318 success! 48319 DELETE FROM "supervisors"; 48320 DELETE FROM sqlite_sequence WHERE name='supervisors' 48321 success! 48322 DELETE FROM "streets"; 48323 DELETE FROM sqlite_sequence WHERE name='streets' 48324 success! 48325 DELETE FROM "crew"; 48326 DELETE FROM sqlite_sequence WHERE name='crew' 48327 success! 48328 DELETE FROM "supervisors"; 48329 DELETE FROM sqlite_sequence WHERE name='supervisors' 48330 success! 48331 DELETE FROM "streets"; 48332 DELETE FROM sqlite_sequence WHERE name='streets' 48333 success! 48334 DELETE FROM "crew"; 48335 DELETE FROM sqlite_sequence WHERE name='crew' 48336 success! 48337 DELETE FROM "supervisors"; 48338 DELETE FROM sqlite_sequence WHERE name='supervisors' 48339 success! 48340 DELETE FROM "streets"; 48341 DELETE FROM sqlite_sequence WHERE name='streets' 48342 success! 48343 DELETE FROM "crew"; 48344 DELETE FROM sqlite_sequence WHERE name='crew' 48345 success! 48346 DELETE FROM "supervisors"; 48347 DELETE FROM sqlite_sequence WHERE name='supervisors' 48348 success! 48349 DELETE FROM "streets"; 48350 DELETE FROM sqlite_sequence WHERE name='streets' 48351 success! 48352 DELETE FROM "crew"; 48353 DELETE FROM sqlite_sequence WHERE name='crew' 48354 success! 48355 DELETE FROM "supervisors"; 48356 DELETE FROM sqlite_sequence WHERE name='supervisors' 48357 success! 48358 DELETE FROM "streets"; 48359 DELETE FROM sqlite_sequence WHERE name='streets' 48360 success! 48361 DELETE FROM "crew"; 48362 DELETE FROM sqlite_sequence WHERE name='crew' 48363 success! 48364 DELETE FROM "supervisors"; 48365 DELETE FROM sqlite_sequence WHERE name='supervisors' 48366 success! 48367 DELETE FROM "streets"; 48368 DELETE FROM sqlite_sequence WHERE name='streets' 48369 success! 48370 DELETE FROM "crew"; 48371 DELETE FROM sqlite_sequence WHERE name='crew' 48372 success! 48373 DELETE FROM "supervisors"; 48374 DELETE FROM sqlite_sequence WHERE name='supervisors' 48375 success! 48376 DELETE FROM "streets"; 48377 DELETE FROM sqlite_sequence WHERE name='streets' 48378 success! 48379 DELETE FROM "crew"; 48380 DELETE FROM sqlite_sequence WHERE name='crew' 48381 success! 48382 DELETE FROM "supervisors"; 48383 DELETE FROM sqlite_sequence WHERE name='supervisors' 48384 success! 48385 DELETE FROM "streets"; 48386 DELETE FROM sqlite_sequence WHERE name='streets' 48387 success! 48388 DELETE FROM "crew"; 48389 DELETE FROM sqlite_sequence WHERE name='crew' 48390 success! 48391 DELETE FROM "supervisors"; 48392 DELETE FROM sqlite_sequence WHERE name='supervisors' 48393 success! 48394 DELETE FROM "streets"; 48395 DELETE FROM sqlite_sequence WHERE name='streets' 48396 success! 48397 DELETE FROM "crew"; 48398 DELETE FROM sqlite_sequence WHERE name='crew' 48399 success! 48400 DELETE FROM "supervisors"; 48401 DELETE FROM sqlite_sequence WHERE name='supervisors' 48402 success! 48403 DELETE FROM "streets"; 48404 DELETE FROM sqlite_sequence WHERE name='streets' 48405 success! 48406 DELETE FROM "crew"; 48407 DELETE FROM sqlite_sequence WHERE name='crew' 48408 success! 48409 DELETE FROM "supervisors"; 48410 DELETE FROM sqlite_sequence WHERE name='supervisors' 48411 success! 48412 DELETE FROM "streets"; 48413 DELETE FROM sqlite_sequence WHERE name='streets' 48414 success! 48415 DELETE FROM "crew"; 48416 DELETE FROM sqlite_sequence WHERE name='crew' 48417 success! 48418 DELETE FROM "supervisors"; 48419 DELETE FROM sqlite_sequence WHERE name='supervisors' 48420 success! 48421 DELETE FROM "streets"; 48422 DELETE FROM sqlite_sequence WHERE name='streets' 48423 success! 48424 DELETE FROM "crew"; 48425 DELETE FROM sqlite_sequence WHERE name='crew' 48426 success! 48427 DELETE FROM "supervisors"; 48428 DELETE FROM sqlite_sequence WHERE name='supervisors' 48429 success! 48430 DELETE FROM "streets"; 48431 DELETE FROM sqlite_sequence WHERE name='streets' 48432 success! 48433 DELETE FROM "crew"; 48434 DELETE FROM sqlite_sequence WHERE name='crew' 48435 success! 48436 DELETE FROM "supervisors"; 48437 DELETE FROM sqlite_sequence WHERE name='supervisors' 48438 success! 48439 DELETE FROM "streets"; 48440 DELETE FROM sqlite_sequence WHERE name='streets' 48441 success! 48442 DELETE FROM "crew"; 48443 DELETE FROM sqlite_sequence WHERE name='crew' 48444 success! 48445 DELETE FROM "supervisors"; 48446 DELETE FROM sqlite_sequence WHERE name='supervisors' 48447 success! 48448 DELETE FROM "streets"; 48449 DELETE FROM sqlite_sequence WHERE name='streets' 48450 success! 48451 DELETE FROM "crew"; 48452 DELETE FROM sqlite_sequence WHERE name='crew' 48453 success! 48454 DELETE FROM "supervisors"; 48455 DELETE FROM sqlite_sequence WHERE name='supervisors' 48456 success! 48457 DELETE FROM "streets"; 48458 DELETE FROM sqlite_sequence WHERE name='streets' 48459 success! 48460 DELETE FROM "crew"; 48461 DELETE FROM sqlite_sequence WHERE name='crew' 48462 success! 48463 DELETE FROM "supervisors"; 48464 DELETE FROM sqlite_sequence WHERE name='supervisors' 48465 success! 48466 DELETE FROM "streets"; 48467 DELETE FROM sqlite_sequence WHERE name='streets' 48468 success! 48469 DELETE FROM "crew"; 48470 DELETE FROM sqlite_sequence WHERE name='crew' 48471 success! 48472 DELETE FROM "supervisors"; 48473 DELETE FROM sqlite_sequence WHERE name='supervisors' 48474 success! 48475 DELETE FROM "streets"; 48476 DELETE FROM sqlite_sequence WHERE name='streets' 48477 success! 48478 DELETE FROM "crew"; 48479 DELETE FROM sqlite_sequence WHERE name='crew' 48480 success! 48481 DELETE FROM "supervisors"; 48482 DELETE FROM sqlite_sequence WHERE name='supervisors' 48483 success! 48484 DELETE FROM "streets"; 48485 DELETE FROM sqlite_sequence WHERE name='streets' 48486 success! 48487 DELETE FROM "crew"; 48488 DELETE FROM sqlite_sequence WHERE name='crew' 48489 success! 48490 DELETE FROM "supervisors"; 48491 DELETE FROM sqlite_sequence WHERE name='supervisors' 48492 success! 48493 DELETE FROM "streets"; 48494 DELETE FROM sqlite_sequence WHERE name='streets' 48495 success! 48496 DELETE FROM "crew"; 48497 DELETE FROM sqlite_sequence WHERE name='crew' 48498 success! 48499 DELETE FROM "supervisors"; 48500 DELETE FROM sqlite_sequence WHERE name='supervisors' 48501 success! 48502 DELETE FROM "streets"; 48503 DELETE FROM sqlite_sequence WHERE name='streets' 48504 success! 48505 DELETE FROM "crew"; 48506 DELETE FROM sqlite_sequence WHERE name='crew' 48507 success! 48508 DELETE FROM "supervisors"; 48509 DELETE FROM sqlite_sequence WHERE name='supervisors' 48510 success! 48511 DELETE FROM "streets"; 48512 DELETE FROM sqlite_sequence WHERE name='streets' 48513 success! 48514 DELETE FROM "crew"; 48515 DELETE FROM sqlite_sequence WHERE name='crew' 48516 success! 48517 DELETE FROM "supervisors"; 48518 DELETE FROM sqlite_sequence WHERE name='supervisors' 48519 success! 48520 DELETE FROM "streets"; 48521 DELETE FROM sqlite_sequence WHERE name='streets' 48522 success! 48523 DELETE FROM "crew"; 48524 DELETE FROM sqlite_sequence WHERE name='crew' 48525 success! 48526 DELETE FROM "supervisors"; 48527 DELETE FROM sqlite_sequence WHERE name='supervisors' 48528 success! 48529 DELETE FROM "streets"; 48530 DELETE FROM sqlite_sequence WHERE name='streets' 48531 success! 48532 DELETE FROM "crew"; 48533 DELETE FROM sqlite_sequence WHERE name='crew' 48534 success! 48535 DELETE FROM "supervisors"; 48536 DELETE FROM sqlite_sequence WHERE name='supervisors' 48537 success! 48538 DELETE FROM "streets"; 48539 DELETE FROM sqlite_sequence WHERE name='streets' 48540 success! 48541 DELETE FROM "crew"; 48542 DELETE FROM sqlite_sequence WHERE name='crew' 48543 success! 48544 DELETE FROM "supervisors"; 48545 DELETE FROM sqlite_sequence WHERE name='supervisors' 48546 success! 48547 DELETE FROM "streets"; 48548 DELETE FROM sqlite_sequence WHERE name='streets' 48549 success! 48550 DELETE FROM "crew"; 48551 DELETE FROM sqlite_sequence WHERE name='crew' 48552 success! 48553 DELETE FROM "supervisors"; 48554 DELETE FROM sqlite_sequence WHERE name='supervisors' 48555 success! 48556 DELETE FROM "streets"; 48557 DELETE FROM sqlite_sequence WHERE name='streets' 48558 success! 48559 DELETE FROM "crew"; 48560 DELETE FROM sqlite_sequence WHERE name='crew' 48561 success! 48562 DELETE FROM "supervisors"; 48563 DELETE FROM sqlite_sequence WHERE name='supervisors' 48564 success! 48565 DELETE FROM "streets"; 48566 DELETE FROM sqlite_sequence WHERE name='streets' 48567 success! 48568 DELETE FROM "crew"; 48569 DELETE FROM sqlite_sequence WHERE name='crew' 48570 success! 48571 DELETE FROM "supervisors"; 48572 DELETE FROM sqlite_sequence WHERE name='supervisors' 48573 success! 48574 DELETE FROM "streets"; 48575 DELETE FROM sqlite_sequence WHERE name='streets' 48576 success! 48577 DELETE FROM "crew"; 48578 DELETE FROM sqlite_sequence WHERE name='crew' 48579 success! 48580 DELETE FROM "supervisors"; 48581 DELETE FROM sqlite_sequence WHERE name='supervisors' 48582 success! 48583 DELETE FROM "streets"; 48584 DELETE FROM sqlite_sequence WHERE name='streets' 48585 success! 48586 DELETE FROM "crew"; 48587 DELETE FROM sqlite_sequence WHERE name='crew' 48588 success! 48589 DELETE FROM "supervisors"; 48590 DELETE FROM sqlite_sequence WHERE name='supervisors' 48591 success! 48592 DELETE FROM "streets"; 48593 DELETE FROM sqlite_sequence WHERE name='streets' 48594 success! 48595 DELETE FROM "crew"; 48596 DELETE FROM sqlite_sequence WHERE name='crew' 48597 success! 48598 DELETE FROM "supervisors"; 48599 DELETE FROM sqlite_sequence WHERE name='supervisors' 48600 success! 48601 DELETE FROM "streets"; 48602 DELETE FROM sqlite_sequence WHERE name='streets' 48603 success! 48604 DELETE FROM "crew"; 48605 DELETE FROM sqlite_sequence WHERE name='crew' 48606 success! 48607 DELETE FROM "supervisors"; 48608 DELETE FROM sqlite_sequence WHERE name='supervisors' 48609 success! 48610 DELETE FROM "streets"; 48611 DELETE FROM sqlite_sequence WHERE name='streets' 48612 success! 48613 DELETE FROM "crew"; 48614 DELETE FROM sqlite_sequence WHERE name='crew' 48615 success! 48616 DELETE FROM "supervisors"; 48617 DELETE FROM sqlite_sequence WHERE name='supervisors' 48618 success! 48619 DELETE FROM "streets"; 48620 DELETE FROM sqlite_sequence WHERE name='streets' 48621 success! 48622 DELETE FROM "crew"; 48623 DELETE FROM sqlite_sequence WHERE name='crew' 48624 success! 48625 DELETE FROM "supervisors"; 48626 DELETE FROM sqlite_sequence WHERE name='supervisors' 48627 success! 48628 DELETE FROM "streets"; 48629 DELETE FROM sqlite_sequence WHERE name='streets' 48630 success! 48631 DELETE FROM "crew"; 48632 DELETE FROM sqlite_sequence WHERE name='crew' 48633 success! 48634 DELETE FROM "supervisors"; 48635 DELETE FROM sqlite_sequence WHERE name='supervisors' 48636 success! 48637 DELETE FROM "streets"; 48638 DELETE FROM sqlite_sequence WHERE name='streets' 48639 success! 48640 DELETE FROM "crew"; 48641 DELETE FROM sqlite_sequence WHERE name='crew' 48642 success! 48643 DELETE FROM "supervisors"; 48644 DELETE FROM sqlite_sequence WHERE name='supervisors' 48645 success! 48646 DELETE FROM "streets"; 48647 DELETE FROM sqlite_sequence WHERE name='streets' 48648 success! 48649 DELETE FROM "crew"; 48650 DELETE FROM sqlite_sequence WHERE name='crew' 48651 success! 48652 DELETE FROM "supervisors"; 48653 DELETE FROM sqlite_sequence WHERE name='supervisors' 48654 success! 48655 DELETE FROM "streets"; 48656 DELETE FROM sqlite_sequence WHERE name='streets' 48657 success! 48658 DELETE FROM "crew"; 48659 DELETE FROM sqlite_sequence WHERE name='crew' 48660 success! 48661 DELETE FROM "supervisors"; 48662 DELETE FROM sqlite_sequence WHERE name='supervisors' 48663 success! 48664 DELETE FROM "streets"; 48665 DELETE FROM sqlite_sequence WHERE name='streets' 48666 success! 48667 DELETE FROM "crew"; 48668 DELETE FROM sqlite_sequence WHERE name='crew' 48669 success! 48670 DELETE FROM "supervisors"; 48671 DELETE FROM sqlite_sequence WHERE name='supervisors' 48672 success! 48673 DELETE FROM "streets"; 48674 DELETE FROM sqlite_sequence WHERE name='streets' 48675 success! 48676 DELETE FROM "crew"; 48677 DELETE FROM sqlite_sequence WHERE name='crew' 48678 success! 48679 DELETE FROM "supervisors"; 48680 DELETE FROM sqlite_sequence WHERE name='supervisors' 48681 success! 48682 DELETE FROM "streets"; 48683 DELETE FROM sqlite_sequence WHERE name='streets' 48684 success! 48685 DELETE FROM "crew"; 48686 DELETE FROM sqlite_sequence WHERE name='crew' 48687 success! 48688 DELETE FROM "supervisors"; 48689 DELETE FROM sqlite_sequence WHERE name='supervisors' 48690 success! 48691 DELETE FROM "streets"; 48692 DELETE FROM sqlite_sequence WHERE name='streets' 48693 success! 48694 DELETE FROM "crew"; 48695 DELETE FROM sqlite_sequence WHERE name='crew' 48696 success! 48697 DELETE FROM "supervisors"; 48698 DELETE FROM sqlite_sequence WHERE name='supervisors' 48699 success! 48700 DELETE FROM "streets"; 48701 DELETE FROM sqlite_sequence WHERE name='streets' 48702 success! 48703 DELETE FROM "crew"; 48704 DELETE FROM sqlite_sequence WHERE name='crew' 48705 success! 48706 DELETE FROM "supervisors"; 48707 DELETE FROM sqlite_sequence WHERE name='supervisors' 48708 success! 48709 DELETE FROM "streets"; 48710 DELETE FROM sqlite_sequence WHERE name='streets' 48711 success! 48712 DELETE FROM "crew"; 48713 DELETE FROM sqlite_sequence WHERE name='crew' 48714 success! 48715 DELETE FROM "supervisors"; 48716 DELETE FROM sqlite_sequence WHERE name='supervisors' 48717 success! 48718 DELETE FROM "streets"; 48719 DELETE FROM sqlite_sequence WHERE name='streets' 48720 success! 48721 DELETE FROM "crew"; 48722 DELETE FROM sqlite_sequence WHERE name='crew' 48723 success! 48724 DELETE FROM "supervisors"; 48725 DELETE FROM sqlite_sequence WHERE name='supervisors' 48726 success! 48727 DELETE FROM "streets"; 48728 DELETE FROM sqlite_sequence WHERE name='streets' 48729 success! 48730 DELETE FROM "crew"; 48731 DELETE FROM sqlite_sequence WHERE name='crew' 48732 success! 48733 DELETE FROM "supervisors"; 48734 DELETE FROM sqlite_sequence WHERE name='supervisors' 48735 success! 48736 DELETE FROM "streets"; 48737 DELETE FROM sqlite_sequence WHERE name='streets' 48738 success! 48739 DELETE FROM "crew"; 48740 DELETE FROM sqlite_sequence WHERE name='crew' 48741 success! 48742 DELETE FROM "supervisors"; 48743 DELETE FROM sqlite_sequence WHERE name='supervisors' 48744 success! 48745 DELETE FROM "streets"; 48746 DELETE FROM sqlite_sequence WHERE name='streets' 48747 success! 48748 DELETE FROM "crew"; 48749 DELETE FROM sqlite_sequence WHERE name='crew' 48750 success! 48751 DELETE FROM "supervisors"; 48752 DELETE FROM sqlite_sequence WHERE name='supervisors' 48753 success! 48754 DELETE FROM "streets"; 48755 DELETE FROM sqlite_sequence WHERE name='streets' 48756 success! 48757 DELETE FROM "crew"; 48758 DELETE FROM sqlite_sequence WHERE name='crew' 48759 success! 48760 DELETE FROM "supervisors"; 48761 DELETE FROM sqlite_sequence WHERE name='supervisors' 48762 success! 48763 DELETE FROM "streets"; 48764 DELETE FROM sqlite_sequence WHERE name='streets' 48765 success! 48766 DELETE FROM "crew"; 48767 DELETE FROM sqlite_sequence WHERE name='crew' 48768 success! 48769 DELETE FROM "supervisors"; 48770 DELETE FROM sqlite_sequence WHERE name='supervisors' 48771 success! 48772 DELETE FROM "streets"; 48773 DELETE FROM sqlite_sequence WHERE name='streets' 48774 success! 48775 DELETE FROM "crew"; 48776 DELETE FROM sqlite_sequence WHERE name='crew' 48777 success! 48778 DELETE FROM "supervisors"; 48779 DELETE FROM sqlite_sequence WHERE name='supervisors' 48780 success! 48781 DELETE FROM "streets"; 48782 DELETE FROM sqlite_sequence WHERE name='streets' 48783 success! 48784 DELETE FROM "crew"; 48785 DELETE FROM sqlite_sequence WHERE name='crew' 48786 success! 48787 DELETE FROM "supervisors"; 48788 DELETE FROM sqlite_sequence WHERE name='supervisors' 48789 success! 48790 DELETE FROM "streets"; 48791 DELETE FROM sqlite_sequence WHERE name='streets' 48792 success! 48793 DELETE FROM "crew"; 48794 DELETE FROM sqlite_sequence WHERE name='crew' 48795 success! 48796 DELETE FROM "supervisors"; 48797 DELETE FROM sqlite_sequence WHERE name='supervisors' 48798 success! 48799 DELETE FROM "streets"; 48800 DELETE FROM sqlite_sequence WHERE name='streets' 48801 success! 48802 DELETE FROM "crew"; 48803 DELETE FROM sqlite_sequence WHERE name='crew' 48804 success! 48805 DELETE FROM "supervisors"; 48806 DELETE FROM sqlite_sequence WHERE name='supervisors' 48807 success! 48808 DELETE FROM "streets"; 48809 DELETE FROM sqlite_sequence WHERE name='streets' 48810 success! 48811 DELETE FROM "crew"; 48812 DELETE FROM sqlite_sequence WHERE name='crew' 48813 success! 48814 DELETE FROM "supervisors"; 48815 DELETE FROM sqlite_sequence WHERE name='supervisors' 48816 success! 48817 DELETE FROM "streets"; 48818 DELETE FROM sqlite_sequence WHERE name='streets' 48819 success! 48820 DELETE FROM "crew"; 48821 DELETE FROM sqlite_sequence WHERE name='crew' 48822 success! 48823 DELETE FROM "supervisors"; 48824 DELETE FROM sqlite_sequence WHERE name='supervisors' 48825 success! 48826 DELETE FROM "streets"; 48827 DELETE FROM sqlite_sequence WHERE name='streets' 48828 success! 48829 DELETE FROM "crew"; 48830 DELETE FROM sqlite_sequence WHERE name='crew' 48831 success! 48832 DELETE FROM "supervisors"; 48833 DELETE FROM sqlite_sequence WHERE name='supervisors' 48834 success! 48835 DELETE FROM "streets"; 48836 DELETE FROM sqlite_sequence WHERE name='streets' 48837 success! 48838 DELETE FROM "crew"; 48839 DELETE FROM sqlite_sequence WHERE name='crew' 48840 success! 48841 DELETE FROM "supervisors"; 48842 DELETE FROM sqlite_sequence WHERE name='supervisors' 48843 success! 48844 DELETE FROM "streets"; 48845 DELETE FROM sqlite_sequence WHERE name='streets' 48846 success! 48847 DELETE FROM "crew"; 48848 DELETE FROM sqlite_sequence WHERE name='crew' 48849 success! 48850 DELETE FROM "supervisors"; 48851 DELETE FROM sqlite_sequence WHERE name='supervisors' 48852 success! 48853 DELETE FROM "streets"; 48854 DELETE FROM sqlite_sequence WHERE name='streets' 48855 success! 48856 DELETE FROM "crew"; 48857 DELETE FROM sqlite_sequence WHERE name='crew' 48858 success! 48859 DELETE FROM "supervisors"; 48860 DELETE FROM sqlite_sequence WHERE name='supervisors' 48861 success! 48862 DELETE FROM "streets"; 48863 DELETE FROM sqlite_sequence WHERE name='streets' 48864 success! 48865 DELETE FROM "crew"; 48866 DELETE FROM sqlite_sequence WHERE name='crew' 48867 success! 48868 DELETE FROM "supervisors"; 48869 DELETE FROM sqlite_sequence WHERE name='supervisors' 48870 success! 48871 DELETE FROM "streets"; 48872 DELETE FROM sqlite_sequence WHERE name='streets' 48873 success! 48874 DELETE FROM "crew"; 48875 DELETE FROM sqlite_sequence WHERE name='crew' 48876 success! 48877 DELETE FROM "supervisors"; 48878 DELETE FROM sqlite_sequence WHERE name='supervisors' 48879 success! 48880 DELETE FROM "streets"; 48881 DELETE FROM sqlite_sequence WHERE name='streets' 48882 success! 48883 DELETE FROM "crew"; 48884 DELETE FROM sqlite_sequence WHERE name='crew' 48885 success! 48886 DELETE FROM "supervisors"; 48887 DELETE FROM sqlite_sequence WHERE name='supervisors' 48888 success! 48889 DELETE FROM "streets"; 48890 DELETE FROM sqlite_sequence WHERE name='streets' 48891 success! 48892 DELETE FROM "crew"; 48893 DELETE FROM sqlite_sequence WHERE name='crew' 48894 success! 48895 DELETE FROM "supervisors"; 48896 DELETE FROM sqlite_sequence WHERE name='supervisors' 48897 success! 48898 DELETE FROM "streets"; 48899 DELETE FROM sqlite_sequence WHERE name='streets' 48900 success! 48901 DELETE FROM "crew"; 48902 DELETE FROM sqlite_sequence WHERE name='crew' 48903 success! 48904 DELETE FROM "supervisors"; 48905 DELETE FROM sqlite_sequence WHERE name='supervisors' 48906 success! 48907 DELETE FROM "streets"; 48908 DELETE FROM sqlite_sequence WHERE name='streets' 48909 success! 48910 DELETE FROM "crew"; 48911 DELETE FROM sqlite_sequence WHERE name='crew' 48912 success! 48913 DELETE FROM "supervisors"; 48914 DELETE FROM sqlite_sequence WHERE name='supervisors' 48915 success! 48916 DELETE FROM "streets"; 48917 DELETE FROM sqlite_sequence WHERE name='streets' 48918 success! 48919 DELETE FROM "crew"; 48920 DELETE FROM sqlite_sequence WHERE name='crew' 48921 success! 48922 DELETE FROM "supervisors"; 48923 DELETE FROM sqlite_sequence WHERE name='supervisors' 48924 success! 48925 DELETE FROM "streets"; 48926 DELETE FROM sqlite_sequence WHERE name='streets' 48927 success! 48928 DELETE FROM "crew"; 48929 DELETE FROM sqlite_sequence WHERE name='crew' 48930 success! 48931 DELETE FROM "supervisors"; 48932 DELETE FROM sqlite_sequence WHERE name='supervisors' 48933 success! 48934 DELETE FROM "streets"; 48935 DELETE FROM sqlite_sequence WHERE name='streets' 48936 success! 48937 DELETE FROM "crew"; 48938 DELETE FROM sqlite_sequence WHERE name='crew' 48939 success! 48940 DELETE FROM "supervisors"; 48941 DELETE FROM sqlite_sequence WHERE name='supervisors' 48942 success! 48943 DELETE FROM "streets"; 48944 DELETE FROM sqlite_sequence WHERE name='streets' 48945 success! 48946 DELETE FROM "crew"; 48947 DELETE FROM sqlite_sequence WHERE name='crew' 48948 success! 48949 DELETE FROM "supervisors"; 48950 DELETE FROM sqlite_sequence WHERE name='supervisors' 48951 success! 48952 DELETE FROM "streets"; 48953 DELETE FROM sqlite_sequence WHERE name='streets' 48954 success! 48955 DELETE FROM "crew"; 48956 DELETE FROM sqlite_sequence WHERE name='crew' 48957 success! 48958 DELETE FROM "supervisors"; 48959 DELETE FROM sqlite_sequence WHERE name='supervisors' 48960 success! 48961 DELETE FROM "streets"; 48962 DELETE FROM sqlite_sequence WHERE name='streets' 48963 success! 48964 DELETE FROM "crew"; 48965 DELETE FROM sqlite_sequence WHERE name='crew' 48966 success! 48967 DELETE FROM "supervisors"; 48968 DELETE FROM sqlite_sequence WHERE name='supervisors' 48969 success! 48970 DELETE FROM "streets"; 48971 DELETE FROM sqlite_sequence WHERE name='streets' 48972 success! 48973 DELETE FROM "crew"; 48974 DELETE FROM sqlite_sequence WHERE name='crew' 48975 success! 48976 DELETE FROM "supervisors"; 48977 DELETE FROM sqlite_sequence WHERE name='supervisors' 48978 success! 48979 DELETE FROM "streets"; 48980 DELETE FROM sqlite_sequence WHERE name='streets' 48981 success! 48982 DELETE FROM "crew"; 48983 DELETE FROM sqlite_sequence WHERE name='crew' 48984 success! 48985 DELETE FROM "supervisors"; 48986 DELETE FROM sqlite_sequence WHERE name='supervisors' 48987 success! 48988 DELETE FROM "streets"; 48989 DELETE FROM sqlite_sequence WHERE name='streets' 48990 success! 48991 DELETE FROM "crew"; 48992 DELETE FROM sqlite_sequence WHERE name='crew' 48993 success! 48994 DELETE FROM "supervisors"; 48995 DELETE FROM sqlite_sequence WHERE name='supervisors' 48996 success! 48997 DELETE FROM "streets"; 48998 DELETE FROM sqlite_sequence WHERE name='streets' 48999 success! 49000 DELETE FROM "crew"; 49001 DELETE FROM sqlite_sequence WHERE name='crew' 49002 success! 49003 DELETE FROM "supervisors"; 49004 DELETE FROM sqlite_sequence WHERE name='supervisors' 49005 success! 49006 DELETE FROM "streets"; 49007 DELETE FROM sqlite_sequence WHERE name='streets' 49008 success! 49009 DELETE FROM "crew"; 49010 DELETE FROM sqlite_sequence WHERE name='crew' 49011 success! 49012 DELETE FROM "supervisors"; 49013 DELETE FROM sqlite_sequence WHERE name='supervisors' 49014 success! 49015 DELETE FROM "streets"; 49016 DELETE FROM sqlite_sequence WHERE name='streets' 49017 success! 49018 DELETE FROM "crew"; 49019 DELETE FROM sqlite_sequence WHERE name='crew' 49020 success! 49021 DELETE FROM "supervisors"; 49022 DELETE FROM sqlite_sequence WHERE name='supervisors' 49023 success! 49024 DELETE FROM "streets"; 49025 DELETE FROM sqlite_sequence WHERE name='streets' 49026 success! 49027 DELETE FROM "crew"; 49028 DELETE FROM sqlite_sequence WHERE name='crew' 49029 success! 49030 DELETE FROM "supervisors"; 49031 DELETE FROM sqlite_sequence WHERE name='supervisors' 49032 success! 49033 DELETE FROM "streets"; 49034 DELETE FROM sqlite_sequence WHERE name='streets' 49035 success! 49036 DELETE FROM "crew"; 49037 DELETE FROM sqlite_sequence WHERE name='crew' 49038 success! 49039 DELETE FROM "supervisors"; 49040 DELETE FROM sqlite_sequence WHERE name='supervisors' 49041 success! 49042 DELETE FROM "streets"; 49043 DELETE FROM sqlite_sequence WHERE name='streets' 49044 success! 49045 DELETE FROM "crew"; 49046 DELETE FROM sqlite_sequence WHERE name='crew' 49047 success! 49048 DELETE FROM "supervisors"; 49049 DELETE FROM sqlite_sequence WHERE name='supervisors' 49050 success! 49051 DELETE FROM "streets"; 49052 DELETE FROM sqlite_sequence WHERE name='streets' 49053 success! 49054 DELETE FROM "crew"; 49055 DELETE FROM sqlite_sequence WHERE name='crew' 49056 success! 49057 DELETE FROM "supervisors"; 49058 DELETE FROM sqlite_sequence WHERE name='supervisors' 49059 success! 49060 DELETE FROM "streets"; 49061 DELETE FROM sqlite_sequence WHERE name='streets' 49062 success! 49063 DELETE FROM "crew"; 49064 DELETE FROM sqlite_sequence WHERE name='crew' 49065 success! 49066 DELETE FROM "supervisors"; 49067 DELETE FROM sqlite_sequence WHERE name='supervisors' 49068 success! 49069 DELETE FROM "streets"; 49070 DELETE FROM sqlite_sequence WHERE name='streets' 49071 success! 49072 DELETE FROM "crew"; 49073 DELETE FROM sqlite_sequence WHERE name='crew' 49074 success! 49075 DELETE FROM "supervisors"; 49076 DELETE FROM sqlite_sequence WHERE name='supervisors' 49077 success! 49078 DELETE FROM "streets"; 49079 DELETE FROM sqlite_sequence WHERE name='streets' 49080 success! 49081 DELETE FROM "crew"; 49082 DELETE FROM sqlite_sequence WHERE name='crew' 49083 success! 49084 DELETE FROM "supervisors"; 49085 DELETE FROM sqlite_sequence WHERE name='supervisors' 49086 success! 49087 DELETE FROM "streets"; 49088 DELETE FROM sqlite_sequence WHERE name='streets' 49089 success! 49090 DELETE FROM "crew"; 49091 DELETE FROM sqlite_sequence WHERE name='crew' 49092 success! 49093 DELETE FROM "supervisors"; 49094 DELETE FROM sqlite_sequence WHERE name='supervisors' 49095 success! 49096 DELETE FROM "streets"; 49097 DELETE FROM sqlite_sequence WHERE name='streets' 49098 success! 49099 DELETE FROM "crew"; 49100 DELETE FROM sqlite_sequence WHERE name='crew' 49101 success! 49102 DELETE FROM "supervisors"; 49103 DELETE FROM sqlite_sequence WHERE name='supervisors' 49104 success! 49105 DELETE FROM "streets"; 49106 DELETE FROM sqlite_sequence WHERE name='streets' 49107 success! 49108 DELETE FROM "crew"; 49109 DELETE FROM sqlite_sequence WHERE name='crew' 49110 success! 49111 DELETE FROM "supervisors"; 49112 DELETE FROM sqlite_sequence WHERE name='supervisors' 49113 success! 49114 DELETE FROM "streets"; 49115 DELETE FROM sqlite_sequence WHERE name='streets' 49116 success! 49117 DELETE FROM "crew"; 49118 DELETE FROM sqlite_sequence WHERE name='crew' 49119 success! 49120 DELETE FROM "supervisors"; 49121 DELETE FROM sqlite_sequence WHERE name='supervisors' 49122 success! 49123 DELETE FROM "streets"; 49124 DELETE FROM sqlite_sequence WHERE name='streets' 49125 success! 49126 DELETE FROM "crew"; 49127 DELETE FROM sqlite_sequence WHERE name='crew' 49128 success! 49129 DELETE FROM "supervisors"; 49130 DELETE FROM sqlite_sequence WHERE name='supervisors' 49131 success! 49132 DELETE FROM "streets"; 49133 DELETE FROM sqlite_sequence WHERE name='streets' 49134 success! 49135 DELETE FROM "crew"; 49136 DELETE FROM sqlite_sequence WHERE name='crew' 49137 success! 49138 DELETE FROM "supervisors"; 49139 DELETE FROM sqlite_sequence WHERE name='supervisors' 49140 success! 49141 DELETE FROM "streets"; 49142 DELETE FROM sqlite_sequence WHERE name='streets' 49143 success! 49144 DELETE FROM "crew"; 49145 DELETE FROM sqlite_sequence WHERE name='crew' 49146 success! 49147 DELETE FROM "supervisors"; 49148 DELETE FROM sqlite_sequence WHERE name='supervisors' 49149 success! 49150 DELETE FROM "streets"; 49151 DELETE FROM sqlite_sequence WHERE name='streets' 49152 success! 49153 DELETE FROM "crew"; 49154 DELETE FROM sqlite_sequence WHERE name='crew' 49155 success! 49156 DELETE FROM "supervisors"; 49157 DELETE FROM sqlite_sequence WHERE name='supervisors' 49158 success! 49159 DELETE FROM "streets"; 49160 DELETE FROM sqlite_sequence WHERE name='streets' 49161 success! 49162 DELETE FROM "crew"; 49163 DELETE FROM sqlite_sequence WHERE name='crew' 49164 success! 49165 DELETE FROM "supervisors"; 49166 DELETE FROM sqlite_sequence WHERE name='supervisors' 49167 success! 49168 DELETE FROM "streets"; 49169 DELETE FROM sqlite_sequence WHERE name='streets' 49170 success! 49171 DELETE FROM "crew"; 49172 DELETE FROM sqlite_sequence WHERE name='crew' 49173 success! 49174 DELETE FROM "supervisors"; 49175 DELETE FROM sqlite_sequence WHERE name='supervisors' 49176 success! 49177 DELETE FROM "streets"; 49178 DELETE FROM sqlite_sequence WHERE name='streets' 49179 success! 49180 DELETE FROM "crew"; 49181 DELETE FROM sqlite_sequence WHERE name='crew' 49182 success! 49183 DELETE FROM "supervisors"; 49184 DELETE FROM sqlite_sequence WHERE name='supervisors' 49185 success! 49186 DELETE FROM "streets"; 49187 DELETE FROM sqlite_sequence WHERE name='streets' 49188 success! 49189 DELETE FROM "crew"; 49190 DELETE FROM sqlite_sequence WHERE name='crew' 49191 success! 49192 DELETE FROM "supervisors"; 49193 DELETE FROM sqlite_sequence WHERE name='supervisors' 49194 success! 49195 DELETE FROM "streets"; 49196 DELETE FROM sqlite_sequence WHERE name='streets' 49197 success! 49198 DELETE FROM "crew"; 49199 DELETE FROM sqlite_sequence WHERE name='crew' 49200 success! 49201 DELETE FROM "supervisors"; 49202 DELETE FROM sqlite_sequence WHERE name='supervisors' 49203 success! 49204 DELETE FROM "streets"; 49205 DELETE FROM sqlite_sequence WHERE name='streets' 49206 success! 49207 DELETE FROM "crew"; 49208 DELETE FROM sqlite_sequence WHERE name='crew' 49209 success! 49210 DELETE FROM "supervisors"; 49211 DELETE FROM sqlite_sequence WHERE name='supervisors' 49212 success! 49213 DELETE FROM "streets"; 49214 DELETE FROM sqlite_sequence WHERE name='streets' 49215 success! 49216 DELETE FROM "crew"; 49217 DELETE FROM sqlite_sequence WHERE name='crew' 49218 success! 49219 DELETE FROM "supervisors"; 49220 DELETE FROM sqlite_sequence WHERE name='supervisors' 49221 success! 49222 DELETE FROM "streets"; 49223 DELETE FROM sqlite_sequence WHERE name='streets' 49224 success! 49225 DELETE FROM "crew"; 49226 DELETE FROM sqlite_sequence WHERE name='crew' 49227 success! 49228 DELETE FROM "supervisors"; 49229 DELETE FROM sqlite_sequence WHERE name='supervisors' 49230 success! 49231 DELETE FROM "streets"; 49232 DELETE FROM sqlite_sequence WHERE name='streets' 49233 success! 49234 DELETE FROM "crew"; 49235 DELETE FROM sqlite_sequence WHERE name='crew' 49236 success! 49237 DELETE FROM "supervisors"; 49238 DELETE FROM sqlite_sequence WHERE name='supervisors' 49239 success! 49240 DELETE FROM "streets"; 49241 DELETE FROM sqlite_sequence WHERE name='streets' 49242 success! 49243 DELETE FROM "crew"; 49244 DELETE FROM sqlite_sequence WHERE name='crew' 49245 success! 49246 DELETE FROM "supervisors"; 49247 DELETE FROM sqlite_sequence WHERE name='supervisors' 49248 success! 49249 DELETE FROM "streets"; 49250 DELETE FROM sqlite_sequence WHERE name='streets' 49251 success! 49252 DELETE FROM "crew"; 49253 DELETE FROM sqlite_sequence WHERE name='crew' 49254 success! 49255 DELETE FROM "supervisors"; 49256 DELETE FROM sqlite_sequence WHERE name='supervisors' 49257 success! 49258 DELETE FROM "streets"; 49259 DELETE FROM sqlite_sequence WHERE name='streets' 49260 success! 49261 DELETE FROM "crew"; 49262 DELETE FROM sqlite_sequence WHERE name='crew' 49263 success! 49264 DELETE FROM "supervisors"; 49265 DELETE FROM sqlite_sequence WHERE name='supervisors' 49266 success! 49267 DELETE FROM "streets"; 49268 DELETE FROM sqlite_sequence WHERE name='streets' 49269 success! 49270 DELETE FROM "crew"; 49271 DELETE FROM sqlite_sequence WHERE name='crew' 49272 success! 49273 DELETE FROM "supervisors"; 49274 DELETE FROM sqlite_sequence WHERE name='supervisors' 49275 success! 49276 DELETE FROM "streets"; 49277 DELETE FROM sqlite_sequence WHERE name='streets' 49278 success! 49279 DELETE FROM "crew"; 49280 DELETE FROM sqlite_sequence WHERE name='crew' 49281 success! 49282 DELETE FROM "supervisors"; 49283 DELETE FROM sqlite_sequence WHERE name='supervisors' 49284 success! 49285 DELETE FROM "streets"; 49286 DELETE FROM sqlite_sequence WHERE name='streets' 49287 success! 49288 DELETE FROM "crew"; 49289 DELETE FROM sqlite_sequence WHERE name='crew' 49290 success! 49291 DELETE FROM "supervisors"; 49292 DELETE FROM sqlite_sequence WHERE name='supervisors' 49293 success! 49294 DELETE FROM "streets"; 49295 DELETE FROM sqlite_sequence WHERE name='streets' 49296 success! 49297 DELETE FROM "crew"; 49298 DELETE FROM sqlite_sequence WHERE name='crew' 49299 success! 49300 DELETE FROM "supervisors"; 49301 DELETE FROM sqlite_sequence WHERE name='supervisors' 49302 success! 49303 DELETE FROM "streets"; 49304 DELETE FROM sqlite_sequence WHERE name='streets' 49305 success! 49306 DELETE FROM "crew"; 49307 DELETE FROM sqlite_sequence WHERE name='crew' 49308 success! 49309 DELETE FROM "supervisors"; 49310 DELETE FROM sqlite_sequence WHERE name='supervisors' 49311 success! 49312 DELETE FROM "streets"; 49313 DELETE FROM sqlite_sequence WHERE name='streets' 49314 success! 49315 DELETE FROM "crew"; 49316 DELETE FROM sqlite_sequence WHERE name='crew' 49317 success! 49318 DELETE FROM "supervisors"; 49319 DELETE FROM sqlite_sequence WHERE name='supervisors' 49320 success! 49321 DELETE FROM "streets"; 49322 DELETE FROM sqlite_sequence WHERE name='streets' 49323 success! 49324 DELETE FROM "crew"; 49325 DELETE FROM sqlite_sequence WHERE name='crew' 49326 success! 49327 DELETE FROM "supervisors"; 49328 DELETE FROM sqlite_sequence WHERE name='supervisors' 49329 success! 49330 DELETE FROM "streets"; 49331 DELETE FROM sqlite_sequence WHERE name='streets' 49332 success! 49333 DELETE FROM "crew"; 49334 DELETE FROM sqlite_sequence WHERE name='crew' 49335 success! 49336 DELETE FROM "supervisors"; 49337 DELETE FROM sqlite_sequence WHERE name='supervisors' 49338 success! 49339 DELETE FROM "streets"; 49340 DELETE FROM sqlite_sequence WHERE name='streets' 49341 success! 49342 DELETE FROM "crew"; 49343 DELETE FROM sqlite_sequence WHERE name='crew' 49344 success! 49345 DELETE FROM "supervisors"; 49346 DELETE FROM sqlite_sequence WHERE name='supervisors' 49347 success! 49348 DELETE FROM "streets"; 49349 DELETE FROM sqlite_sequence WHERE name='streets' 49350 success! 49351 DELETE FROM "crew"; 49352 DELETE FROM sqlite_sequence WHERE name='crew' 49353 success! 49354 DELETE FROM "supervisors"; 49355 DELETE FROM sqlite_sequence WHERE name='supervisors' 49356 success! 49357 DELETE FROM "streets"; 49358 DELETE FROM sqlite_sequence WHERE name='streets' 49359 success! 49360 DELETE FROM "crew"; 49361 DELETE FROM sqlite_sequence WHERE name='crew' 49362 success! 49363 DELETE FROM "supervisors"; 49364 DELETE FROM sqlite_sequence WHERE name='supervisors' 49365 success! 49366 DELETE FROM "streets"; 49367 DELETE FROM sqlite_sequence WHERE name='streets' 49368 success! 49369 DELETE FROM "crew"; 49370 DELETE FROM sqlite_sequence WHERE name='crew' 49371 success! 49372 DELETE FROM "supervisors"; 49373 DELETE FROM sqlite_sequence WHERE name='supervisors' 49374 success! 49375 DELETE FROM "streets"; 49376 DELETE FROM sqlite_sequence WHERE name='streets' 49377 success! 49378 DELETE FROM "crew"; 49379 DELETE FROM sqlite_sequence WHERE name='crew' 49380 success! 49381 DELETE FROM "supervisors"; 49382 DELETE FROM sqlite_sequence WHERE name='supervisors' 49383 success! 49384 DELETE FROM "streets"; 49385 DELETE FROM sqlite_sequence WHERE name='streets' 49386 success! 49387 DELETE FROM "crew"; 49388 DELETE FROM sqlite_sequence WHERE name='crew' 49389 success! 49390 DELETE FROM "supervisors"; 49391 DELETE FROM sqlite_sequence WHERE name='supervisors' 49392 success! 49393 DELETE FROM "streets"; 49394 DELETE FROM sqlite_sequence WHERE name='streets' 49395 success! 49396 DELETE FROM "crew"; 49397 DELETE FROM sqlite_sequence WHERE name='crew' 49398 success! 49399 DELETE FROM "supervisors"; 49400 DELETE FROM sqlite_sequence WHERE name='supervisors' 49401 success! 49402 DELETE FROM "streets"; 49403 DELETE FROM sqlite_sequence WHERE name='streets' 49404 success! 49405 DELETE FROM "crew"; 49406 DELETE FROM sqlite_sequence WHERE name='crew' 49407 success! 49408 DELETE FROM "supervisors"; 49409 DELETE FROM sqlite_sequence WHERE name='supervisors' 49410 success! 49411 DELETE FROM "streets"; 49412 DELETE FROM sqlite_sequence WHERE name='streets' 49413 success! 49414 DELETE FROM "crew"; 49415 DELETE FROM sqlite_sequence WHERE name='crew' 49416 success! 49417 DELETE FROM "supervisors"; 49418 DELETE FROM sqlite_sequence WHERE name='supervisors' 49419 success! 49420 DELETE FROM "streets"; 49421 DELETE FROM sqlite_sequence WHERE name='streets' 49422 success! 49423 DELETE FROM "crew"; 49424 DELETE FROM sqlite_sequence WHERE name='crew' 49425 success! 49426 DELETE FROM "supervisors"; 49427 DELETE FROM sqlite_sequence WHERE name='supervisors' 49428 success! 49429 DELETE FROM "streets"; 49430 DELETE FROM sqlite_sequence WHERE name='streets' 49431 success! 49432 DELETE FROM "crew"; 49433 DELETE FROM sqlite_sequence WHERE name='crew' 49434 success! 49435 DELETE FROM "supervisors"; 49436 DELETE FROM sqlite_sequence WHERE name='supervisors' 49437 success! 49438 DELETE FROM "streets"; 49439 DELETE FROM sqlite_sequence WHERE name='streets' 49440 success! 49441 DELETE FROM "crew"; 49442 DELETE FROM sqlite_sequence WHERE name='crew' 49443 success! 49444 DELETE FROM "supervisors"; 49445 DELETE FROM sqlite_sequence WHERE name='supervisors' 49446 success! 49447 DELETE FROM "streets"; 49448 DELETE FROM sqlite_sequence WHERE name='streets' 49449 success! 49450 DELETE FROM "crew"; 49451 DELETE FROM sqlite_sequence WHERE name='crew' 49452 success! 49453 DELETE FROM "supervisors"; 49454 DELETE FROM sqlite_sequence WHERE name='supervisors' 49455 success! 49456 DELETE FROM "streets"; 49457 DELETE FROM sqlite_sequence WHERE name='streets' 49458 success! 49459 DELETE FROM "crew"; 49460 DELETE FROM sqlite_sequence WHERE name='crew' 49461 success! 49462 DELETE FROM "supervisors"; 49463 DELETE FROM sqlite_sequence WHERE name='supervisors' 49464 success! 49465 DELETE FROM "streets"; 49466 DELETE FROM sqlite_sequence WHERE name='streets' 49467 success! 49468 DELETE FROM "crew"; 49469 DELETE FROM sqlite_sequence WHERE name='crew' 49470 success! 49471 DELETE FROM "supervisors"; 49472 DELETE FROM sqlite_sequence WHERE name='supervisors' 49473 success! 49474 DELETE FROM "streets"; 49475 DELETE FROM sqlite_sequence WHERE name='streets' 49476 success! 49477 DELETE FROM "crew"; 49478 DELETE FROM sqlite_sequence WHERE name='crew' 49479 success! 49480 DELETE FROM "supervisors"; 49481 DELETE FROM sqlite_sequence WHERE name='supervisors' 49482 success! 49483 DELETE FROM "streets"; 49484 DELETE FROM sqlite_sequence WHERE name='streets' 49485 success! 49486 DELETE FROM "crew"; 49487 DELETE FROM sqlite_sequence WHERE name='crew' 49488 success! 49489 DELETE FROM "supervisors"; 49490 DELETE FROM sqlite_sequence WHERE name='supervisors' 49491 success! 49492 DELETE FROM "streets"; 49493 DELETE FROM sqlite_sequence WHERE name='streets' 49494 success! 49495 DELETE FROM "crew"; 49496 DELETE FROM sqlite_sequence WHERE name='crew' 49497 success! 49498 DELETE FROM "supervisors"; 49499 DELETE FROM sqlite_sequence WHERE name='supervisors' 49500 success! 49501 DELETE FROM "streets"; 49502 DELETE FROM sqlite_sequence WHERE name='streets' 49503 success! 49504 DELETE FROM "crew"; 49505 DELETE FROM sqlite_sequence WHERE name='crew' 49506 success! 49507 DELETE FROM "supervisors"; 49508 DELETE FROM sqlite_sequence WHERE name='supervisors' 49509 success! 49510 DELETE FROM "streets"; 49511 DELETE FROM sqlite_sequence WHERE name='streets' 49512 success! 49513 DELETE FROM "crew"; 49514 DELETE FROM sqlite_sequence WHERE name='crew' 49515 success! 49516 DELETE FROM "supervisors"; 49517 DELETE FROM sqlite_sequence WHERE name='supervisors' 49518 success! 49519 DELETE FROM "streets"; 49520 DELETE FROM sqlite_sequence WHERE name='streets' 49521 success! 49522 DELETE FROM "crew"; 49523 DELETE FROM sqlite_sequence WHERE name='crew' 49524 success! 49525 DELETE FROM "supervisors"; 49526 DELETE FROM sqlite_sequence WHERE name='supervisors' 49527 success! 49528 DELETE FROM "streets"; 49529 DELETE FROM sqlite_sequence WHERE name='streets' 49530 success! 49531 DELETE FROM "crew"; 49532 DELETE FROM sqlite_sequence WHERE name='crew' 49533 success! 49534 DELETE FROM "supervisors"; 49535 DELETE FROM sqlite_sequence WHERE name='supervisors' 49536 success! 49537 DELETE FROM "streets"; 49538 DELETE FROM sqlite_sequence WHERE name='streets' 49539 success! 49540 DELETE FROM "crew"; 49541 DELETE FROM sqlite_sequence WHERE name='crew' 49542 success! 49543 DELETE FROM "supervisors"; 49544 DELETE FROM sqlite_sequence WHERE name='supervisors' 49545 success! 49546 DELETE FROM "streets"; 49547 DELETE FROM sqlite_sequence WHERE name='streets' 49548 success! 49549 DELETE FROM "crew"; 49550 DELETE FROM sqlite_sequence WHERE name='crew' 49551 success! 49552 DELETE FROM "supervisors"; 49553 DELETE FROM sqlite_sequence WHERE name='supervisors' 49554 success! 49555 DELETE FROM "streets"; 49556 DELETE FROM sqlite_sequence WHERE name='streets' 49557 success! 49558 DELETE FROM "crew"; 49559 DELETE FROM sqlite_sequence WHERE name='crew' 49560 success! 49561 DELETE FROM "supervisors"; 49562 DELETE FROM sqlite_sequence WHERE name='supervisors' 49563 success! 49564 DELETE FROM "streets"; 49565 DELETE FROM sqlite_sequence WHERE name='streets' 49566 success! 49567 DELETE FROM "crew"; 49568 DELETE FROM sqlite_sequence WHERE name='crew' 49569 success! 49570 DELETE FROM "supervisors"; 49571 DELETE FROM sqlite_sequence WHERE name='supervisors' 49572 success! 49573 DELETE FROM "streets"; 49574 DELETE FROM sqlite_sequence WHERE name='streets' 49575 success! 49576 DELETE FROM "crew"; 49577 DELETE FROM sqlite_sequence WHERE name='crew' 49578 success! 49579 DELETE FROM "supervisors"; 49580 DELETE FROM sqlite_sequence WHERE name='supervisors' 49581 success! 49582 DELETE FROM "streets"; 49583 DELETE FROM sqlite_sequence WHERE name='streets' 49584 success! 49585 DELETE FROM "crew"; 49586 DELETE FROM sqlite_sequence WHERE name='crew' 49587 success! 49588 DELETE FROM "supervisors"; 49589 DELETE FROM sqlite_sequence WHERE name='supervisors' 49590 success! 49591 DELETE FROM "streets"; 49592 DELETE FROM sqlite_sequence WHERE name='streets' 49593 success! 49594 DELETE FROM "crew"; 49595 DELETE FROM sqlite_sequence WHERE name='crew' 49596 success! 49597 DELETE FROM "supervisors"; 49598 DELETE FROM sqlite_sequence WHERE name='supervisors' 49599 success! 49600 DELETE FROM "streets"; 49601 DELETE FROM sqlite_sequence WHERE name='streets' 49602 success! 49603 DELETE FROM "crew"; 49604 DELETE FROM sqlite_sequence WHERE name='crew' 49605 success! 49606 DELETE FROM "supervisors"; 49607 DELETE FROM sqlite_sequence WHERE name='supervisors' 49608 success! 49609 DELETE FROM "streets"; 49610 DELETE FROM sqlite_sequence WHERE name='streets' 49611 success! 49612 DELETE FROM "crew"; 49613 DELETE FROM sqlite_sequence WHERE name='crew' 49614 success! -
branches/LCSv2/errors
-
Property
svn:ignore
set to
*
-
Property
svn:ignore
set to
-
branches/LCSv2/progress.log
r623 r626 1295 1295 [2020-08-21 14:00:13] EDIT LCSv2/views/default/list.html: 0 1296 1296 [2020-08-25 15:40:08] EDIT LCSv2/models/menu.py: 0 1297 [2020-08-30 14:41:51] EDIT LCSv2/views/default/home.html: 4 1298 [2020-08-30 14:42:25] EDIT LCSv2/views/default/home.html: -2 1299 [2020-08-30 14:44:12] EDIT LCSv2/views/default/home.html: 1 1300 [2020-08-30 14:45:03] EDIT LCSv2/views/default/home.html: 1 1301 [2020-08-30 14:45:37] EDIT LCSv2/views/default/home.html: 0 1302 [2020-08-30 14:46:12] EDIT LCSv2/views/default/home.html: 0 1303 [2020-08-30 14:46:48] EDIT LCSv2/views/default/home.html: 0 1304 [2020-08-30 14:48:55] EDIT LCSv2/views/default/home.html: -4 1305 [2020-08-30 14:49:20] EDIT LCSv2/views/default/help.html: 4 1306 [2020-08-30 14:50:56] EDIT LCSv2/views/default/help.html: 0 1307 [2020-08-30 15:06:57] EDIT LCSv2/controllers/default.py: 0 1308 [2020-08-30 15:08:55] EDIT LCSv2/controllers/default.py: 0 1309 [2020-08-30 15:20:37] EDIT LCSv2/controllers/default.py: 1 1310 [2020-08-30 15:30:46] EDIT LCSv2/controllers/default.py: 0 1311 [2020-08-30 15:32:30] EDIT LCSv2/controllers/default.py: 1 1312 [2020-08-30 15:33:33] EDIT LCSv2/controllers/default.py: 1 1313 [2020-08-30 15:35:46] EDIT LCSv2/controllers/default.py: 2 -
branches/LCSv2/sessions
-
Property
svn:ignore
set to
*
-
Property
svn:ignore
set to
-
branches/LCSv2/views/default/help.html
r619 r626 1 1 {{extend 'layout.html'}} 2 2 <h1>Sorry, we haven't written the help yet.</h1> 3 <div style="color: gray; text-align:center"> 4 <HR> 5 6 LCS Revision 622 7 </div> -
branches/LCSv2/views/default/help.html.bak
r619 r626 1 1 {{extend 'layout.html'}} 2 <h1>This is the default/help.html template</h1> 3 {{=BEAUTIFY(response._vars)}} 2 <h1>Sorry, we haven't written the help yet.</h1> 3 <div style="color: gray; position: fixed; bottom: 0; width: 760px; "> 4 <HR> 5 Revision 622 6 </div> -
branches/LCSv2/views/default/home.html.bak
r619 r626 1 1 {{extend 'layout.html'}} 2 2 3 <h1>Home Page</h1> 4 Welcome {{=name}}<br> 5 <h4> 6 District Messages 7 </h4> 8 DTM CONTACTS – CONSTRUCTION: Adam Ant – 555-888-1111<br> 9 PERMITS & MAINTENANCE: Becky Bee – 555-666-2222<br> 10 LCS IT ISSUES: Carly Cow – 111-555-6666<br> 3 <div id="main" role="main" class="mainflex" style="text-align: center;"> 4 <div id="pageTitle" class="header">Home</div> 5 <div class="block-content" style="display: block; text-align:left; min-width: 760px; margin: 4% 0% 7% 0%;"> 6 <div style="width:760px;"> 7 <p class="heading3">Welcome, {{=name}}</p> 8 <div role="heading" aria-level="2" class="heading2">District Messages </div> 9 <div role="heading" aria-level="2" class="heading2">DTM CONTACTS - CONSTRUCTION: 10 <span style="margin-left: 5%;">Adam Ant - 555-888-1111</span> </div> 11 <div role="heading" aria-level="2" class="heading2">PERMITS & MAINTENANCE: 12 <span style="margin-left: 5%;"> Becky Bee - 555-666-2222 </span> </div> 13 <div role="heading" aria-level="2" class="heading2">LCS IT ISSUES: 14 <span style="margin-left: 5%;"> Carly Cow - 111-555-6666 </span></div> 15 </div> 16 <div style="color: gray; position: fixed; bottom: 0; width: 760px; "> 17 <HR> 18 Revision 622 19 </div> 20 </div> 21 </div>
Note: See TracChangeset
for help on using the changeset viewer.
