• last updated 3 hours ago
Constraints: committers
Constraints: files
Constraints: dates
use SQL functions (instead of plpgsql) defined as stabe and strict for

* content_folder__is_folder

* content_folder__is_sub_folder, and

* content_folder__is_empty

... having as well more sane constructs returning boolean values

  1. … 2 more files in changeset.
improve performance of content_folder__is_sub_folder

  1. … 2 more files in changeset.
improve spelling

  1. … 35 more files in changeset.
Fix typos

  1. … 14 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

  1. … 7834 more files in changeset.
Allow copy of files/folders into the same folder of the original content. This is done by appending a numerical suffix to the name.

It required modifying copy stored procedures so they could accept a different name and title for the copy.

I have also removed redundant package definition in oracle code that was immediately overridden afterwards.

  1. … 12 more files in changeset.
- Fix type of v_is_registered in dql function content_folder__register_content_type to boolean (was "varchar")

(This chance is necessary at least for pg 9.5)

  1. … 2 more files in changeset.
- fix type of v_is_registered to boolean. This fix is necessary at least under pg 9.5

  1. … 1 more file in changeset.
Bring PostgreSQL functions closer to the current level of PL/pgSQL:

- upgrade PL/pgSQL functions to the $$ notation (recommended since pg8.0, jan 2005).

- get rid of backslash usages in function definitions

- drop aliases in favor of named function arguments (recommended since pg8.0)

- fix wrong function_args, add missing function_args, align default semantics

with the defaults in pg (providing "null" as default means the argument is


- change return types of triggers from "opaque" to "trigger" (recommended since pg8.0)

- unify names of triggers *_tr

- removed some version dependencies of pg 7.2 and 7.3

  1. … 54 more files in changeset.
Checking that the copy.name is not null when copying it to same parent folder

of the source folder.

  1. … 3 more files in changeset.
Adding basic checks to content_folder.copy procedure in order to avoid

infinit loops.

  1. … 4 more files in changeset.
fix more function_args, fix comment for default values in stored procedures

  1. … 2 more files in changeset.
Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.


1. Bump acs-core package version numbers to 5.3.0d1

2. Would be nice to do a test install, wouldn't it?

  1. … 721 more files in changeset.
Remove code that guesses package_id based on parent_id. In almost all cases

this will return null anyway.

  1. … 2 more files in changeset.
Changes to make the root of parentless items = -4 (security context root) instead of 0 (unregistered visitor)

Sites upgradeed from 4.6-4.6.1 have been operating with -4 as the parent_id for years (for example openacs.org) while new installs had

parent_id = 0. This caused problems with the new package_id code that calls content_item__get_root_folder which was assuming the root =

0. It looks like the new install code did not accomodate parent_id=-4 and that is now fixed.

Needs testing on Oracle.

  1. … 7 more files in changeset.
Allow folders to have non-cr_items are parents

Moving folders was broken. Adding the correct definitios of

content_folder__move function.

Fix define function args for content_folder__is_folder to match oracle.

  1. … 2 more files in changeset.
fix laundry list of bugs in content repository copy code.

duplicate version of the 11arg content_folder__new

copy_creation_ip rather than copy__creation_ip in content_revision__copy

content_folder__copy did not preserve context_id properly

content_item__copy2 had a bunch of unused varaibles -- removed them.

content_item__copy now preserves live_revision so things which copy an

item with a live revision to not have to explicitly publish the new copy

(which eg file storage did not do).

content_revision__copy did an insert into acs_objects without specifying

column names which breaks on a new install since the order is not as expected.

  1. … 3 more files in changeset.
minor fix: move_name should have been move__name

  1. … 1 more file in changeset.
Add content_folder__move function that allows rename on move. Already existed on Oracle.

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20050111 and jcd-merge-5-1-20050224

  1. … 321 more files in changeset.
Fix content_folder__is_subfolder pl/sql. Also fix tcl proc which was

passing in the wrong list format to package_exec_plsql. Add upgrade

script and tests.

  1. … 5 more files in changeset.
commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

  1. … 2275 more files in changeset.
fix to return folder id present in upgrade. just putting it here as well

Set package_id from content_folder__new

  1. … 2 more files in changeset.
Add CR Tcl API from HEAD.

  1. … 17 more files in changeset.
bad quoting of string literal in plpgsql functions

add define_function_args definitions for most functions, bump to 5.2.0d5, upgrade script

  1. … 9 more files in changeset.
merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040517 and jcd-merge-5-1-20040628 to HEAD

  1. … 687 more files in changeset.