OpenACS / openacs-4 / packages / acs-content-repository / sql / oracle

content-item.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 13
Last Commit: 08 Aug 17
Commits this week: 0
Total Lines of Code (LoC): 1,768
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
Monday 21 Feb 2022
7:20 pm

gustafn

Fixes for Oracle 19c: made set_live_revision compatible with postgres version

Options
    • -14
    • +24
    ./content-item.sql
  2. … 1 more file in changeset.
Sunday 13 Feb 2022
12:46 pm

gustafn

More fixes for Oracle 19c in essential packages

in essence, this fixes

- package content_item

- package content_folder

with the following errors popping at at installation:

Errors for PACKAGE BODY CONTENT_FOLDER:

LINE/COL ERROR

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

76/11 PLS-00323: subprogram or cursor 'COPY' is declared in a package

specification and must be defined in the package body

Errors for PACKAGE BODY CONTENT_ITEM:

LINE/COL ERROR

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

22/10 PLS-00323: subprogram or cursor 'NEW' is declared in a package

specification and must be defined in the package body

40/1 PL/SQL: Item ignored

67/38 PLS-00382: expression is of wrong type

275/11 PLS-00323: subprogram or cursor 'SET_LIVE_REVISION' is declared

in a package specification and must be defined in the package

body

DRG-10595: ALTER INDEX CR_REV_ATTRIBUTE_INDEX failed

DRG-11000: invalid keyword SYNC

DRG-10595: ALTER INDEX CR_REV_CONTENT_INDEX failed

DRG-11000: invalid keyword SYNC

Options
    • -2
    • +2
    ./content-item.sql
  2. … 2 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -5
    • +8
    ./content-item.sql
  2. … 7834 more files in changeset.
Saturday 13 Feb 2016
4:31 pm

gustafn

Content-Repository Reform: reduce dependency on cr_child_rels and make

creation of cr_child_rels entries optional. Most applications do not

need cr_child_rels, these take substantial space and slow down

operations. The change is fully backward compatible, since per

default cr_child_rels are still created. First tests show an

improvement for the creation of cr_items by 17% and for deletion by

28% (when parent item is a plain cr_item, as it is e.g. the case in

xwowiki). Same change made as well for Oracle.

- affected functions (here with pg-names)

* procedure content_item__new/21 (version for text or file entries) has new optional boolean parameter: with_child_rels

* procedure content_item__new/17 (version for blob entries) has new optional boolean parameter: with_child_rels

- remove/reduce dependency on cr_child_rels (if no rel-tag is used, the chile-information is obtained from cr_items)

* content_item__is_publishable/1

* content_item__is_valid_child/3

* content_item__is_valid_child/2

- reduce number of functions by using defaults

* content_item__copy/5

* content_item__get_title/2

* content_item__move/3

Options
    • -3
    • +5
    ./content-item.sql
  2. … 4 more files in changeset.
Tuesday 02 Feb 2016
2:14 pm

gustafn

