[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
Re: r203 - in trunk: db db/procs db/tests libdm
- To: uu@total-knowledge.com
- Subject: Re: r203 - in trunk: db db/procs db/tests libdm
- From: "Alexey Parshin" <alexeyp@gmail.com>
- Date: Wed, 9 Jul 2008 10:41:10 +1000
- Delivered-to: mailing list uu@total-knowledge.com
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type:references; bh=oTS6HNCudBHg5rLUH2uCSnyVcT6paPMTHf94M4uA8Rs=; b=mLHTLHEEVUdFg728Sk+d/Msgjn0Hrb4w8xNQXBKhAsHyKP0aI9Ri8Y9AieYl+0qh5f dRSn1P7hVZ4NH1brOSVFDv+FbyD3eVTjMwt/V0m9lCY6eJtoH0W6izUEhZwXV9fPHvLf 271GDfh279nNIQe5vXpg45qxX7/bMaJxNP5/0=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:references; b=BDnzUrv6R3rmOU3Tl8avzv+ZhINgc4piPbtrss60BbkequZZ8Q+S1HjLsF82snbfiQ QbhETpYmEpDB/kl1XphWrvygL/Zv4PhhsEdodbqswIeBDc/48QSzTy0E1wW/+kUSJ3Gr dgZVXTrNev8y/GokpD2+NKfqwK5ZLkj580/+0=
- In-reply-to: <4873FA32.4040107@total-knowledge.com>
- Mailing-list: contact uu-help@total-knowledge.com; run by ezmlm
- References: <20080708131727.5902.qmail@gateway.total-knowledge.com> <48738A05.20601@total-knowledge.com> <a75bc3cf0807081542y772ca80fqd8dd6adabdbb401a@mail.gmail.com> <4873FA32.4040107@total-knowledge.com>
Ok, I'll add the time zone list generation during the database creation.
2008/7/9 Ilya A. Volynets-Evenbakh <
ilya@total-knowledge.com>:
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.
Ilya.
--
Alexey Parshin,
http://www.sptk.net
--
Alexey Parshin,
http://www.sptk.net