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

revision-procs-oracle.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 1
Total Committers: 11
Last Commit: 16:43
Commits this week: 1
Total Lines of Code (LoC): 168
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 40 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Today
40 mins ago

antoniop

cr_write_content reform

when serving files, do not trust the content information, as the absolute path to the file can be determined programmatically in this case.

This also reduce divergency between Oracle and Postgres

Options
    • -8
    • +0
    ./revision-procs-oracle.xql
  2. … 2 more files in changeset.
Monday 05 Dec 2022
12:26 pm

gustafn

fix incorrect names in .xql files

Options
    • -1
    • +1
    ./revision-procs-oracle.xql
  2. … 1 more file 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
    • -1
    • +1
    ./revision-procs-oracle.xql
  2. … 16 more files in changeset.
Friday 23 Oct 2020
7:03 pm

gustafn

use bind variables instead of tcl variable substition in xql fullqueries

Options
    • -1
    • +1
    ./revision-procs-oracle.xql
  2. … 16 more files in changeset.
Friday 03 Jan 2020
11:46 am

antoniop

Whitespace cleanup

Options
    • -4
    • +4
    ./revision-procs-oracle.xql
  2. … 1 more file in changeset.
11:43 am

antoniop

Reduce divergency between oracle and postgres codebase, bring portable sql inline

Options
    • -41
    • +0
    ./revision-procs-oracle.xql
  2. … 3 more files in changeset.
Friday 22 Apr 2005
10:29 am

eduardop

bugfix: fixing bug #2402, bad merge

Options
    • -1
    • +0
    ./revision-procs-oracle.xql
Wednesday 20 Apr 2005
3:21 pm

eduardop

fix (people should try these changes first prior to commit)

Options
    • -1
    • +1
    ./revision-procs-oracle.xql
Thursday 13 Jan 2005
2:54 pm

jeffd

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

Options
    • -0
    • +2
    ./revision-procs-oracle.xql
  2. … 2275 more files in changeset.
Tuesday 07 Sep 2004
10:45 pm

andrewg

Fixing a typo.

Options
    • -1
    • +1
    ./revision-procs-oracle.xql
Friday 03 Sep 2004
5:58 pm

tracya

filestorage was displying the ugly filename instead of the pretty title for the main entry; also wasn't updating the filename to the newest upload (still need to ask DaveB about getting the links to work with the latest upload filename

Options
    • -1
    • +2
    ./revision-procs-oracle.xql
  2. … 7 more files in changeset.
Tuesday 20 Apr 2004
11:12 pm

jeffd

merge all the changes on the oacs-5-1 and dotlrn-2-0 branches up to tag jcd-merge-20040420

Options
    • -1
    • +2
    ./revision-procs-oracle.xql
  2. … 647 more files in changeset.
Thursday 01 Apr 2004
3:20 am

daveb

Fix content-length support to use proper header name and actually check in

the queries that grab content length from cr_revisions.

Options
    • -1
    • +2
    ./revision-procs-oracle.xql
  2. … 2 more files in changeset.
Friday 12 Mar 2004
7:48 pm

jeffd

Remerge Timo's changes for tip 42,43, cf tip 53

Options
    • -4
    • +8
    ./revision-procs-oracle.xql
  2. … 97 more files in changeset.
Thursday 04 Mar 2004
3:52 pm

jeffd

rollback of Timo's name, package_id commit; see TIP 53

Options
    • -8
    • +4
    ./revision-procs-oracle.xql
  2. … 96 more files in changeset.
Tuesday 02 Mar 2004
6:00 pm

timoh

TIP#42,43: adding package_id and title to acs_objects table

Options
    • -4
    • +8
    ./revision-procs-oracle.xql
  2. … 96 more files in changeset.
Wednesday 18 Jun 2003
3:43 pm

jeffd

seperate queries for oracle and postgres for cr_import_content.set_file_content

Options
    • -0
    • +10
    ./revision-procs-oracle.xql
  2. … 2 more files in changeset.
3:40 pm

jeffd

seperate queries for oracle and postgres for cr_import_content.set_file_content

Options
    • -0
    • +10
    ./revision-procs-oracle.xql
  2. … 2 more files in changeset.
Saturday 17 May 2003
11:35 am

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -36
    • +2
    ./revision-procs-oracle.xql
  2. … 101 more files in changeset.
Sunday 04 May 2003
1:51 am

donb

1. removed some needless LARS notices

2. removed acs_methods and friends from the permissions documentation

and got rid of the commented-out table stubs.

3. dropping of permissions was broken in PG, fixed that.

4. cc_users and registered_users views have been sped up.

5. removed an unused and incorrect proc from revision-procs

6. updated acs-kernel to 4.6.3

-------------------------------------------------------------------------------------

Options
    • -36
    • +0
    ./revision-procs-oracle.xql
  2. … 11 more files in changeset.
Saturday 26 Apr 2003
3:03 am

donb

title and mime_type weren't set for the initial revision of an image.

Options
    • -0
    • +2
    ./revision-procs-oracle.xql
Friday 14 Jun 2002
8:24 pm

arjun

fix to cr_import_content.content_revision_new to call the right PL/SQL proc

Options
    • -3
    • +3
    ./revision-procs-oracle.xql
Thursday 15 Nov 2001
2:47 am

donb

1. Fixed permissions bug in the PG version (missing OR clause in a view)

2. Added (untested thus far) site-wide-search to glossary

3. Added centralized support for importing files into the CR (either into

the filesystem or the database).

4. Fixed wp-slim. Fixed it some more. Fixed it again. It still needs

more fixing.

Options
    • -0
    • +130
    ./revision-procs-oracle.xql
  2. … 61 more files in changeset.
Wednesday 31 Oct 2001
9:42 pm

donb

1. Added a new Tcl procedure to the content repository's library, named

cr_write_content, which properly writes content to the connection

regardless of RDBMS and storage type. This simplified a bunch of stuff

(which explains the removed files).

2. Fixed a lot of general comments issues regarding HTML vs. Plain/Text,

attachments, etc.

3. Partially ported glossary.

Options
    • -0
    • +25
    ./revision-procs-oracle.xql
  2. … 81 more files in changeset.
Friday 27 Apr 2001
4:27 am

danw

ported templating to use standard db api

Options
    • -0
    • +31
    ./revision-procs-oracle.xql
  2. … 27 more files in changeset.