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

content-item.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 18
Last Commit: 26 Apr
Commits this week: 0
Total Lines of Code (LoC): 2,466
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
Monday 04 Sep 2017
8:25 am

gustafn

Fix typo in variable name "new_nls_language" (must be "new__nls_language")

Options
    • -2
    • +2
    ./content-item.sql
  2. … 2 more files in changeset.
8:23 am

gustafn

Fix typo in variable name "new_nls_language" (must be "new__nls_language")

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
    • -767
    • +250
    ./content-item.sql
  2. … 7834 more files in changeset.
Friday 21 Apr 2017
4:53 pm

gustafn

Fix spelling errors

Options
    • -3
    • +3
    ./content-item.sql
  2. … 49 more files in changeset.
2:21 pm

antoniop

Performance improvement in content_item__get_path stored procedure (thanks to Thomas Renner)

Options
    • -8
    • +10
    ./content-item.sql
  2. … 2 more files in changeset.
Sunday 27 Nov 2016
11:10 am

gustafn

Reduced generation of dead tuples in postgres.

Background: In the old version, the fields latest and live

revisions were updated always via two separate dmlDML statements.

Every update causes in PostgreSQL (tested to pg 9.6) one more dead

tuple, such that on busy systems, we see 30k + dead tuples per

hour. These dead tuples in turn cause more auto vacuum operations

and can lead to abandoned query plans.

This change can reduce the number of dead tuples on cr_items into

half, by allowing both fields to be set in one operation (namely

content_item__set_live_revision). This function has an optional 4th

argument that can cause this optimization. For legacy applications,

nothing changes.

Btw: since all commonly used applications use the live revision, the

fallback of the latest_revision is unused. One can consider to

remove the cr_revision_latest_tr, at least on on certain

installations.

bump revision to 5.1.9d23

Options
    • -23
    • +31
    ./content-item.sql
  2. … 3 more files in changeset.
Monday 16 May 2016
12:38 pm

gustafn

- Change text enumeration field "storage_type" in cr_items to native

SQL enumeration type

- bump version number to 5.9.1d15

Options
    • -4
    • +4
    ./content-item.sql
  2. … 3 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
    • -178
    • +96
    ./content-item.sql
  2. … 4 more files in changeset.
Thursday 11 Feb 2016
9:07 am

gustafn

Content-Repository Reform: reduce dependency on cr_child_rels and simplify content_item__del() via cascading delete operations

- remove manual deletion operations from content_item__del() via

* delete cr_child_rels via "ON DELETE CASCADE" on parent_id and child_id

* delete cr_item_rels via "ON DELETE CASCADE" on item_id

* delete acs_object_context_index entries via "ON DELETE CASCADE" on ancestor_id and object_id

* delete acs_objects entries via "ON DELETE CASCADE" on context_id

- remove manual deletion operations for symlinks amd journal entries,

since db constrains handle the deletion already

- use cr_items.parent_id instead of cr_child_rels to determine direct children

of items

- remove deletion trigger for content search content_search__dtrg

since "ON DELETE CASCADE" removes entries already

Options
    • -42
    • +15
    ./content-item.sql
  2. … 3 more files in changeset.
Wednesday 10 Feb 2016
10:14 am

gustafn

Content-Repository Reform : Reduction of number of functions in

the content repository for PostgreSQL by using using argument defaults

(while providing compatibility for clients using old versions):

- reduced number of versions of content_item__new from 12 (!) to 6 by using defaults

- commented differences

- commented arguments of plpgsql functions with long argument lists

- reduced code duplication by basing one version of content_item__new/17 directly on /20

- marking on version of content_item__new/17 and content_item__new/6 as deprecated

- reduced number of versions of content_revision__new from 7 to 4 by using defaults

- commented differences

- marking on version of content_revision__new/7 as deprecated

- let automatically generated functions call directly content_revision__new/13

- remove space from automatically generated functions

- updated automatically generated functions for all types of the content repository

- reduced number of versions of image__new from 4 to 2by using defaults

- reduced number of versions of image__new_revision from 2 to 1 by using defaults

Options
    • -399
    • +93
    ./content-item.sql
  2. … 7 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
    • -45
    • +6
    ./content-item.sql
  2. … 4 more files in changeset.
Friday 25 Sep 2015
12:45 pm

gustafn

- white-space changes

Options
    • -24
    • +0
    ./content-item.sql
11:03 am

gustafn

- remove redundant function_args definitions

Options
    • -74
    • +25
    ./content-item.sql
Sunday 03 May 2015
2:32 pm

gustafn

Scalability reform part 3 (content-repository):

- content_revision__del:

* Removed manual nulling of live_revision and latest_revision

by using appropriate ond delete actions on foreign keys

* Removed manual deletion of old_revision and new_revision in

cr_item_publish_audit by using "on delete cascade"

- content_item__del:

* Removed manual deletion of item_id in cr_item_publish_audit

by using "on delete cascade"

* Removed manual deletion of item_id in cr_release_periods

by using "on delete cascade"

