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: 03 Nov
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 19 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 11 Sep
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./oracle/ad-locales.sql
    • -0
    • +0
    ./oracle/message-catalog.sql
    • -0
    • +0
    ./postgresql/ad-locales.sql
    • -0
    • +0
    ./postgresql/message-catalog.sql
  5. … 1461 more files in changeset.
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -2
    • +2
    ./oracle/ad-locales.sql
    • -1
    • +10
    ./oracle/message-catalog.sql
    • -0
    • +19
    ./oracle/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
    • -0
    • +3
    ./oracle/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
    • -0
    • +9
    ./oracle/upgrade/upgrade-5.10.0d13-5.10.0d14.sql
    • -0
    • +14
    ./oracle/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
    • -2
    • +2
    ./postgresql/ad-locales.sql
    • -1
    • +9
    ./postgresql/message-catalog.sql
    • -0
    • +4
    ./postgresql/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
    • -0
    • +2
    ./postgresql/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
    • -0
    • +8
    ./postgresql/upgrade/upgrade-5.10.0d13-5.10.0d14.sql
    • -0
    • +11
    ./postgresql/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
  13. … 8088 more files in changeset.
Saturday 12 Feb 2022
9:11 pm

gustafn

improving Oracle upgrade scripts

Oracle has no "ALTER TABLE ADD COLUMN ...."

Oracle has no "ALTER TABLE ADD COLUMN if exists .."

Options
    • -3
    • +17
    ./oracle/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
  2. … 8 more files in changeset.
Thursday 10 Feb 2022
10:33 pm

gustafn

fixes for Oracle 19c

Options
    • -7
    • +8
    ./oracle/message-catalog.sql
  2. … 5 more files in changeset.
Wednesday 02 Sep 2020
1:25 pm

antoniop

Do not insert object_ids that do not exist in acs_object (leftover group message keys)

Options
    • -1
    • +2
    ./oracle/upgrade/upgrade-5.10.0d13-5.10.0d14.sql
    • -1
    • +2
    ./postgresql/upgrade/upgrade-5.10.0d13-5.10.0d14.sql
Tuesday 25 Aug 2020
6:27 pm

antoniop

Take also care to populate the newly created column with the group ids coming from automatically generated message keys

Options
    • -0
    • +8
    ./oracle/upgrade/upgrade-5.10.0d13-5.10.0d14.sql
    • -0
    • +7
    ./postgresql/upgrade/upgrade-5.10.0d13-5.10.0d14.sql
  3. … 1 more file in changeset.
6:27 pm

antoniop

file upgrade-5.10.0d13-5.10.0d14.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.0d13-5.10.0d14.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d13-5.10.0d14.sql
6:19 pm

antoniop

Create index on the new lang_message_keys.object_id column

Options
    • -0
    • +3
    ./oracle/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
    • -0
    • +2
    ./postgresql/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
  3. … 1 more file in changeset.
6:19 pm

antoniop

file upgrade-5.10.0d12-5.10.0d13.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
3:38 pm

antoniop

file upgrade-5.10.0d11-5.10.0d12.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
3:38 pm

antoniop

acs-lang reform

Provide an optional object_id which can be used to register message keys that will be bound to the lifecycle of an acs-object. When the object is deleted, so will the message key.

This is useful for groups that automatically define a message key for their pretty name. Tcl api was already aware of this and would cleanup such message keys, but other idioms e.g. stored procedures used to delete groups would leave leftovers behind. These can become relatively numerous on group-intensive systems such as LEARN.

Other future usages for this new feature might be the automatic localization of xowiki FormPage properties.

Options
    • -1
    • +9
    ./oracle/message-catalog.sql
    • -0
    • +5
    ./oracle/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
    • -1
    • +9
    ./postgresql/message-catalog.sql
    • -0
    • +4
    ./postgresql/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
  5. … 6 more files in changeset.
Thursday 14 Mar 2019
11:41 am

antoniop

Trim padding from column to be sure

Options
    • -0
    • +3
    ./oracle/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
11:23 am

