OpenACS / openacs-4 / packages / categories

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 17
Last Commit: 14 Nov
Commits this week: 0
Total Lines of Code (LoC): 5,404
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 23 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 11 Sep
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.0d6-1.0d7.sql
  2. … 1464 more files in changeset.
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -35
    • +0
    ./oracle/categories-init.sql
    • -2
    • +2
    ./oracle/category-package.sql
    • -0
    • +286
    ./oracle/upgrade/upgrade-1.1.5d1-1.1.5d2.sql
    • -0
    • +12
    ./oracle/upgrade/upgrade-1.1.5d3-1.1.5d4.sql
    • -0
    • +4
    ./postgresql/categories-create.sql
    • -2
    • +0
    ./postgresql/categories-drop.sql
    • -37
    • +0
    ./postgresql/categories-init.sql
    • -2
    • +2
    ./postgresql/category-package.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-1.0d6-1.0d7.sql
    • -0
    • +89
    ./postgresql/upgrade/upgrade-1.1.4-1.1.5d1.sql
    • -0
    • +89
    ./postgresql/upgrade/upgrade-1.1.5d1-1.1.5d2.sql
    • -0
    • +10
    ./postgresql/upgrade/upgrade-1.1.5d3-1.1.5d4.sql
    • -0
    • +4
    ./postgresql/upgrade/upgrade-1.1.5d5-1.1.5d6.sql
  14. … 8087 more files in changeset.
Thursday 06 Oct 2022
6:34 pm

gustafn

create indices on FK constraints

Options
    • -0
    • +4
    ./postgresql/categories-create.sql
    • -0
    • +4
    ./postgresql/upgrade/upgrade-1.1.5d5-1.1.5d6.sql
  3. … 1 more file in changeset.
6:34 pm

gustafn

file upgrade-1.1.5d5-1.1.5d6.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.1.5d5-1.1.5d6.sql
Wednesday 10 Mar 2021
4:18 pm

antoniop

Final phasing out of acs_named_objects

- remove table creation

- update documentation

- provide an optional upgrade script to delete the table and the object type (commented out by default, as people might have defined object subtypes downstream).

Context: this table and the related machinery were created at a time where acs_objects where not as mature as they are now and would not include the "title" information. To retrieve the object name, the only option was the stored procedure acs_object.name, which was not scalable.

From an excerpt of the Changelog file:

.....

2004-03-31 jeffd

......

* packages/categories/tcl/category-trees-procs-oracle.xql:

* packages/categories/tcl/category-trees-procs-postgresql.xql:

acs_named_objects superflous now that title is in

acs_objects. need to fix the rest of the occurances though

......

This tells us that the phasing out has already been decided back in 2004, but delayed. One technical reason, could be that the acs_named_objects table would also materialize the translation, while the title column would store sometimes a message key, that would need to be translated manually. This is helpful when e.g. sorting by name in sql. However, only the faq and categories package would seem to make any use of the table and only the faq package would seem to maintain its values... This would make some UIs in the categories package practically useless since a long time.

Options
    • -35
    • +0
    ./oracle/categories-init.sql
    • -0
    • +12
    ./oracle/upgrade/upgrade-1.1.5d3-1.1.5d4.sql
    • -2
    • +0
    ./postgresql/categories-drop.sql
    • -37
    • +0
    ./postgresql/categories-init.sql
    • -0
    • +10
    ./postgresql/upgrade/upgrade-1.1.5d3-1.1.5d4.sql
  6. … 3 more files in changeset.
4:18 pm

antoniop

file upgrade-1.1.5d3-1.1.5d4.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-1.1.5d3-1.1.5d4.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.1.5d3-1.1.5d4.sql
Friday 09 Aug 2019
10:19 pm

gustafn

improve spelling

Options
    • -2
    • +2
    ./postgresql/upgrade/upgrade-1.0d6-1.0d7.sql
  2. … 14 more files in changeset.
Wednesday 17 Apr 2019
11:07 am

antoniop

Add missing where clause from previous upgrade... Oracle was indeed affected as well

