OpenACS / openacs-4 / packages / acs-kernel

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 44
Last Commit: 29 Jul
Commits this week: 0
Total Lines of Code (LoC): 85,961
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 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 19 Apr 2001
4:52 pm

ben

applied patches from Steve Woodcock that port a few more queries, fix a few data model PL/SQL quirks, and generally allow us to get further into a working OpenACS!

Options
    • -4
    • +4
    ./postgresql/acs-permissions-create.sql
  2. … 6 more files in changeset.
3:17 am

danw

more strict string handling changes

Options
    • -1
    • +1
    ./postgresql/acs-objects-create.sql
    • -1
    • +1
    ./postgresql/apm-create.sql
  3. … 3 more files in changeset.
Wednesday 18 Apr 2001
7:20 am

danw

partial fix of rel_constraints tree queries - more work required

Options
    • -9
    • +22
    ./postgresql/rel-constraints-create.sql
    • -1
    • +2
    ./postgresql/rel-segments-body-create.sql
1:41 am

danw

added comments for default api values

Options
    • -11
    • +11
    ./postgresql/acs-create.sql
    • -15
    • +15
    ./postgresql/acs-metadata-create.sql
    • -8
    • +8
    ./postgresql/acs-objects-create.sql
    • -2
    • +2
    ./postgresql/acs-permissions-create.sql
    • -13
    • +13
    ./postgresql/acs-relationships-create.sql
    • -80
    • +80
    ./postgresql/apm-create.sql
    • -26
    • +26
    ./postgresql/community-core-create.sql
    • -18
    • +18
    ./postgresql/groups-body-create.sql
    • -6
    • +6
    ./postgresql/journal-create.sql
    • -7
    • +7
    ./postgresql/rel-constraints-body-create.sql
    • -4
    • +2
    ./postgresql/rel-constraints-create.sql
    • -9
    • +9
    ./postgresql/rel-segments-body-create.sql
    • -7
    • +7
    ./postgresql/site-nodes-create.sql
Saturday 14 Apr 2001
7:29 am

danw

more cleanup of nullable strings in kernel

Options
    • -1
    • +1
    ./postgresql/apm-create.sql
7:21 am

danw

more cleanup of nullable strings in kernel

Options
    • -1
    • +1
    ./postgresql/apm-create.sql
7:12 am

danw

more cleanup of nullable strings in kernel

Options
    • -2
    • +2
    ./postgresql/acs-logs-create.sql
    • -1
    • +1
    ./postgresql/acs-metadata-create.sql
    • -4
    • +4
    ./postgresql/acs-objects-create.sql
    • -7
    • +7
    ./postgresql/apm-create.sql
    • -1
    • +1
    ./postgresql/groups-body-create.sql
    • -2
    • +2
    ./postgresql/groups-create.sql
    • -3
    • +3
    ./postgresql/rel-constraints-body-create.sql
    • -1
    • +1
    ./postgresql/site-nodes-create.sql
    • -2
    • +2
    ./postgresql/test/rel-constraints-test.sql
Wednesday 11 Apr 2001
2:41 pm

danw

applied patch from Steve Woodcock

Options
    • -1
    • +3
    ./postgresql/postgresql.sql
  2. … 2 more files in changeset.
1:53 am

danw

patch submitted by steve woodcock, and workflow porting

Options
    • -1
    • +1
    ./postgresql/acs-create.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
    • -1
    • +2
    ./postgresql/acs-metadata-create.sql
    • -1
    • +2
    ./postgresql/site-nodes-create.sql
  3. … 3 more files in changeset.
Sunday 08 Apr 2001
6:13 pm

danw

fixed acs_object tree trigger

Options
    • -0
    • +1
    ./postgresql/acs-install.sql
    • -1
    • +2
    ./postgresql/acs-objects-create.sql
    • -1
    • +1
    ./postgresql/security-create.sql
1:41 pm

danw

fixed acs-install problems

Options
    • -11
    • +31
    ./postgresql/acs-install.sql
    • -1
    • +1
    ./postgresql/site-nodes-create.sql
  3. … 1 more file in changeset.
Saturday 07 Apr 2001
6:26 pm

danw

fixed typos

Options
    • -4
    • +4
    ./postgresql/acs-install.sql
6:19 pm

danw

fixed quoting in inline function

Options
    • -1
    • +1
    ./postgresql/acs-install.sql
5:54 pm

danw

added anonymous function support for plsql commands

Options
    • -7
    • +0
    ./postgresql/acs-install.sql
    • -0
    • +9
    ./postgresql/lob.sql
    • -1
    • +4
    ./postgresql/postgresql.sql
  4. … 3 more files in changeset.
Thursday 05 Apr 2001
8:23 pm

donb

Big 'ole update to implement multi-db aware packages. Don't try this yet,

I can't *possibly* have gotten all the right files added and removed in

one fell swoop!

Options
    • -7
    • +39
    ./oracle/apm-create.sql
    • -9
    • +31
    ./postgresql/apm-create.sql
  3. … 117 more files in changeset.
Wednesday 04 Apr 2001
1:59 am

danw

more debugging of test script

Options
    • -1
    • +1
    ./postgresql/acs-objects-create.sql
  2. … 2 more files in changeset.
Tuesday 03 Apr 2001
6:28 am