* Removed manual deletion of item_id in cr_item_template_map

by using "on delete cascade"

* Removed manual deletion of item_id in cr_item_keyword_map

by using "on delete cascade"

* Removed manual deletion of direct permissions (was already

cascading)

- Added missing index for child_id to cr_child_rels.

This index was in the create scripts (with a non-conformant name),

but not in the upgrade scripts

- bump version number of acs-content-repository to 5.9.0d3

Options
    • -91
    • +52
    ./content-item.sql
  2. … 4 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
    • -279
    • +6
    ./content-item.sql
  2. … 2547 more files in changeset.
Saturday 13 Sep 2014
1:09 pm

gustafn

cleanup in cr::keyword::* namespace

one cannot advocate to create a keyword with

content::keyword::item_assign and query it with

cr::keyword::item_get_assigned)

- marked the following function as deprecaed

* cr::keyword::get_children

* cr::keyword::get_keyword_id

* cr::keyword::get_options_flat

* cr::keyword::item_get_assigned

* cr::keyword::item_unassign

* cr::keyword::item_unassign_children

- added new functions:

* content::keyword::get_children

* content::keyword::get_keyword_id

* content::keyword::get_options_flat

* content::keyword::item_get_assigned

* content::keyword::item_unassign_children

- updated regression test

Options
    • -7
    • +3
    ./content-item.sql
  2. … 3 more files in changeset.
Friday 05 Sep 2014
6:32 pm

gustafn

- remove commented code

Options
    • -273
    • +4
    ./content-item.sql
Thursday 07 Jul 2011
12:46 pm

gustafn

Bring PostgreSQL functions closer to the current level of PL/pgSQL:

- upgrade PL/pgSQL functions to the $$ notation (recommended since pg8.0, jan 2005).

- get rid of backslash usages in function definitions

- drop aliases in favor of named function arguments (recommended since pg8.0)

- fix wrong function_args, add missing function_args, align default semantics

with the defaults in pg (providing "null" as default means the argument is

optional).

- change return types of triggers from "opaque" to "trigger" (recommended since pg8.0)

- unify names of triggers *_tr

- removed some version dependencies of pg 7.2 and 7.3

Options
    • -676
    • +1097
    ./content-item.sql
  2. … 54 more files in changeset.
Wednesday 11 Jun 2008
2:08 am

donb

Removed stupid NOTICEs to the log file when deleting stuff. Slows large

deletes down a LOT and fills log file with GARBAGE.

Options
    • -14
    • +1
    ./content-item.sql
Monday 01 Oct 2007
12:15 pm

gustafn

add update script

Options
    • -21
    • +21
    ./content-item.sql
  2. … 1 more file in changeset.
Monday 17 Sep 2007
11:43 am

gustafn

Get rid of the postgres warning "adding missing FROM-clause entry " on sequences

Make "db_nextval acs_object_id_seq" more than twice as fast (from 948 microseconds to 378 microseconds)

Options
    • -8
    • +11
    ./content-item.sql
  2. … 9 more files in changeset.
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
    • -63
    • +35
    ./content-item.sql
  2. … 721 more files in changeset.
Thursday 12 Jan 2006
7:23 pm

daveb

Remove code that guesses package_id based on parent_id. In almost all cases

this will return null anyway.

Options
    • -43
    • +15
    ./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
    • -20
    • +20
    ./content-item.sql
  2. … 7 more files in changeset.
Friday 28 Oct 2005
8:03 pm

daveb

Don't try to get the package id of folder_id 0 (which isn't a folder anyway!)

Options
    • -2
    • +2
    ./content-item.sql
  2. … 2 more files in changeset.
Friday 23 Sep 2005
9:25 am

maltes

Fixed move function

Options
    • -2
    • +2
    ./content-item.sql
Tuesday 13 Sep 2005
4:08 pm

timoh

bugfix: moving content item

Options
    • -2
    • +2
    ./content-item.sql
  2. … 2 more files in changeset.
Monday 20 Jun 2005
8:20 pm

jader

Fix bug #2497, error in content_item__copy, added upgrade script

Options
    • -2
    • +2
    ./content-item.sql
  2. … 1 more file in changeset.
Saturday 26 Mar 2005
1:30 pm

jeffd

propigate title rather than name for content_item__new, bump to d15, upgrade

Options
    • -32
    • +30
    ./content-item.sql
  2. … 2 more files in changeset.
Sunday 20 Mar 2005
4:58 pm

jeffd

fix laundry list of bugs in content repository copy code.

duplicate version of the 11arg content_folder__new

copy_creation_ip rather than copy__creation_ip in content_revision__copy

content_folder__copy did not preserve context_id properly

content_item__copy2 had a bunch of unused varaibles -- removed them.

content_item__copy now preserves live_revision so things which copy an

item with a live revision to not have to explicitly publish the new copy

(which eg file storage did not do).

content_revision__copy did an insert into acs_objects without specifying

column names which breaks on a new install since the order is not as expected.

Options
    • -14
    • +28
    ./content-item.sql
  2. … 3 more files in changeset.