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 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 11 Dec 2003
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.
Friday 08 Aug 2003
2:21 pm

lars

1. Added search for words in messages feature.

2. Added locale enable/disable feature

3. Cleaned up translation UI

4. Improved batch message edit

Options
    • -65
    • +70
    ./ad-locales.sql
    • -1
    • +7
    ./message-catalog.sql
    • -0
    • +13
    ./upgrade/upgrade-4.7d9-5.0d1.sql
  4. … 39 more files in changeset.
9:24 am

peterm

adding the british locale

Options
    • -1
    • +7
    ./ad-locales.sql
  2. … 1 more file in changeset.
Friday 27 Jun 2003
10:26 am

peterm

removing duplicate locales from datamodel and upgrade scripts

Options
    • -11
    • +1
    ./ad-locales.sql
    • -10
    • +0
    ./upgrade/upgrade-4.7d8-4.7d9.sql
  3. … 2 more files in changeset.
Tuesday 24 Jun 2003
2:31 pm

peterm

adding new locales from the translation server

Options
    • -1
    • +41
    ./ad-locales.sql
    • -0
    • +41
    ./upgrade/upgrade-4.7d8-4.7d9.sql
  3. … 3 more files in changeset.
Monday 19 May 2003
2:27 pm

peterm

adding missing locales ast_ES and gl_EST

Options
    • -1
    • +13
    ./ad-locales.sql
  2. … 1 more file in changeset.
Wednesday 26 Feb 2003
10:43 am

peterm

making catalog messages cascade when packages are deleted

Options
    • -1
    • +3
    ./message-catalog.sql
    • -0
    • +21
    ./upgrade/upgrade-4.7d7-4.7d8.sql
  3. … 3 more files in changeset.
Tuesday 18 Feb 2003
12:00 am

peterm

allowing for 3 character ISO 639-2 language codes

Options
    • -2
    • +2
    ./ad-locales.sql
    • -0
    • +30
    ./upgrade/upgrade-4.7d6-4.7d7.sql
  3. … 6 more files in changeset.
Saturday 08 Feb 2003
9:03 pm

peterm

the upgrade to acs-lang 4.7d5 would break if server already had swedish locale, added check to fix that

Options
    • -6
    • +22
    ./upgrade/upgrade-4.7d4-4.7d5.sql
  2. … 1 more file in changeset.
7:54 pm

peterm

upgrade of acs-lang 4.7d4-4.7d5 adding locales from the translation server

Options
    • -0
    • +79
    ./upgrade/upgrade-4.7d4-4.7d5.sql
  2. … 2 more files in changeset.
Tuesday 21 Jan 2003
5:27 pm

peterm

adding all locales from the dotlrn translation server. Kudos to all the translators.

Options
    • -60
    • +111
    ./ad-locales.sql
  2. … 1 more file in changeset.
Thursday 19 Dec 2002
4:29 pm

peterm

message catalog upgrade support - adding upgrade_status columns to tables lang_messages and lang_message_keys

Options
    • -1
    • +7
    ./message-catalog.sql
    • -0
    • +9
    ./upgrade/upgrade-4.7d3-4.7d4.sql
  3. … 2 more files in changeset.
Wednesday 04 Dec 2002
8:34 pm

lars

Bug: acs-lang had a default sysdate. Changed to default now()

Options
    • -2
    • +2
    ./message-catalog.sql