Index: openacs-4/packages/datamanager-portlet/sql/postgresql/datamanager-portlet-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/datamanager-portlet/sql/postgresql/datamanager-portlet-drop.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/datamanager-portlet/sql/postgresql/datamanager-portlet-drop.sql 5 Jul 2005 10:10:59 -0000 1.1.2.1 +++ openacs-4/packages/datamanager-portlet/sql/postgresql/datamanager-portlet-drop.sql 20 Jul 2005 13:52:51 -0000 1.1.2.2 @@ -1,108 +1,2 @@ --- --- Copyright (C) 2004 University XYZ --- --- 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. --- --- --- Procedures to support the datamanager portlet --- --- @author YYY ZZZ (YYY.ZZZ@xx.yy) --- @creation-date 2004-10-10 --- @version $Id: datamanager-portlet-drop.sql,v 0.1 2004/10/10 - -create function inline_1() -returns integer as ' -declare - ds_id portal_datasources.datasource_id%TYPE; -begin - - select datasource_id into ds_id - from portal_datasources - where name = ''datamanager_portlet''; - - if not found then - RAISE EXCEPTION '' No datasource id found '', ds_id; - ds_id := null; - end if; - - if ds_id is NOT null then - perform portal_datasource__delete(ds_id); - end if; - - -- drop the hooks - perform acs_sc_impl_alias__delete ( - ''portal_datasource'', - ''datamanager_portlet'', - ''GetMyName'' - ); - - perform acs_sc_impl_alias__delete ( - ''portal_datasource'', - ''datamanager_portlet'', - ''GetPrettyName'' - ); - - - perform acs_sc_impl_alias__delete ( - ''portal_datasource'', - ''datamanager_portlet'', - ''Link'' - ); - - perform acs_sc_impl_alias__delete ( - ''portal_datasource'', - ''datamanager_portlet'', - ''AddSelfToPage'' - ); - - perform acs_sc_impl_alias__delete ( - ''portal_datasource'', - ''datamanager_portlet'', - ''Show'' - ); - - perform acs_sc_impl_alias__delete ( - ''portal_datasource'', - ''datamanager_portlet'', - ''Edit'' - ); - - perform acs_sc_impl_alias__delete ( - ''portal_datasource'', - ''datamanager_portlet'', - ''RemoveSelfFromPage'' - ); - - -- Drop the binding - perform acs_sc_binding__delete ( - ''portal_datasource'', - ''datamanager_portlet'' - ); - - -- drop the impl - perform acs_sc_impl__delete ( - ''portal_datasource'', - ''datamanager_portlet'' - ); - - return 0; -end;' language 'plpgsql'; - -select inline_1(); -drop function inline_1(); - \i datamanager-admin-portlet-drop.sql - - -