Home Projects Jobs Clientele Contact


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: r203 - in trunk: db db/procs db/tests libdm

Alexey Parshin wrote:
Define 'RI', please. (I guess tha's reference information).
Referential Integrity.
Currently, it's done by parsing a time_zones.txt file that contains a list of the time zones. This file is generated from /usr/share/zoneinfo by a single command. I can include that command in the _create_db.pl script if you want. The presentation of the time zines by groups reflects the most popular way of defining 'em - as two combo boxes (groups and time zones for a group). The query to build a full TZ name is a trivial join. The reference information is necessary to avoid any TZ misspelling on the user input. At the very least, we can verify the spelling and existance of the user TZ.
Main point is - we need to create zone list at installation time from the available timezones,
not store whole list in SVN.

2008/7/9 Ilya A. Volynets-Evenbakh <ilya@total-knowledge.com <mailto:ilya@total-knowledge.com>>:

    I am not sure we really need RI on time zones (could just store tz
    string in user prefs),
    but even if we do, tz table should just contain TZ strings, and
    init of TZ table should
    be done by a separate script, which would go through server's
    zoneinfo structure, and
    fill out the table with all available info.


Alexey Parshin,

Authoright © Total Knowledge: 2001-2008