content-revision-procs-postgresql.xql

  • last updated 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
new function: ::content::revision::export_to_filesystem

This change moves functionality from file-storage to acs-content-repository.

all application packages should be free of internals, such as the storage

type. Storage_type should be handeled in the content-repository package.

We are not yet done, there is still more to do in this respect in

the file-storage package.

    • -1
    • +9
    ./content-revision-procs-postgresql.xql
  1. … 7 more files in changeset.
Refactor content repository backend

The refactored code is a first step to become able to provide plugins

for backends for storing content in different systems. Instead of

using switch statements to distinguish between backends "file", "lob"

and "text", procs with a suffix of the storage name are provided

now. Essentially, by providing process with additional suffixes can be

used to provide additional storage systems.

In addition, the deletion handling was also refactored such that the

non-scalable functions iterating over all items (such as

"cr_check_orphaned_files") will become obsolete. This is imporant for

content repositories with double and triple digit terabytes.

    • -22
    • +4
    ./content-revision-procs-postgresql.xql
  1. … 16 more files in changeset.
Removed obsolete @arch-tag

    • -2
    • +1
    ./content-revision-procs-postgresql.xql
  1. … 29 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

    • -2
    • +2
    ./content-revision-procs-postgresql.xql
  1. … 7834 more files in changeset.
- prefer sql statements between curly braces

    • -2
    • +2
    ./content-revision-procs-postgresql.xql
  1. … 10 more files in changeset.
Initial image api to imagemagick to create optional thumbnails and medium file sizes. Need to add parameters and make executable path handling smarter

    • -1
    • +11
    ./content-revision-procs-postgresql.xql
  1. … 2 more files in changeset.
Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.

TODO:

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

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

    • -2
    • +2
    ./content-revision-procs-postgresql.xql
  1. … 721 more files in changeset.
Add -tmp_filename parameter to content::item::new and

content::revision::new to handle file uploads at a low level with the

cr tcl api. You still need to figure out the mime type and cotent type

(image,etc.) before calling content::item::new. A convenience wrapper

should be written if you need that feature. (that would replace

cr_import_content, it think.)

    • -1
    • +40
    ./content-revision-procs-postgresql.xql
  1. … 6 more files in changeset.
Added procedure to retrieve the item_id

    • -1
    • +9
    ./content-revision-procs-postgresql.xql
  1. … 1 more file in changeset.
Insert content as BLOB in seperate query.

    • -0
    • +24
    ./content-revision-procs-postgresql.xql
  1. … 2 more files in changeset.
Remove broken generic query.

Add correct Oracle specific blob compatible query.

    • -0
    • +24
    ./content-revision-procs-postgresql.xql
  1. … 4 more files in changeset.
file content-revision-procs-postgresql.xql was initially added on branch oacs-5-1.

    • -0
    • +0
    ./content-revision-procs-postgresql.xql