file-storage-package-create.sql

  • last updated 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fixes for Oracle 19c: fix broken variable references (introduced in oacs-5-9)

  1. … 1 more file in changeset.
Fixes for Oracle 19c: added missing SQL package declaration

    • -1
    • +147
    ./file-storage-package-create.sql
merged changes from the oacs-5-9 branch and resolved conflicts

    • -153
    • +9
    ./file-storage-package-create.sql
  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.

    • -153
    • +9
    ./file-storage-package-create.sql
  1. … 12 more files in changeset.
First shot at merging oacs-5-2 apps used in .LRN to HEAD.

  1. … 2478 more files in changeset.
1. Got rid of some extraneous notification comments

2. Fixed bug 2851 for Oracle (it was fixed previously for Postgres)

  1. … 5 more files in changeset.
file_storage.get_title to return cr_revisions.title of the live revision instead of cr_items.name

  1. … 2 more files in changeset.
Added callbacks for integration with PM. Made sure the package_id is set correctly

  1. … 61 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.
Changed CR "rename" procs to "edit_name" to avoid issues with Oracle 9.2 (and

changed PG for consistency)

  1. … 25 more files in changeset.
Fixed Bug #1858: qualifying "rename" works in 8i bug chokes in 9i causing

the reported error on installation. Fixed by changing the name to "edit_name"

and implemented it for PG as well (to keep names similar)

  1. … 28 more files in changeset.
merge changes on oacs-5-1 branch to head, changes between jcd-merge-20040420 and jcd-merge-5-1-20040517 were merged, head pre changes is jcd-merge-pre-20040517 and post is jcd-merge-post-20040517

  1. … 834 more files in changeset.
Adding optional cascade_p parameter to file_storage__delete_folder to support

deleting of folder contents.

  1. … 1 more file in changeset.

Fix new_root_folder for oracle.

  1. … 1 more file in changeset.
Put fs::new_root_folder tcl procedure back in. It has new optional parameters

but should behave the same as the original procedure.

  1. … 4 more files in changeset.
Give root folders for each package a unique cr_items.name in case multiple

package instances called "File Storage" are mounted. Fixed bug#1332

  1. … 10 more files in changeset.
Fix bug#1029. Originally added to HEAD

  1. … 3 more files in changeset.
Update last modified of the content item when a new revision is added.

Fixes bug#1029

  1. … 3 more files in changeset.
Removing unused file-add-2.

Simplified upgrade to swap name and title.

Added upgrade for oracle and fixed oracle functions.

    • -18
    • +17
    ./file-storage-package-create.sql
  1. … 8 more files in changeset.
Clean up postgresql functions so name refers to name and title refers to title.

Move everything into one upgrade script.

  1. … 6 more files in changeset.
Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

    • -10
    • +10
    ./file-storage-package-create.sql
  1. … 275 more files in changeset.
Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

  1. … 816 more files in changeset.
add user id and IP address to update_last_modified()

  1. … 10 more files in changeset.
merge of 4.6.3b1 to HEAD

  1. … 64 more files in changeset.
Fixed typo in PG upgrade script ("can''t" vs. "can't") and added symlinks

as registered content types to folders in order to ease further extension

of the semantics of file-storage.

  1. … 3 more files in changeset.
1. One fix to track APM changes made by Peter, in acs-subsite

2. changed attachments to use cr_extlinks

3. Fixed a couple of problems with my prior commit to file-storage that

removed fs_urls.

  1. … 3 more files in changeset.
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.

  1. … 46 more files in changeset.
Roll in fixes from sloan.

Adds folder-edit to rename folders.

some bug fixes in postgresql procs.

Adds file_upload_name to fs views.

Supports upload of files with unkown mimetype (needs change to acs-kernel datamodel)

changed vendor to openacs.

Needs db upgrade script. Notched version from 4.1c to 4.2

  1. … 27 more files in changeset.
Added stuff to form processing including the new form builder type

"file" which is a bit cleaner than the widget-only kludge which existed

before.

  1. … 11 more files in changeset.
changed from using content_item.update_last_modified to acs_object.update_last_modified

  1. … 3 more files in changeset.