Index: openacs-4/packages/dotlrn-dotlrn/sql/postgresql/dotlrn-dotlrn-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-dotlrn/sql/postgresql/dotlrn-dotlrn-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/dotlrn-dotlrn/sql/postgresql/dotlrn-dotlrn-create.sql 10 May 2002 06:35:14 -0000 1.2 +++ openacs-4/packages/dotlrn-dotlrn/sql/postgresql/dotlrn-dotlrn-create.sql 8 Jul 2002 23:00:32 -0000 1.3 @@ -1,133 +1,165 @@ +-- +-- Copyright (C) 2001, 2002 OpenForce, Inc. +-- +-- This file is part of dotLRN. +-- +-- dotLRN is free software; you can redistribute it and/or modify it under the +-- terms of the GNU General Public License as published by the Free Software +-- Foundation; either version 2 of the License, or (at your option) any later +-- version. +-- +-- dotLRN is distributed in the hope that it will be useful, but WITHOUT ANY +-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS +-- FOR A PARTICULAR PURPOSE. See the GNU General Public License for more +-- details. +-- + -- -- The "dotLRN" applet for dotLRN -- copyright 2001, OpenForce -- distributed under GPL v2.0 -- --- ported to PG by Ben +-- -- ben,arjun@openforce.net -- -- 10/05/2001 -- +-- ported to pg by dan chak (chak@openforce.net) +-- 2002-07-08 - +create function inline_0() +returns integer as ' +declare + foo integer; begin -- create the implementation - select acs_sc_impl__new ( - 'dotlrn_applet', - 'dotlrn_dotlrn', - 'dotlrn_dotlrn' + foo := acs_sc_impl__new ( + ''dotlrn_applet'', + ''dotlrn_dotlrn'', + ''dotlrn_dotlrn'' ); -- add all the hooks -- GetPrettyName - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_dotlrn', - 'GetPrettyName', - 'dotlrn_dotlrn::get_pretty_name', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_dotlrn'', + ''GetPrettyName'', + ''dotlrn_dotlrn::get_pretty_name'', + ''TCL'' ); -- AddApplet - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_dotlrn', - 'AddApplet', - 'dotlrn_dotlrn::add_applet', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_dotlrn'', + ''AddApplet'', + ''dotlrn_dotlrn::add_applet'', + ''TCL'' ); + -- RemoveApplet + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_dotlrn'', + ''RemoveApplet'', + ''dotlrn_dotlrn::remove_applet'', + ''TCL'' + ); -- AddAppletToCommunity - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_dotlrn', - 'AddAppletToCommunity', - 'dotlrn_dotlrn::add_applet_to_community', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_dotlrn'', + ''AddAppletToCommunity'', + ''dotlrn_dotlrn::add_applet_to_community'', + ''TCL'' ); - - -- RemoveApplet - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_dotlrn', - 'RemoveApplet', - 'dotlrn_dotlrn::remove_applet', - 'TCL' + -- RemoveAppletFromCommunity + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_dotlrn'', + ''RemoveAppletFromCommunity'', + ''dotlrn_dotlrn::remove_applet_from_community'', + ''TCL'' ); + -- AddUser - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_dotlrn', - 'AddUser', - 'dotlrn_dotlrn::add_user', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_dotlrn'', + ''AddUser'', + ''dotlrn_dotlrn::add_user'', + ''TCL'' ); + -- RemoveUser + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_dotlrn'', + ''RemoveUser'', + ''dotlrn_dotlrn::remove_user'', + ''TCL'' + ); -- AddUserToCommunity - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_dotlrn', - 'AddUserToCommunity', - 'dotlrn_dotlrn::add_user_to_community', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_dotlrn'', + ''AddUserToCommunity'', + ''dotlrn_dotlrn::add_user_to_community'', + ''TCL'' ); - -- RemoveUser - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_dotlrn', - 'RemoveUser', - 'dotlrn_dotlrn::remove_user', - 'TCL' - ); - -- RemoveUserFromCommunity - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_dotlrn', - 'RemoveUserFromCommunity', - 'dotlrn_dotlrn::remove_user_from_community', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_dotlrn'', + ''RemoveUserFromCommunity'', + ''dotlrn_dotlrn::remove_user_from_community'', + ''TCL'' ); -- AddPortlet - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_dotlrn', - 'AddPortlet', - 'dotlrn_dotlrn::add_portlet', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_dotlrn'', + ''AddPortlet'', + ''dotlrn_dotlrn::add_portlet'', + ''TCL'' ); -- RemovePortlet - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_dotlrn', - 'RemovePortlet', - 'dotlrn_dotlrn::remove_portlet', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_dotlrn'', + ''RemovePortlet'', + ''dotlrn_dotlrn::remove_portlet'', + ''TCL'' ); -- Clone - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_dotlrn', - 'Clone', - 'dotlrn_dotlrn::clone', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_dotlrn'', + ''Clone'', + ''dotlrn_dotlrn::clone'', + ''TCL'' ); -- Add the binding - select acs_sc_binding__new ( - contract_name => 'dotlrn_applet', - impl_name => 'dotlrn_dotlrn' + perform acs_sc_binding__new ( + ''dotlrn_applet'', + ''dotlrn_dotlrn'' ); -end; -\i dotlrn-members-create.sql -\i dotlrn-members-staff-create.sql + return 0; + +end;' language 'plpgsql'; + +select inline_0(); +drop function inline_0(); + Index: openacs-4/packages/dotlrn-dotlrn/sql/postgresql/dotlrn-members-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-dotlrn/sql/postgresql/dotlrn-members-create.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/dotlrn-dotlrn/sql/postgresql/dotlrn-members-create.sql 29 Mar 2002 16:59:13 -0000 1.1 +++ openacs-4/packages/dotlrn-dotlrn/sql/postgresql/dotlrn-members-create.sql 8 Jul 2002 23:00:32 -0000 1.2 @@ -1,104 +1,164 @@ +-- +-- Copyright (C) 2001, 2002 OpenForce, Inc. +-- +-- This file is part of dotLRN. +-- +-- dotLRN is free software; you can redistribute it and/or modify it under the +-- terms of the GNU General Public License as published by the Free Software +-- Foundation; either version 2 of the License, or (at your option) any later +-- version. +-- +-- dotLRN is distributed in the hope that it will be useful, but WITHOUT ANY +-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS +-- FOR A PARTICULAR PURPOSE. See the GNU General Public License for more +-- details. +-- + -- -- The "dotLRN members" applet for dotLRN -- copyright 2001, OpenForce -- distributed under GPL v2.0 -- --- ported to PG by Ben +-- -- ben,arjun@openforce.net -- -- 10/05/2001 -- +-- ported by dan chak (chak@openforce.net) +-- 2002-07-08 - +create function inline_0() +returns integer as ' +declare + foo integer; begin -- create the implementation - select acs_sc_impl__new ( - 'dotlrn_applet', - 'dotlrn_members', - 'dotlrn_members' + foo := acs_sc_impl__new ( + ''dotlrn_applet'', + ''dotlrn_members'', + ''dotlrn_members'' ); -- add all the hooks -- GetPrettyName - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members', - 'GetPrettyName', - 'dotlrn_members::get_pretty_name', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members'', + ''GetPrettyName'', + ''dotlrn_members::get_pretty_name'', + ''TCL'' ); -- AddApplet - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members', - 'AddApplet', - 'dotlrn_members::add_applet', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members'', + ''AddApplet'', + ''dotlrn_members::add_applet'', + ''TCL'' ); + -- RemoveApplet + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members'', + ''RemoveApplet'', + ''dotlrn_members::remove_applet'', + ''TCL'' + ); -- AddAppletToCommunity - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members', - 'AddAppletToCommunity', - 'dotlrn_members::add_applet_to_community', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members'', + ''AddAppletToCommunity'', + ''dotlrn_members::add_applet_to_community'', + ''TCL'' ); - - -- RemoveApplet - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members', - 'RemoveApplet', - 'dotlrn_members::remove_applet', - 'TCL' + -- RemoveAppletFromCommunity + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members'', + ''RemoveAppletFromCommunity'', + ''dotlrn_members::remove_applet_from_community'', + ''TCL'' ); -- AddUser - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members', - 'AddUser', - 'dotlrn_members::add_user', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members'', + ''AddUser'', + ''dotlrn_members::add_user'', + ''TCL'' ); + -- RemoveUser + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members'', + ''RemoveUser'', + ''dotlrn_members::remove_user'', + ''TCL'' + ); -- AddUserToCommunity - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members', - 'AddUserToCommunity', - 'dotlrn_members::add_user_to_community', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members'', + ''AddUserToCommunity'', + ''dotlrn_members::add_user_to_community'', + ''TCL'' ); - -- RemoveUser - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members', - 'RemoveUser', - 'dotlrn_members::remove_user', - 'TCL' - ); - -- RemoveUserFromCommunity - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members', - 'RemoveUserFromCommunity', - 'dotlrn_members::remove_user_from_community', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members'', + ''RemoveUserFromCommunity'', + ''dotlrn_members::remove_user_from_community'', + ''TCL'' ); + -- AddPortlet + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members'', + ''AddPortlet'', + ''dotlrn_members::add_portlet'', + ''TCL'' + ); + + -- RemovePortlet + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members'', + ''RemovePortlet'', + ''dotlrn_members::remove_portlet'', + ''TCL'' + ); + + -- Clone + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members'', + ''Clone'', + ''dotlrn_members::clone'', + ''TCL'' + ); + -- Add the binding - select acs_sc_binding__new ( - contract_name => 'dotlrn_applet', - impl_name => 'dotlrn_members' + perform acs_sc_binding__new ( + ''dotlrn_applet'', + ''dotlrn_members'' ); -end; + + return 0; + +end;' language 'plpgsql'; + +select inline_0(); +drop function inline_0(); Index: openacs-4/packages/dotlrn-dotlrn/sql/postgresql/dotlrn-members-staff-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-dotlrn/sql/postgresql/dotlrn-members-staff-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/dotlrn-dotlrn/sql/postgresql/dotlrn-members-staff-create.sql 10 May 2002 06:35:14 -0000 1.2 +++ openacs-4/packages/dotlrn-dotlrn/sql/postgresql/dotlrn-members-staff-create.sql 8 Jul 2002 23:00:32 -0000 1.3 @@ -1,4 +1,20 @@ +-- +-- Copyright (C) 2001, 2002 OpenForce, Inc. +-- +-- This file is part of dotLRN. +-- +-- dotLRN is free software; you can redistribute it and/or modify it under the +-- terms of the GNU General Public License as published by the Free Software +-- Foundation; either version 2 of the License, or (at your option) any later +-- version. +-- +-- dotLRN is distributed in the hope that it will be useful, but WITHOUT ANY +-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS +-- FOR A PARTICULAR PURPOSE. See the GNU General Public License for more +-- details. +-- + -- -- The "dotLRN members" applet for dotLRN -- copyright 2001, OpenForce @@ -9,124 +25,140 @@ -- -- 10/05/2001 -- +-- ported to pg by dan chak (chak@openforce.net) +-- 2002-07-08 - +create function inline_0() +returns integer as ' +declare + foo integer; begin -- create the implementation - select acs_sc_impl__new ( - 'dotlrn_applet', - 'dotlrn_members_staff', - 'dotlrn_members_staff' + foo := acs_sc_impl__new ( + ''dotlrn_applet'', + ''dotlrn_members_staff'', + ''dotlrn_members_staff'' ); -- add all the hooks -- GetPrettyName - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members_staff', - 'GetPrettyName', - 'dotlrn_members_staff::get_pretty_name', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members_staff'', + ''GetPrettyName'', + ''dotlrn_members_staff::get_pretty_name'', + ''TCL'' ); -- AddApplet - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members_staff', - 'AddApplet', - 'dotlrn_members_staff::add_applet', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members_staff'', + ''AddApplet'', + ''dotlrn_members_staff::add_applet'', + ''TCL'' ); + -- RemoveApplet + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members_staff'', + ''RemoveApplet'', + ''dotlrn_members_staff::remove_applet'', + ''TCL'' + ); -- AddAppletToCommunity - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members_staff', - 'AddAppletToCommunity', - 'dotlrn_members_staff::add_applet_to_community', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members_staff'', + ''AddAppletToCommunity'', + ''dotlrn_members_staff::add_applet_to_community'', + ''TCL'' ); - - -- RemoveApplet - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members_staff', - 'RemoveApplet', - 'dotlrn_members_staff::remove_applet', - 'TCL' + -- RemoveAppletFromCommunity + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members_staff'', + ''RemoveAppletFromCommunity'', + ''dotlrn_members_staff::remove_applet_from_community'', + ''TCL'' ); -- AddUser - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members_staff', - 'AddUser', - 'dotlrn_members_staff::add_user', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members_staff'', + ''AddUser'', + ''dotlrn_members_staff::add_user'', + ''TCL'' ); + -- RemoveUser + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members_staff'', + ''RemoveUser'', + ''dotlrn_members_staff::remove_user'', + ''TCL'' + ); -- AddUserToCommunity - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members_staff', - 'AddUserToCommunity', - 'dotlrn_members_staff::add_user_to_community', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members_staff'', + ''AddUserToCommunity'', + ''dotlrn_members_staff::add_user_to_community'', + ''TCL'' ); - -- RemoveUser - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members_staff', - 'RemoveUser', - 'dotlrn_members_staff::remove_user', - 'TCL' - ); - -- RemoveUserFromCommunity - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members_staff', - 'RemoveUserFromCommunity', - 'dotlrn_members_staff::remove_user_from_community', - 'TCL' + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members_staff'', + ''RemoveUserFromCommunity'', + ''dotlrn_members_staff::remove_user_from_community'', + ''TCL'' ); + -- AddPortlet + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members_staff'', + ''AddPortlet'', + ''dotlrn_members_staff::add_portlet'', + ''TCL'' + ); - -- AddUserToCommunity - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members_staff', - 'AddUserToCommunity', - 'dotlrn_members_staff::add_user_to_community', - 'TCL' - ); + -- RemovePortlet + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members_staff'', + ''RemovePortlet'', + ''dotlrn_members_staff::remove_portlet'', + ''TCL'' + ); - -- RemoveUser - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members_staff', - 'RemoveUser', - 'dotlrn_members_staff::remove_user', - 'TCL' - ); + -- Clone + foo := acs_sc_impl_alias__new ( + ''dotlrn_applet'', + ''dotlrn_members_staff'', + ''Clone'', + ''dotlrn_members_staff::clone'', + ''TCL'' + ); - -- RemoveUserFromCommunity - select acs_sc_impl_alias__new ( - 'dotlrn_applet', - 'dotlrn_members_staff', - 'RemoveUserFromCommunity', - 'dotlrn_members_staff::remove_user_from_community', - 'TCL' - ); - -- Add the binding - select acs_sc_binding__new ( - contract_name => 'dotlrn_applet', - impl_name => 'dotlrn_members_staff_staff' + perform acs_sc_binding__new ( + ''dotlrn_applet'', + ''dotlrn_members_staff'' ); -end; + + return 0; + +end;' language 'plpgsql'; + +select inline_0(); +drop function inline_0();