OpenACS / openacs-4 / packages / acs-lang / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 14
Last Commit: 26 Dec
Commits this week: 0
Total Lines of Code (LoC): 1,630
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 12 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 24 Feb 2004
1:03 pm

jeffd

drop script for acs-lang, bug 1431 patch 425 Jon Griffin (and me for postgres side)

Options
    • -0
    • +7
    ./acs-lang-drop.sql
    • -1
    • +3
    ./ad-locales-drop.sql
    • -7
    • +8
    ./message-catalog-drop.sql
  4. … 3 more files in changeset.
Wednesday 11 Feb 2004
10:41 am

peterm

changing the HR_HR locale to be disabled by default like all the other non-en_US locales

Options
    • -3
    • +2
    ./ad-locales.sql
    • -2
    • +2
    ./upgrade/upgrade-5.0.0-5.0.1.sql
  3. … 2 more files in changeset.
Tuesday 10 Feb 2004
2:45 pm

joela

added tagalog bug fix and Croatian locale to ad-locale.sql

Options
    • -2
    • +7
    ./ad-locales.sql
  2. … 1 more file in changeset.
Monday 09 Feb 2004
5:34 pm

peterm

leaving sync_time null and not assuming we were ever in sync. This has the downside that we have no base when bootstrapping the new upgrade feature causing a lot of update conflicts. However, it avoids delete conflicts.

Options
    • -26
    • +2
    ./upgrade/upgrade-5.0.0b4-5.0.0b5.sql
  2. … 1 more file in changeset.
1:46 pm

joela

added tagalog bug fix and Croatian locale

Options
    • -0
    • +11
    ./upgrade/upgrade-5.0.0-5.0.1.sql
  2. … 1 more file in changeset.
Friday 06 Feb 2004
6:42 pm

peterm

adding new locales from the translation server and making them part of the 5.0.1 upgrade scripts

Options
    • -1
    • +16
    ./ad-locales.sql
    • -0
    • +15
    ./upgrade/upgrade-5.0.0-5.0.1.sql
  3. … 2 more files in changeset.
10:34 am

peterm

file upgrade-5.0.0-5.0.1.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.0.0-5.0.1.sql
  2. … 1 more file in changeset.
10:34 am

peterm

changing the lang_messages_audit table to have a new audit_id integer primary key column. Having the overwrite_date in a composite primary key seemed problematic. Bumping version number of acs-lang to 5.0.1

Options
    • -3
    • +5
    ./message-catalog.sql
    • -0
    • +42
    ./upgrade/upgrade-5.0.0-5.0.1.sql
  3. … 7 more files in changeset.
Monday 26 Jan 2004
4:39 pm

jeffd

merge of changes between oacs-5-0-0b4 and oacs-5-0-0-final to HEAD

Options
    • -1
    • +3
    ./message-catalog-drop.sql
    • -1
    • +3
    ./message-catalog.sql
    • -2
    • +32
    ./upgrade/upgrade-5.0.0b4-5.0.0b5.sql
  4. … 284 more files in changeset.
Monday 15 Dec 2003
10:16 pm

jeffd

drop lang_messages_audit and lang_messages_keys bug 1291

Options
    • -1
    • +3
    ./message-catalog-drop.sql
  2. … 1 more file in changeset.
Saturday 13 Dec 2003
12:55 am

jeffd

fix the lang_messages and lang_messages_audit sync_time update statements, bug 1280

Options
    • -11
    • +11
    ./upgrade/upgrade-5.0.0b4-5.0.0b5.sql
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -7
    • +10
    ./message-catalog.sql
    • -0
    • +27
    ./upgrade/upgrade-5.0.0b4-5.0.0b5.sql
  3. … 597 more files in changeset.
3:35 pm

peterm

adding missing comma in lang_messages_audit table

Options
    • -2
    • +2
    ./message-catalog.sql
  2. … 1 more file in changeset.
1:40 pm

peterm

adding primary key to the lang_messages_audit table. Fixed upgrade script to version 5.0.0b5 so that sync_time is set for the first revision of each I18N message

Options
    • -1
    • +3
    ./message-catalog.sql
    • -2
    • +32
    ./upgrade/upgrade-5.0.0b4-5.0.0b5.sql
  3. … 3 more files in changeset.
Tuesday 09 Dec 2003
2:41 pm

peterm

file upgrade-5.0.0b4-5.0.0b5.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.0.0b4-5.0.0b5.sql
  2. … 1 more file in changeset.
2:41 pm

peterm

Adding support for I18N message catalog upgrades. Any import of

messages from catalog files that is done after the initial import is

considered an upgrade. The message import and upgrade logic is

encapsulated in the proc lang::catalog::import_messages (invoked

through lang::catalog::import).

acs-lang package

- Bumping version of package to 5.0.0b5

- Changes to datamodel:

- Adding columns deleted_p, conflict_p, and sync_time to lang_messages table.

- Removed column upgrade_status from lang_message_keys table

- Adding columns deleted_p, sync_time, conflict_p, upgrade_status to lang_messages_audit table

- Changes to lang::catalog Tcl API:

- Added proc lang::catalog::import_messages that encapsulates the logic for import and upgrade of

messages from catalog files to database.