Options
    • -2
    • +2
    ./oracle/category-package.sql
    • -0
    • +286
    ./oracle/upgrade/upgrade-1.1.5d1-1.1.5d2.sql
    • -1
    • +1
    ./postgresql/category-package.sql
    • -0
    • +89
    ./postgresql/upgrade/upgrade-1.1.5d1-1.1.5d2.sql
  5. … 1 more file in changeset.
11:07 am

antoniop

file upgrade-1.1.5d1-1.1.5d2.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-1.1.5d1-1.1.5d2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.1.5d1-1.1.5d2.sql
Tuesday 16 Apr 2019
3:52 pm

antoniop

Apply fix to category__change_parent provided by franz.penz@km.at

apparently Oracle was not affected

Options
    • -1
    • +1
    ./postgresql/category-package.sql
    • -0
    • +89
    ./postgresql/upgrade/upgrade-1.1.4-1.1.5d1.sql
  3. … 1 more file in changeset.
3:52 pm

antoniop

file upgrade-1.1.4-1.1.5d1.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.1.4-1.1.5d1.sql
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -3
    • +3
    ./oracle/categories-create.sql
    • -3
    • +3
    ./oracle/upgrade/upgrade-1.0d3-1.0d4.sql
    • -18
    • +8
    ./postgresql/categories-create.sql
    • -4
    • +0
    ./postgresql/categories-drop.sql
    • -3
    • +3
    ./postgresql/category-package.sql
    • -3
    • +3
    ./postgresql/category-synonym-package.sql
    • -4
    • +4
    ./postgresql/category-tree-package.sql
    • -3
    • +3
    ./postgresql/upgrade/upgrade-1.0d3-1.0d4.sql
    • -0
    • +260
    ./postgresql/upgrade/upgrade-1.1.3d4-1.1.3d5.sql
    • -0
    • +2
    ./postgresql/upgrade/upgrade-1.1.3d5-1.1.3d6.sql
    • -0
    • +13
    ./postgresql/upgrade/upgrade-1.1.3d6-1.1.3d7.sql
    • -0
    • +5
    ./postgresql/upgrade/upgrade-1.1.3d7-1.1.3d8.sql
  13. … 7823 more files in changeset.
Friday 21 Apr 2017
10:25 pm

gustafn

Fix spelling errors

Options
    • -3
    • +3
    ./oracle/categories-create.sql
    • -3
    • +3
    ./oracle/upgrade/upgrade-1.0d3-1.0d4.sql
    • -3
    • +3
    ./postgresql/categories-create.sql
    • -3
    • +3
    ./postgresql/upgrade/upgrade-1.0d3-1.0d4.sql
  5. … 6 more files in changeset.
Monday 13 Feb 2017
12:40 pm

gustafn

- remove leftovers from earlier upgrades

- bump version number to 1.1.3d8

Options
    • -0
    • +5
    ./postgresql/upgrade/upgrade-1.1.3d7-1.1.3d8.sql
  2. … 1 more file in changeset.
12:40 pm

gustafn

file upgrade-1.1.3d7-1.1.3d8.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.1.3d7-1.1.3d8.sql
Wednesday 16 Nov 2016
6:07 pm

hectorr

acs_privilege_descendant_map is obsolete: http://openacs.org/forums/message-view?message_id=5330206

Options
    • -4
    • +0
    ./postgresql/categories-drop.sql
Tuesday 15 Nov 2016
5:20 pm

antoniop

Remove possibly leftover definition of category_tree__new/9 stored procedure.

It can still be present on old upgraded installations, conflicting with the new one (different argument types...)

Options
    • -0
    • +14
    ./postgresql/upgrade/upgrade-1.1.3d4-1.1.3d5.sql
    • -0
    • +13
    ./postgresql/upgrade/upgrade-1.1.3d6-1.1.3d7.sql
  3. … 1 more file in changeset.
5:20 pm

antoniop

file upgrade-1.1.3d6-1.1.3d7.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.1.3d6-1.1.3d7.sql
Friday 04 Nov 2016
12:09 pm

gustafn

- add missing upgrade script

Options
    • -0
    • +2
    ./postgresql/upgrade/upgrade-1.1.3d5-1.1.3d6.sql
12:09 pm

gustafn

file upgrade-1.1.3d5-1.1.3d6.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.1.3d5-1.1.3d6.sql
Sunday 15 May 2016
7:21 pm

