acs-content-repository-procs-oracle.xql

  • last updated 19 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
.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

    • -6
    • +0
    ./acs-content-repository-procs-oracle.xql
  1. … 15 more files in changeset.
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

    • -0
    • +6
    ./acs-content-repository-procs-oracle.xql
  1. … 2547 more files in changeset.
- use external command "find" instead of tcllib package fileutil for speed and better filtering

- add index for much quicker reverse lookup file names in the content repository

    • -0
    • +6
    ./acs-content-repository-procs-oracle.xql
  1. … 6 more files in changeset.
provided default template in oracle

    • -0
    • +44
    ./acs-content-repository-procs-oracle.xql
  1. … 5 more files in changeset.
comma missing between crftd.path, crftd.storage_area_key

    • -1
    • +1
    ./acs-content-repository-procs-oracle.xql
fixed mangled queries

    • -1
    • +1
    ./acs-content-repository-procs-oracle.xql
  1. … 1 more file in changeset.
Bad oracle fetch_paths query merged from oacs-4-6

    • -1
    • +1
    ./acs-content-repository-procs-oracle.xql
Bad oracle fetch_paths query closes bug 122/patch 40 C. R. Oldham

    • -1
    • +1
    ./acs-content-repository-procs-oracle.xql
merge from oacs-4-6

    • -0
    • +16
    ./acs-content-repository-procs-oracle.xql
  1. … 110 more files in changeset.
file acs-content-repository-procs-oracle.xql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./acs-content-repository-procs-oracle.xql
fixed file sweeper proc for oracle

    • -0
    • +16
    ./acs-content-repository-procs-oracle.xql
  1. … 2 more files in changeset.