- Changed the lang::catalog::import_from_file and lang::catalog:import procs to use the new import_messages proc.

- Added the upgrade Tcl API test cases that extensively tests through the import_messages proc with both

en_US and de_DE locales.

- Changes to lang::message Tcl API:

- Changed lang::message::register to take new switches upgrade_sync, upgrade_status, and conlfict. Cleaned up the

proc a little and made it construct SQL dynamically.

- Added procs delete, get, and get_element.

- Added the edit proc that is used when editing attributes of a message other than the message text itself. This

proc will not create a new message revision. It is invoked for example by the delete proc.

- Added the count_conflicts proc.

- Changes to admin UI

- New canonical pages for import/export of catalog files that check for site-wide-admin priv

- Made the message delete page use appropriate Tcl API

- Added the message-conflicts page that shows conflicting messages. Linking to this page from

index page, locale-, and package index pages.

acs-admin package

- Removed the import/export messages pages and using the ones in acs-lang package instead.

Options
    • -7
    • +10
    ./message-catalog.sql
    • -0
    • +27
    ./upgrade/upgrade-5.0.0b4-5.0.0b5.sql
  3. … 43 more files in changeset.
Wednesday 01 Oct 2003
10:49 am

peterm

upgrade script fix: lang_messages_audit audit table was not created with columns that it had at the time

Options
    • -2
    • +1
    ./upgrade/upgrade-4.7d3-4.7d4.sql
Tuesday 30 Sep 2003
2:52 pm

peterm

upgrade script fix: Oracle table def was mistakenly copied into PG upgrade script

Options
    • -2
    • +5
    ./upgrade/upgrade-4.7d3-4.7d4.sql
2:32 pm

peterm

using create view instead of create or replace view for PG 7.2 support. Adding creation of lang_messages_audit in upgrade script. It was missing

Options
    • -0
    • +23
    ./upgrade/upgrade-4.7d3-4.7d4.sql
    • -2
    • +2
    ./upgrade/upgrade-4.7d9-5.0d1.sql
  3. … 1 more file in changeset.
Tuesday 23 Sep 2003
10:55 am

peterm

making sure only one locale per language is default

Options
    • -3
    • +3
    ./ad-locales.sql
    • -2
    • +2
    ./upgrade/upgrade-5.0d1-5.0d2.sql
  3. … 2 more files in changeset.
Monday 22 Sep 2003
1:49 pm

peterm

adding the columns creation_user and creation_date to lang_messages. At least on the translation server those are useful. Those columns replace the table lang_messages_created in the messages-audit.sql file (now removed)

Options
    • -1
    • +7
    ./message-catalog.sql
    • -0
    • +45
    ./upgrade/upgrade-5.0d2-5.0d3.sql
  3. … 7 more files in changeset.
Friday 19 Sep 2003
5:08 pm

peterm

fixing misspelled charset in Arabic locales

Options
    • -3
    • +3
    ./ad-locales.sql
    • -1
    • +1
    ./upgrade/upgrade-4.7d8-4.7d9.sql
    • -1
    • +1
    ./upgrade/upgrade-5.0d1-5.0d2.sql
  4. … 3 more files in changeset.
Thursday 18 Sep 2003
1:57 pm

peterm

To speed up package installation we made en_US be the only enabled locale by default. Changed catalog loading to only load files for enabled locales. Added a link in UI so that catalog files can be loaded for a certain enabled locale after installation

Options
    • -11
    • +11
    ./ad-locales.sql
  2. … 6 more files in changeset.
Wednesday 17 Sep 2003
5:05 pm

peterm

adding Portugese locale from translation server

Options
    • -1
    • +6
    ./ad-locales.sql
    • -0
    • +5
    ./upgrade/upgrade-5.0d1-5.0d2.sql
  3. … 2 more files in changeset.
4:14 pm

peterm

adding Arabic Lebanese locale from translation server

Options
    • -1
    • +6
    ./ad-locales.sql
    • -0
    • +4
    ./upgrade/upgrade-5.0d1-5.0d2.sql
  3. … 2 more files in changeset.
Thursday 28 Aug 2003
10:57 am

peterm

making danish, french, and finnish enabled by default, fixing Tcl API tests

Options
    • -4
    • +4
    ./ad-locales.sql
  2. … 3 more files in changeset.
10:11 am

peterm

fixing typo in column name in lang_messages_audit - changing from comment to comment_text

Options
    • -6
    • +3
    ./message-catalog.sql
Tuesday 26 Aug 2003
1:20 pm

peterm

changing create or replace to create for PG 7.2 compatibility

Options
    • -2
    • +2
    ./ad-locales.sql
Monday 18 Aug 2003
12:33 pm

lars

Adding description to message keys

Options
    • -1
    • +2
    ./message-catalog.sql
    • -1
    • +7
    ./upgrade/upgrade-4.7d9-5.0d1.sql
  3. … 2 more files in changeset.
Monday 11 Aug 2003
6:43 pm

lars

1. Comments on messages

2. Rename lang_messages_audit.message to old_message

Options
    • -3
    • +6
    ./message-catalog.sql
    • -0
    • +72
    ./upgrade/upgrade-4.7d9-5.0d1.sql
  3. … 2 more files in changeset.