OpenACS / openacs-4 / packages / acs-lang

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 16
Last Commit: 28 Dec
Commits this week: 0
Total Lines of Code (LoC): 3,130
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 10 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Saturday 26 Jun 2004
4:04 pm

joela

typo in fa_IR upgrade

Options
    • -1
    • +1
    ./oracle/upgrade/upgrade-5.1.1d1-5.1.1d2.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.1.1d1-5.1.1d2.sql
3:52 pm

joela

file upgrade-5.1.1d1-5.1.1d2.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.1.1d1-5.1.1d2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.1.1d1-5.1.1d2.sql
3:52 pm

joela

fixing bug 1519 - misnamed locales

Options
    • -14
    • +28
    ./oracle/ad-locales.sql
    • -0
    • +157
    ./oracle/upgrade/upgrade-5.1.1d1-5.1.1d2.sql
    • -14
    • +19
    ./postgresql/ad-locales.sql
    • -0
    • +157
    ./postgresql/upgrade/upgrade-5.1.1d1-5.1.1d2.sql
  5. … 1 more file in changeset.
Thursday 26 Feb 2004
4:28 pm

jeffd

merge of all changes on oacs-5-0 branch between tag openacs-5-0-0-final and jcd-merge-pre503 (except those in lars-blogger).

Options
    • -2
    • +22
    ./oracle/ad-locales.sql
    • -4
    • +7
    ./oracle/message-catalog.sql
    • -0
    • +54
    ./oracle/upgrade/upgrade-5.0.0-5.0.1.sql
    • -26
    • +2
    ./oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql
    • -3
    • +22
    ./postgresql/ad-locales.sql
    • -3
    • +5
    ./postgresql/message-catalog.sql
    • -0
    • +68
    ./postgresql/upgrade/upgrade-5.0.0-5.0.1.sql
    • -26
    • +2
    ./postgresql/upgrade/upgrade-5.0.0b4-5.0.0b5.sql
  9. … 286 more files in changeset.
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
    ./oracle/acs-lang-drop.sql
    • -1
    • +3
    ./oracle/ad-locales-drop.sql
    • -2
    • +2
    ./oracle/message-catalog-drop.sql
    • -0
    • +7
    ./postgresql/acs-lang-drop.sql
    • -1
    • +3
    ./postgresql/ad-locales-drop.sql
    • -7
    • +8
    ./postgresql/message-catalog-drop.sql
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
    • -2
    • +2
    ./oracle/ad-locales.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-5.0.0-5.0.1.sql
    • -3
    • +2
    ./postgresql/ad-locales.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-5.0.0-5.0.1.sql
Tuesday 10 Feb 2004
2:45 pm

joela

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

Options
    • -2
    • +7
    ./oracle/ad-locales.sql
    • -2
    • +7
    ./postgresql/ad-locales.sql
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
    ./oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql
    • -26
    • +2
    ./postgresql/upgrade/upgrade-5.0.0b4-5.0.0b5.sql
1:46 pm

joela

added tagalog bug fix and Croatian locale

Options
    • -0
    • +10
    ./oracle/upgrade/upgrade-5.0.0-5.0.1.sql
    • -0
    • +11
    ./postgresql/upgrade/upgrade-5.0.0-5.0.1.sql
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
    ./oracle/ad-locales.sql
    • -0
    • +15
    ./oracle/upgrade/upgrade-5.0.0-5.0.1.sql
    • -1
    • +16
    ./postgresql/ad-locales.sql
    • -0
    • +15
    ./postgresql/upgrade/upgrade-5.0.0-5.0.1.sql
3:29 pm

peterm

fixing and simplifying upgrade script. Using same approach as in PG version, i.e. adding column to existing table instead of creating brand new table

Options
    • -56
    • +14
    ./oracle/upgrade/upgrade-5.0.0-5.0.1.sql
10:34 am

