OpenACS / openacs-4 / packages / ref-timezones / sql

common

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 7
Last Commit: 25 Dec
Commits this week: 0
Total Lines of Code (LoC): 226,303
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 14 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 19 Mar 2009
3:04 pm

victorg

- Solving problem for overlaping in changes for some european times.

- Loading more timezones.

Ref: http://alice.wu-wien.ac.at:8000/xowiki/timezone-updgrade

Options
    • -35931
    • +39960
    ./timezone-rules.dat
    • -518
    • +549
    ./timezones.dat
  3. … 3 more files in changeset.
Thursday 17 Jul 2003
3:10 am

donb

Decided that assuming SQL data files are CSV-formatted files is a bad idea

after running into a package that embeds comments in its data! Changed

from .csv to .dat and all that implies. Still more testing to do...

Options
    • -527
    • +0
    ./ref-timezones-data.sql
    • -36045
    • +0
    ./ref-timezones-rules.sql
    • -35931
    • +0
    ./timezone-rules.csv
    • -0
    • +35931
    ./timezone-rules.dat
    • -521
    • +0
    ./timezones.csv
    • -0
    • +521
    ./timezones.dat
  7. … 28 more files in changeset.
Wednesday 16 Jul 2003
2:06 am

donb

Switching to the use of PostgreSQL's COPY command and Oracle's SQL*Loader

to load the data for this package. Much, much faster than a bazillion

INSERT statements.

Options
    • -521
    • +0
    ./00-timezones.csv
    • -35931
    • +0
    ./01-timezone-rules.csv
    • -0
    • +35931
    ./timezone-rules.csv
    • -0
    • +521
    ./timezones.csv
  5. … 5 more files in changeset.
Sunday 13 Jul 2003
9:45 pm

donb

Moved csv files to match naming scheme that makes it easy to load in both

PG and Oracle - dd-table-name.csv where dd is the sequence number, used

to control the order in which table data is loaded.

Options
    • -0
    • +521
    ./00-timezones.csv
    • -0
    • +35931
    ./01-timezone-rules.csv
    • -521
    • +0
    ./ref-timezones-data.csv
    • -35931
    • +0
    ./ref-timezones-rules.csv
Saturday 17 May 2003
1:02 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -0
    • +521
    ./ref-timezones-data.csv
    • -0
    • +35931
    ./ref-timezones-rules.csv
  3. … 8 more files in changeset.
Saturday 29 Mar 2003
3:59 am

donb

Created CSV files for the timezone data and rules that can be loaded by

either PostgreSQL or Oracle many, many times more quickly than inserts.

Code to do the loading will be checked in after I write it.

Options
    • -0
    • +521
    ./ref-timezones-data.csv
    • -0
    • +35931
    ./ref-timezones-rules.csv
3:59 am

donb

file ref-timezones-data.csv was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./ref-timezones-data.csv
3:59 am

donb

file ref-timezones-rules.csv was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./ref-timezones-rules.csv
Thursday 23 Jan 2003
10:55 pm

peterm

rolling back bad commit. I committed installation timesaver changes to these files as part of my catalog file commit. Needless to say, Jeff the Gatekeeper Davis immediately spotted this mistake so that it could be corrected...

Options
    • -1
    • +520
    ./ref-timezones-data.sql
    • -1
    • +36016
    ./ref-timezones-rules.sql
Tuesday 21 Jan 2003
7:45 pm

peterm

I18N: committing all the message catalog files from the dotLRN translation server. Kudos to all our translators for this contribution.

Options
    • -520
    • +1
    ./ref-timezones-data.sql
    • -36016
    • +1
    ./ref-timezones-rules.sql
  3. … 333 more files in changeset.
Friday 10 May 2002
2:39 am

yon

undo bad commit

Options
    • -0
    • +36016
    ./ref-timezones-rules.sql
  2. … 7 more files in changeset.
2:33 am

yon

use 'scoped_p' instead of 'style' to determine which view to present

Options
    • -36017
    • +1
    ./ref-timezones-rules.sql
  2. … 7 more files in changeset.
Sunday 20 Jan 2002
12:57 am

yon

this was correct, reverting back to version 1.2

Options
    • -515
    • +522
    ./ref-timezones-data.sql
12:53 am

yon

fixed back commit

Options
    • -521
    • +514
    ./ref-timezones-data.sql
    • -0
    • +36015
    ./ref-timezones-rules.sql
12:45 am

yon

just a bit of work

Options
    • -36016
    • +1
    ./ref-timezones-rules.sql
  2. … 11 more files in changeset.
Monday 15 Oct 2001
9:33 pm

donb

Made ref-timezones work with PostgreSQL, made names of reference packages

be consistent.

Options
    • -35934
    • +35934
    ./ref-timezones-rules.sql
  2. … 10 more files in changeset.
Tuesday 04 Sep 2001
6:39 am

jong

updated timezones. I was missing all after 505

Options
    • -515
    • +522
    ./ref-timezones-data.sql
4:49 am

jong

initial revision

Options
    • -0
    • +520
    ./ref-timezones-data.sql
    • -0
    • +36045
    ./ref-timezones-rules.sql
  3. … 2 more files in changeset.