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

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 40
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 32,399
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 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 30 Apr 2001
10:04 pm

stevew

Add content_item__get_title(integer) helper function

Options
    • -1
    • +12
    ./content-item.sql
3:34 am

danw

added file support to CR data-model

Options
    • -5
    • +5
    ./content-create.sql
    • -4
    • +4
    ./content-extlink.sql
    • -2
    • +2
    ./content-folder.sql
    • -46
    • +197
    ./content-item.sql
    • -2
    • +7
    ./content-revision.sql
    • -3
    • +3
    ./content-symlink.sql
    • -2
    • +2
    ./content-template.sql
  8. … 6 more files in changeset.
Saturday 28 Apr 2001
9:58 pm

donb

Removed more of the "default '' not null" kludge.

Options
    • -20
    • +20
    ./content-create.sql
    • -2
    • +2
    ./content-extlink.sql
    • -2
    • +2
    ./content-folder.sql
    • -4
    • +4
    ./content-item.sql
    • -1
    • +1
    ./content-keyword.sql
    • -6
    • +6
    ./content-revision.sql
    • -2
    • +2
    ./content-schedule.sql
    • -2
    • +2
    ./content-symlink.sql
    • -3
    • +3
    ./content-type.sql
    • -2
    • +2
    ./content-xml.sql
  11. … 9 more files in changeset.
Friday 27 Apr 2001
4:27 am

danw

ported templating to use standard db api

Options
    • -5
    • +5
    ./content-revision.sql
  2. … 27 more files in changeset.
Thursday 19 Apr 2001
3:17 am

danw

more strict string handling changes

Options
    • -5
    • +6
    ./content-folder.sql
    • -5
    • +5
    ./content-item.sql
    • -3
    • +3
    ./content-symlink.sql
  4. … 2 more files in changeset.
1:27 am

danw

added comments for default parameters

Options
    • -8
    • +8
    ./content-extlink.sql
    • -17
    • +17
    ./content-folder.sql
    • -38
    • +38
    ./content-item.sql
    • -11
    • +11
    ./content-keyword.sql
    • -13
    • +13
    ./content-perms.sql
    • -23
    • +23
    ./content-revision.sql
    • -8
    • +8
    ./content-symlink.sql
    • -7
    • +7
    ./content-template.sql
    • -33
    • +32
    ./content-type.sql
  10. … 2 more files in changeset.
Tuesday 17 Apr 2001
6:10 am

danw

patch submitted by Steve Woodcock

Options
    • -3
    • +3
    ./content-create.sql
    • -3
    • +3
    ./content-extlink.sql
  3. … 12 more files in changeset.
Saturday 14 Apr 2001
7:39 am

danw

directory restructuring

Options
    • -0
    • +13
    ./upgrade/upgrade-4.1-4.1.2.sql
  2. … 1 more file in changeset.
Monday 09 Apr 2001
6:55 am

danw

fixed problem with infinite recursion on updates of tables with tree query triggers

Options
    • -2
    • +3
    ./content-create.sql
    • -110
    • +0
    ./lob.sql
  3. … 3 more files in changeset.
Saturday 07 Apr 2001
5:54 pm

danw

added anonymous function support for plsql commands

Options
    • -2
    • +6
    ./content-create.sql
    • -6
    • +7
    ./content-revision.sql
  3. … 4 more files in changeset.
Thursday 05 Apr 2001
1:56 am

danw

finished porting and testing content-test.sql

Options
    • -6
    • +1
    ./content-folder.sql
    • -11
    • +11
    ./content-item.sql
    • -2
    • +3
    ./content-revision.sql
    • -114
    • +106
    ./content-test.sql
Wednesday 04 Apr 2001
7:03 am

danw

more test script debugging

Options
    • -5
    • +28
    ./content-test.sql
1:59 am

danw

more debugging of test script

Options
    • -6
    • +6
    ./content-item.sql
    • -13
    • +237
    ./content-test.sql
  3. … 1 more file in changeset.
Tuesday 03 Apr 2001
2:10 pm

danw

fixed up table detection on creation of new content type

Options
    • -5
    • +4
    ./content-type.sql
7:01 am

danw

more debugging of test script and associated fixes

Options
    • -4
    • +4
    ./content-folder.sql
    • -7
    • +12
    ./content-item.sql
    • -9
    • +10
    ./content-symlink.sql
    • -21
    • +28
    ./content-test.sql
1:14 am

danw

fixed dual-cursor query

Options
    • -33
    • +96
    ./content-item.sql
    • -8
    • +11
    ./content-test.sql
  3. … 1 more file in changeset.
Monday 02 Apr 2001
7:35 am

danw

partial work on content-test

Options
    • -2
    • +2
    ./content-extlink.sql
    • -9
    • +29
    ./content-folder.sql
    • -28
    • +52
    ./content-item.sql
    • -29
    • +7
    ./content-keyword.sql
    • -16
    • +6
    ./content-perms.sql
    • -21
    • +13
    ./content-revision.sql
    • -2
    • +3
    ./content-schedule.sql
    • -2
    • +2
    ./content-symlink.sql
    • -9
    • +3
    ./content-template.sql
    • -33
    • +43
    ./content-test.sql
    • -3
    • +4
    ./content-type.sql
