OpenACS / openacs-4 / packages / dotlrn / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 16
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 8,639
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
Friday 02 Aug 2002
11:07 pm

chak

fixed another typo in a member_rel_creation..

Options
    • -2
    • +2
    ./dotlrn-init.sql
10:55 pm

chak

fixed a typo in a member_rel_creation..

Options
    • -2
    • +2
    ./dotlrn-init.sql
Wednesday 31 Jul 2002
11:18 pm

yon

added an operation to the dotlrn_applet service contract. the operation's name

is ChangeEventHandler and is usually implemented by change_event_handler

method in the dotlrn_applet implementation. dotLRN can throw events based on

changes to a community via the dotlrn_community::generate_change_event method.

currently the only event being thrown and handled is the 'rename' event. this

event is thrown when the name of a community is changed. the only applets that

currently listen for this event are dotlrn_fs, dotlrn_forums, and

dotlrn_calendar.

applets do not have to handle all events, only events they are interested in

handling.

we will add events on an as needed basis.

Options
    • -204
    • +225
    ./applet-sc-create.sql
    • -2
    • +13
    ./applet-sc-drop.sql
  3. … 50 more files in changeset.
Monday 29 Jul 2002
8:45 pm

chak

new users can be added as dotlrn_externals now

Options
    • -2
    • +2
    ./externals-package-create.sql
  2. … 2 more files in changeset.
Friday 26 Jul 2002
4:53 pm

yon

added rel_type and segment_id columns to dotlrn_user_types table and

dotlrn_users view.

Options
    • -8
    • +9
    ./admins-init.sql
    • -8
    • +9
    ./externals-init.sql
    • -8
    • +9
    ./professors-init.sql
    • -8
    • +9
    ./students-init.sql
    • -2
    • +14
    ./users-create.sql
  6. … 5 more files in changeset.
3:57 am

arjun

increase term_year lenght to 9

Options
    • -2
    • +2
    ./classes-create.sql
    • -0
    • +27
    ./upgrade/upgrade-july-25-2002.sql
  3. … 1 more file in changeset.
Tuesday 16 Jul 2002
11:43 pm

chak

fix for pg 7.1

Options
    • -27
    • +33
    ./security-create.sql
Monday 15 Jul 2002
8:32 pm

chak

dotlrn.. it keeps going, and going..

Options
    • -4
    • +4
    ./communities-package-create.sql
    • -2
    • +2
    ./community-memberships-packages-create.sql
  3. … 5 more files in changeset.
Saturday 13 Jul 2002
2:43 am

yon

update info file. fix referential constraint in dotlrn_applets table.

Options
    • -2
    • +2
    ./applets-create.sql
  2. … 2 more files in changeset.
2:13 am

yon

some changes regarding dotlrn applets. the data model has changed. some other

small api changes. most of these api are not used.

Options
    • -0
    • +68
    ./applets-create.sql
    • -0
    • +28
    ./applets-drop.sql
    • -40
    • +1
    ./communities-create.sql
    • -3
    • +1
    ./communities-drop.sql
    • -0
    • +1
    ./dotlrn-create.sql
    • -1
    • +2
    ./dotlrn-drop.sql
  7. … 28 more files in changeset.
Friday 12 Jul 2002
11:26 pm

chak

lots of fixes to get the pg dotlrn working

Options
    • -2
    • +3
    ./admins-package-create.sql
    • -4
    • +4
    ./communities-package-create.sql
    • -1
    • +1
    ./communities-tree-create.sql
    • -2
    • +2
    ./externals-package-create.sql
    • -5
    • +5
    ./professors-package-create.sql
    • -8
    • +20
    ./students-package-create.sql
    • -1
    • +3
    ./users-create.sql
    • -18
    • +20
    ./users-package-create.sql
  9. … 9 more files in changeset.
Thursday 11 Jul 2002
5:54 pm

chak

some query porting, and bug fixes to support it

Options
    • -2
    • +4
    ./classes-create.sql
    • -2
    • +4
    ./clubs-create.sql
    • -9
    • +11
    ./communities-package-create.sql
    • -21
    • +21
    ./communities-tree-create.sql
  5. … 3 more files in changeset.
Monday 08 Jul 2002
11:50 pm

yon

fix include statement

Options
    • -2
    • +2
    ./dotlrn-drop.sql
11:07 pm

chak

fixed name of file to correspond with oracle

Options
    • -33
    • +0
    ./community-membership-packages-drop.sql
    • -0
    • +33
    ./community-memberships-packages-drop.sql
    • -2
    • +2
    ./dotlrn-drop.sql
11:04 pm

yon

renamed files to match oracle versions

