• last updated 7 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.

    • -0
    • +10
    ./upgrade/upgrade-1.1.5d3-1.1.5d4.sql
  1. … 5 more files in changeset.
file upgrade-1.1.5d3-1.1.5d4.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-1.1.5d3-1.1.5d4.sql
  1. … 1 more file in changeset.
improve spelling

  1. … 14 more files in changeset.
Add missing where clause from previous upgrade... Oracle was indeed affected as well

    • -0
    • +89
    ./upgrade/upgrade-1.1.5d1-1.1.5d2.sql
  1. … 3 more files in changeset.
file upgrade-1.1.5d1-1.1.5d2.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-1.1.5d1-1.1.5d2.sql
  1. … 1 more file in changeset.
Apply fix to category__change_parent provided by franz.penz@km.at

apparently Oracle was not affected

    • -0
    • +89
    ./upgrade/upgrade-1.1.4-1.1.5d1.sql
  1. … 1 more file in changeset.
file upgrade-1.1.4-1.1.5d1.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-1.1.4-1.1.5d1.sql
merged changes from the oacs-5-9 branch and resolved conflicts

    • -0
    • +260
    ./upgrade/upgrade-1.1.3d4-1.1.3d5.sql
    • -0
    • +13
    ./upgrade/upgrade-1.1.3d6-1.1.3d7.sql
  1. … 7825 more files in changeset.
Fix spelling errors

  1. … 8 more files in changeset.
- remove leftovers from earlier upgrades

- bump version number to 1.1.3d8

  1. … 1 more file in changeset.
file upgrade-1.1.3d7-1.1.3d8.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade/upgrade-1.1.3d7-1.1.3d8.sql
acs_privilege_descendant_map is obsolete: http://openacs.org/forums/message-view?message_id=5330206

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...)

    • -0
    • +14
    ./upgrade/upgrade-1.1.3d4-1.1.3d5.sql
    • -0
    • +13
    ./upgrade/upgrade-1.1.3d6-1.1.3d7.sql
  1. … 1 more file in changeset.
file upgrade-1.1.3d6-1.1.3d7.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade/upgrade-1.1.3d6-1.1.3d7.sql
- add missing upgrade script

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

    • -0
    • +0
    ./upgrade/upgrade-1.1.3d5-1.1.3d6.sql
- update dirty editor buffer

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

    • -0
    • +0
    ./upgrade/upgrade-1.1.3d4-1.1.3d5.sql
Alter caveman style booleans (type character(1)) to real SQL boolean types.

    • -0
    • +246
    ./upgrade/upgrade-1.1.3d4-1.1.3d5.sql
  1. … 1 more file in changeset.
- add function args missed by earlier upgrades

- bump version numbers

    • -0
    • +29
    ./upgrade/upgrade-1.1.3d3-1.1.3d4.sql
  1. … 9 more files in changeset.
- update postgres function to modern style plpgsql definitions using dollar quoting

    • -77
    • +154
    ./category-synonym-package.sql
    • -150
    • +183
    ./category-tree-package.sql
    • -17
    • +20
    ./upgrade/upgrade-1.0d1-1.0d2.sql
    • -41
    • +63
    ./upgrade/upgrade-1.0d6-1.0d7.sql
    • -19
    • +21
    ./upgrade/upgrade-1.1.2d1-1.1.2d2.sql
    • -10
    • +17
    ./upgrade/upgrade-1.1.2d2-1.1.2d3.sql
    • -16
    • +18
    ./upgrade/upgrade-1.1.2d3-1.1.2d4.sql
    • -16
    • +20
    ./upgrade/upgrade-1.1d1-1.1d2.sql
    • -58
    • +55
    ./upgrade/upgrade-1.1d2-1.1d3.sql
    • -27
    • +27
    ./upgrade/upgrade-1.1d3-1.1d4.sql
  1. … 27 more files in changeset.
dont give table and id columns for tables that do not exist; maybe there should be an upgrade to fix this as well

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

- fix incorrect reference to table in category_tree__copy

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

  1. … 1 more file in changeset.
Fixed apparently untested fix by gustafn that tried to update a table

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

fix 2 bugs

- call to a non-existing acs_object__new with 5 args

- 2 table references were incorrect in category_tree__copy

    • -0
    • +63
    ./upgrade/upgrade-1.1.2d3-1.1.2d4.sql
  1. … 1 more file in changeset.
Fix missing column "widget" in category_tree_map in Oracle; strangely enough, the upgrade script was available.

  1. … 1 more file in changeset.
Fix missing column "widget" in category_tree_map in Oracle

  1. … 1 more file in changeset.
add update script

    • -0
    • +18
    ./upgrade/upgrade-1.1.2d2-1.1.2d3.sql
  1. … 1 more file in changeset.
add missing alias for function category__name

  1. … 1 more file in changeset.