OpenACS / openacs-4 / packages / acs-content-repository / tcl

acs-content-repository-procs-oracle.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 5
Last Commit: 14 Nov
Commits this week: 0
Total Lines of Code (LoC): 25
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 21 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -5
    • +14
    ./acs-content-repository-procs-oracle.xql
  2. … 8099 more files in changeset.
Monday 22 Feb 2021
12:47 pm

gustafn

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.

Options
    • -5
    • +14
    ./acs-content-repository-procs-oracle.xql
  2. … 16 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -6
    • +0
    ./acs-content-repository-procs-oracle.xql
  2. … 7834 more files in changeset.
Saturday 02 Jan 2016
3:31 pm

gustafn

.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

Options
    • -6
    • +0
    ./acs-content-repository-procs-oracle.xql
  2. … 15 more files in changeset.
Monday 27 Oct 2014
5:38 pm

victorg

Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

Options
    • -0
    • +6
    ./acs-content-repository-procs-oracle.xql
  2. … 2547 more files in changeset.
Wednesday 25 Dec 2013
5:10 pm

gustafn

- 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

Options
    • -0
    • +6
    ./acs-content-repository-procs-oracle.xql
  2. … 6 more files in changeset.
Tuesday 29 Mar 2005
3:50 pm

timoh

provided default template in oracle

Options
    • -0
    • +44
    ./acs-content-repository-procs-oracle.xql
  2. … 5 more files in changeset.
Wednesday 19 Mar 2003
10:05 pm

jeffd

comma missing between crftd.path, crftd.storage_area_key

Options
    • -1
    • +1
    ./acs-content-repository-procs-oracle.xql
Thursday 13 Feb 2003
3:42 pm

danw

fixed mangled queries

Options
    • -1
    • +1
    ./acs-content-repository-procs-oracle.xql
  2. … 1 more file in changeset.
Tuesday 14 Jan 2003
2:02 am

jeffd

Bad oracle fetch_paths query merged from oacs-4-6

Options
    • -1
    • +1
    ./acs-content-repository-procs-oracle.xql
2:01 am

jeffd

Bad oracle fetch_paths query closes bug 122/patch 40 C. R. Oldham

Options
    • -1
    • +1
    ./acs-content-repository-procs-oracle.xql
Saturday 30 Nov 2002
6:11 pm

jeffd

merge from oacs-4-6

Options
    • -0
    • +16
    ./acs-content-repository-procs-oracle.xql
  2. … 110 more files in changeset.
Friday 27 Sep 2002
5:03 pm

danw

file acs-content-repository-procs-oracle.xql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./acs-content-repository-procs-oracle.xql
5:02 pm

danw

fixed file sweeper proc for oracle

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