- Add argument to content_item__set_live_revision (and oracle's counterpart)

to honor optionally provided "publish_date". The old behavior used hard-coded

the current time. The function is fully backward compatible, when no

publish_date is provided, the current time is used for the publish_date.

- changes for PostgreSQL and Oracle.

Options
    • -3
    • +4
    ./content-item.sql
  2. … 4 more files in changeset.
Wednesday 11 Jun 2008
2:10 am

donb

Got rid of stupid logging of delete operations, just as I did on PG.

Options
    • -12
    • +1
    ./content-item.sql
Sunday 04 Jun 2006
2:45 am

donb

Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.

TODO:

1. Bump acs-core package version numbers to 5.3.0d1

2. Would be nice to do a test install, wouldn't it?

Options
    • -20
    • +13
    ./content-item.sql
  2. … 721 more files in changeset.
Thursday 12 Jan 2006
7:25 pm

daveb

Remove code that guesses package_id based on parent_id

Options
    • -12
    • +5
    ./content-item.sql
  2. … 2 more files in changeset.
Thursday 29 Dec 2005
2:24 am

daveb

Changes to make the root of parentless items = -4 (security context root) instead of 0 (unregistered visitor)

Sites upgradeed from 4.6-4.6.1 have been operating with -4 as the parent_id for years (for example openacs.org) while new installs had

parent_id = 0. This caused problems with the new package_id code that calls content_item__get_root_folder which was assuming the root =

0. It looks like the new install code did not accomodate parent_id=-4 and that is now fixed.

Needs testing on Oracle.

Options
    • -10
    • +10
    ./content-item.sql
  2. … 7 more files in changeset.
Saturday 12 Mar 2005
8:22 pm

andrewg

Bugfix

Options
    • -2
    • +2
    ./content-item.sql
  2. … 1 more file in changeset.
Thursday 24 Feb 2005
2:32 pm

jeffd

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

Options
    • -3
    • +4
    ./content-item.sql
  2. … 321 more files in changeset.
Monday 31 Jan 2005
8:29 am

timoh

fixed some upgrade scripts for oracle

Options
    • -3
    • +5
    ./content-item.sql
  2. … 7 more files in changeset.
Saturday 24 Jul 2004
10:33 am

jeffd

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

Options
    • -1
    • +5
    ./content-item.sql
  2. … 138 more files in changeset.
Tuesday 20 Jul 2004
5:03 pm

janine

add view content_item_globals, which already exists for PG but was missing for Oracle

Options
    • -1
    • +5
    ./content-item.sql
  2. … 2 more files in changeset.
Tuesday 29 Jun 2004
12:17 pm

jeffd

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040517 and jcd-merge-5-1-20040628 to HEAD

Options
    • -1
    • +1
    ./content-item.sql
  2. … 687 more files in changeset.
Wednesday 02 Jun 2004
12:54 am

donb

Changed CR "rename" procs to "edit_name" to avoid issues with Oracle 9.2 (and

changed PG for consistency)

Options
    • -9
    • +9
    ./content-item.sql
  2. … 25 more files in changeset.
Wednesday 26 May 2004
8:50 pm

donb

Further fixing of bug #1858

Options
    • -7
    • +7
    ./content-item.sql
  2. … 3 more files in changeset.
Monday 17 May 2004
5:14 pm

jeffd

merge changes on oacs-5-1 branch to head, changes between jcd-merge-20040420 and jcd-merge-5-1-20040517 were merged, head pre changes is jcd-merge-pre-20040517 and post is jcd-merge-post-20040517

Options
    • -6
    • +6
    ./content-item.sql
  2. … 834 more files in changeset.
Friday 23 Apr 2004
6:16 pm

daveb

Fix content_item.rename to actually have an effect.

Options
    • -5
    • +5
    ./content-item.sql
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
    • -7
    • +7
    ./content-item.sql
  2. … 647 more files in changeset.
Friday 09 Apr 2004
4:00 pm

andrewg

various bug fixes for package_id, title addition to acs_objects

Options
    • -2
    • +2
    ./content-item.sql
  2. … 4 more files in changeset.
Tuesday 16 Mar 2004
7:33 pm

rocaelh

fixing bug 1598

Options
    • -7
    • +7
    ./content-item.sql
  2. … 1 more file in changeset.
Friday 12 Mar 2004
7:48 pm

jeffd

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

Options
    • -3
    • +36
    ./content-item.sql
  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
    • -35
    • +2
    ./content-item.sql
  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
    • -3
    • +36
    ./content-item.sql
  2. … 96 more files in changeset.
Monday 01 Mar 2004
12:55 pm

marka

modified content_item.get_title to return a useful label for extlinks (postgres and oracle)

Options
    • -1
    • +4
    ./content-item.sql
  2. … 1 more file in changeset.
Saturday 24 Jan 2004
6:54 pm

daveb

Fix content_item.move and content_folder.move

Options
    • -9
    • +4
    ./content-item.sql
  2. … 2 more files in changeset.
Friday 23 Jan 2004
4:18 am

daveb

Fix missing commas in function definitions

Options
    • -4
    • +4
    ./content-item.sql
Thursday 22 Jan 2004
4:39 am

daveb

Added optional name parameter to content_item.copy and content_item.move.

Options
    • -17
    • +40
    ./content-item.sql
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -7
    • +5
    ./content-item.sql
  2. … 598 more files in changeset.