antoniop

Redefine ad_locales.language table column as varchar to avoid Oracle idiosyncrasies when comparing a char(n) with other string datatypes when using bind variables (following insightful LARS's remark)

char(n) in Oracle are automatically padded to be n characters long. Apparently, comparing char(n) -> char(n) is "blanks insensitive", while comparing char(n) -> varchar2(n) will account for such automatically inserted blanks. When using bind variables, one should carefully specify the type to use to avoid surprises with char(n) (for this we should touch the oracle driver), normalize the value via trim/pad all the time or replace every char(n) datatype with varchar2. ...are there other places where this is happening?

Options
    • -2
    • +2
    ./oracle/ad-locales.sql
    • -0
    • +11
    ./oracle/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
    • -2
    • +2
    ./postgresql/ad-locales.sql
    • -0
    • +11
    ./postgresql/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
  5. … 2 more files in changeset.
11:23 am

antoniop

file upgrade-5.10.0d2-5.10.0d3.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
Wednesday 15 Aug 2018
6:48 pm

gustafn

Removed obsolete @arch-tag

Options
    • -2
    • +1
    ./oracle/upgrade/upgrade-5.2.3d1-5.2.3d2.sql
    • -1
    • +0
    ./oracle/upgrade/upgrade-5.3.0d1-5.3.0d2.sql
    • -2
    • +1
    ./postgresql/upgrade/upgrade-5.2.3d1-5.2.3d2.sql
    • -1
    • +0
    ./postgresql/upgrade/upgrade-5.3.0d1-5.3.0d2.sql
  5. … 27 more files in changeset.
Tuesday 27 Mar 2018
2:43 pm

hectorr

Fix typos

Options
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.1-4.7d2.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-4.1-4.7d2.sql
  3. … 5 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -2
    • +2
    ./oracle/ad-locales.sql
    • -2
    • +2
    ./oracle/message-catalog.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-5.3.0d1-5.3.0d2.sql
    • -2
    • +4
    ./postgresql/ad-locales.sql
    • -2
    • +2
    ./postgresql/message-catalog.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.3.0d1-5.3.0d2.sql
    • -0
    • +21
    ./postgresql/upgrade/upgrade-5.9.1d1-5.9.1d2.sql
  8. … 7828 more files in changeset.
Friday 21 Apr 2017
5:59 pm

gustafn

Fix spelling errors

Options
    • -2
    • +2
    ./oracle/ad-locales.sql
    • -2
    • +2
    ./oracle/message-catalog.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-5.3.0d1-5.3.0d2.sql
    • -2
    • +2
    ./postgresql/ad-locales.sql
    • -2
    • +2
    ./postgresql/message-catalog.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.3.0d1-5.3.0d2.sql
  7. … 43 more files in changeset.
Saturday 26 Nov 2016
8:42 am

gustafn

- make upgrade script more robust

Options
    • -2
    • +1
    ./postgresql/ad-locales.sql
    • -2
    • +20
    ./postgresql/upgrade/upgrade-5.9.1d1-5.9.1d2.sql
Friday 25 Nov 2016
12:22 pm

antoniop

Add index on ad_locale_user_prefs for foreign key user_id

Options
    • -1
    • +4
    ./postgresql/ad-locales.sql
    • -0
    • +3
    ./postgresql/upgrade/upgrade-5.9.1d1-5.9.1d2.sql
  3. … 1 more file in changeset.
12:22 pm

antoniop

file upgrade-5.9.1d1-5.9.1d2.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1d1-5.9.1d2.sql
Monday 27 Oct 2014
5:38 pm

victorg

Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

Options
    • -9
    • +16
    ./postgresql/upgrade/upgrade-4.7d4-4.7d5.sql
    • -6
    • +13
    ./postgresql/upgrade/upgrade-5.0.0-5.0.1.sql
  3. … 2546 more files in changeset.
Friday 05 Sep 2014
6:29 pm

gustafn

- change to dollar-quoting

Options
    • -9
    • +16
    ./postgresql/upgrade/upgrade-4.7d4-4.7d5.sql
    • -6
    • +13
    ./postgresql/upgrade/upgrade-5.0.0-5.0.1.sql
Sunday 17 Oct 2010
11:06 pm

donb

Merged oacs-5-6 to HEAD. HEAD now installs and passes all core tests. There

may still be some lingering problems due to my screwing up the oacs-5-6

branch earlier, I'll be looking into this later.

Options
    • -3
    • +2
    ./oracle/ad-locales-drop.sql
    • -18
    • +1
    ./oracle/ad-locales.sql
    • -21
    • +1
    ./oracle/upgrade/upgrade-5.6.0d2-5.6.0d3.sql
    • -2
    • +0
    ./postgresql/ad-locales-drop.sql
    • -18
    • +1
    ./postgresql/ad-locales.sql
    • -21
    • +1
    ./postgresql/upgrade/upgrade-5.6.0d2-5.6.0d3.sql
  7. … 209 more files in changeset.
Friday 14 May 2010
3:15 pm

emmar

- Moves support for 3 chars language codes to ref-language

- Adds dependencies to ref-language and ref-countries

- Bumps version number

Options
    • -3
    • +2
    ./oracle/ad-locales-drop.sql
    • -18
    • +1
    ./oracle/ad-locales.sql
    • -21
    • +1
    ./oracle/upgrade/upgrade-5.6.0d2-5.6.0d3.sql
    • -3
    • +1
    ./postgresql/ad-locales-drop.sql
    • -18
    • +1
    ./postgresql/ad-locales.sql
    • -21
    • +1
    ./postgresql/upgrade/upgrade-5.6.0d2-5.6.0d3.sql
  7. … 7 more files in changeset.
Monday 22 Mar 2010
2:24 am

donb

And for PG too ...

Options
    • -2
    • +2
    ./postgresql/upgrade/upgrade-5.6.0d2-5.6.0d3.sql
2:24 am

donb

Same change to pk constraint names as for initial install.

Options
    • -2
    • +2
    ./oracle/upgrade/upgrade-5.6.0d2-5.6.0d3.sql
1:51 am

donb

Changed primary key constraints to meet our naming conventions, because

the slightly non-standard name caused my pretty "no errors" page for this

package to turn red :(.

Options
    • -3
    • +3
    ./oracle/ad-locales.sql
    • -3
    • +3
    ./postgresql/ad-locales.sql
Friday 08 Jan 2010
6:39 pm

emmar

Implements TIP#137 Support for 3-chars language codes

Options
    • -2
    • +3
    ./oracle/ad-locales-drop.sql
    • -9
    • +26
    ./oracle/ad-locales.sql
    • -0
    • +6
    ./oracle/upgrade/upgrade-5.6.0d1-5.6.0d2.sql
    • -0
    • +34
    ./oracle/upgrade/upgrade-5.6.0d2-5.6.0d3.sql
    • -2
    • +3
    ./postgresql/ad-locales-drop.sql
    • -7
    • +24
    ./postgresql/ad-locales.sql
    • -0
    • +6
    ./postgresql/upgrade/upgrade-5.6.0d1-5.6.0d2.sql
    • -0
    • +34
    ./postgresql/upgrade/upgrade-5.6.0d2-5.6.0d3.sql
  9. … 8 more files in changeset.
Saturday 07 Jun 2008
10:28 pm

donb

Merged from 5.4.2

Options
    • -3
    • +13
    ./oracle/ad-locales.sql
    • -0
    • +6
    ./oracle/upgrade/upgrade-5.4.1d1-5.4.1d2.sql
    • -0
    • +4
    ./oracle/upgrade/upgrade-5.4.1d2-5.4.1d3.sql
    • -3
    • +10
    ./postgresql/ad-locales.sql
    • -0
    • +6
    ./postgresql/upgrade/upgrade-5.4.1d1-5.4.1d2.sql
    • -0
    • +4
    ./postgresql/upgrade/upgrade-5.4.1d2-5.4.1d3.sql
  7. … 278 more files in changeset.