Mercurial > p > roundup > code
annotate frontends/README.txt @ 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 | 7c852cad2ca8 |
| children |
| rev | line source |
|---|---|
|
446
ea9a4ca3fb84
Added a Zope frontend for roundup.
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
1 This directory contains alternate front-ends for Roundup. |
|
ea9a4ca3fb84
Added a Zope frontend for roundup.
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
2 |
|
3736
a2d22d0de0bc
WSGI support via roundup.cgi.wsgi_handler
Richard Jones <richard@users.sourceforge.net>
parents:
724
diff
changeset
|
3 roundup.cgi |
|
a2d22d0de0bc
WSGI support via roundup.cgi.wsgi_handler
Richard Jones <richard@users.sourceforge.net>
parents:
724
diff
changeset
|
4 This is a cgi-bin script. |
|
446
ea9a4ca3fb84
Added a Zope frontend for roundup.
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
5 |
|
6390
7c852cad2ca8
Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
3736
diff
changeset
|
6 wsgi.py |
|
7c852cad2ca8
Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
3736
diff
changeset
|
7 This is a wrapper to be used when running under wsgi. |
|
7c852cad2ca8
Add wsgi.py to frontends. Update docs.
John Rouillard <rouilj@ieee.org>
parents:
3736
diff
changeset
|
8 |
|
3736
a2d22d0de0bc
WSGI support via roundup.cgi.wsgi_handler
Richard Jones <richard@users.sourceforge.net>
parents:
724
diff
changeset
|
9 ZRoundup |
|
a2d22d0de0bc
WSGI support via roundup.cgi.wsgi_handler
Richard Jones <richard@users.sourceforge.net>
parents:
724
diff
changeset
|
10 This is a simple Zope frontend that installs as a regular Zope product. |
|
446
ea9a4ca3fb84
Added a Zope frontend for roundup.
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
11 |
|
3736
a2d22d0de0bc
WSGI support via roundup.cgi.wsgi_handler
Richard Jones <richard@users.sourceforge.net>
parents:
724
diff
changeset
|
12 See Roundup's doc/installation.txt for more info on installing these |
|
a2d22d0de0bc
WSGI support via roundup.cgi.wsgi_handler
Richard Jones <richard@users.sourceforge.net>
parents:
724
diff
changeset
|
13 frontends. |
