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

content-revision-procs-oracle.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 7
Last Commit: 05 Apr
Commits this week: 0
Total Lines of Code (LoC): 64
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 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 06 Apr 2021
9:16 pm

gustafn

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.

Options
    • -3
    • +10
    ./content-revision-procs-oracle.xql
  2. … 7 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
    • -10
    • +21
    ./content-revision-procs-oracle.xql
  2. … 16 more files in changeset.
Wednesday 15 Aug 2018
6:59 pm

gustafn

Removed obsolete @arch-tag

Options
    • -2
    • +1
    ./content-revision-procs-oracle.xql
  2. … 29 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -10
    • +1
    ./content-revision-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
    • -10
    • +1
    ./content-revision-procs-oracle.xql
  2. … 15 more files in changeset.
Thursday 23 Jul 2009
2:30 pm

miguelc

fix for an error with Oracle, which din't find get_cr_file_path.get_storage_key_and_path query.

Options
    • -1
    • +12
    ./content-revision-procs-oracle.xql
Wednesday 31 May 2006
3:42 pm

daveb

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.)

Options
    • -1
    • +29
    ./content-revision-procs-oracle.xql
  2. … 6 more files in changeset.
Wednesday 29 Mar 2006
1:22 pm

emmar

Added missing query item_id

Options
    • -1
    • +9
    ./content-revision-procs-oracle.xql
Thursday 24 Feb 2005
2:41 pm

jeffd

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

Options
    • -3
    • +13
    ./content-revision-procs-oracle.xql
Wednesday 23 Feb 2005
11:24 am

timoh

bugfix: fixed bug with lob-columns in attributes

Options
    • -1
    • +10
    ./content-revision-procs-oracle.xql
  2. … 1 more file in changeset.
Sunday 13 Feb 2005
3:10 am

donb

commiting Daveb's oracle fixes ...

Options
    • -3
    • +3
    ./content-revision-procs-oracle.xql
  2. … 2 more files in changeset.
Thursday 10 Feb 2005
8:06 pm

daveb

Switch to support oracle 8.1.6

Options
    • -2
    • +2
    ./content-revision-procs-oracle.xql
8:06 pm

daveb

Switch to support oracle version 8.1.6

Options
    • -2
    • +2
    ./content-revision-procs-oracle.xql
2:40 am

daveb

Insert content as BLOB in seperate query.

Options
    • -0
    • +25
    ./content-revision-procs-oracle.xql
  2. … 2 more files in changeset.
Wednesday 09 Feb 2005
5:14 pm

daveb

Remove broken generic query.

Add correct Oracle specific blob compatible query.

Options
    • -0
    • +25
    ./content-revision-procs-oracle.xql
  2. … 4 more files in changeset.
5:14 pm

daveb

file content-revision-procs-oracle.xql was initially added on branch oacs-5-1.

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