gustafn

- update dirty editor buffer

Options
    • -2
    • +2
    ./postgresql/category-tree-package.sql
Saturday 14 May 2016
8:54 pm

gustafn

file upgrade-1.1.3d4-1.1.3d5.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.1.3d4-1.1.3d5.sql
8:54 pm

gustafn

Alter caveman style booleans (type character(1)) to real SQL boolean types.

Options
    • -15
    • +5
    ./postgresql/categories-create.sql
    • -3
    • +3
    ./postgresql/category-package.sql
    • -3
    • +3
    ./postgresql/category-synonym-package.sql
    • -2
    • +2
    ./postgresql/category-tree-package.sql
    • -0
    • +246
    ./postgresql/upgrade/upgrade-1.1.3d4-1.1.3d5.sql
  6. … 1 more file in changeset.
Tuesday 30 Jun 2015
1:39 pm

gustafn

- add function args missed by earlier upgrades

- bump version numbers

Options
    • -0
    • +29
    ./postgresql/upgrade/upgrade-1.1.3d3-1.1.3d4.sql
  2. … 9 more files in changeset.
Saturday 30 Mar 2013
11:50 pm

gustafn

- update postgres function to modern style plpgsql definitions using dollar quoting

Options
    • -11
    • +11
    ./postgresql/categories-init.sql
    • -23
    • +23
    ./postgresql/categories-relation.sql
    • -17
    • +32
    ./postgresql/category-link-package.sql
    • -123
    • +156
    ./postgresql/category-package.sql
    • -77
    • +154
    ./postgresql/category-synonym-package.sql
    • -150
    • +183
    ./postgresql/category-tree-package.sql
    • -17
    • +20
    ./postgresql/upgrade/upgrade-1.0d1-1.0d2.sql
    • -6
    • +13
    ./postgresql/upgrade/upgrade-1.0d3-1.0d4.sql
    • -41
    • +63
    ./postgresql/upgrade/upgrade-1.0d6-1.0d7.sql
    • -19
    • +21
    ./postgresql/upgrade/upgrade-1.1.2d1-1.1.2d2.sql
    • -10
    • +17
    ./postgresql/upgrade/upgrade-1.1.2d2-1.1.2d3.sql
    • -16
    • +18
    ./postgresql/upgrade/upgrade-1.1.2d3-1.1.2d4.sql
    • -16
    • +20
    ./postgresql/upgrade/upgrade-1.1d1-1.1d2.sql
    • -58
    • +55
    ./postgresql/upgrade/upgrade-1.1d2-1.1d3.sql
    • -27
    • +27
    ./postgresql/upgrade/upgrade-1.1d3-1.1d4.sql
  16. … 27 more files in changeset.
Tuesday 30 Nov 2010
7:58 pm

jeffd

dont give table and id columns for tables that do not exist; maybe there should be an upgrade to fix this as well

Options
    • -4
    • +4
    ./postgresql/categories-relation.sql
Sunday 06 Dec 2009
9:11 pm

donb

Basic package drop works now for PostgreSQL (Oracle will come later)

Options
    • -16
    • +10
    ./postgresql/categories-drop.sql
Sunday 01 Feb 2009
7:38 pm

gustafn

- fix incorrect reference to table in category_tree__copy

- revert a change of don to make categories admin interface working again.

Options
    • -1
    • +1
    ./postgresql/category-tree-package.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-1.1.2d3-1.1.2d4.sql
  3. … 1 more file in changeset.
Friday 30 Jan 2009
3:59 am

donb

Fixed apparently untested fix by gustafn that tried to update a table

using the syntax "update categories c set ...", which is not SQL.

Options
    • -1
    • +1
    ./postgresql/category-tree-package.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-1.1.2d3-1.1.2d4.sql
Thursday 06 Nov 2008
4:39 pm

gustafn

fix 2 bugs

- call to a non-existing acs_object__new with 5 args

- 2 table references were incorrect in category_tree__copy

Options
    • -2
    • +3
    ./postgresql/category-tree-package.sql
    • -0
    • +63
    ./postgresql/upgrade/upgrade-1.1.2d3-1.1.2d4.sql
  3. … 1 more file in changeset.