OpenACS / openacs-4 / packages

ref-timezones

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 19
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 228,073
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 21 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 31 Oct 2003
5:11 pm

jeffd

switch to using \\copy rather than copy since the backend typically

is not able to read the dat file because of permissions (or if it is

on a remote machine the file typically will not even exist).

bug #1033

Options
    • -3
    • +1
    ./sql/postgresql/00-timezones.ctl
    • -4
    • +1
    ./sql/postgresql/01-timezone-rules.ctl
  3. … 7 more files in changeset.
Friday 10 Oct 2003
2:12 pm

lars

Fixed broken install due to ref-timezones required, but acs-reference not part of initiall install set

Options
    • -1
    • +1
    ./ref-timezones.info
  2. … 1 more file in changeset.
12:32 pm

lars

Forgot to set initial-install, I thought it actually resolved the dependencies, but alas ...

Options
    • -1
    • +1
    ./ref-timezones.info
10:01 am

lars

Changed the version number to 0.4 (it was already done partially)

Options
    • -2
    • +2
    ./ref-timezones.info
Wednesday 08 Oct 2003
6:53 pm

mohanp

Added upgrade to upgrade to changes made for Oracle 9i support

Options
    • -0
    • +341
    ./sql/oracle/upgrade/upgrade-0.3-0.4d1.sql
  2. … 23 more files in changeset.
6:05 pm

mohanp

Updated version numbers to upgrade to changes made for Oracle 9i support

Options
    • -3
    • +3
    ./ref-timezones.info
  2. … 37 more files in changeset.
Friday 03 Oct 2003
12:11 pm

jeffd

allow bulk loading with 7.2

Options
    • -2
    • +1
    ./sql/postgresql/00-timezones.ctl
  2. … 6 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

Options
    • -3
    • +3
    ./sql/oracle/ref-timezones-create.sql
    • -2
    • +2
    ./sql/oracle/ref-timezones-drop.sql
  3. … 274 more files in changeset.
Tuesday 02 Sep 2003
5:27 pm

lars

Fixed upgrade for PG 7.2. Unfortunately, COPY has different syntax between 7.2 and 7.3

Options
    • -1
    • +4
    ./sql/postgresql/00-timezones.ctl
    • -1
    • +4
    ./sql/postgresql/01-timezone-rules.ctl
Monday 18 Aug 2003
5:24 pm

peterm

adding upgrade script for PG for version 0.3 that we forgot to add previously

Options
    • -0
    • +29
    ./sql/postgresql/upgrade/upgrade-0.2d-0.3.sql
12:37 pm

lars

Added timezone__convert_to_locale proc for PG

Options
    • -2
    • +2
    ./ref-timezones.info
    • -1
    • +23
    ./sql/postgresql/ref-timezones-create.sql
Saturday 19 Jul 2003
12:18 am

donb

Forgot to change data control file to reference this package rather than

my test package ...

Options
    • -1
    • +1
    ./sql/postgresql/01-timezone-rules.ctl
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
    ./sql/common/ref-timezones-data.sql
    • -36045
    • +0
    ./sql/common/ref-timezones-rules.sql
    • -35931
    • +0
    ./sql/common/timezone-rules.csv
    • -0
    • +35931
    ./sql/common/timezone-rules.dat
    • -521
    • +0
    ./sql/common/timezones.csv
    • -0
    • +521
    ./sql/common/timezones.dat
    • -1
    • +1
    ./sql/oracle/00-timezones.ctl
    • -1
    • +1
    ./sql/oracle/01-timezone-rules.ctl
    • -1
    • +1
    ./sql/postgresql/00-timezones.ctl
    • -1
    • +1
    ./sql/postgresql/01-timezone-rules.ctl
  11. … 24 more files in changeset.
Wednesday 16 Jul 2003
2:47 am

donb

Removed references to the old INSERT data initialization files in the

oracle version.

Options
    • -7
    • +1
    ./sql/oracle/ref-timezones-create.sql
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
    ./sql/common/00-timezones.csv
    • -35931
    • +0
    ./sql/common/01-timezone-rules.csv
    • -0
    • +35931
    ./sql/common/timezone-rules.csv
    • -0
    • +521
    ./sql/common/timezones.csv
    • -0
    • +5
    ./sql/oracle/00-timezones.ctl
    • -0
    • +11
    ./sql/oracle/01-timezone-rules.ctl
    • -0
    • +1
    ./sql/postgresql/00-timezones.ctl
    • -0
    • +1
    ./sql/postgresql/01-timezone-rules.ctl
    • -7
    • +1
    ./sql/postgresql/ref-timezones-create.sql
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
    ./sql/common/00-timezones.csv
    • -0
    • +35931
    ./sql/common/01-timezone-rules.csv
    • -521
    • +0
    ./sql/common/ref-timezones-data.csv
    • -35931
    • +0
    ./sql/common/ref-timezones-rules.csv