Options
    • -0
    • +75
    ./admin-profile-provider-create.sql
    • -0
    • +72
    ./admin-profile-provider-drop.sql
    • -0
    • +34
    ./admins-create.sql
    • -0
    • +28
    ./admins-drop.sql
    • -0
    • +89
    ./admins-init.sql
    • -0
    • +91
    ./admins-package-create.sql
    • -0
    • +24
    ./admins-package-drop.sql
    • -0
    • +91
    ./admins-sanitize.sql
    • -0
    • +314
    ./applet-sc-create.sql
    • -0
    • +197
    ./applet-sc-drop.sql
    • -0
    • +72
    ./class-membership-drop.sql
    • -0
    • +225
    ./class-memberships-create.sql
    • -0
    • +341
    ./classes-create.sql
    • -0
    • +39
    ./classes-drop.sql
    • -0
    • +113
    ./clubs-create.sql
  16. … 121 more files in changeset.
10:33 pm

chak

datamodel loading dropping works without errors\!

Options
    • -11
    • +11
    ./dotlrn-class-memberships-create.sql
    • -2
    • +2
    ./dotlrn-communities-drop.sql
    • -1
    • +5
    ./dotlrn-communities-package-create.sql
    • -1
    • +1
    ./dotlrn-communities-tree-create.sql
    • -2
    • +2
    ./dotlrn-communities-tree-drop.sql
    • -18
    • +37
    ./dotlrn-init.sql
    • -2
    • +1
    ./dotlrn-professors-drop.sql
    • -3
    • +3
    ./dotlrn-students-init.sql
6:12 am

chak

fixed functions in which variable names conflicted with function bodies

Options
    • -6
    • +8
    ./dotlrn-admins-init.sql
    • -6
    • +8
    ./dotlrn-externals-init.sql
    • -6
    • +6
    ./dotlrn-professors-init.sql
    • -6
    • +6
    ./dotlrn-students-init.sql
    • -48
    • +4
    ./dotlrn-users-init.sql
Friday 05 Jul 2002
5:26 pm

chak

dangerously close to loading/dropping without errors

Options
    • -2
    • +1
    ./dotlrn-admins-package-drop.sql
    • -2
    • +2
    ./dotlrn-admins-sanitize.sql
    • -7
    • +7
    ./dotlrn-class-membership-drop.sql
    • -2
    • +2
    ./dotlrn-communities-package-create.sql
    • -2
    • +2
    ./dotlrn-professors-drop.sql
    • -0
    • +68
    ./dotlrn-security-drop.sql
    • -61
    • +0
    ./dotlrn-security.drop.sql
Wednesday 03 Jul 2002
9:58 pm

chak

datamodel loading *almost* works

Options
    • -3
    • +3
    ./dotlrn-admins-init.sql
    • -87
    • +95
    ./dotlrn-applet-sc-drop.sql
    • -17
    • +24
    ./dotlrn-class-membership-drop.sql
    • -52
    • +59
    ./dotlrn-class-memberships-create.sql
    • -3
    • +3
    ./dotlrn-classes-create.sql
    • -3
    • +3
    ./dotlrn-clubs-create.sql
    • -3
    • +3
    ./dotlrn-communities-create.sql
    • -10
    • +12
    ./dotlrn-communities-package-create.sql
    • -2
    • +2
    ./dotlrn-communities-tree-drop.sql
    • -3
    • +4
    ./dotlrn-create.sql
    • -38
    • +0
    ./dotlrn-dotlrn-drop.sql
    • -83
    • +91
    ./dotlrn-dotlrn-sanitize.sql
    • -0
    • +38
    ./dotlrn-drop.sql
    • -4
    • +5
    ./dotlrn-externals-init.sql
    • -2
    • +2
    ./dotlrn-externals-sanitize.sql
  16. … 7 more files in changeset.
Tuesday 02 Jul 2002
9:53 pm

chak

little closer to getting the data model to load...

Options
    • -27
    • +34
    ./dotlrn-admin-profile-provider-create.sql
    • -4
    • +4
    ./dotlrn-admins-create.sql
    • -125
    • +133
    ./dotlrn-applet-sc-create.sql
    • -37
    • +37
    ./dotlrn-applet-sc-drop.sql
    • -3
    • +4
    ./dotlrn-communities-create.sql
    • -3
    • +3
    ./dotlrn-communities-package-create.sql
    • -3
    • +3
    ./dotlrn-communities-package-drop.sql
    • -2
    • +4
    ./dotlrn-communities-tree-drop.sql
    • -2
    • +2
    ./dotlrn-community-memberships-create.sql
    • -2
    • +2
    ./dotlrn-dotlrn-drop.sql
    • -31
    • +31
    ./dotlrn-dotlrn-sanitize.sql
    • -27
    • +35
    ./dotlrn-external-profile-provider-create.sql
    • -31
    • +31
    ./dotlrn-init.sql
    • -16
    • +16
    ./dotlrn-main-portlet-create.sql
    • -11
    • +12
    ./dotlrn-main-portlet-drop.sql
  16. … 9 more files in changeset.
8:40 pm

chak

first hack at pg compatibility

