folder-chunk-postgresql.xql

  • last updated 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fix typo

Refactor the query in the folder-chunk page so that on postgres one can enforce permissions in bulk, rather than for each file

  1. … 2 more files in changeset.
Reduce divergency between Oracle and Postgres codebase

  1. … 2 more files in changeset.
Put template::list name back as parametric, because this code might be included multiple times

  1. … 3 more files in changeset.
Redefine this page as ad_include_contract, therefore removing all hardcoded variable checks and exploit builtin checks, remove duplicated definitions and queries, streamline template::list definitions in a way its is readable and simpler to maintain

  1. … 3 more files in changeset.
Reduce divergencies between oracle and postgres codebase

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

  1. … 7834 more files in changeset.
- reduce dependencies on acs_object_party_privilege_map (for PostgreSQL)

  1. … 3 more files in changeset.
Using acs_permission__permission_p for checking persmissions instead of querying view acs_object_party_privilege_map (for PG >= 8.4).

  1. … 4 more files in changeset.
Encode files URL properly (would fail if the filename had a plus sign, sharp one etc in it)

  1. … 3 more files in changeset.
Moving categories_limitation partial query to a db_map

  1. … 2 more files in changeset.
Adding support for the categorization of files (if the CategoriesP parameter is enabled for a package instance). Version is increased to 5.4.0d3 and folder, file and simple www/*-edit-2 files were removed and consolidated into www/*-edit.

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

  1. … 2478 more files in changeset.
Fixed bug #2817: order by clause in folder-chunk.tcl wasn't implemented for

Oracle. Very simple fix (sigh).

  1. … 2 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.
Patch#538. Use filename instead of title for link text.

  1. … 7 more files in changeset.
Fix view URLs broken by title display change.

  1. … 1 more file 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.
Show title on folder listing. If filename is different than title, show that as well. Show cr_mime_types.label mime type description instead of techincal mime type "code".

  1. … 6 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.
Remove permissions checks for extlinks. Moved to a seperate view/edit page

similar to how files are handled.

  1. … 2 more files in changeset.
merge of changes between oacs-5-0-0b4 and oacs-5-0-0-final to HEAD

  1. … 286 more files in changeset.
User interface work, ad_form and listbuilder support added.

  1. … 7 more files in changeset.
Pulled out the call to get__path from the main query in 'folder-chunk' and added a separate query before that db_multirow - suggested by Dave and Don for scalability reasons.

  1. … 2 more files in changeset.
Timezonized

  1. … 5 more files in changeset.
1. Added support for retrieval of live revision of files by their URL (a.k.a. virtual URLs).

This will make relative linking of images and sub-documents in HTML documents work.

As a small bonus, HTML and text documents will be templated, but only if they

are being stored in the db. Files stored in the file system look like before ...

2. Provided upgrade scripts for file-storage and the CR.

  1. … 14 more files in changeset.
last_modified became wrong during merge. Reverted to previous state.

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

  1. … 64 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.
Typo in query caused URLs to be listed many, many times