peterm

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

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.0.0-5.0.1.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.0.0-5.0.1.sql
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
    • -4
    • +7
    ./oracle/message-catalog.sql
    • -0
    • +71
    ./oracle/upgrade/upgrade-5.0.0-5.0.1.sql
    • -3
    • +5
    ./postgresql/message-catalog.sql
    • -0
    • +42
    ./postgresql/upgrade/upgrade-5.0.0-5.0.1.sql
  5. … 5 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
    ./oracle/message-catalog-drop.sql
    • -1
    • +3
    ./oracle/message-catalog.sql
    • -27
    • +0
    ./oracle/upgrade-5.0.0b4-5.0.0b5.sql
    • -0
    • +57
    ./oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql
    • -1
    • +3
    ./postgresql/message-catalog-drop.sql
    • -1
    • +3
    ./postgresql/message-catalog.sql
    • -2
    • +32
    ./postgresql/upgrade/upgrade-5.0.0b4-5.0.0b5.sql
  8. … 280 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
    ./oracle/message-catalog-drop.sql
    • -1
    • +3
    ./postgresql/message-catalog-drop.sql
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
    ./postgresql/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
    • -4
    • +14
    ./oracle/message-catalog.sql
    • -0
    • +27
    ./oracle/upgrade-5.0.0b4-5.0.0b5.sql
    • -7
    • +10
    ./postgresql/message-catalog.sql
    • -0
    • +27
    ./postgresql/upgrade/upgrade-5.0.0b4-5.0.0b5.sql
  5. … 595 more files in changeset.
3:35 pm

peterm

adding missing comma in lang_messages_audit table

Options
    • -2
    • +2
    ./oracle/message-catalog.sql
    • -2
    • +2
    ./postgresql/message-catalog.sql
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
    ./oracle/message-catalog.sql
    • -27
    • +0
    ./oracle/upgrade-5.0.0b4-5.0.0b5.sql
    • -0
    • +57
    ./oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql
    • -1
    • +3
    ./postgresql/message-catalog.sql
    • -2
    • +32
    ./postgresql/upgrade/upgrade-5.0.0b4-5.0.0b5.sql
1:40 pm

peterm

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

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql
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
    ./oracle/upgrade-5.0.0b4-5.0.0b5.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.0.0b4-5.0.0b5.sql
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
    • -4
    • +14
    ./oracle/message-catalog.sql
    • -0
    • +27
    ./oracle/upgrade-5.0.0b4-5.0.0b5.sql
    • -7
    • +10
    ./postgresql/message-catalog.sql
    • -0
    • +27
    ./postgresql/upgrade/upgrade-5.0.0b4-5.0.0b5.sql
  5. … 41 more files in changeset.
Wednesday 01 Oct 2003
12:50 pm

peterm

table ad_locale_user_prefs had gone missing from the create script (not sure how or when). Re-adding

Options
    • -1
    • +13
    ./oracle/ad-locales.sql
12:48 pm

peterm

upgrade script fix: the table ad_locale_user_prefs was never created so creating

Options
    • -5
    • +25
    ./oracle/upgrade/upgrade-4.7d5-4.7d6.sql
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
    ./postgresql/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
    ./postgresql/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
    ./oracle/upgrade/upgrade-4.7d3-4.7d4.sql
    • -0
    • +23
    ./postgresql/upgrade/upgrade-4.7d3-4.7d4.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-4.7d9-5.0d1.sql
Tuesday 23 Sep 2003
10:55 am

peterm

making sure only one locale per language is default

Options
    • -3
    • +3
    ./oracle/ad-locales.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-5.0d1-5.0d2.sql
    • -3
    • +3
    ./postgresql/ad-locales.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-5.0d1-5.0d2.sql
Monday 22 Sep 2003
1:57 pm

peterm

removing message-audit.sql obsolete file

Options
    • -51
    • +0
    ./oracle/message-audit.sql
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
    • +5
    ./oracle/message-catalog.sql
    • -0
    • +4
    ./oracle/upgrade/upgrade-5.0d2-5.0d3.sql
    • -1
    • +7
    ./postgresql/message-catalog.sql
    • -0
    • +45
    ./postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
  5. … 5 more files in changeset.