Changeset 620 in tmcsimulator for branches/LCSv2/models/db.py.bak

Timestamp:

07/13/2020 12:23:49 PM (6 years ago)

Author:

jdalbey

Message:

Implement #248 to enhance LCS Request page

File:

• branches/LCSv2/models/db.py.bak (modified) (3 diffs)

branches/LCSv2/models/db.py.bak

@@ -7 +7 @@
                 Field('direction'),
                 Field('facility'),
-                Field('startdate',length=8, comment="Must be stored as YYYYMMDD"),
-                Field('enddate',length=8, comment="Must be stored as YYYYMMDD"),
+                Field('startdate','date', comment="Must be stored as YYYY-MM-DD"),
+                Field('enddate','date', comment="Must be stored as YYYY-MM-DD"),
                 Field('starttime',length=4, comment="Must be stored as HHMM"),
                 Field('endtime',length=4, comment="Must be stored as HHMM"),
@@ -53 +53 @@
 db.define_table('supervisors',
                 Field('name'),
-                Field('radiocallnum')\
+                Field('radiocallnum')
                 )
 db.supervisors.truncate() # delete all records and reset the counter of the id.
@@ -64 +64 @@
 db.streets.truncate()
 db.streets.import_from_csv_file(open('streets.csv', 'r')) #import the file
+
+db.define_table('crew',
+                Field('name'),
+                Field('radiocallnum')
+                )
+db.supervisors.truncate() # delete all records and reset the counter of the id.
+db.supervisors.import_from_csv_file(open('crew.csv', 'r')) #import the file