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 19 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.
Thursday 24 Feb 2005
8:34 pm

jeffd

set live and latest to null so delete does not violate fk constraints

Options
    • -1
    • +4
    ./content-item.sql
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
    • -17
    • +8
    ./content-item.sql
  2. … 2275 more files in changeset.
Friday 07 Jan 2005
4:03 am

daveb

Fix define function args for content_item__set_live revision

Options
    • -2
    • +2
    ./content-item.sql
  2. … 2 more files in changeset.
Thursday 06 Jan 2005
5:52 pm

daveb

Fix __delete functions to have __del variant.

Options
    • -5
    • +13
    ./content-item.sql
  2. … 5 more files in changeset.
5:31 pm

daveb

Add __del function to match oracle so package_exec_plsql will work

Options
    • -3
    • +13
    ./content-item.sql
  2. … 2 more files in changeset.
Wednesday 05 Jan 2005
4:39 pm

cesarh

Fixing the params in the function content_item__set_live_revision() changing the param item_id by revision_id

Options
    • -2
    • +2
    ./content-item.sql
Tuesday 21 Dec 2004
7:22 pm

daveb

Add CR Tcl API from HEAD.

Options
    • -14
    • +36
    ./content-item.sql
  2. … 17 more files in changeset.
Wednesday 01 Sep 2004
12:36 am

donb

Upgrade to track my earlier bug fix

Options
    • -2
    • +2
    ./content-item.sql
  2. … 2 more files in changeset.
Wednesday 11 Aug 2004
1:56 am

donb

Fixed a typo in one of the cr_item__new procs

Options
    • -2
    • +2
    ./content-item.sql
  2. … 1 more file in changeset.
Monday 02 Aug 2004
3:40 pm

daveb

Make sure all versions of content_item__new behave in the same way, creating

a new revision if content or title is specified. Patch#580 from

Dave Manginelli fixes bug#2040.

Options
    • -4
    • +19
    ./content-item.sql
Tuesday 20 Jul 2004
5:19 pm

jvdongen

Fixed CR part of bug #1953

Options
    • -2
    • +2
    ./content-item.sql
  2. … 2 more files in changeset.
4:26 pm

jvdongen

Fixed the CR part of bug 1953.

Options
    • -3
    • +3
    ./content-item.sql
  2. … 2 more files in changeset.
Sunday 18 Jul 2004
7:28 pm

daveb

Fix syntax error in drop column statement in content_type__drop__attribute.

Fixes bug#2014. Added upgrade script and increased version in info file.

Options
    • -2
    • +2
    ./content-item.sql
  2. … 3 more files in changeset.
Thursday 01 Jul 2004
6:33 pm

jeffd

add define_function_args definitions for most functions, bump to 5.2.0d5, upgrade script

Options
    • -4
    • +46
    ./content-item.sql
  2. … 9 more files in changeset.