Changeset 641 in tmcsimulator for branches/LCSv2


Ignore:
Timestamp:
03/13/2021 05:17:45 PM (5 years ago)
Author:
jdalbey
Message:

LCSv2.default.py modified for #254. Changed studentnames file reading.

Location:
branches/LCSv2
Files:
7 edited

Legend:

Unmodified
Added
Removed
  • branches/LCSv2/controllers/default.py

    r636 r641  
    11# added comments for testing 
    22# Constants 
    3 kLogfile = "samplelogfile.txt" 
     3kLogfile = "LCSlogfile.txt" 
    44kSimtimefile = "sim_elapsedtime.json"  #"../webapps/dynamicdata/sim_elapsed_time.json" 
    55hwys = ['','1','5', '22', '55', '57', '73', '74', '91', '133', '142', '241', '261', '405', '605'] 
     
    77# Names to appear in the username dropdown box 
    88users = [] 
     9users.append('') 
    910# Show the login page 
    1011def index(): 
    1112    userfile = open('student_names.txt','r') 
    12     users = [line.strip() for line in userfile.readlines()] 
    13     users.insert(0,'') 
     13    # read the file into a buffer 
     14    buffer = [line.strip() for line in userfile.readlines()] 
     15    # Append each name in the buffer to the users list, skipping blank lines 
     16    for item in buffer: 
     17        if len(item) > 0: 
     18            users.append(item) 
     19    # build the form 
    1420    form = FORM(LABEL('User:',_for='username', _class="label username-label"), 
    1521                #INPUT(_name='username', _size='15', _style="font-size: 18px;"), BR(), 
     
    1824    if form.process().accepted: 
    1925        # Put the username entry into the session variable 
    20         session.username = form.vars.username 
     26        session.username = reverseNameFields(form.vars.username) 
    2127        redirect(URL('home')) 
    2228    return dict(form=form) 
     
    376382        return "NO" 
    377383 
     384# Swap the fields in a name, changing lastname first to firstname first. 
     385def reverseNameFields(formattedname): 
     386    # Divide the name into last and first names 
     387    x = formattedname.split(',') 
     388    # If there isn't a comma, return the entire name 
     389    if len(x) == 1: 
     390        return x[0].strip() 
     391    else:  # return the swapped fields 
     392        return x[1].strip() + ' ' + x[0] 
     393 
    378394# Convert the lanes closed checkboxes into a human readable string 
    379395# E.g.  #1 #3 of 4 
  • branches/LCSv2/controllers/default.py.bak

    r634 r641  
    22# Constants 
    33kLogfile = "samplelogfile.txt" 
    4 kSimtimefile = "sim_elapsedtime.json" 
     4kSimtimefile = "sim_elapsedtime.json"  #"../webapps/dynamicdata/sim_elapsed_time.json" 
    55hwys = ['','1','5', '22', '55', '57', '73', '74', '91', '133', '142', '241', '261', '405', '605'] 
    66hwyDirections = ['','NB', 'SB', 'NB/SB','EB','WB','EB/WB'] 
    77# Names to appear in the username dropdown box 
    88users = [] 
     9users.append('') 
    910# Show the login page 
    1011def index(): 
    1112    userfile = open('student_names.txt','r') 
    12     users = [line.strip() for line in userfile.readlines()] 
    13     users.insert(0,'') 
     13    # read the file into a buffer 
     14    buffer = [line.strip() for line in userfile.readlines()] 
     15    # Append each name in the buffer to the users list, skipping blank lines 
     16    for item in buffer: 
     17        if len(item) > 0: 
     18            users.append(item) 
    1419    form = FORM(LABEL('User:',_for='username', _class="label username-label"), 
    1520                #INPUT(_name='username', _size='15', _style="font-size: 18px;"), BR(), 
     
    1823    if form.process().accepted: 
    1924        # Put the username entry into the session variable 
    20         session.username = form.vars.username 
     25        session.username = reverseNameFields(form.vars.username) 
    2126        redirect(URL('home')) 
    2227    return dict(form=form) 
     
    192197            db(db.closures.closureid == session.statustype[4:]).update(**{fieldname:now.strftime("%H%M")}) 
    193198            # Log the update to external file 
    194             logmessage = getSimTime() + " LCS status update: " + session.statustype[4:] + ", " + session.statustype[0:4] + ", " + session.statuser + " " + "\n" 
     199            logmessage = getSimTime() + ", LCS status update: " + session.username + ", " + session.statustype[4:] + ", " + session.statustype[0:4] + ", " + session.statuser + " " + "\n" 
    195200            text_file = open(kLogfile, "a") 
    196201            text_file.write(logmessage) 
     
    216221        currentSimTime = jsontime["elapsedtime"] 
    217222        timestamp = str(datetime.timedelta(seconds = int(currentSimTime))) 
    218         return timestamp 
     223        return '0'+timestamp  # assume simtime is < 10 and prefix a zero 
    219224    except: 
    220225        # Fallback if missing file, use current time  
     
    317322        session.flash = 'New lane closure added: ' + newID + ' ' + newLognum + ': ' + selectedlanes 
    318323        # Log the new closure to external file. Username, closureID, route, dir, type of closure, type of work 
    319         logmessage = getSimTime() + " LCS new closure: " + session.username + newID + '.' + newLognum + ', ' + form.vars.route + form.vars.direction + ', ' + form.vars.closuretype + ', ' + form.vars.worktype + "\n" 
     324        logmessage = getSimTime() + ", LCS new closure: " + session.username + ", " + newID + '.' + newLognum + ', ' + form.vars.route + form.vars.direction + ', ' + form.vars.closuretype + ', ' + form.vars.worktype + "\n" 
    320325        text_file = open(kLogfile, "a") 
    321326        text_file.write(logmessage) 
     
    376381        return "NO" 
    377382 
     383# Swap the fields in a name, changing lastname first to firstname first. 
     384def reverseNameFields(formattedname): 
     385    # Divide the name into last and first names 
     386    x = formattedname.split(',') 
     387    # If there isn't a comma, return the entire name 
     388    if len(x) == 1: 
     389        return x[0].strip() 
     390    else:  # return the swapped fields 
     391        return x[1].strip() + ' ' + x[0] 
     392 
    378393# Convert the lanes closed checkboxes into a human readable string 
    379394# E.g.  #1 #3 of 4 
  • branches/LCSv2/databases/sql.log

    r634 r641  
    5138651386DELETE FROM sqlite_sequence WHERE name='crew' 
    5138751387success! 
     51388DELETE FROM "supervisors"; 
     51389DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51390success! 
     51391DELETE FROM "streets"; 
     51392DELETE FROM sqlite_sequence WHERE name='streets' 
     51393success! 
     51394DELETE FROM "crew"; 
     51395DELETE FROM sqlite_sequence WHERE name='crew' 
     51396success! 
     51397DELETE FROM "supervisors"; 
     51398DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51399success! 
     51400DELETE FROM "streets"; 
     51401DELETE FROM sqlite_sequence WHERE name='streets' 
     51402success! 
     51403DELETE FROM "crew"; 
     51404DELETE FROM sqlite_sequence WHERE name='crew' 
     51405success! 
     51406DELETE FROM "supervisors"; 
     51407DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51408success! 
     51409DELETE FROM "streets"; 
     51410DELETE FROM sqlite_sequence WHERE name='streets' 
     51411success! 
     51412DELETE FROM "crew"; 
     51413DELETE FROM sqlite_sequence WHERE name='crew' 
     51414success! 
     51415DELETE FROM "supervisors"; 
     51416DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51417success! 
     51418DELETE FROM "streets"; 
     51419DELETE FROM sqlite_sequence WHERE name='streets' 
     51420success! 
     51421DELETE FROM "crew"; 
     51422DELETE FROM sqlite_sequence WHERE name='crew' 
     51423success! 
     51424DELETE FROM "supervisors"; 
     51425DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51426success! 
     51427DELETE FROM "streets"; 
     51428DELETE FROM sqlite_sequence WHERE name='streets' 
     51429success! 
     51430DELETE FROM "crew"; 
     51431DELETE FROM sqlite_sequence WHERE name='crew' 
     51432success! 
     51433DELETE FROM "supervisors"; 
     51434DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51435success! 
     51436DELETE FROM "streets"; 
     51437DELETE FROM sqlite_sequence WHERE name='streets' 
     51438success! 
     51439DELETE FROM "crew"; 
     51440DELETE FROM sqlite_sequence WHERE name='crew' 
     51441success! 
     51442DELETE FROM "supervisors"; 
     51443DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51444success! 
     51445DELETE FROM "streets"; 
     51446DELETE FROM sqlite_sequence WHERE name='streets' 
     51447success! 
     51448DELETE FROM "crew"; 
     51449DELETE FROM sqlite_sequence WHERE name='crew' 
     51450success! 
     51451DELETE FROM "supervisors"; 
     51452DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51453success! 
     51454DELETE FROM "streets"; 
     51455DELETE FROM sqlite_sequence WHERE name='streets' 
     51456success! 
     51457DELETE FROM "crew"; 
     51458DELETE FROM sqlite_sequence WHERE name='crew' 
     51459success! 
     51460DELETE FROM "supervisors"; 
     51461DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51462success! 
     51463DELETE FROM "streets"; 
     51464DELETE FROM sqlite_sequence WHERE name='streets' 
     51465success! 
     51466DELETE FROM "crew"; 
     51467DELETE FROM sqlite_sequence WHERE name='crew' 
     51468success! 
     51469DELETE FROM "supervisors"; 
     51470DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51471success! 
     51472DELETE FROM "streets"; 
     51473DELETE FROM sqlite_sequence WHERE name='streets' 
     51474success! 
     51475DELETE FROM "crew"; 
     51476DELETE FROM sqlite_sequence WHERE name='crew' 
     51477success! 
     51478DELETE FROM "supervisors"; 
     51479DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51480success! 
     51481DELETE FROM "streets"; 
     51482DELETE FROM sqlite_sequence WHERE name='streets' 
     51483success! 
     51484DELETE FROM "crew"; 
     51485DELETE FROM sqlite_sequence WHERE name='crew' 
     51486success! 
     51487DELETE FROM "supervisors"; 
     51488DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51489success! 
     51490DELETE FROM "streets"; 
     51491DELETE FROM sqlite_sequence WHERE name='streets' 
     51492success! 
     51493DELETE FROM "crew"; 
     51494DELETE FROM sqlite_sequence WHERE name='crew' 
     51495success! 
     51496DELETE FROM "supervisors"; 
     51497DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51498success! 
     51499DELETE FROM "streets"; 
     51500DELETE FROM sqlite_sequence WHERE name='streets' 
     51501success! 
     51502DELETE FROM "crew"; 
     51503DELETE FROM sqlite_sequence WHERE name='crew' 
     51504success! 
     51505DELETE FROM "supervisors"; 
     51506DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51507success! 
     51508DELETE FROM "streets"; 
     51509DELETE FROM sqlite_sequence WHERE name='streets' 
     51510success! 
     51511DELETE FROM "crew"; 
     51512DELETE FROM sqlite_sequence WHERE name='crew' 
     51513success! 
     51514DELETE FROM "supervisors"; 
     51515DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51516success! 
     51517DELETE FROM "streets"; 
     51518DELETE FROM sqlite_sequence WHERE name='streets' 
     51519success! 
     51520DELETE FROM "crew"; 
     51521DELETE FROM sqlite_sequence WHERE name='crew' 
     51522success! 
     51523DELETE FROM "supervisors"; 
     51524DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51525success! 
     51526DELETE FROM "streets"; 
     51527DELETE FROM sqlite_sequence WHERE name='streets' 
     51528success! 
     51529DELETE FROM "crew"; 
     51530DELETE FROM sqlite_sequence WHERE name='crew' 
     51531success! 
     51532DELETE FROM "supervisors"; 
     51533DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51534success! 
     51535DELETE FROM "streets"; 
     51536DELETE FROM sqlite_sequence WHERE name='streets' 
     51537success! 
     51538DELETE FROM "crew"; 
     51539DELETE FROM sqlite_sequence WHERE name='crew' 
     51540success! 
     51541DELETE FROM "supervisors"; 
     51542DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51543success! 
     51544DELETE FROM "streets"; 
     51545DELETE FROM sqlite_sequence WHERE name='streets' 
     51546success! 
     51547DELETE FROM "crew"; 
     51548DELETE FROM sqlite_sequence WHERE name='crew' 
     51549success! 
     51550DELETE FROM "supervisors"; 
     51551DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51552success! 
     51553DELETE FROM "streets"; 
     51554DELETE FROM sqlite_sequence WHERE name='streets' 
     51555success! 
     51556DELETE FROM "crew"; 
     51557DELETE FROM sqlite_sequence WHERE name='crew' 
     51558success! 
     51559DELETE FROM "supervisors"; 
     51560DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51561success! 
     51562DELETE FROM "streets"; 
     51563DELETE FROM sqlite_sequence WHERE name='streets' 
     51564success! 
     51565DELETE FROM "crew"; 
     51566DELETE FROM sqlite_sequence WHERE name='crew' 
     51567success! 
     51568DELETE FROM "supervisors"; 
     51569DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51570success! 
     51571DELETE FROM "streets"; 
     51572DELETE FROM sqlite_sequence WHERE name='streets' 
     51573success! 
     51574DELETE FROM "crew"; 
     51575DELETE FROM sqlite_sequence WHERE name='crew' 
     51576success! 
     51577DELETE FROM "supervisors"; 
     51578DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51579success! 
     51580DELETE FROM "streets"; 
     51581DELETE FROM sqlite_sequence WHERE name='streets' 
     51582success! 
     51583DELETE FROM "crew"; 
     51584DELETE FROM sqlite_sequence WHERE name='crew' 
     51585success! 
     51586DELETE FROM "supervisors"; 
     51587DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51588success! 
     51589DELETE FROM "streets"; 
     51590DELETE FROM sqlite_sequence WHERE name='streets' 
     51591success! 
     51592DELETE FROM "crew"; 
     51593DELETE FROM sqlite_sequence WHERE name='crew' 
     51594success! 
     51595DELETE FROM "supervisors"; 
     51596DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51597success! 
     51598DELETE FROM "streets"; 
     51599DELETE FROM sqlite_sequence WHERE name='streets' 
     51600success! 
     51601DELETE FROM "crew"; 
     51602DELETE FROM sqlite_sequence WHERE name='crew' 
     51603success! 
     51604DELETE FROM "supervisors"; 
     51605DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51606success! 
     51607DELETE FROM "streets"; 
     51608DELETE FROM sqlite_sequence WHERE name='streets' 
     51609success! 
     51610DELETE FROM "crew"; 
     51611DELETE FROM sqlite_sequence WHERE name='crew' 
     51612success! 
     51613DELETE FROM "supervisors"; 
     51614DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51615success! 
     51616DELETE FROM "streets"; 
     51617DELETE FROM sqlite_sequence WHERE name='streets' 
     51618success! 
     51619DELETE FROM "crew"; 
     51620DELETE FROM sqlite_sequence WHERE name='crew' 
     51621success! 
     51622DELETE FROM "supervisors"; 
     51623DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51624success! 
     51625DELETE FROM "streets"; 
     51626DELETE FROM sqlite_sequence WHERE name='streets' 
     51627success! 
     51628DELETE FROM "crew"; 
     51629DELETE FROM sqlite_sequence WHERE name='crew' 
     51630success! 
     51631DELETE FROM "supervisors"; 
     51632DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51633success! 
     51634DELETE FROM "streets"; 
     51635DELETE FROM sqlite_sequence WHERE name='streets' 
     51636success! 
     51637DELETE FROM "crew"; 
     51638DELETE FROM sqlite_sequence WHERE name='crew' 
     51639success! 
     51640DELETE FROM "supervisors"; 
     51641DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51642success! 
     51643DELETE FROM "streets"; 
     51644DELETE FROM sqlite_sequence WHERE name='streets' 
     51645success! 
     51646DELETE FROM "crew"; 
     51647DELETE FROM sqlite_sequence WHERE name='crew' 
     51648success! 
     51649DELETE FROM "supervisors"; 
     51650DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51651success! 
     51652DELETE FROM "streets"; 
     51653DELETE FROM sqlite_sequence WHERE name='streets' 
     51654success! 
     51655DELETE FROM "crew"; 
     51656DELETE FROM sqlite_sequence WHERE name='crew' 
     51657success! 
     51658DELETE FROM "supervisors"; 
     51659DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51660success! 
     51661DELETE FROM "streets"; 
     51662DELETE FROM sqlite_sequence WHERE name='streets' 
     51663success! 
     51664DELETE FROM "crew"; 
     51665DELETE FROM sqlite_sequence WHERE name='crew' 
     51666success! 
     51667DELETE FROM "supervisors"; 
     51668DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51669success! 
     51670DELETE FROM "streets"; 
     51671DELETE FROM sqlite_sequence WHERE name='streets' 
     51672success! 
     51673DELETE FROM "crew"; 
     51674DELETE FROM sqlite_sequence WHERE name='crew' 
     51675success! 
     51676DELETE FROM "supervisors"; 
     51677DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51678success! 
     51679DELETE FROM "streets"; 
     51680DELETE FROM sqlite_sequence WHERE name='streets' 
     51681success! 
     51682DELETE FROM "crew"; 
     51683DELETE FROM sqlite_sequence WHERE name='crew' 
     51684success! 
     51685DELETE FROM "supervisors"; 
     51686DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51687success! 
     51688DELETE FROM "streets"; 
     51689DELETE FROM sqlite_sequence WHERE name='streets' 
     51690success! 
     51691DELETE FROM "crew"; 
     51692DELETE FROM sqlite_sequence WHERE name='crew' 
     51693success! 
     51694DELETE FROM "supervisors"; 
     51695DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51696success! 
     51697DELETE FROM "streets"; 
     51698DELETE FROM sqlite_sequence WHERE name='streets' 
     51699success! 
     51700DELETE FROM "crew"; 
     51701DELETE FROM sqlite_sequence WHERE name='crew' 
     51702success! 
     51703DELETE FROM "supervisors"; 
     51704DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51705success! 
     51706DELETE FROM "streets"; 
     51707DELETE FROM sqlite_sequence WHERE name='streets' 
     51708success! 
     51709DELETE FROM "crew"; 
     51710DELETE FROM sqlite_sequence WHERE name='crew' 
     51711success! 
     51712DELETE FROM "supervisors"; 
     51713DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51714success! 
     51715DELETE FROM "streets"; 
     51716DELETE FROM sqlite_sequence WHERE name='streets' 
     51717success! 
     51718DELETE FROM "crew"; 
     51719DELETE FROM sqlite_sequence WHERE name='crew' 
     51720success! 
     51721DELETE FROM "supervisors"; 
     51722DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51723success! 
     51724DELETE FROM "streets"; 
     51725DELETE FROM sqlite_sequence WHERE name='streets' 
     51726success! 
     51727DELETE FROM "crew"; 
     51728DELETE FROM sqlite_sequence WHERE name='crew' 
     51729success! 
     51730DELETE FROM "supervisors"; 
     51731DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51732success! 
     51733DELETE FROM "streets"; 
     51734DELETE FROM sqlite_sequence WHERE name='streets' 
     51735success! 
     51736DELETE FROM "crew"; 
     51737DELETE FROM sqlite_sequence WHERE name='crew' 
     51738success! 
     51739DELETE FROM "supervisors"; 
     51740DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51741success! 
     51742DELETE FROM "streets"; 
     51743DELETE FROM sqlite_sequence WHERE name='streets' 
     51744success! 
     51745DELETE FROM "crew"; 
     51746DELETE FROM sqlite_sequence WHERE name='crew' 
     51747success! 
     51748DELETE FROM "supervisors"; 
     51749DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51750success! 
     51751DELETE FROM "streets"; 
     51752DELETE FROM sqlite_sequence WHERE name='streets' 
     51753success! 
     51754DELETE FROM "crew"; 
     51755DELETE FROM sqlite_sequence WHERE name='crew' 
     51756success! 
     51757DELETE FROM "supervisors"; 
     51758DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51759success! 
     51760DELETE FROM "streets"; 
     51761DELETE FROM sqlite_sequence WHERE name='streets' 
     51762success! 
     51763DELETE FROM "crew"; 
     51764DELETE FROM sqlite_sequence WHERE name='crew' 
     51765success! 
     51766DELETE FROM "supervisors"; 
     51767DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51768success! 
     51769DELETE FROM "streets"; 
     51770DELETE FROM sqlite_sequence WHERE name='streets' 
     51771success! 
     51772DELETE FROM "crew"; 
     51773DELETE FROM sqlite_sequence WHERE name='crew' 
     51774success! 
     51775DELETE FROM "supervisors"; 
     51776DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51777success! 
     51778DELETE FROM "streets"; 
     51779DELETE FROM sqlite_sequence WHERE name='streets' 
     51780success! 
     51781DELETE FROM "crew"; 
     51782DELETE FROM sqlite_sequence WHERE name='crew' 
     51783success! 
     51784DELETE FROM "supervisors"; 
     51785DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51786success! 
     51787DELETE FROM "streets"; 
     51788DELETE FROM sqlite_sequence WHERE name='streets' 
     51789success! 
     51790DELETE FROM "crew"; 
     51791DELETE FROM sqlite_sequence WHERE name='crew' 
     51792success! 
     51793DELETE FROM "supervisors"; 
     51794DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51795success! 
     51796DELETE FROM "streets"; 
     51797DELETE FROM sqlite_sequence WHERE name='streets' 
     51798success! 
     51799DELETE FROM "crew"; 
     51800DELETE FROM sqlite_sequence WHERE name='crew' 
     51801success! 
     51802DELETE FROM "supervisors"; 
     51803DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51804success! 
     51805DELETE FROM "streets"; 
     51806DELETE FROM sqlite_sequence WHERE name='streets' 
     51807success! 
     51808DELETE FROM "crew"; 
     51809DELETE FROM sqlite_sequence WHERE name='crew' 
     51810success! 
     51811DELETE FROM "supervisors"; 
     51812DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51813success! 
     51814DELETE FROM "streets"; 
     51815DELETE FROM sqlite_sequence WHERE name='streets' 
     51816success! 
     51817DELETE FROM "crew"; 
     51818DELETE FROM sqlite_sequence WHERE name='crew' 
     51819success! 
     51820DELETE FROM "supervisors"; 
     51821DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51822success! 
     51823DELETE FROM "streets"; 
     51824DELETE FROM sqlite_sequence WHERE name='streets' 
     51825success! 
     51826DELETE FROM "crew"; 
     51827DELETE FROM sqlite_sequence WHERE name='crew' 
     51828success! 
     51829DELETE FROM "supervisors"; 
     51830DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51831success! 
     51832DELETE FROM "streets"; 
     51833DELETE FROM sqlite_sequence WHERE name='streets' 
     51834success! 
     51835DELETE FROM "crew"; 
     51836DELETE FROM sqlite_sequence WHERE name='crew' 
     51837success! 
     51838DELETE FROM "supervisors"; 
     51839DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51840success! 
     51841DELETE FROM "streets"; 
     51842DELETE FROM sqlite_sequence WHERE name='streets' 
     51843success! 
     51844DELETE FROM "crew"; 
     51845DELETE FROM sqlite_sequence WHERE name='crew' 
     51846success! 
     51847DELETE FROM "supervisors"; 
     51848DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51849success! 
     51850DELETE FROM "streets"; 
     51851DELETE FROM sqlite_sequence WHERE name='streets' 
     51852success! 
     51853DELETE FROM "crew"; 
     51854DELETE FROM sqlite_sequence WHERE name='crew' 
     51855success! 
     51856DELETE FROM "supervisors"; 
     51857DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51858success! 
     51859DELETE FROM "streets"; 
     51860DELETE FROM sqlite_sequence WHERE name='streets' 
     51861success! 
     51862DELETE FROM "crew"; 
     51863DELETE FROM sqlite_sequence WHERE name='crew' 
     51864success! 
     51865DELETE FROM "supervisors"; 
     51866DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51867success! 
     51868DELETE FROM "streets"; 
     51869DELETE FROM sqlite_sequence WHERE name='streets' 
     51870success! 
     51871DELETE FROM "crew"; 
     51872DELETE FROM sqlite_sequence WHERE name='crew' 
     51873success! 
     51874DELETE FROM "supervisors"; 
     51875DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51876success! 
     51877DELETE FROM "streets"; 
     51878DELETE FROM sqlite_sequence WHERE name='streets' 
     51879success! 
     51880DELETE FROM "crew"; 
     51881DELETE FROM sqlite_sequence WHERE name='crew' 
     51882success! 
     51883DELETE FROM "supervisors"; 
     51884DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51885success! 
     51886DELETE FROM "streets"; 
     51887DELETE FROM sqlite_sequence WHERE name='streets' 
     51888success! 
     51889DELETE FROM "crew"; 
     51890DELETE FROM sqlite_sequence WHERE name='crew' 
     51891success! 
     51892DELETE FROM "supervisors"; 
     51893DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51894success! 
     51895DELETE FROM "streets"; 
     51896DELETE FROM sqlite_sequence WHERE name='streets' 
     51897success! 
     51898DELETE FROM "crew"; 
     51899DELETE FROM sqlite_sequence WHERE name='crew' 
     51900success! 
     51901DELETE FROM "supervisors"; 
     51902DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51903success! 
     51904DELETE FROM "streets"; 
     51905DELETE FROM sqlite_sequence WHERE name='streets' 
     51906success! 
     51907DELETE FROM "crew"; 
     51908DELETE FROM sqlite_sequence WHERE name='crew' 
     51909success! 
     51910DELETE FROM "supervisors"; 
     51911DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51912success! 
     51913DELETE FROM "streets"; 
     51914DELETE FROM sqlite_sequence WHERE name='streets' 
     51915success! 
     51916DELETE FROM "crew"; 
     51917DELETE FROM sqlite_sequence WHERE name='crew' 
     51918success! 
     51919DELETE FROM "supervisors"; 
     51920DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51921success! 
     51922DELETE FROM "streets"; 
     51923DELETE FROM sqlite_sequence WHERE name='streets' 
     51924success! 
     51925DELETE FROM "crew"; 
     51926DELETE FROM sqlite_sequence WHERE name='crew' 
     51927success! 
     51928DELETE FROM "supervisors"; 
     51929DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51930success! 
     51931DELETE FROM "streets"; 
     51932DELETE FROM sqlite_sequence WHERE name='streets' 
     51933success! 
     51934DELETE FROM "crew"; 
     51935DELETE FROM sqlite_sequence WHERE name='crew' 
     51936success! 
     51937DELETE FROM "supervisors"; 
     51938DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51939success! 
     51940DELETE FROM "streets"; 
     51941DELETE FROM sqlite_sequence WHERE name='streets' 
     51942success! 
     51943DELETE FROM "crew"; 
     51944DELETE FROM sqlite_sequence WHERE name='crew' 
     51945success! 
     51946DELETE FROM "supervisors"; 
     51947DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51948success! 
     51949DELETE FROM "streets"; 
     51950DELETE FROM sqlite_sequence WHERE name='streets' 
     51951success! 
     51952DELETE FROM "crew"; 
     51953DELETE FROM sqlite_sequence WHERE name='crew' 
     51954success! 
     51955DELETE FROM "supervisors"; 
     51956DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51957success! 
     51958DELETE FROM "streets"; 
     51959DELETE FROM sqlite_sequence WHERE name='streets' 
     51960success! 
     51961DELETE FROM "crew"; 
     51962DELETE FROM sqlite_sequence WHERE name='crew' 
     51963success! 
     51964DELETE FROM "supervisors"; 
     51965DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51966success! 
     51967DELETE FROM "streets"; 
     51968DELETE FROM sqlite_sequence WHERE name='streets' 
     51969success! 
     51970DELETE FROM "crew"; 
     51971DELETE FROM sqlite_sequence WHERE name='crew' 
     51972success! 
     51973DELETE FROM "supervisors"; 
     51974DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51975success! 
     51976DELETE FROM "streets"; 
     51977DELETE FROM sqlite_sequence WHERE name='streets' 
     51978success! 
     51979DELETE FROM "crew"; 
     51980DELETE FROM sqlite_sequence WHERE name='crew' 
     51981success! 
     51982DELETE FROM "supervisors"; 
     51983DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51984success! 
     51985DELETE FROM "streets"; 
     51986DELETE FROM sqlite_sequence WHERE name='streets' 
     51987success! 
     51988DELETE FROM "crew"; 
     51989DELETE FROM sqlite_sequence WHERE name='crew' 
     51990success! 
     51991DELETE FROM "supervisors"; 
     51992DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51993success! 
     51994DELETE FROM "streets"; 
     51995DELETE FROM sqlite_sequence WHERE name='streets' 
     51996success! 
     51997DELETE FROM "crew"; 
     51998DELETE FROM sqlite_sequence WHERE name='crew' 
     51999success! 
     52000DELETE FROM "supervisors"; 
     52001DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52002success! 
     52003DELETE FROM "streets"; 
     52004DELETE FROM sqlite_sequence WHERE name='streets' 
     52005success! 
     52006DELETE FROM "crew"; 
     52007DELETE FROM sqlite_sequence WHERE name='crew' 
     52008success! 
     52009DELETE FROM "supervisors"; 
     52010DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52011success! 
     52012DELETE FROM "streets"; 
     52013DELETE FROM sqlite_sequence WHERE name='streets' 
     52014success! 
     52015DELETE FROM "crew"; 
     52016DELETE FROM sqlite_sequence WHERE name='crew' 
     52017success! 
     52018DELETE FROM "supervisors"; 
     52019DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52020success! 
     52021DELETE FROM "streets"; 
     52022DELETE FROM sqlite_sequence WHERE name='streets' 
     52023success! 
     52024DELETE FROM "crew"; 
     52025DELETE FROM sqlite_sequence WHERE name='crew' 
     52026success! 
     52027DELETE FROM "supervisors"; 
     52028DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52029success! 
     52030DELETE FROM "streets"; 
     52031DELETE FROM sqlite_sequence WHERE name='streets' 
     52032success! 
     52033DELETE FROM "crew"; 
     52034DELETE FROM sqlite_sequence WHERE name='crew' 
     52035success! 
     52036DELETE FROM "supervisors"; 
     52037DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52038success! 
     52039DELETE FROM "streets"; 
     52040DELETE FROM sqlite_sequence WHERE name='streets' 
     52041success! 
     52042DELETE FROM "crew"; 
     52043DELETE FROM sqlite_sequence WHERE name='crew' 
     52044success! 
     52045DELETE FROM "supervisors"; 
     52046DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52047success! 
     52048DELETE FROM "streets"; 
     52049DELETE FROM sqlite_sequence WHERE name='streets' 
     52050success! 
     52051DELETE FROM "crew"; 
     52052DELETE FROM sqlite_sequence WHERE name='crew' 
     52053success! 
     52054DELETE FROM "supervisors"; 
     52055DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52056success! 
     52057DELETE FROM "streets"; 
     52058DELETE FROM sqlite_sequence WHERE name='streets' 
     52059success! 
     52060DELETE FROM "crew"; 
     52061DELETE FROM sqlite_sequence WHERE name='crew' 
     52062success! 
     52063DELETE FROM "supervisors"; 
     52064DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52065success! 
     52066DELETE FROM "streets"; 
     52067DELETE FROM sqlite_sequence WHERE name='streets' 
     52068success! 
     52069DELETE FROM "crew"; 
     52070DELETE FROM sqlite_sequence WHERE name='crew' 
     52071success! 
     52072DELETE FROM "supervisors"; 
     52073DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52074success! 
     52075DELETE FROM "streets"; 
     52076DELETE FROM sqlite_sequence WHERE name='streets' 
     52077success! 
     52078DELETE FROM "crew"; 
     52079DELETE FROM sqlite_sequence WHERE name='crew' 
     52080success! 
     52081DELETE FROM "supervisors"; 
     52082DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52083success! 
     52084DELETE FROM "streets"; 
     52085DELETE FROM sqlite_sequence WHERE name='streets' 
     52086success! 
     52087DELETE FROM "crew"; 
     52088DELETE FROM sqlite_sequence WHERE name='crew' 
     52089success! 
     52090DELETE FROM "supervisors"; 
     52091DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52092success! 
     52093DELETE FROM "streets"; 
     52094DELETE FROM sqlite_sequence WHERE name='streets' 
     52095success! 
     52096DELETE FROM "crew"; 
     52097DELETE FROM sqlite_sequence WHERE name='crew' 
     52098success! 
     52099DELETE FROM "supervisors"; 
     52100DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52101success! 
     52102DELETE FROM "streets"; 
     52103DELETE FROM sqlite_sequence WHERE name='streets' 
     52104success! 
     52105DELETE FROM "crew"; 
     52106DELETE FROM sqlite_sequence WHERE name='crew' 
     52107success! 
     52108DELETE FROM "supervisors"; 
     52109DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52110success! 
     52111DELETE FROM "streets"; 
     52112DELETE FROM sqlite_sequence WHERE name='streets' 
     52113success! 
     52114DELETE FROM "crew"; 
     52115DELETE FROM sqlite_sequence WHERE name='crew' 
     52116success! 
     52117DELETE FROM "supervisors"; 
     52118DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52119success! 
     52120DELETE FROM "streets"; 
     52121DELETE FROM sqlite_sequence WHERE name='streets' 
     52122success! 
     52123DELETE FROM "crew"; 
     52124DELETE FROM sqlite_sequence WHERE name='crew' 
     52125success! 
     52126DELETE FROM "supervisors"; 
     52127DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52128success! 
     52129DELETE FROM "streets"; 
     52130DELETE FROM sqlite_sequence WHERE name='streets' 
     52131success! 
     52132DELETE FROM "crew"; 
     52133DELETE FROM sqlite_sequence WHERE name='crew' 
     52134success! 
     52135DELETE FROM "supervisors"; 
     52136DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52137success! 
     52138DELETE FROM "streets"; 
     52139DELETE FROM sqlite_sequence WHERE name='streets' 
     52140success! 
     52141DELETE FROM "crew"; 
     52142DELETE FROM sqlite_sequence WHERE name='crew' 
     52143success! 
     52144DELETE FROM "supervisors"; 
     52145DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52146success! 
     52147DELETE FROM "streets"; 
     52148DELETE FROM sqlite_sequence WHERE name='streets' 
     52149success! 
     52150DELETE FROM "crew"; 
     52151DELETE FROM sqlite_sequence WHERE name='crew' 
     52152success! 
     52153DELETE FROM "supervisors"; 
     52154DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52155success! 
     52156DELETE FROM "streets"; 
     52157DELETE FROM sqlite_sequence WHERE name='streets' 
     52158success! 
     52159DELETE FROM "crew"; 
     52160DELETE FROM sqlite_sequence WHERE name='crew' 
     52161success! 
     52162DELETE FROM "supervisors"; 
     52163DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52164success! 
     52165DELETE FROM "streets"; 
     52166DELETE FROM sqlite_sequence WHERE name='streets' 
     52167success! 
     52168DELETE FROM "crew"; 
     52169DELETE FROM sqlite_sequence WHERE name='crew' 
     52170success! 
     52171DELETE FROM "supervisors"; 
     52172DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52173success! 
     52174DELETE FROM "streets"; 
     52175DELETE FROM sqlite_sequence WHERE name='streets' 
     52176success! 
     52177DELETE FROM "crew"; 
     52178DELETE FROM sqlite_sequence WHERE name='crew' 
     52179success! 
     52180DELETE FROM "supervisors"; 
     52181DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52182success! 
     52183DELETE FROM "streets"; 
     52184DELETE FROM sqlite_sequence WHERE name='streets' 
     52185success! 
     52186DELETE FROM "crew"; 
     52187DELETE FROM sqlite_sequence WHERE name='crew' 
     52188success! 
     52189DELETE FROM "supervisors"; 
     52190DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52191success! 
     52192DELETE FROM "streets"; 
     52193DELETE FROM sqlite_sequence WHERE name='streets' 
     52194success! 
     52195DELETE FROM "crew"; 
     52196DELETE FROM sqlite_sequence WHERE name='crew' 
     52197success! 
     52198DELETE FROM "supervisors"; 
     52199DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52200success! 
     52201DELETE FROM "streets"; 
     52202DELETE FROM sqlite_sequence WHERE name='streets' 
     52203success! 
     52204DELETE FROM "crew"; 
     52205DELETE FROM sqlite_sequence WHERE name='crew' 
     52206success! 
     52207DELETE FROM "supervisors"; 
     52208DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52209success! 
     52210DELETE FROM "streets"; 
     52211DELETE FROM sqlite_sequence WHERE name='streets' 
     52212success! 
     52213DELETE FROM "crew"; 
     52214DELETE FROM sqlite_sequence WHERE name='crew' 
     52215success! 
     52216DELETE FROM "supervisors"; 
     52217DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52218success! 
     52219DELETE FROM "streets"; 
     52220DELETE FROM sqlite_sequence WHERE name='streets' 
     52221success! 
     52222DELETE FROM "crew"; 
     52223DELETE FROM sqlite_sequence WHERE name='crew' 
     52224success! 
     52225DELETE FROM "supervisors"; 
     52226DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52227success! 
     52228DELETE FROM "streets"; 
     52229DELETE FROM sqlite_sequence WHERE name='streets' 
     52230success! 
     52231DELETE FROM "crew"; 
     52232DELETE FROM sqlite_sequence WHERE name='crew' 
     52233success! 
     52234DELETE FROM "supervisors"; 
     52235DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52236success! 
     52237DELETE FROM "streets"; 
     52238DELETE FROM sqlite_sequence WHERE name='streets' 
     52239success! 
     52240DELETE FROM "crew"; 
     52241DELETE FROM sqlite_sequence WHERE name='crew' 
     52242success! 
     52243DELETE FROM "supervisors"; 
     52244DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52245success! 
     52246DELETE FROM "streets"; 
     52247DELETE FROM sqlite_sequence WHERE name='streets' 
     52248success! 
     52249DELETE FROM "crew"; 
     52250DELETE FROM sqlite_sequence WHERE name='crew' 
     52251success! 
     52252DELETE FROM "supervisors"; 
     52253DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52254success! 
     52255DELETE FROM "streets"; 
     52256DELETE FROM sqlite_sequence WHERE name='streets' 
     52257success! 
     52258DELETE FROM "crew"; 
     52259DELETE FROM sqlite_sequence WHERE name='crew' 
     52260success! 
     52261DELETE FROM "supervisors"; 
     52262DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52263success! 
     52264DELETE FROM "streets"; 
     52265DELETE FROM sqlite_sequence WHERE name='streets' 
     52266success! 
     52267DELETE FROM "crew"; 
     52268DELETE FROM sqlite_sequence WHERE name='crew' 
     52269success! 
     52270DELETE FROM "supervisors"; 
     52271DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52272success! 
     52273DELETE FROM "streets"; 
     52274DELETE FROM sqlite_sequence WHERE name='streets' 
     52275success! 
     52276DELETE FROM "crew"; 
     52277DELETE FROM sqlite_sequence WHERE name='crew' 
     52278success! 
     52279DELETE FROM "supervisors"; 
     52280DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52281success! 
     52282DELETE FROM "streets"; 
     52283DELETE FROM sqlite_sequence WHERE name='streets' 
     52284success! 
     52285DELETE FROM "crew"; 
     52286DELETE FROM sqlite_sequence WHERE name='crew' 
     52287success! 
     52288DELETE FROM "supervisors"; 
     52289DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52290success! 
     52291DELETE FROM "streets"; 
     52292DELETE FROM sqlite_sequence WHERE name='streets' 
     52293success! 
     52294DELETE FROM "crew"; 
     52295DELETE FROM sqlite_sequence WHERE name='crew' 
     52296success! 
     52297DELETE FROM "supervisors"; 
     52298DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52299success! 
     52300DELETE FROM "streets"; 
     52301DELETE FROM sqlite_sequence WHERE name='streets' 
     52302success! 
     52303DELETE FROM "crew"; 
     52304DELETE FROM sqlite_sequence WHERE name='crew' 
     52305success! 
     52306DELETE FROM "supervisors"; 
     52307DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52308success! 
     52309DELETE FROM "streets"; 
     52310DELETE FROM sqlite_sequence WHERE name='streets' 
     52311success! 
     52312DELETE FROM "crew"; 
     52313DELETE FROM sqlite_sequence WHERE name='crew' 
     52314success! 
     52315DELETE FROM "supervisors"; 
     52316DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52317success! 
     52318DELETE FROM "streets"; 
     52319DELETE FROM sqlite_sequence WHERE name='streets' 
     52320success! 
     52321DELETE FROM "crew"; 
     52322DELETE FROM sqlite_sequence WHERE name='crew' 
     52323success! 
     52324DELETE FROM "supervisors"; 
     52325DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52326success! 
     52327DELETE FROM "streets"; 
     52328DELETE FROM sqlite_sequence WHERE name='streets' 
     52329success! 
     52330DELETE FROM "crew"; 
     52331DELETE FROM sqlite_sequence WHERE name='crew' 
     52332success! 
     52333DELETE FROM "supervisors"; 
     52334DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52335success! 
     52336DELETE FROM "streets"; 
     52337DELETE FROM sqlite_sequence WHERE name='streets' 
     52338success! 
     52339DELETE FROM "crew"; 
     52340DELETE FROM sqlite_sequence WHERE name='crew' 
     52341success! 
     52342DELETE FROM "supervisors"; 
     52343DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52344success! 
     52345DELETE FROM "streets"; 
     52346DELETE FROM sqlite_sequence WHERE name='streets' 
     52347success! 
     52348DELETE FROM "crew"; 
     52349DELETE FROM sqlite_sequence WHERE name='crew' 
     52350success! 
     52351DELETE FROM "supervisors"; 
     52352DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52353success! 
     52354DELETE FROM "streets"; 
     52355DELETE FROM sqlite_sequence WHERE name='streets' 
     52356success! 
     52357DELETE FROM "crew"; 
     52358DELETE FROM sqlite_sequence WHERE name='crew' 
     52359success! 
     52360DELETE FROM "supervisors"; 
     52361DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52362success! 
     52363DELETE FROM "streets"; 
     52364DELETE FROM sqlite_sequence WHERE name='streets' 
     52365success! 
     52366DELETE FROM "crew"; 
     52367DELETE FROM sqlite_sequence WHERE name='crew' 
     52368success! 
     52369DELETE FROM "supervisors"; 
     52370DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52371success! 
     52372DELETE FROM "streets"; 
     52373DELETE FROM sqlite_sequence WHERE name='streets' 
     52374success! 
     52375DELETE FROM "crew"; 
     52376DELETE FROM sqlite_sequence WHERE name='crew' 
     52377success! 
     52378DELETE FROM "supervisors"; 
     52379DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52380success! 
     52381DELETE FROM "streets"; 
     52382DELETE FROM sqlite_sequence WHERE name='streets' 
     52383success! 
     52384DELETE FROM "crew"; 
     52385DELETE FROM sqlite_sequence WHERE name='crew' 
     52386success! 
     52387DELETE FROM "supervisors"; 
     52388DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52389success! 
     52390DELETE FROM "streets"; 
     52391DELETE FROM sqlite_sequence WHERE name='streets' 
     52392success! 
     52393DELETE FROM "crew"; 
     52394DELETE FROM sqlite_sequence WHERE name='crew' 
     52395success! 
     52396DELETE FROM "supervisors"; 
     52397DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52398success! 
     52399DELETE FROM "streets"; 
     52400DELETE FROM sqlite_sequence WHERE name='streets' 
     52401success! 
     52402DELETE FROM "crew"; 
     52403DELETE FROM sqlite_sequence WHERE name='crew' 
     52404success! 
     52405DELETE FROM "supervisors"; 
     52406DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52407success! 
     52408DELETE FROM "streets"; 
     52409DELETE FROM sqlite_sequence WHERE name='streets' 
     52410success! 
     52411DELETE FROM "crew"; 
     52412DELETE FROM sqlite_sequence WHERE name='crew' 
     52413success! 
     52414DELETE FROM "supervisors"; 
     52415DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52416success! 
     52417DELETE FROM "streets"; 
     52418DELETE FROM sqlite_sequence WHERE name='streets' 
     52419success! 
     52420DELETE FROM "crew"; 
     52421DELETE FROM sqlite_sequence WHERE name='crew' 
     52422success! 
     52423DELETE FROM "supervisors"; 
     52424DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52425success! 
     52426DELETE FROM "streets"; 
     52427DELETE FROM sqlite_sequence WHERE name='streets' 
     52428success! 
     52429DELETE FROM "crew"; 
     52430DELETE FROM sqlite_sequence WHERE name='crew' 
     52431success! 
     52432DELETE FROM "supervisors"; 
     52433DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52434success! 
     52435DELETE FROM "streets"; 
     52436DELETE FROM sqlite_sequence WHERE name='streets' 
     52437success! 
     52438DELETE FROM "crew"; 
     52439DELETE FROM sqlite_sequence WHERE name='crew' 
     52440success! 
     52441DELETE FROM "supervisors"; 
     52442DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52443success! 
     52444DELETE FROM "streets"; 
     52445DELETE FROM sqlite_sequence WHERE name='streets' 
     52446success! 
     52447DELETE FROM "crew"; 
     52448DELETE FROM sqlite_sequence WHERE name='crew' 
     52449success! 
     52450DELETE FROM "supervisors"; 
     52451DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52452success! 
     52453DELETE FROM "streets"; 
     52454DELETE FROM sqlite_sequence WHERE name='streets' 
     52455success! 
     52456DELETE FROM "crew"; 
     52457DELETE FROM sqlite_sequence WHERE name='crew' 
     52458success! 
     52459DELETE FROM "supervisors"; 
     52460DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52461success! 
     52462DELETE FROM "streets"; 
     52463DELETE FROM sqlite_sequence WHERE name='streets' 
     52464success! 
     52465DELETE FROM "crew"; 
     52466DELETE FROM sqlite_sequence WHERE name='crew' 
     52467success! 
     52468DELETE FROM "supervisors"; 
     52469DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52470success! 
     52471DELETE FROM "streets"; 
     52472DELETE FROM sqlite_sequence WHERE name='streets' 
     52473success! 
     52474DELETE FROM "crew"; 
     52475DELETE FROM sqlite_sequence WHERE name='crew' 
     52476success! 
     52477DELETE FROM "supervisors"; 
     52478DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52479success! 
     52480DELETE FROM "streets"; 
     52481DELETE FROM sqlite_sequence WHERE name='streets' 
     52482success! 
     52483DELETE FROM "crew"; 
     52484DELETE FROM sqlite_sequence WHERE name='crew' 
     52485success! 
     52486DELETE FROM "supervisors"; 
     52487DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52488success! 
     52489DELETE FROM "streets"; 
     52490DELETE FROM sqlite_sequence WHERE name='streets' 
     52491success! 
     52492DELETE FROM "crew"; 
     52493DELETE FROM sqlite_sequence WHERE name='crew' 
     52494success! 
     52495DELETE FROM "supervisors"; 
     52496DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52497success! 
     52498DELETE FROM "streets"; 
     52499DELETE FROM sqlite_sequence WHERE name='streets' 
     52500success! 
     52501DELETE FROM "crew"; 
     52502DELETE FROM sqlite_sequence WHERE name='crew' 
     52503success! 
     52504DELETE FROM "supervisors"; 
     52505DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52506success! 
     52507DELETE FROM "streets"; 
     52508DELETE FROM sqlite_sequence WHERE name='streets' 
     52509success! 
     52510DELETE FROM "crew"; 
     52511DELETE FROM sqlite_sequence WHERE name='crew' 
     52512success! 
     52513DELETE FROM "supervisors"; 
     52514DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52515success! 
     52516DELETE FROM "streets"; 
     52517DELETE FROM sqlite_sequence WHERE name='streets' 
     52518success! 
     52519DELETE FROM "crew"; 
     52520DELETE FROM sqlite_sequence WHERE name='crew' 
     52521success! 
     52522DELETE FROM "supervisors"; 
     52523DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52524success! 
     52525DELETE FROM "streets"; 
     52526DELETE FROM sqlite_sequence WHERE name='streets' 
     52527success! 
     52528DELETE FROM "crew"; 
     52529DELETE FROM sqlite_sequence WHERE name='crew' 
     52530success! 
     52531DELETE FROM "supervisors"; 
     52532DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52533success! 
     52534DELETE FROM "streets"; 
     52535DELETE FROM sqlite_sequence WHERE name='streets' 
     52536success! 
     52537DELETE FROM "crew"; 
     52538DELETE FROM sqlite_sequence WHERE name='crew' 
     52539success! 
     52540DELETE FROM "supervisors"; 
     52541DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52542success! 
     52543DELETE FROM "streets"; 
     52544DELETE FROM sqlite_sequence WHERE name='streets' 
     52545success! 
     52546DELETE FROM "crew"; 
     52547DELETE FROM sqlite_sequence WHERE name='crew' 
     52548success! 
     52549DELETE FROM "supervisors"; 
     52550DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52551success! 
     52552DELETE FROM "streets"; 
     52553DELETE FROM sqlite_sequence WHERE name='streets' 
     52554success! 
     52555DELETE FROM "crew"; 
     52556DELETE FROM sqlite_sequence WHERE name='crew' 
     52557success! 
     52558DELETE FROM "supervisors"; 
     52559DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52560success! 
     52561DELETE FROM "streets"; 
     52562DELETE FROM sqlite_sequence WHERE name='streets' 
     52563success! 
     52564DELETE FROM "crew"; 
     52565DELETE FROM sqlite_sequence WHERE name='crew' 
     52566success! 
     52567DELETE FROM "supervisors"; 
     52568DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52569success! 
     52570DELETE FROM "streets"; 
     52571DELETE FROM sqlite_sequence WHERE name='streets' 
     52572success! 
     52573DELETE FROM "crew"; 
     52574DELETE FROM sqlite_sequence WHERE name='crew' 
     52575success! 
     52576DELETE FROM "supervisors"; 
     52577DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52578success! 
     52579DELETE FROM "streets"; 
     52580DELETE FROM sqlite_sequence WHERE name='streets' 
     52581success! 
     52582DELETE FROM "crew"; 
     52583DELETE FROM sqlite_sequence WHERE name='crew' 
     52584success! 
     52585DELETE FROM "supervisors"; 
     52586DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52587success! 
     52588DELETE FROM "streets"; 
     52589DELETE FROM sqlite_sequence WHERE name='streets' 
     52590success! 
     52591DELETE FROM "crew"; 
     52592DELETE FROM sqlite_sequence WHERE name='crew' 
     52593success! 
     52594DELETE FROM "supervisors"; 
     52595DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52596success! 
     52597DELETE FROM "streets"; 
     52598DELETE FROM sqlite_sequence WHERE name='streets' 
     52599success! 
     52600DELETE FROM "crew"; 
     52601DELETE FROM sqlite_sequence WHERE name='crew' 
     52602success! 
     52603DELETE FROM "supervisors"; 
     52604DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52605success! 
     52606DELETE FROM "streets"; 
     52607DELETE FROM sqlite_sequence WHERE name='streets' 
     52608success! 
     52609DELETE FROM "crew"; 
     52610DELETE FROM sqlite_sequence WHERE name='crew' 
     52611success! 
     52612DELETE FROM "supervisors"; 
     52613DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52614success! 
     52615DELETE FROM "streets"; 
     52616DELETE FROM sqlite_sequence WHERE name='streets' 
     52617success! 
     52618DELETE FROM "crew"; 
     52619DELETE FROM sqlite_sequence WHERE name='crew' 
     52620success! 
     52621DELETE FROM "supervisors"; 
     52622DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52623success! 
     52624DELETE FROM "streets"; 
     52625DELETE FROM sqlite_sequence WHERE name='streets' 
     52626success! 
     52627DELETE FROM "crew"; 
     52628DELETE FROM sqlite_sequence WHERE name='crew' 
     52629success! 
     52630DELETE FROM "supervisors"; 
     52631DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52632success! 
     52633DELETE FROM "streets"; 
     52634DELETE FROM sqlite_sequence WHERE name='streets' 
     52635success! 
     52636DELETE FROM "crew"; 
     52637DELETE FROM sqlite_sequence WHERE name='crew' 
     52638success! 
     52639DELETE FROM "supervisors"; 
     52640DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52641success! 
     52642DELETE FROM "streets"; 
     52643DELETE FROM sqlite_sequence WHERE name='streets' 
     52644success! 
     52645DELETE FROM "crew"; 
     52646DELETE FROM sqlite_sequence WHERE name='crew' 
     52647success! 
     52648DELETE FROM "supervisors"; 
     52649DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52650success! 
     52651DELETE FROM "streets"; 
     52652DELETE FROM sqlite_sequence WHERE name='streets' 
     52653success! 
     52654DELETE FROM "crew"; 
     52655DELETE FROM sqlite_sequence WHERE name='crew' 
     52656success! 
     52657DELETE FROM "supervisors"; 
     52658DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52659success! 
     52660DELETE FROM "streets"; 
     52661DELETE FROM sqlite_sequence WHERE name='streets' 
     52662success! 
     52663DELETE FROM "crew"; 
     52664DELETE FROM sqlite_sequence WHERE name='crew' 
     52665success! 
     52666DELETE FROM "supervisors"; 
     52667DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52668success! 
     52669DELETE FROM "streets"; 
     52670DELETE FROM sqlite_sequence WHERE name='streets' 
     52671success! 
     52672DELETE FROM "crew"; 
     52673DELETE FROM sqlite_sequence WHERE name='crew' 
     52674success! 
     52675DELETE FROM "supervisors"; 
     52676DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52677success! 
     52678DELETE FROM "streets"; 
     52679DELETE FROM sqlite_sequence WHERE name='streets' 
     52680success! 
     52681DELETE FROM "crew"; 
     52682DELETE FROM sqlite_sequence WHERE name='crew' 
     52683success! 
     52684DELETE FROM "supervisors"; 
     52685DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52686success! 
     52687DELETE FROM "streets"; 
     52688DELETE FROM sqlite_sequence WHERE name='streets' 
     52689success! 
     52690DELETE FROM "crew"; 
     52691DELETE FROM sqlite_sequence WHERE name='crew' 
     52692success! 
     52693DELETE FROM "supervisors"; 
     52694DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52695success! 
     52696DELETE FROM "streets"; 
     52697DELETE FROM sqlite_sequence WHERE name='streets' 
     52698success! 
     52699DELETE FROM "crew"; 
     52700DELETE FROM sqlite_sequence WHERE name='crew' 
     52701success! 
     52702DELETE FROM "supervisors"; 
     52703DELETE FROM sqlite_sequence WHERE name='supervisors' 
     52704success! 
     52705DELETE FROM "streets"; 
     52706DELETE FROM sqlite_sequence WHERE name='streets' 
     52707success! 
     52708DELETE FROM "crew"; 
     52709DELETE FROM sqlite_sequence WHERE name='crew' 
     52710success! 
  • branches/LCSv2/progress.log

    r634 r641  
    13251325[2021-02-25 09:51:43] EDIT LCSv2/controllers/default.py: 0 
    13261326[2021-02-25 09:56:07] EDIT LCSv2/controllers/default.py: 0 
     1327[2021-03-08 12:32:44] EDIT LCSv2/controllers/default.py: 0 
     1328[2021-03-08 12:39:32] EDIT LCSv2/controllers/default.py: 0 
     1329[2021-03-08 12:49:02] EDIT LCSv2/controllers/default.py: 0 
     1330[2021-03-13 17:05:11] EDIT LCSv2/controllers/default.py: 13 
     1331[2021-03-13 17:06:08] EDIT LCSv2/controllers/default.py: 0 
     1332[2021-03-13 17:09:33] EDIT LCSv2/controllers/default.py: 1 
     1333[2021-03-13 17:13:37] EDIT LCSv2/views/default/help.html: 0 
  • branches/LCSv2/views/default/help.html

    r635 r641  
    33<div style="color: gray; text-align:center"> 
    44<HR> 
    5 Revision 2021.03.08 
     5Revision 2021.03.14 
    66</div> 
  • branches/LCSv2/views/default/help.html.bak

    r627 r641  
    33<div style="color: gray; text-align:center"> 
    44<HR> 
    5      
    6     LCS Revision 622 
     5Revision 2021.03.08 
    76</div> 
Note: See TracChangeset for help on using the changeset viewer.