content-revision-procs-oracle.xql

  • last updated 12 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.

    • -3
    • +10
    ./content-revision-procs-oracle.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.

    • -10
    • +21
    ./content-revision-procs-oracle.xql
  1. … 16 more files in changeset.
Removed obsolete @arch-tag

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

    • -10
    • +1
    ./content-revision-procs-oracle.xql
  1. … 7834 more files in changeset.
.xql-file reform of acs-content-repository

- remove sql statements from the code, where these are provided via .xql

- prefer empty sql statements over various forms of *SQL*

- remove unneeded sql queries

cr_check_orphaned_files.fetch_path

content::item::upload_file.get_parent_existing_filenames

content::revision::new.update_lob_attribute

content::init_all.get_template_url

content::init.get_live_revision

content::init_all.get_live_revision

cr::keyword::item_unassign.item_unassign

cr::keyword::get_keyword_id.select_keyword_id

cr::keyword::item_unassign_children.item_unassign_children

cr::keyword::item_get_assigned.get_keywords

cr::keyword::item_get_assigned.get_child_keywords

cr::keyword::get_options_flat.select_keyword_options

publish::write_content.get_revision_id

    • -10
    • +1
    ./content-revision-procs-oracle.xql
  1. … 15 more files in changeset.
fix for an error with Oracle, which din't find get_cr_file_path.get_storage_key_and_path query.

    • -1
    • +12
    ./content-revision-procs-oracle.xql
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
    • +29
    ./content-revision-procs-oracle.xql
  1. … 6 more files in changeset.
Added missing query item_id

merge change by hand because the file was manually added on head.

    • -3
    • +13
    ./content-revision-procs-oracle.xql
bugfix: fixed bug with lob-columns in attributes

    • -1
    • +10
    ./content-revision-procs-oracle.xql
  1. … 1 more file in changeset.
commiting Daveb's oracle fixes ...

  1. … 2 more files in changeset.
Switch to support oracle 8.1.6

Switch to support oracle version 8.1.6

Insert content as BLOB in seperate query.

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

Add correct Oracle specific blob compatible query.

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

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