Options
    • -22
    • +28
    ./dotlrn-admin-profile-provider-drop.sql
    • -9
    • +1
    ./dotlrn-admins-create.sql
    • -5
    • +4
    ./dotlrn-admins-drop.sql
    • -49
    • +6
    ./dotlrn-admins-init.sql
    • -81
    • +15
    ./dotlrn-admins-package-create.sql
    • -3
    • +3
    ./dotlrn-admins-package-drop.sql
    • -20
    • +30
    ./dotlrn-admins-sanitize.sql
    • -99
    • +112
    ./dotlrn-applet-sc-create.sql
    • -0
    • +189
    ./dotlrn-applet-sc-drop.sql
    • -0
    • +65
    ./dotlrn-class-membership-drop.sql
    • -0
    • +218
    ./dotlrn-class-memberships-create.sql
    • -37
    • +35
    ./dotlrn-classes-create.sql
    • -0
    • +39
    ./dotlrn-classes-drop.sql
    • -25
    • +17
    ./dotlrn-clubs-create.sql
    • -0
    • +29
    ./dotlrn-clubs-drop.sql
  16. … 47 more files in changeset.
Tuesday 21 May 2002
9:46 am

yon

displaying role in community correctly everywhere

Options
    • -6
    • +4
    ./dotlrn-community-memberships-create.sql
  2. … 9 more files in changeset.
Friday 10 May 2002
8:35 am

arjun

Added 3 procs to applet contract and impls. Infrastructure for getting rid of dummy_comm_p, cloning, and community deleting

Options
    • -5
    • +66
    ./dotlrn-applet-sc-create.sql
  2. … 24 more files in changeset.
1:59 am

arjun

Big checkin. All portal elements tcl and sql have been cleaned up. cleaned up portal api's. still incomplete

Options
    • -3
    • +3
    ./dotlrn-main-portlet-create.sql
  2. … 76 more files in changeset.
Tuesday 16 Apr 2002
3:53 pm

arjun

dotlrn portal template stuff (not fully functional).

Options
    • -2
    • +4
    ./dotlrn-communities-create.sql
  2. … 22 more files in changeset.
Saturday 06 Apr 2002
8:27 am

yon

optimized dotlrn_users view

Options
    • -11
    • +17
    ./dotlrn-users-create.sql
  2. … 1 more file in changeset.
Friday 29 Mar 2002
9:21 pm

yon

separating packages from ddl

Options
    • -282
    • +1
    ./dotlrn-communities-create.sql
    • -0
    • +309
    ./dotlrn-communities-package-create.sql
    • -0
    • +1
    ./dotlrn-create.sql
  4. … 1 more file in changeset.
8:59 pm

yon

working around limitations in acs_object_types caused an error in the creation of the base dotlrn_community_types; this will be fixed once i fix the acs_object_types table

Options
    • -0
    • +4
    ./dotlrn-init.sql
  2. … 1 more file in changeset.
8:14 pm

yon

adding license

Options
    • -1
    • +17
    ./dotlrn-admin-profile-provider-create.sql
    • -1
    • +17
    ./dotlrn-admin-profile-provider-drop.sql
    • -1
    • +17
    ./dotlrn-admins-create.sql
    • -1
    • +17
    ./dotlrn-admins-drop.sql
    • -2
    • +18
    ./dotlrn-admins-init.sql
    • -1
    • +17
    ./dotlrn-admins-package-create.sql
    • -1
    • +17
    ./dotlrn-admins-package-drop.sql
    • -1
    • +17
    ./dotlrn-admins-sanitize.sql
    • -0
    • +16
    ./dotlrn-applet-sc-create.sql
    • -1
    • +17
    ./dotlrn-classes-create.sql
    • -1
    • +17
    ./dotlrn-clubs-create.sql
    • -1
    • +17
    ./dotlrn-communities-create.sql
    • -1
    • +17
    ./dotlrn-community-memberships-create.sql
    • -0
    • +16
    ./dotlrn-community-memberships-packages-create.sql
    • -0
    • +16
    ./dotlrn-create.sql
  16. … 381 more files in changeset.
5:53 pm

ben

added PG support

Options
    • -0
    • +52
    ./dotlrn-admin-profile-provider-create.sql
    • -0
    • +50
    ./dotlrn-admin-profile-provider-drop.sql
    • -0
    • +26
    ./dotlrn-admins-create.sql
    • -0
    • +13
    ./dotlrn-admins-drop.sql
    • -0
    • +114
    ./dotlrn-admins-init.sql
    • -0
    • +141
    ./dotlrn-admins-package-create.sql
    • -0
    • +9
    ./dotlrn-admins-package-drop.sql
    • -0
    • +65
    ./dotlrn-admins-sanitize.sql
    • -0
    • +216
    ./dotlrn-applet-sc-create.sql
    • -0
    • +327
    ./dotlrn-classes-create.sql
    • -0
    • +105
    ./dotlrn-clubs-create.sql
    • -0
    • +408
    ./dotlrn-communities-create.sql
    • -0
    • +302
    ./dotlrn-community-memberships-create.sql
    • -0
    • +407
    ./dotlrn-community-memberships-packages-create.sql
    • -50
    • +13
    ./dotlrn-create.sql
  16. … 54 more files in changeset.