- Committer: mattgiuca
- Date: 2008-03-07 15:12:02 UTC
- Revision ID: svn-v3-trunk0:2b9c9e99-6f39-0410-b283-7f802c844ae2:trunk:669
Timestamps are now stored within the program as Python "time" module's
"struct_time" objects, rather than strings directly from the DB.
They are parsed into struct_time objects when reading from the db.
They are formatted into SQL Timestamp strings when writing to the db.
This allows them to be manipulated and compared within the program.
common.db: _escape now accepts struct_time objects - it formats them into SQL
time strings.
common.user: The User constructor now parses "acct_exp", "pass_exp" and
"last_login" fields as timestamp strings, and stores them
internally as struct_time.
tutorialservice: When recording a submission, the "date" field is now stored
as a struct_time, not a formatted string.
login.py: When logging in, uncommented call to write last_login to the DB,
passing the current local time. (This now works correctly).
Note that this is done after retrieving the user details, so the
value of last_login stored in the session is the _old_ last login,
not the new one (this is intentional).
(With Tom Conway).
"struct_time" objects, rather than strings directly from the DB.
They are parsed into struct_time objects when reading from the db.
They are formatted into SQL Timestamp strings when writing to the db.
This allows them to be manipulated and compared within the program.
common.db: _escape now accepts struct_time objects - it formats them into SQL
time strings.
common.user: The User constructor now parses "acct_exp", "pass_exp" and
"last_login" fields as timestamp strings, and stores them
internally as struct_time.
tutorialservice: When recording a submission, the "date" field is now stored
as a struct_time, not a formatted string.
login.py: When logging in, uncommented call to write last_login to the DB,
passing the current local time. (This now works correctly).
Note that this is done after retrieving the user details, so the
value of last_login stored in the session is the _old_ last login,
not the new one (this is intentional).
(With Tom Conway).
| Filename | Latest Rev | Last Changed | Committer | Comment | Size | ||
|---|---|---|---|---|---|---|---|
 ..
|
|||||||
db_tools.php |
443 | 17 years ago | dcoles | Added Forum application along with unmodifed versi | 37.4 KB |
|
|
|
dbal.php |
443 | 17 years ago | dcoles | Added Forum application along with unmodifed versi | 19.1 KB |
|
|
|
firebird.php |
443 | 17 years ago | dcoles | Added Forum application along with unmodifed versi | 10.9 KB |
|
|
|
index.htm |
443 | 17 years ago | dcoles | Added Forum application along with unmodifed versi | 169 bytes |
|
|
|
mssql.php |
443 | 17 years ago | dcoles | Added Forum application along with unmodifed versi | 9.1 KB |
|
|
|
mssql_odbc.php |
443 | 17 years ago | dcoles | Added Forum application along with unmodifed versi | 8.5 KB |
|
|
|
mysql.php |
443 | 17 years ago | dcoles | Added Forum application along with unmodifed versi | 10.2 KB |
|
|
|
mysqli.php |
443 | 17 years ago | dcoles | Added Forum application along with unmodifed versi | 9.5 KB |
|
|
|
oracle.php |
443 | 17 years ago | dcoles | Added Forum application along with unmodifed versi | 15.7 KB |
|
|
|
postgres.php |
443 | 17 years ago | dcoles | Added Forum application along with unmodifed versi | 8.8 KB |
|
|
|
sqlite.php |
443 | 17 years ago | dcoles | Added Forum application along with unmodifed versi | 6.7 KB |
|
|