Sunday 01 Apr 2001
8:25 pm

danw

initial whack at porting test code for content-repository

Options
    • -1
    • +41
    ./content-item.sql
    • -1
    • +25
    ./content-revision.sql
    • -1
    • +16
    ./content-template.sql
    • -0
    • +446
    ./content-test.sql
5:03 pm

danw

content-search.sql

Options
    • -2
    • +3
    ./content-create.sql
    • -0
    • +111
    ./content-search.sql
7:57 am

danw

I relealized that the dynmic trigger code wouldn't work as the trigger is actually being applied to a view. Changed code to use a rule instead, and now everything seems to work. More evaluation required however.

Options
    • -79
    • +57
    ./content-type.sql
    • -1
    • +13
    ./content-util.sql
Saturday 31 Mar 2001
7:12 am

danw

fixed up dynamic trigger creation for new content types

Options
    • -67
    • +70
    ./content-type.sql
    • -23
    • +34
    ./content-util.sql
Friday 30 Mar 2001
7:31 am

danw

fixed up content-repository code so that it will load. Dynamic trigger code commented out for now

Options
    • -15
    • +16
    ./content-create.sql
    • -2
    • +2
    ./content-drop.sql
    • -13
    • +16
    ./content-folder.sql
    • -10
    • +10
    ./content-image.sql
    • -8
    • +8
    ./content-item.sql
    • -4
    • +4
    ./content-revision.sql
    • -2
    • +2
    ./content-schedule.sql
    • -5
    • +5
    ./content-symlink.sql
    • -2
    • +7
    ./content-template.sql
    • -9
    • +19
    ./content-type.sql
    • -3
    • +3
    ./content-update.sql
    • -3
    • +1
    ./content-util.sql
    • -1
    • +1
    ./packages-create.sql
    • -6
    • +7
    ./types-create.sql
5:03 am

danw

added tree queries

Options
    • -2
    • +97
    ./content-create.sql
    • -6
    • +19
    ./content-folder.sql
    • -15
    • +58
    ./content-keyword.sql
    • -12
    • +54
    ./content-perms.sql
    • -2
    • +2
    ./content-revision.sql
    • -4
    • +5
    ./content-type.sql
    • -3
    • +10
    ./types-create.sql
Thursday 29 Mar 2001
7:38 am

danw

started porting tree queries

Options
    • -2
    • +97
    ./content-create.sql
    • -18
    • +57
    ./content-folder.sql
    • -12
    • +37
    ./content-item.sql
    • -12
    • +31
    ./content-revision.sql
    • -24
    • +67
    ./content-type.sql
4:46 am

danw

added strict string semantics

Options
    • -19
    • +19
    ./content-create.sql
    • -2
    • +2
    ./content-folder.sql
    • -2
    • +2
    ./content-type.sql
    • -2
    • +2
    ./content-update.sql
    • -2
    • +2
    ./content-xml.sql
3:21 am

danw

more cleanup, added lob support for cr_revisions

Options
    • -28
    • +21
    ./content-create.sql
    • -3
    • +3
    ./content-folder.sql
    • -8
    • +11
    ./content-item.sql
    • -1
    • +1
    ./content-keyword.sql
    • -4
    • +4
    ./content-perms.sql
    • -54
    • +108
    ./content-revision.sql
    • -2
    • +2
    ./content-type.sql
    • -6
    • +4
    ./content-update.sql
    • -0
    • +110
    ./lob.sql
  10. … 1 more file in changeset.
Wednesday 28 Mar 2001
2:57 pm

danw

more cleanup

Options
    • -53
    • +61
    ./content-create.sql
4:20 am

danw

fixed typo

Options
    • -2
    • +2
    ./content-type.sql
4:15 am

danw

general cleanup of initial porting effort

Options
    • -8
    • +8
    ./content-extlink.sql
    • -19
    • +21
    ./content-folder.sql
    • -41
    • +51
    ./content-item.sql
    • -1
    • +1
    ./content-keyword.sql
    • -14
    • +32
    ./content-perms.sql
    • -34
    • +43
    ./content-revision.sql
    • -17
    • +14
    ./content-schedule.sql
    • -18
    • +16
    ./content-symlink.sql
    • -16
    • +21
    ./content-type.sql
    • -11
    • +11
    ./content-update.sql
    • -4
    • +4
    ./content-util.sql
    • -85
    • +4
    ./doc-package.sql
Tuesday 27 Mar 2001
4:02 am

danw

initial port to postgresql

Options
    • -0
    • +209
    ./content-drop.sql
    • -0
    • +45
    ./content-image-drop.sql
    • -0
    • +91
    ./content-image.sql
    • -0
    • +349
    ./content-perms.sql
    • -0
    • +37
    ./datatype-upgrade.sql
    • -0
    • +135
    ./doc-package.sql
    • -0
    • +561
    ./types-create.sql
    • -0
    • +161
    ./types-drop.sql