acs-content-repository

  • last updated 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

Changeset MAIN:donb:20030320221136:3 does not match your current filter (clear filter).

file extlink-procs-oracle.xql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./tcl/extlink-procs-oracle.xql
file extlink-procs.xql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./tcl/extlink-procs.xql
file extlink-procs.tcl was initially added on branch oacs-4-6.

    • -0
    • +0
    ./tcl/extlink-procs.tcl
file extlink-procs-postgresql.xql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./tcl/extlink-procs-postgresql.xql
file upgrade-4.6.4-4.6.5.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-4.6.4-4.6.5.sql
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-4.6.4-4.6.5.sql
Removed the vile fs_simple_objects added by OF to store URLs in file

storage despite the existence of a non-versioned URL type in the content

repository. Upgrade scripts provided. I added Tcl API to the content

repository to honor our desire to export the SQL API to Tcl client code.

1. folder contents are now counted correctly (bug fix)

2. The fs_objects view is now usable in PG (it was a UNION view before and

therefore didn't scale)

3. Code in file storage is considerably simpler now and all file storage

objects are now stored in the content repository, as they should

be.

The Oracle version may need some work I'll finish testing this afternoon.

    • -0
    • +1908
    ./sql/oracle/upgrade/upgrade-4.6.4-4.6.5.sql
    • -7
    • +60
    ./sql/postgresql/content-extlink.sql
    • -70
    • +11
    ./sql/postgresql/content-item.sql
    • -1749
    • +0
    ./sql/postgresql/packages-create.sql
    • -0
    • +186
    ./sql/postgresql/upgrade/upgrade-4.6.4-4.6.5.sql
  1. … 32 more files in changeset.
comma missing between crftd.path, crftd.storage_area_key

    • -1
    • +1
    ./tcl/acs-content-repository-procs-oracle.xql
tweak the mappings a little and make the text descriptions easier to scan in select widget

Merged over workflow/bug-tracker changes from 4.6 branch

    • -0
    • +146
    ./sql/postgresql/upgrade/upgrade-4.6.3-4.6.4.sql
Added check that content type is a subclass of content_revision, so you don't accidentally subclass something else, like I did

file keyword-procs-oracle.xql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./tcl/keyword-procs-oracle.xql
file keyword-procs.xql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./tcl/keyword-procs.xql
file keyword-procs.tcl was initially added on branch oacs-4-6.

    • -0
    • +0
    ./tcl/keyword-procs.tcl
file keyword-procs-postgresql.xql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./tcl/keyword-procs-postgresql.xql
file upgrade-4.6.3-4.6.4.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-4.6.3-4.6.4.sql
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-4.6.3-4.6.4.sql
Upgrade to 4.6.2: A few bug fixes, Tcl API for keywords.

    • -0
    • +146
    ./sql/postgresql/upgrade/upgrade-4.6.3-4.6.4.sql
Worked on fixing cms-news-demo in order to give Greenpeace (and others) an

example CR/CMS app to play with. It's not finished but partway there. On

the way found a couple of CR bugs and fixed them.

  1. … 9 more files in changeset.
Partial conversion from timestamp to timestamptz for PG 7.3 (need to keep

time zone timestamps so dumps from PG 7.2 installs will still work)

    • -4
    • +4
    ./sql/postgresql/content-image-drop.sql
  1. … 7 more files in changeset.
Merged from HEAD: Fixed typo (extra parenthesis) in content_keyword__is_assigned

    • -22
    • +2
    ./sql/postgresql/content-keyword.sql
Fixed typo (extra parenthesis) in content_keyword__is_assigned

    • -22
    • +2
    ./sql/postgresql/content-keyword.sql
register_child_type would only register one type per parent since it

ignored relation tag when checking if the relation existed.

is_valid_type failed with more than one type since it wanted to count

max_n but did not sum.

needs an upgrade script.

bumping up version name to 4.7d1 (Lars forgot to do that when he added the upgrade scripts for the new mime types)

forgot about all of the trigger work-arounds for data-change violation problem that no longer exists. Fixed now.

  1. … 7 more files in changeset.
forgot about all of the trigger work-arounds for data-change violation problem that no longer exists. Fixed now.

  1. … 3 more files in changeset.
Eliminated acs_privilege_hierarchy_index in favor of using acs_privilege_descendant_map. In addition, rewrote trigger for creating acs_privilege_descendant_map as permissions creation was getting too slow on .LRN. .LRN has somewhere in the neighborhood of 90 entries in the privilege hierarchy, which is much higher than anticipated.

file_extension not always defined

Added a note that joining is more efficient than using the get_live_revision function

fixed mangled queries

    • -1
    • +1
    ./tcl/acs-content-repository-procs-oracle.xql
    • -1
    • +1
    ./tcl/acs-content-repository-procs.xql
Added check for table name longer than 25 chars, because that caused me significant pain to track this problem down.

Adding new mime-types, which I forgot to add back when I added the new richtext widget. Jeff will probably go in and rename them something else for me, and hopefully he'll propagate the change to the richtext widget and acs-tcl/tcl/text-html-procs as well.

    • -0
    • +7
    ./sql/oracle/upgrade/upgrade-4.6.1-4.7d1.sql
    • -0
    • +7
    ./sql/postgresql/upgrade/upgrade-4.6.1-4.7d1.sql