ben

query dispatcher actually working...

Options
    • -6
    • +7
    ./postgresql/apm-create.sql
  2. … 2 more files in changeset.
1:14 am

danw

fixed dual-cursor query

Options
    • -2
    • +2
    ./postgresql/postgresql.sql
  2. … 2 more files in changeset.
Friday 30 Mar 2001
7:44 am

ben

query dispatcher progress

Options
    • -3
    • +4
    ./postgresql/apm-create.sql
  2. … 5 more files in changeset.
5:15 am

danw

added Don's lob hack to support content-repository porting

Options
    • -0
    • +110
    ./postgresql/lob.sql
Thursday 29 Mar 2001
3:21 am

danw

more cleanup, added lob support for cr_revisions

Options
    • -0
    • +1
    ./postgresql/acs-kernel-create.sql
  2. … 9 more files in changeset.
Tuesday 27 Mar 2001
7:20 am

danw

added functons for introspection of db functions

Options
    • -0
    • +98
    ./postgresql/postgresql.sql
Saturday 24 Mar 2001
1:34 am

danw

fixed up some tree queries

Options
    • -1
    • +1
    ./postgresql/acs-permissions-create.sql
    • -25
    • +32
    ./postgresql/rel-constraints-create.sql
    • -16
    • +33
    ./postgresql/site-nodes-create.sql
    • -0
    • +46
    ./postgresql/test/rel-constraints-test.sql
    • -0
    • +1
    ./postgresql/test/rel-segments-test.sql
Friday 23 Mar 2001
1:21 am

danw

finished porting test-harness code

Options
    • -19
    • +37
    ./postgresql/acs-objects-create.sql
    • -11
    • +6
    ./postgresql/postgresql.sql
    • -6
    • +8
    ./postgresql/rel-constraints-body-create.sql
    • -9
    • +10
    ./postgresql/test/acs-objects-test.sql
    • -53
    • +179
    ./postgresql/test/rel-constraints-test.sql
    • -21
    • +20
    ./postgresql/test/rel-segments-test-types-create.sql
    • -3
    • +3
    ./postgresql/test/rel-segments-test-types-drop.sql
    • -58
    • +71
    ./postgresql/test/rel-segments-test.sql
    • -14
    • +3
    ./postgresql/test-harness/acs-core.sql
Thursday 22 Mar 2001
1:21 am

danw

added postgresql specific test files

Options
    • -0
    • +311
    ./postgresql/test/acs-objects-test.sql
    • -0
    • +170
    ./postgresql/test/groups-test.sql
    • -0
    • +363
    ./postgresql/test/rel-constraints-test.sql
    • -0
    • +205
    ./postgresql/test/rel-segments-test-types-create.sql
    • -0
    • +14
    ./postgresql/test/rel-segments-test-types-drop.sql
    • -0
    • +377
    ./postgresql/test/rel-segments-test.sql
    • -0
    • +79
    ./postgresql/test-harness/acs-core.sql
    • -0
    • +250
    ./postgresql/test-harness/acs-permissions.sql
1:09 am

danw

more porting of test-harness packages

Options
    • -17
    • +14
    ./postgresql/acs-relationships-create.sql
    • -0
    • +2
    ./postgresql/groups-create.sql
    • -3
    • +3
    ./postgresql/rel-constraints-body-create.sql
Wednesday 21 Mar 2001
7:41 am

danw

fixed a couple of dynamic sql statements

Options
    • -10
    • +12
    ./postgresql/acs-objects-create.sql
6:46 am

danw

fixed exception messages, membership_rels delete trigger and composition_rels delete trigger

Options
    • -18
    • +19
    ./postgresql/acs-objects-create.sql
    • -1
    • +1
    ./postgresql/acs-relationships-create.sql
    • -2
    • +1
    ./postgresql/apm-create.sql
    • -6
    • +2
    ./postgresql/groups-body-create.sql
    • -2
    • +2
    ./postgresql/groups-create.sql
    • -2
    • +1
    ./postgresql/site-nodes-create.sql
Tuesday 20 Mar 2001
11:51 pm

donb

bootstrapper can now load either the Oracle or PostgreSQL acs-kernel

datamodel. It checks on-the-fly for which db is configured in the OpenNSD

database pools allocated to OpenACS. Only acs-kernel is correctly self-

configured at this point.

Options
    • -274
    • +0
    ./acs-create.sql
    • -12
    • +0
    ./acs-drop.sql
    • -119
    • +0
    ./acs-install.sql
    • -32
    • +0
    ./acs-kernel-create.sql
    • -25
    • +0
    ./acs-kernel-drop.sql
    • -104
    • +0
    ./acs-logs-create.sql
    • -3
    • +0
    ./acs-logs-drop.sql
    • -689
    • +0
    ./acs-metadata-create.sql
    • -21
    • +0
    ./acs-metadata-drop.sql
    • -1024
    • +0
    ./acs-objects-create.sql
    • -25
    • +0
    ./acs-objects-drop.sql
    • -391
    • +0
    ./acs-permissions-create.sql
    • -23
    • +0
    ./acs-permissions-drop.sql
    • -506
    • +0
    ./acs-relationships-create.sql
    • -16
    • +0
    ./acs-relationships-drop.sql
  16. … 99 more files in changeset.