annotate frontends/wsgi.py @ 6806:bdd28b244839

- issue2551223 - fix timestamp truncation in mysql and postgresql The data types used to represent timestamps in pg and mysql for ephemeral tables: sessions and otks don't have enough signifcant digits to work. As a result the timestamps are rounduped (up/down) rsuling in the stored timestamp being 2 minutes (pg) or 2-3 hours(mysql) off from what it should be. Modify db schema to use a numeric type that preserves more significant figures. Implement schema upgrade. Document need for upgrade in upgrading.txt. Write tests for schema upgrade. Implement test for updateTimestamp method on BasicDatabase that showed this issue in the first place. Write overrides for test for anydbm/memorydb which store timestamp properly or not at all.
author John Rouillard <rouilj@ieee.org>
date Mon, 25 Jul 2022 17:20:20 -0400
parents 285d9adfefdb
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
6390
7c852cad2ca8 Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
diff changeset
1 # If you installed roundup to the system locations
7c852cad2ca8 Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
diff changeset
2 # using pip you don't need to change this
7c852cad2ca8 Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
diff changeset
3 # section. If you installed roundup in a custom
7c852cad2ca8 Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
diff changeset
4 # location, uncomment these lines and change the
7c852cad2ca8 Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
diff changeset
5 # path in the append() method to your custom path.
7c852cad2ca8 Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
diff changeset
6 #import sys
7c852cad2ca8 Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
diff changeset
7 #sys.path.append('/custom/location/where/roundup/is/installed')
7c852cad2ca8 Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
diff changeset
8
7c852cad2ca8 Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
diff changeset
9 # Obtain the WSGI request dispatcher
7c852cad2ca8 Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
diff changeset
10 from roundup.cgi.wsgi_handler import RequestDispatcher
7c852cad2ca8 Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
diff changeset
11
7c852cad2ca8 Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
diff changeset
12 # Set the path to tracker home.
7c852cad2ca8 Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
diff changeset
13 tracker_home = '/path/to/tracker'
7c852cad2ca8 Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
diff changeset
14
6747
d32d43e4a5ba wsgi can cache tracker instance enabled by feature flag.
John Rouillard <rouilj@ieee.org>
parents: 6390
diff changeset
15 # Enable the feature flag to speed up wsgi response by caching the
d32d43e4a5ba wsgi can cache tracker instance enabled by feature flag.
John Rouillard <rouilj@ieee.org>
parents: 6390
diff changeset
16 # Roundup tracker instance on startup. See upgrading.txt for
d32d43e4a5ba wsgi can cache tracker instance enabled by feature flag.
John Rouillard <rouilj@ieee.org>
parents: 6390
diff changeset
17 # more info.
d32d43e4a5ba wsgi can cache tracker instance enabled by feature flag.
John Rouillard <rouilj@ieee.org>
parents: 6390
diff changeset
18 feature_flags = { "cache_tracker": "" }
d32d43e4a5ba wsgi can cache tracker instance enabled by feature flag.
John Rouillard <rouilj@ieee.org>
parents: 6390
diff changeset
19
6390
7c852cad2ca8 Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
diff changeset
20 # Definition signature for app: app(environ, start_response):
6776
285d9adfefdb Update comment to allow use with mod_wsgi
John Rouillard <rouilj@ieee.org>
parents: 6772
diff changeset
21 # If using apache mod_wsgi change app to application.
6772
fde9fe504ebd fix syntax error.
John Rouillard <rouilj@ieee.org>
parents: 6747
diff changeset
22 app = RequestDispatcher(tracker_home, feature_flags=feature_flags)

Roundup Issue Tracker: http://roundup-tracker.org/