Saturday 17 May 2003
1:02 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -10
    • +1
    ./ref-timezones.info
    • -0
    • +521
    ./sql/common/ref-timezones-data.csv
    • -0
    • +35931
    ./sql/common/ref-timezones-rules.csv
    • -47
    • +48
    ./sql/postgresql/ref-timezones-create.sql
    • -7
    • +7
    ./sql/postgresql/ref-timezones-drop.sql
  6. … 5 more files in changeset.
Monday 05 May 2003
11:33 am

peterm

removing the file listings from the info files since those are no longer used by OpenACS

Options
    • -9
    • +0
    ./ref-timezones.info
  2. … 5 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
    ./sql/common/ref-timezones-data.csv
    • -0
    • +35931
    ./sql/common/ref-timezones-rules.csv
3:59 am

donb

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

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

donb

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

Options
    • -0
    • +0
    ./sql/common/ref-timezones-rules.csv
Thursday 27 Mar 2003
3:46 am

donb

A variety of changes that add up to making outlook synchronization work

with PostgreSQL (at all) and Oracle (better).

1. Changed calendar to read SystemTimezone rather than hardwire it to

US/Eastern.

2. Made calendar depend on acs-lang since that's where the param lives.

3. Fixed the query on the acs-lang page that lets you set the timezone

(used the Oracle-ism UNIQUE rather than the standard DISTINCT)

4. Saw that the test stuff doesn't work and got rid of the links on the

index page - people can live without testing it for this release (we

should fix it for 4.7)

5. Fixed timezone__local_to_utc so it works with calendar, though it's

very whacky (shifted so the timezone'd date part is the UTC date, would

be much much better to use timestamp without timezone but PG doesn't

accept that syntax for function returns and we're not ready to drop

PG 7.2 support yet so I can't take advantage of the timestamp/timestamptz

type names, sigh)

Options
    • -25
    • +16
    ./sql/postgresql/ref-timezones-create.sql
  2. … 6 more files in changeset.
Sunday 23 Mar 2003
3:09 am

donb

1. Made it possible to upgrade from acs-kernel 4.6.1 to acs-kernel 4.6.2

by using the APM rather than running the upgrade script by hand from

PSQL or SQL*Plus.

2. Changed a bunch of package .info files to depend on acs-kernel 4.6.2

to force the APM to upgrade acs-kernel (and therefore the APM datamodel)

before anything else. No guarantee on this though since not all

packages properly define their dependence on the kernel, it appears.

3. Whacked the release notes to suggest people use the APM to upgrade

acs-kernel first, other package later, just for safety's sake.

4. Fixed goof-up in acs-subsite I accidently introduced.

Options
    • -1
    • +1
    ./ref-timezones.info
  2. … 34 more files in changeset.
Sunday 02 Mar 2003
11:42 pm

donb

I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

Options
    • -26
    • +35
    ./sql/postgresql/ref-timezones-create.sql
    • -7
    • +7
    ./sql/postgresql/ref-timezones-drop.sql
  3. … 38 more files in changeset.
Tuesday 18 Feb 2003
11:02 am

jeffd

correctly quote interval and use extract(timezone_hour...) bug 253 patch 85 Matthew Walker and patch 88 me

Options
    • -8
    • +9
    ./sql/postgresql/ref-timezones-create.sql
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
    ./sql/common/ref-timezones-data.sql
    • -1
    • +36016
    ./sql/common/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
    ./sql/common/ref-timezones-data.sql
    • -36016
    • +1
    ./sql/common/ref-timezones-rules.sql
  3. … 333 more files in changeset.
Thursday 16 Jan 2003
2:48 pm

jeffd

Merge of all changes from oacs-4-6 to HEAD. All changes up to tag jcd-merge-2

on oacs-4-6 are included.

Options
    • -1
    • +1
    ./ref-timezones.info
  2. … 56 more files in changeset.
Monday 09 Dec 2002
3:29 pm

jeffd

sync info files with package data and correct provides identifiers

Options
    • -1
    • +1
    ./ref-timezones.info
  2. … 36 more files in changeset.
Friday 10 May 2002
2:39 am

yon

undo bad commit

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