Changeset 626 in tmcsimulator for branches/LCSv2/controllers/default.py

Timestamp:

08/30/2020 01:49:28 PM (6 years ago)

Author:

jdalbey

Message:

LCS Add revision number to Help page. Add resetdb page.

File:

• branches/LCSv2/controllers/default.py (modified) (2 diffs)

branches/LCSv2/controllers/default.py

@@ -299 +299 @@
     return dict(form=form)
 
+# An unlinked page to allow admin to reset the database to simulation start state
+def resetdb():
+    form = FORM("Press this button to reset the closure database to its original state at the start of a simulation.",BR(),
+                "Warning: this will delete all the current closures.",BR(),
+                "Import filename is 'db_closures_start.csv'.",BR(),
+                INPUT(_value="Reset Database", _type='submit', _class="btn btn-primary btn-default"))
+    if form.process().accepted:
+        db(db.closures.id > 0).delete()   # remove all current records
+        with open('db_closures_start.csv', 'rb') as dumpfile:
+            db.closures.import_from_csv_file(dumpfile)  # import from starting state
+        session.flash = 'Closure database has been reset'
+        redirect(URL('search.html'))
+    return dict(form=form)
+
 # Validation for existing closure button
 # If user selected Yes (it's existing incident) then they must select a closure ID
@@ -347 +361 @@
             result = result + "#"+item + " "
         result = result + "of " + lanecount
-    return result 
+    return result