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 6 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
Monday 26 Mar 2001
7:36 am

danw

initial port to postgresql

Options
    • -0
    • +160
    ./content-schedule.sql
7:20 am

danw

initial port to postgresql

Options
    • -0
    • +218
    ./content-update.sql
12:47 am

danw

initial port to postgresql

Options
    • -0
    • +323
    ./content-keyword.sql
12:11 am

danw

initial port to postgresql

Options
    • -0
    • +646
    ./content-folder.sql
    • -0
    • +132
    ./content-template.sql
Sunday 25 Mar 2001
11:11 pm

danw

initial port to postgresql

Options
    • -0
    • +113
    ./content-extlink.sql
    • -0
    • +272
    ./content-symlink.sql
10:47 pm

danw

initial port to postgresql

Options
    • -0
    • +541
    ./content-revision.sql
9:47 pm

danw

initial port to postgresql

Options
    • -0
    • +1708
    ./content-item.sql