Index: openacs-4/packages/dotlrn-homework/sql/oracle/dotlrn-homework-portlet-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-homework/sql/oracle/Attic/dotlrn-homework-portlet-drop.sql,v diff -u -N --- openacs-4/packages/dotlrn-homework/sql/oracle/dotlrn-homework-portlet-drop.sql 17 Feb 2003 20:56:15 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,179 +0,0 @@ - --- Drops homework portlets - --- @author Don Baccus (dhogaza@pacifier.com) --- @creation-date 2002-07-19 - --- $Id: dotlrn-homework-portlet-drop.sql,v 1.1 2003/02/17 20:56:15 donb Exp $ - --- This is free software distributed under the terms of the GNU Public --- License version 2 or higher. Full text of the license is available --- from the GNU Project: http://www.fsf.org/copyleft/gpl.html - -declare - ds_id portal_datasources.datasource_id%TYPE; -begin - - begin - select datasource_id into ds_id - from portal_datasources - where name = 'dotlrn_homework_portlet'; - exception when no_data_found then - ds_id := null; - end; - - if ds_id is not null then - portal_datasource.delete(ds_id); - end if; - -end; -/ -show errors; - -declare - foo integer; -begin - - -- drop the hooks - foo := acs_sc_impl.delete_alias ( - 'portal_datasource', - 'dotlrn_homework_portlet', - 'GetMyName' - ); - - foo := acs_sc_impl.delete_alias ( - 'portal_datasource', - 'dotlrn_homework_portlet', - 'GetPrettyName' - ); - - - foo := acs_sc_impl.delete_alias ( - 'portal_datasource', - 'dotlrn_homework_portlet', - 'Link' - ); - - foo := acs_sc_impl.delete_alias ( - 'portal_datasource', - 'dotlrn_homework_portlet', - 'AddSelfToPage' - ); - - foo := acs_sc_impl.delete_alias ( - 'portal_datasource', - 'dotlrn_homework_portlet', - 'Show' - ); - - foo := acs_sc_impl.delete_alias ( - 'portal_datasource', - 'dotlrn_homework_portlet', - 'Edit' - ); - - foo := acs_sc_impl.delete_alias ( - 'portal_datasource', - 'dotlrn_homework_portlet', - 'RemoveSelfFromPage' - ); - - -- Drop the binding - acs_sc_binding.delete ( - contract_name => 'portal_datasource', - impl_name => 'dotlrn_homework_portlet' - ); - - -- drop the impl - acs_sc_impl.delete ( - 'portal_datasource', - 'dotlrn_homework_portlet' - ); -end; -/ -show errors - --- Drop admin portlet -declare - ds_id portal_datasources.datasource_id%TYPE; -begin - - begin - select datasource_id into ds_id - from portal_datasources - where name = 'dotlrn_homework_admin_portlet'; - exception when no_data_found then - ds_id := null; - end; - - if ds_id is not null then - portal_datasource.delete(ds_id); - end if; - -end; -/ -show errors; - -declare - foo integer; -begin - - -- drop the hooks - foo := acs_sc_impl.delete_alias ( - 'portal_datasource', - 'dotlrn_homework_admin_portlet', - 'GetMyName' - ); - - foo := acs_sc_impl.delete_alias ( - 'portal_datasource', - 'dotlrn_homework_admin_portlet', - 'GetPrettyName' - ); - - - foo := acs_sc_impl.delete_alias ( - 'portal_datasource', - 'dotlrn_homework_admin_portlet', - 'Link' - ); - - foo := acs_sc_impl.delete_alias ( - 'portal_datasource', - 'dotlrn_homework_admin_portlet', - 'AddSelfToPage' - ); - - foo := acs_sc_impl.delete_alias ( - 'portal_datasource', - 'dotlrn_homework_admin_portlet', - 'Show' - ); - - foo := acs_sc_impl.delete_alias ( - 'portal_datasource', - 'dotlrn_homework_admin_portlet', - 'Edit' - ); - - foo := acs_sc_impl.delete_alias ( - 'portal_datasource', - 'dotlrn_homework_admin_portlet', - 'RemoveSelfFromPage' - ); - - -- Drop the binding - acs_sc_binding.delete ( - contract_name => 'portal_datasource', - impl_name => 'dotlrn_homework_admin_portlet' - ); - - -- drop the impl - acs_sc_impl.delete ( - 'portal_datasource', - 'dotlrn_homework_admin_portlet' - ); -end; -/ -show errors -