file-storage-procs-oracle.xql

  • last updated 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
While working on reducing divergencies between oracle and postgres codebase and testing changes I have found the following issues:

- fs::add_created_version.new_text_revision query was defined in postgres only

- version-delete and folder-delete were broken in case notification was enabled,

because this was issued after object was deleted and therefore all references

needed to build notification message were missing (and query failed looking up the object)

  1. … 4 more files in changeset.
Reduce divergency between oracle and postgres codebase

  1. … 2 more files in changeset.
Fix oracle systax to call function via select

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

  1. … 7834 more files in changeset.
Fixes Bug#3176 remove extra column from subquery in where clause

1. Merge 2.4.1 to HEAD other than assessment, imsld, lorsm, and views.

2. Bump version numbers to 2.5.0d1.

  1. … 379 more files in changeset.
First shot at merging oacs-5-2 apps used in .LRN to HEAD.

  1. … 2478 more files in changeset.
added query for fs::notification::get_url

  1. … 1 more file 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.
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.
Fixing bug '#19 Enable notifications on file upload'. Modified patch #534 to make it actually work on HEAD. Should work for Oracle as well but not tested on that db yet. This could do with some cleanup, and i18n-ization.

  1. … 19 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.
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.
merge all the changes on the oacs-5-1 and dotlrn-2-0 branches up to tag jcd-merge-20040420

  1. … 647 more files 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.
The rest of the UI changes

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

  1. … 64 more files in changeset.
Date/time/number localization

  1. … 85 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 some optional parameters to make fs procs more modular for attachments

  1. … 2 more files in changeset.
created a rename_folder method.

  1. … 2 more files in changeset.
tune folder contents query

  1. … 2 more files in changeset.
added support for publishing fs_objects to the file system; also added some archiving infrastructure stuff

  1. … 14 more files in changeset.
mistakenly commited some stuff i didn't want to yet

  1. … 2 more files in changeset.
adding folder-contents view (altough it's not linked yet) and other fixes

  1. … 6 more files in changeset.
added updating of last_modified time of folders when certain actions are performed within them; i hope the postgresql version works

  1. … 20 more files in changeset.
added PG support for new simple objects (not fully tested yet)

  1. … 9 more files in changeset.
some code for seeing if files are newer than a certain number of days ago

  1. … 2 more files in changeset.