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

content-folder.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 13
Last Commit: 07 May
Commits this week: 0
Total Lines of Code (LoC): 1,143
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 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Saturday 14 Mar 2020
6:17 pm

gustafn

use SQL functions (instead of plpgsql) defined as stabe and strict for

* content_folder__is_folder

* content_folder__is_sub_folder, and

* content_folder__is_empty

... having as well more sane constructs returning boolean values

Options
    • -262
    • +241
    ./content-folder.sql
  2. … 2 more files in changeset.
Friday 13 Mar 2020
6:54 pm

trenner

improve performance of content_folder__is_sub_folder

Options
    • -40
    • +15
    ./content-folder.sql
  2. … 2 more files in changeset.
Saturday 10 Aug 2019
8:05 pm

gustafn

improve spelling

Options
    • -3
    • +3
    ./content-folder.sql
  2. … 35 more files in changeset.
Sunday 25 Mar 2018
10:56 pm

hectorr

Fix typos

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

gustafn

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

Options
    • -45
    • +9
    ./content-folder.sql
  2. … 7834 more files in changeset.
Friday 21 Apr 2017
7:14 pm

antoniop

Allow copy of files/folders into the same folder of the original content. This is done by appending a numerical suffix to the name.

It required modifying copy stored procedures so they could accept a different name and title for the copy.

I have also removed redundant package definition in oracle code that was immediately overridden afterwards.

Options
    • -41
    • +8
    ./content-folder.sql
  2. … 12 more files in changeset.
Wednesday 10 Feb 2016
10:22 am

gustafn

- Fix type of v_is_registered in dql function content_folder__register_content_type to boolean (was "varchar")

(This chance is necessary at least for pg 9.5)

Options
    • -5
    • +2
    ./content-folder.sql
  2. … 2 more files in changeset.
9:24 am

gustafn

- fix type of v_is_registered to boolean. This fix is necessary at least under pg 9.5

Options
    • -2
    • +2
    ./content-folder.sql
  2. … 1 more file in changeset.
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
    • -287
    • +484
    ./content-folder.sql
  2. … 54 more files in changeset.
Friday 24 Oct 2008
3:50 pm

victorg

Checking that the copy.name is not null when copying it to same parent folder

of the source folder.

Options
    • -2
    • +2
    ./content-folder.sql
  2. … 3 more files in changeset.
Thursday 23 Oct 2008
3:04 pm

victorg

Adding basic checks to content_folder.copy procedure in order to avoid

infinit loops.

Options
    • -28
    • +34
    ./content-folder.sql
  2. … 4 more files in changeset.
Monday 01 Oct 2007
2:10 am

gustafn

fix more function_args, fix comment for default values in stored procedures

Options
    • -5
    • +5
    ./content-folder.sql
  2. … 2 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
    • -17
    • +11
    ./content-folder.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
    • -10
    • +3
    ./content-folder.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
    • -6
    • +6
    ./content-folder.sql
  2. … 7 more files in changeset.
Saturday 26 Nov 2005
10:22 pm

daveb

Allow folders to have non-cr_items are parents

Options
    • -2
    • +3
    ./content-folder.sql
Wednesday 03 Aug 2005
5:59 pm

victorg

Moving folders was broken. Adding the correct definitios of

content_folder__move function.

Options
    • -5
    • +21
    ./content-folder.sql
Friday 01 Jul 2005
9:58 pm

daveb

Fix define function args for content_folder__is_folder to match oracle.

Options
    • -2
    • +2
    ./content-folder.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
    • -10
    • +8
    ./content-folder.sql
  2. … 3 more files in changeset.
Friday 18 Mar 2005
2:50 pm

jeffd

minor fix: move_name should have been move__name

Options
    • -2
    • +2
    ./content-folder.sql
  2. … 1 more file in changeset.
4:21 am

daveb

Add content_folder__move function that allows rename on move. Already existed on Oracle.

Options
    • -5
    • +21
    ./content-folder.sql
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
    • -8
    • +20
    ./content-folder.sql
  2. … 321 more files in changeset.
Friday 14 Jan 2005
4:14 am

daveb

Fix content_folder__is_subfolder pl/sql. Also fix tcl proc which was

passing in the wrong list format to package_exec_plsql. Add upgrade

script and tests.

Options
    • -6
    • +19
    ./content-folder.sql
  2. … 5 more files in changeset.
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
    • -2
    • +40
    ./content-folder.sql
  2. … 2275 more files in changeset.
Wednesday 12 Jan 2005
2:22 pm

dedsc

fix to return folder id present in upgrade. just putting it here as well

Options
    • -3
    • +2
    ./content-folder.sql
Wednesday 22 Dec 2004
5:13 pm

daveb

Set package_id from content_folder__new

Options
    • -5
    • +40
    ./content-folder.sql
  2. … 2 more files in changeset.
Tuesday 21 Dec 2004
7:22 pm

daveb

Add CR Tcl API from HEAD.

Options
    • -2
    • +16
    ./content-folder.sql
  2. … 17 more files in changeset.
Friday 02 Jul 2004
4:10 pm

jeffd

bad quoting of string literal in plpgsql functions

Options
    • -2
    • +2
    ./content-folder.sql
Thursday 01 Jul 2004
6:33 pm

jeffd

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

Options
    • -78
    • +30
    ./content-folder.sql
  2. … 9 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
    • -19
    • +19
    ./content-folder.sql
  2. … 687 more files in changeset.