Changeset 642 in tmcsimulator
- Timestamp:
- 03/15/2021 04:49:10 PM (5 years ago)
- Location:
- branches/LCSv2
- Files:
-
- 5 edited
-
controllers/default.py (modified) (3 diffs)
-
controllers/default.py.bak (modified) (4 diffs)
-
databases/sql.log (modified) (1 diff)
-
databases/storage.sqlite (modified) (previous)
-
progress.log (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
branches/LCSv2/controllers/default.py
r641 r642 1 1 # added comments for testing 2 2 # Constants 3 kLogfile = " LCSlogfile.txt"3 kLogfile = "../TMCrepo/trunk/webapps/dynamicdata/LCSlogfile.txt" 4 4 kSimtimefile = "sim_elapsedtime.json" #"../webapps/dynamicdata/sim_elapsed_time.json" 5 5 hwys = ['','1','5', '22', '55', '57', '73', '74', '91', '133', '142', '241', '261', '405', '605'] … … 198 198 db(db.closures.closureid == session.statustype[4:]).update(**{fieldname:now.strftime("%H%M")}) 199 199 # Log the update to external file 200 logmessage = getSimTime() + ", LCS status update : " + session.username + ", " + session.statustype[4:] + ", " + session.statustype[0:4] + ", " + session.statuser + " "+ "\n"200 logmessage = getSimTime() + ", LCS status update, " + session.username + ", " + session.statustype[4:] + " / " + session.statustype[0:4] + " / " + session.statuser + "\n" 201 201 text_file = open(kLogfile, "a") 202 202 text_file.write(logmessage) … … 323 323 session.flash = 'New lane closure added: ' + newID + ' ' + newLognum + ': ' + selectedlanes 324 324 # Log the new closure to external file. Username, closureID, route, dir, type of closure, type of work 325 logmessage = getSimTime() + ", LCS new closure : " + session.username + ", " + newID + '.' + newLognum + ', ' + form.vars.route + form.vars.direction + ', ' + form.vars.closuretype + ',' + form.vars.worktype + "\n"325 logmessage = getSimTime() + ", LCS new closure, " + session.username + ", " + newID + '.' + newLognum + ' / ' + form.vars.route + form.vars.direction + ' / ' + form.vars.closuretype + ' / ' + form.vars.worktype + "\n" 326 326 text_file = open(kLogfile, "a") 327 327 text_file.write(logmessage) -
branches/LCSv2/controllers/default.py.bak
r641 r642 1 1 # added comments for testing 2 2 # Constants 3 kLogfile = " samplelogfile.txt"3 kLogfile = "LCSlogfile.txt" 4 4 kSimtimefile = "sim_elapsedtime.json" #"../webapps/dynamicdata/sim_elapsed_time.json" 5 5 hwys = ['','1','5', '22', '55', '57', '73', '74', '91', '133', '142', '241', '261', '405', '605'] … … 17 17 if len(item) > 0: 18 18 users.append(item) 19 # build the form 19 20 form = FORM(LABEL('User:',_for='username', _class="label username-label"), 20 21 #INPUT(_name='username', _size='15', _style="font-size: 18px;"), BR(), … … 197 198 db(db.closures.closureid == session.statustype[4:]).update(**{fieldname:now.strftime("%H%M")}) 198 199 # Log the update to external file 199 logmessage = getSimTime() + ", LCS status update : " + session.username + ", " + session.statustype[4:] + ", " + session.statustype[0:4] + ", " + session.statuser + " "+ "\n"200 logmessage = getSimTime() + ", LCS status update, " + session.username + ", " + session.statustype[4:] + " / " + session.statustype[0:4] + " / " + session.statuser + "\n" 200 201 text_file = open(kLogfile, "a") 201 202 text_file.write(logmessage) … … 322 323 session.flash = 'New lane closure added: ' + newID + ' ' + newLognum + ': ' + selectedlanes 323 324 # Log the new closure to external file. Username, closureID, route, dir, type of closure, type of work 324 logmessage = getSimTime() + ", LCS new closure : " + session.username + ", " + newID + '.' + newLognum + ', ' + form.vars.route + form.vars.direction + ', ' + form.vars.closuretype + ',' + form.vars.worktype + "\n"325 logmessage = getSimTime() + ", LCS new closure, " + session.username + ", " + newID + '.' + newLognum + ' / ' + form.vars.route + form.vars.direction + ' / ' + form.vars.closuretype + ' / ' + form.vars.worktype + "\n" 325 326 text_file = open(kLogfile, "a") 326 327 text_file.write(logmessage) -
branches/LCSv2/databases/sql.log
r641 r642 52709 52709 DELETE FROM sqlite_sequence WHERE name='crew' 52710 52710 success! 52711 DELETE FROM "supervisors"; 52712 DELETE FROM sqlite_sequence WHERE name='supervisors' 52713 success! 52714 DELETE FROM "streets"; 52715 DELETE FROM sqlite_sequence WHERE name='streets' 52716 success! 52717 DELETE FROM "crew"; 52718 DELETE FROM sqlite_sequence WHERE name='crew' 52719 success! 52720 DELETE FROM "supervisors"; 52721 DELETE FROM sqlite_sequence WHERE name='supervisors' 52722 success! 52723 DELETE FROM "streets"; 52724 DELETE FROM sqlite_sequence WHERE name='streets' 52725 success! 52726 DELETE FROM "crew"; 52727 DELETE FROM sqlite_sequence WHERE name='crew' 52728 success! 52729 DELETE FROM "supervisors"; 52730 DELETE FROM sqlite_sequence WHERE name='supervisors' 52731 success! 52732 DELETE FROM "streets"; 52733 DELETE FROM sqlite_sequence WHERE name='streets' 52734 success! 52735 DELETE FROM "crew"; 52736 DELETE FROM sqlite_sequence WHERE name='crew' 52737 success! 52738 DELETE FROM "supervisors"; 52739 DELETE FROM sqlite_sequence WHERE name='supervisors' 52740 success! 52741 DELETE FROM "streets"; 52742 DELETE FROM sqlite_sequence WHERE name='streets' 52743 success! 52744 DELETE FROM "crew"; 52745 DELETE FROM sqlite_sequence WHERE name='crew' 52746 success! 52747 DELETE FROM "supervisors"; 52748 DELETE FROM sqlite_sequence WHERE name='supervisors' 52749 success! 52750 DELETE FROM "streets"; 52751 DELETE FROM sqlite_sequence WHERE name='streets' 52752 success! 52753 DELETE FROM "crew"; 52754 DELETE FROM sqlite_sequence WHERE name='crew' 52755 success! 52756 DELETE FROM "supervisors"; 52757 DELETE FROM sqlite_sequence WHERE name='supervisors' 52758 success! 52759 DELETE FROM "streets"; 52760 DELETE FROM sqlite_sequence WHERE name='streets' 52761 success! 52762 DELETE FROM "crew"; 52763 DELETE FROM sqlite_sequence WHERE name='crew' 52764 success! 52765 DELETE FROM "supervisors"; 52766 DELETE FROM sqlite_sequence WHERE name='supervisors' 52767 success! 52768 DELETE FROM "streets"; 52769 DELETE FROM sqlite_sequence WHERE name='streets' 52770 success! 52771 DELETE FROM "crew"; 52772 DELETE FROM sqlite_sequence WHERE name='crew' 52773 success! 52774 DELETE FROM "supervisors"; 52775 DELETE FROM sqlite_sequence WHERE name='supervisors' 52776 success! 52777 DELETE FROM "streets"; 52778 DELETE FROM sqlite_sequence WHERE name='streets' 52779 success! 52780 DELETE FROM "crew"; 52781 DELETE FROM sqlite_sequence WHERE name='crew' 52782 success! 52783 DELETE FROM "supervisors"; 52784 DELETE FROM sqlite_sequence WHERE name='supervisors' 52785 success! 52786 DELETE FROM "streets"; 52787 DELETE FROM sqlite_sequence WHERE name='streets' 52788 success! 52789 DELETE FROM "crew"; 52790 DELETE FROM sqlite_sequence WHERE name='crew' 52791 success! 52792 DELETE FROM "supervisors"; 52793 DELETE FROM sqlite_sequence WHERE name='supervisors' 52794 success! 52795 DELETE FROM "streets"; 52796 DELETE FROM sqlite_sequence WHERE name='streets' 52797 success! 52798 DELETE FROM "crew"; 52799 DELETE FROM sqlite_sequence WHERE name='crew' 52800 success! 52801 DELETE FROM "supervisors"; 52802 DELETE FROM sqlite_sequence WHERE name='supervisors' 52803 success! 52804 DELETE FROM "streets"; 52805 DELETE FROM sqlite_sequence WHERE name='streets' 52806 success! 52807 DELETE FROM "crew"; 52808 DELETE FROM sqlite_sequence WHERE name='crew' 52809 success! 52810 DELETE FROM "supervisors"; 52811 DELETE FROM sqlite_sequence WHERE name='supervisors' 52812 success! 52813 DELETE FROM "streets"; 52814 DELETE FROM sqlite_sequence WHERE name='streets' 52815 success! 52816 DELETE FROM "crew"; 52817 DELETE FROM sqlite_sequence WHERE name='crew' 52818 success! 52819 DELETE FROM "supervisors"; 52820 DELETE FROM sqlite_sequence WHERE name='supervisors' 52821 success! 52822 DELETE FROM "streets"; 52823 DELETE FROM sqlite_sequence WHERE name='streets' 52824 success! 52825 DELETE FROM "crew"; 52826 DELETE FROM sqlite_sequence WHERE name='crew' 52827 success! 52828 DELETE FROM "supervisors"; 52829 DELETE FROM sqlite_sequence WHERE name='supervisors' 52830 success! 52831 DELETE FROM "streets"; 52832 DELETE FROM sqlite_sequence WHERE name='streets' 52833 success! 52834 DELETE FROM "crew"; 52835 DELETE FROM sqlite_sequence WHERE name='crew' 52836 success! 52837 DELETE FROM "supervisors"; 52838 DELETE FROM sqlite_sequence WHERE name='supervisors' 52839 success! 52840 DELETE FROM "streets"; 52841 DELETE FROM sqlite_sequence WHERE name='streets' 52842 success! 52843 DELETE FROM "crew"; 52844 DELETE FROM sqlite_sequence WHERE name='crew' 52845 success! 52846 DELETE FROM "supervisors"; 52847 DELETE FROM sqlite_sequence WHERE name='supervisors' 52848 success! 52849 DELETE FROM "streets"; 52850 DELETE FROM sqlite_sequence WHERE name='streets' 52851 success! 52852 DELETE FROM "crew"; 52853 DELETE FROM sqlite_sequence WHERE name='crew' 52854 success! 52855 DELETE FROM "supervisors"; 52856 DELETE FROM sqlite_sequence WHERE name='supervisors' 52857 success! 52858 DELETE FROM "streets"; 52859 DELETE FROM sqlite_sequence WHERE name='streets' 52860 success! 52861 DELETE FROM "crew"; 52862 DELETE FROM sqlite_sequence WHERE name='crew' 52863 success! 52864 DELETE FROM "supervisors"; 52865 DELETE FROM sqlite_sequence WHERE name='supervisors' 52866 success! 52867 DELETE FROM "streets"; 52868 DELETE FROM sqlite_sequence WHERE name='streets' 52869 success! 52870 DELETE FROM "crew"; 52871 DELETE FROM sqlite_sequence WHERE name='crew' 52872 success! 52873 DELETE FROM "supervisors"; 52874 DELETE FROM sqlite_sequence WHERE name='supervisors' 52875 success! 52876 DELETE FROM "streets"; 52877 DELETE FROM sqlite_sequence WHERE name='streets' 52878 success! 52879 DELETE FROM "crew"; 52880 DELETE FROM sqlite_sequence WHERE name='crew' 52881 success! 52882 DELETE FROM "supervisors"; 52883 DELETE FROM sqlite_sequence WHERE name='supervisors' 52884 success! 52885 DELETE FROM "streets"; 52886 DELETE FROM sqlite_sequence WHERE name='streets' 52887 success! 52888 DELETE FROM "crew"; 52889 DELETE FROM sqlite_sequence WHERE name='crew' 52890 success! 52891 DELETE FROM "supervisors"; 52892 DELETE FROM sqlite_sequence WHERE name='supervisors' 52893 success! 52894 DELETE FROM "streets"; 52895 DELETE FROM sqlite_sequence WHERE name='streets' 52896 success! 52897 DELETE FROM "crew"; 52898 DELETE FROM sqlite_sequence WHERE name='crew' 52899 success! 52900 DELETE FROM "supervisors"; 52901 DELETE FROM sqlite_sequence WHERE name='supervisors' 52902 success! 52903 DELETE FROM "streets"; 52904 DELETE FROM sqlite_sequence WHERE name='streets' 52905 success! 52906 DELETE FROM "crew"; 52907 DELETE FROM sqlite_sequence WHERE name='crew' 52908 success! 52909 DELETE FROM "supervisors"; 52910 DELETE FROM sqlite_sequence WHERE name='supervisors' 52911 success! 52912 DELETE FROM "streets"; 52913 DELETE FROM sqlite_sequence WHERE name='streets' 52914 success! 52915 DELETE FROM "crew"; 52916 DELETE FROM sqlite_sequence WHERE name='crew' 52917 success! 52918 DELETE FROM "supervisors"; 52919 DELETE FROM sqlite_sequence WHERE name='supervisors' 52920 success! 52921 DELETE FROM "streets"; 52922 DELETE FROM sqlite_sequence WHERE name='streets' 52923 success! 52924 DELETE FROM "crew"; 52925 DELETE FROM sqlite_sequence WHERE name='crew' 52926 success! 52927 DELETE FROM "supervisors"; 52928 DELETE FROM sqlite_sequence WHERE name='supervisors' 52929 success! 52930 DELETE FROM "streets"; 52931 DELETE FROM sqlite_sequence WHERE name='streets' 52932 success! 52933 DELETE FROM "crew"; 52934 DELETE FROM sqlite_sequence WHERE name='crew' 52935 success! 52936 DELETE FROM "supervisors"; 52937 DELETE FROM sqlite_sequence WHERE name='supervisors' 52938 success! 52939 DELETE FROM "streets"; 52940 DELETE FROM sqlite_sequence WHERE name='streets' 52941 success! 52942 DELETE FROM "crew"; 52943 DELETE FROM sqlite_sequence WHERE name='crew' 52944 success! 52945 DELETE FROM "supervisors"; 52946 DELETE FROM sqlite_sequence WHERE name='supervisors' 52947 success! 52948 DELETE FROM "streets"; 52949 DELETE FROM sqlite_sequence WHERE name='streets' 52950 success! 52951 DELETE FROM "crew"; 52952 DELETE FROM sqlite_sequence WHERE name='crew' 52953 success! 52954 DELETE FROM "supervisors"; 52955 DELETE FROM sqlite_sequence WHERE name='supervisors' 52956 success! 52957 DELETE FROM "streets"; 52958 DELETE FROM sqlite_sequence WHERE name='streets' 52959 success! 52960 DELETE FROM "crew"; 52961 DELETE FROM sqlite_sequence WHERE name='crew' 52962 success! 52963 DELETE FROM "supervisors"; 52964 DELETE FROM sqlite_sequence WHERE name='supervisors' 52965 success! 52966 DELETE FROM "streets"; 52967 DELETE FROM sqlite_sequence WHERE name='streets' 52968 success! 52969 DELETE FROM "crew"; 52970 DELETE FROM sqlite_sequence WHERE name='crew' 52971 success! 52972 DELETE FROM "supervisors"; 52973 DELETE FROM sqlite_sequence WHERE name='supervisors' 52974 success! 52975 DELETE FROM "streets"; 52976 DELETE FROM sqlite_sequence WHERE name='streets' 52977 success! 52978 DELETE FROM "crew"; 52979 DELETE FROM sqlite_sequence WHERE name='crew' 52980 success! 52981 DELETE FROM "supervisors"; 52982 DELETE FROM sqlite_sequence WHERE name='supervisors' 52983 success! 52984 DELETE FROM "streets"; 52985 DELETE FROM sqlite_sequence WHERE name='streets' 52986 success! 52987 DELETE FROM "crew"; 52988 DELETE FROM sqlite_sequence WHERE name='crew' 52989 success! 52990 DELETE FROM "supervisors"; 52991 DELETE FROM sqlite_sequence WHERE name='supervisors' 52992 success! 52993 DELETE FROM "streets"; 52994 DELETE FROM sqlite_sequence WHERE name='streets' 52995 success! 52996 DELETE FROM "crew"; 52997 DELETE FROM sqlite_sequence WHERE name='crew' 52998 success! 52999 DELETE FROM "supervisors"; 53000 DELETE FROM sqlite_sequence WHERE name='supervisors' 53001 success! 53002 DELETE FROM "streets"; 53003 DELETE FROM sqlite_sequence WHERE name='streets' 53004 success! 53005 DELETE FROM "crew"; 53006 DELETE FROM sqlite_sequence WHERE name='crew' 53007 success! 53008 DELETE FROM "supervisors"; 53009 DELETE FROM sqlite_sequence WHERE name='supervisors' 53010 success! 53011 DELETE FROM "streets"; 53012 DELETE FROM sqlite_sequence WHERE name='streets' 53013 success! 53014 DELETE FROM "crew"; 53015 DELETE FROM sqlite_sequence WHERE name='crew' 53016 success! 53017 DELETE FROM "supervisors"; 53018 DELETE FROM sqlite_sequence WHERE name='supervisors' 53019 success! 53020 DELETE FROM "streets"; 53021 DELETE FROM sqlite_sequence WHERE name='streets' 53022 success! 53023 DELETE FROM "crew"; 53024 DELETE FROM sqlite_sequence WHERE name='crew' 53025 success! 53026 DELETE FROM "supervisors"; 53027 DELETE FROM sqlite_sequence WHERE name='supervisors' 53028 success! 53029 DELETE FROM "streets"; 53030 DELETE FROM sqlite_sequence WHERE name='streets' 53031 success! 53032 DELETE FROM "crew"; 53033 DELETE FROM sqlite_sequence WHERE name='crew' 53034 success! 53035 DELETE FROM "supervisors"; 53036 DELETE FROM sqlite_sequence WHERE name='supervisors' 53037 success! 53038 DELETE FROM "streets"; 53039 DELETE FROM sqlite_sequence WHERE name='streets' 53040 success! 53041 DELETE FROM "crew"; 53042 DELETE FROM sqlite_sequence WHERE name='crew' 53043 success! 53044 DELETE FROM "supervisors"; 53045 DELETE FROM sqlite_sequence WHERE name='supervisors' 53046 success! 53047 DELETE FROM "streets"; 53048 DELETE FROM sqlite_sequence WHERE name='streets' 53049 success! 53050 DELETE FROM "crew"; 53051 DELETE FROM sqlite_sequence WHERE name='crew' 53052 success! -
branches/LCSv2/progress.log
r641 r642 1332 1332 [2021-03-13 17:09:33] EDIT LCSv2/controllers/default.py: 1 1333 1333 [2021-03-13 17:13:37] EDIT LCSv2/views/default/help.html: 0 1334 [2021-03-15 16:33:09] EDIT LCSv2/controllers/default.py: 0 1335 [2021-03-15 16:34:26] EDIT LCSv2/controllers/default.py: 0 1336 [2021-03-15 16:40:58] EDIT LCSv2/controllers/default.py: 0
Note: See TracChangeset
for help on using the changeset viewer.
