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

revision-procs-postgresql.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 8
Last Commit: 17 Dec
Commits this week: 0
Total Lines of Code (LoC): 138
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
    • -46
    • +9
    ./revision-procs-postgresql.xql
  2. … 8099 more files in changeset.
Friday 31 May
3:10 pm

antoniop

Revert https://cvs.openacs.org/changelog/OpenACS?cs=oacs-5-10%3Aantoniop%3A20240423144330

currently, file-storage will copy files by simply copying the revision entry of the new file from the original one. This means that copied files will in fact point to the same filesystem file of the original.

This "works" because the file-storage api will currently never delete a file from the filesystem, so deleting the original file will not affect the copies.

This behavior is probably not ideal, but we won't address it before the release, as to change it will most likely require some careful planning, in particular for existing installations.

Options
    • -0
    • +8
    ./revision-procs-postgresql.xql
  2. … 2 more files in changeset.
Tuesday 23 Apr
4:43 pm

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-postgresql.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-postgresql.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-postgresql.xql
  2. … 16 more files in changeset.
Friday 03 Jan 2020
11:46 am

antoniop

Whitespace cleanup

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

antoniop

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

Options
    • -37
    • +0
    ./revision-procs-postgresql.xql
  2. … 3 more files in changeset.
Wednesday 09 Oct 2019
5:22 pm

gustafn

Add cast (many thanks to Franz Penz for the change)

Options
    • -1
    • +1
    ./revision-procs-postgresql.xql
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -15
    • +20
    ./revision-procs-postgresql.xql
  2. … 7834 more files in changeset.
Monday 28 Nov 2016
8:53 pm

gustafn

- avoid call of deprecated sql variant with 12 args via API (many thnaks to Guenter Ernst)

- handling of NULL values in cr_revision_latest_tr (many thanks to Guenter Ernst)

- bump version to 5.9.1d24

Options
    • -12
    • +13
    ./revision-procs-postgresql.xql
  2. … 3 more files in changeset.
Wednesday 31 Aug 2016
12:55 pm

hectorr

Avoid using deprecated content_item__new/17

Options
    • -1
    • +5
    ./revision-procs-postgresql.xql
Tuesday 05 Jan 2016
3:55 pm

gustafn

- fix lob interface (especially for portraits)

Options
    • -1
    • +1
    ./revision-procs-postgresql.xql
  2. … 5 more files in changeset.
Saturday 02 Jan 2016
10:24 pm

gustafn

- prefer sql statements between curly braces

Options
    • -1
    • +1
    ./revision-procs-postgresql.xql
  2. … 10 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-postgresql.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-postgresql.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-postgresql.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-postgresql.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-postgresql.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-postgresql.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-postgresql.xql
  2. … 2 more files in changeset.
Saturday 17 May 2003
11:35 am

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -36
    • +0
    ./revision-procs-postgresql.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-postgresql.xql
  2. … 11 more files in changeset.
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
    • +135
    ./revision-procs-postgresql.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
    • +24
    ./revision-procs-postgresql.xql
  2. … 81 more files in changeset.
Thursday 03 May 2001
6:00 am

danw

tested lob support for content-repository. converted photo upload in acs-subsite to use lobs instead of files

Options
    • -3
    • +1
    ./revision-procs-postgresql.xql
  2. … 9 more files in changeset.
Friday 27 Apr 2001
4:27 am

danw

ported templating to use standard db api

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