lang-message-procs-oracle.xql

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

  1. … 8099 more files in changeset.
Fixes for Oracle 19c: (temporary?) fix for message catalogs

This change fixes the problem that after a fresh installation, all (!)

messages keys are empty. I am not sure what the source of the problem

is, why this has supposedly worked some years before, and whether

there are undesired side-effects of this change. Without this change,

the openacs installation leads to fully broken state.

Reduce divergence between oracle and postgres codebase

  1. … 3 more files in changeset.
merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

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

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

  1. … 8 more files in changeset.
Added queries to deal with descriptions

  1. … 5 more files in changeset.
adding message catalog upgrade support to the acs-lang package. message keys and messages now have an upgrade status (added, deleted, updated). Being more rigorous about determining what is a catalog file and moving this logic to the acs-bootstrap-installer package (apm_is_catalog_file) as it is needed before the acs-lang library is loaded. Updated procedure documentation.

  1. … 7 more files in changeset.
adding timezone support, adding auditing of edited messages, adding package scoped locale preference and package scoped locale

  1. … 40 more files in changeset.
fixed the check in lang::message::register that embedded variables are not tampered with, translator mode links vastly improved by Lars - translations that can be edited have a hyperlinked green circle after them, texts with missing translations are highlighted in yellow and have a hyperlinked red star after them, now navigation (links) are not broken by translator mode being on

  1. … 2 more files in changeset.
Splitting up the message keys into package_key and message_key in the datamodel, adding a message key table, changing format of catalog files to be xml based, cleaning up tcl API and its documentation, adding acs-automated-testing tests that test some catalog and message TCL procs

  1. … 32 more files in changeset.
Collaboraid: adding namespaces to the TCL API, adding new procedures for extracting keys from adp pages and parsing keys embedded in text, adding a translation web UI that was used at Greenpeace (at www/admin) and making it work with PostgreSQL, moving the old pages under www to be under www/admin/test, making the lang_messages table use locale rather than language, added upgrade scripts

    • -0
    • +24
    ./lang-message-procs-oracle.xql
  1. … 111 more files in changeset.