• last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
merge from oacs-5-10

    • -35711
    • +220868
    ./timezone-rules.dat
  1. … 8098 more files in changeset.
Updates timezone data once again, bump version to 5.10.1b3

The timezone data from IANA has changed (probably several years ago),

and the min/max years have to be changed to -2147481748/2147485547,

which are no acceptable years for timestamps in PostgreSQL and

Oracle. The new timezone data maps now these boundary values 1/9999.

This commit fixes as well a bug introduced by the last version of the

timezone data in cases, where Tcl versions with older timezone data

were used, and the fallback operations based on Tcl failed. Tcl

versions 8.6.14* and Tcl 9.0* have up-to-date time zones, e.g. Tcl

8.6.13 still requires in some rare cases the fallback to the database,

where the error might show up.

    • -80739
    • +81885
    ./timezone-rules.dat
  1. … 3 more files in changeset.
Upgrade timezone data to tzdb-2024a (Released 2024-02-01) from IANA

The last update of the timezone data of OpenACS happened on Sep 29,

2015 in the release process of OpenACS 5.9.0. The new timezone data is

based on the newest released data from IANA reflecting the changes

made by political bodies to time zone boundaries, UTC offsets, and

daylight-saving rules. The procedures to update the database are

described in RFC 6557 (https://www.rfc-editor.org/rfc/rfc6557.html)

and contains data for e.g. Europe up to the year 2499.

    • -36419
    • +220430
    ./timezone-rules.dat
  1. … 2 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

    • -38611
    • +39200
    ./timezone-rules.dat
  1. … 7833 more files in changeset.
- updating timezone info (old data was 7 years old, we have now 43 more timezones and many fixes)

    • -38611
    • +39200
    ./timezone-rules.dat
  1. … 2 more files in changeset.
- Solving problem for overlaping in changes for some european times.

- Loading more timezones.

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

    • -35931
    • +39960
    ./timezone-rules.dat
  1. … 3 more files in changeset.
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...

    • -0
    • +35931
    ./timezone-rules.dat
  1. … 28 more files in changeset.
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.

    • -0
    • +35931
    ./timezone-rules.csv
  1. … 5 more files in changeset.
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.

    • -0
    • +521
    ./00-timezones.csv
    • -0
    • +35931
    ./01-timezone-rules.csv
merge of 4.6.3b1 to HEAD

  1. … 8 more files in changeset.
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.

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

    • -0
    • +0
    ./ref-timezones-data.csv
file ref-timezones-rules.csv was initially added on branch oacs-4-6.

    • -0
    • +0
    ./ref-timezones-rules.csv
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...

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

  1. … 333 more files in changeset.
undo bad commit

  1. … 7 more files in changeset.
use 'scoped_p' instead of 'style' to determine which view to present

  1. … 7 more files in changeset.
this was correct, reverting back to version 1.2

fixed back commit

just a bit of work

  1. … 11 more files in changeset.

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

be consistent.

    • -35934
    • +35934
    ./ref-timezones-rules.sql
  1. … 10 more files in changeset.
updated timezones. I was missing all after 505

initial revision

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