Index: openacs-4/packages/faq-portlet/sql/postgresql/faq-admin-portlet-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/faq-portlet/sql/postgresql/faq-admin-portlet-create.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/faq-portlet/sql/postgresql/faq-admin-portlet-create.sql 10 Jul 2002 16:55:06 -0000 1.1 @@ -0,0 +1,171 @@ +-- +-- 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. +-- + +-- +-- Creates FAQ portlet +-- +-- @author Arjun Sanyal (arjun@openforce.net) +-- @author Ben Adida (ben@openforce) +-- @creation-date 2002-01-19 +-- @version $Id: faq-admin-portlet-create.sql,v 1.1 2002/07/10 16:55:06 chak Exp $ +-- +-- Postgresql port adarsh@symphinity.com +-- +-- 10th July 2002 +-- + +create function inline_0 () +returns integer as ' +declare + ds_id portal_datasources.datasource_id%TYPE; +begin + ds_id = portal_datasource__new( + ''faq_admin_portlet'', + ''Displays a FAQ'' + ); + +RAISE NOTICE '' created new ds''; + + perform portal_datasource__set_def_param ( + ds_id, + ''t'', + ''t'', + ''shadeable_p'', + ''f'' + ); + +RAISE NOTICE '' set shadeable''; + perform portal_datasource__set_def_param ( + ds_id, + ''t'', + ''t'', + ''hideable_p'', + ''f'' + ); + +RAISE NOTICE '' set hideable''; + perform portal_datasource__set_def_param ( + ds_id, + ''t'', + ''t'', + ''user_editable_p'', + ''f'' + ); + + perform portal_datasource__set_def_param ( + ds_id, + ''t'', + ''t'', + ''shaded_p'', + ''f'' + ); + + perform portal_datasource__set_def_param ( + ds_id, + ''t'', + ''t'', + ''link_hideable_p'', + ''t'' + ); + + perform portal_datasource__set_def_param ( + ds_id, + ''t'', + ''f'', + ''package_id'', + '' '' + ); + + +return 0; + +end;' language 'plpgsql'; + + + +select inline_0(); + +drop function inline_0 (); + +-- create the implementation +select acs_sc_impl__new ( + 'portal_datasource', + 'faq_admin_portlet', + 'faq_admin_portlet' +); + +-- add all the hooks +select acs_sc_impl_alias__new( + 'portal_datasource', + 'faq_admin_portlet', + 'GetMyName', + 'faq_admin_portlet::get_my_name', + 'TCL' +); + +select acs_sc_impl_alias__new( + 'portal_datasource', + 'faq_admin_portlet', + 'GetPrettyName', + 'faq_admin_portlet::get_pretty_name', + 'TCL' +); + +select acs_sc_impl_alias__new( + 'portal_datasource', + 'faq_admin_portlet', + 'Link', + 'faq_admin_portlet::link', + 'TCL' +); + +select acs_sc_impl_alias__new( + 'portal_datasource', + 'faq_admin_portlet', + 'AddSelfToPage', + 'faq_admin_portlet::add_self_to_page', + 'TCL' +); + +select acs_sc_impl_alias__new( + 'portal_datasource', + 'faq_admin_portlet', + 'Show', + 'faq_admin_portlet::show', + 'TCL' +); + +select acs_sc_impl_alias__new( + 'portal_datasource', + 'faq_admin_portlet', + 'Edit', + 'faq_admin_portlet::edit', + 'TCL' +); + +select acs_sc_impl_alias__new( + 'portal_datasource', + 'faq_admin_portlet', + 'RemoveSelfFromPage', + 'faq_admin_portlet::remove_self_from_page', + 'TCL' +); + +-- Add the binding +select acs_sc_binding__new( + 'portal_datasource', + 'faq_admin_portlet' +); Index: openacs-4/packages/faq-portlet/sql/postgresql/faq-admin-portlet-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/faq-portlet/sql/postgresql/faq-admin-portlet-drop.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/faq-portlet/sql/postgresql/faq-admin-portlet-drop.sql 10 Jul 2002 16:55:06 -0000 1.1 @@ -0,0 +1,123 @@ +-- +-- 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. +-- + +-- +-- /faq-portlet/sql/oracle/faq-portlet-drop.sql +-- + +-- Drops faq portlet + +-- Copyright (C) 2001 Openforce, Inc. +-- @author Arjun Sanyal (arjun@openforce.net) +-- @creation-date 2001-30-09 + +-- $Id: faq-admin-portlet-drop.sql,v 1.1 2002/07/10 16:55:06 chak 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 +-- +-- Postgresql port adarsh@symphinity.com +-- +-- 10 July 2002 + + +create function inline_0 () +returns integer as ' +declare + ds_id portal_datasources.datasource_id%TYPE; +begin + + select datasource_id into ds_id + from portal_datasources + where name = ''faq_admin_portlet''; + + if not found then + raise exception ''No datasource_id found here '',ds_id ; + ds_id := null; + end if; + + + if ds_id is NOT null then + perform portal_datasource__delete(ds_id); + end if; + +return 0; + +end;' language 'plpgsql'; + +select inline_0 (); + +drop function inline_0 (); + +-- create the implementation +select acs_sc_impl__delete ( + 'portal_datasource', + 'faq_admin_portlet' +); + +-- add all the hooks +select acs_sc_impl_alias__delete( + 'portal_datasource', + 'faq_admin_portlet', + 'GetMyName' +); + +select acs_sc_impl_alias__delete( + 'portal_datasource', + 'faq_admin_portlet', + 'GetPrettyName' +); + +select acs_sc_impl_alias__delete( + 'portal_datasource', + 'faq_admin_portlet', + 'Link' +); + +select acs_sc_impl_alias__delete( + 'portal_datasource', + 'faq_admin_portlet', + 'AddSelfToPage' +); + +select acs_sc_impl_alias__delete( + 'portal_datasource', + 'faq_admin_portlet', + 'Show' +); + +select acs_sc_impl_alias__delete( + 'portal_datasource', + 'faq_admin_portlet', + 'Edit' +); + +select acs_sc_impl_alias__delete( + 'portal_datasource', + 'faq_admin_portlet', + 'RemoveSelfFromPage' +); + +-- Add the binding +select acs_sc_binding__delete( + 'portal_datasource', + 'faq_admin_portlet' +); + + + + Index: openacs-4/packages/faq-portlet/sql/postgresql/faq-portlet-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/faq-portlet/sql/postgresql/faq-portlet-create.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/faq-portlet/sql/postgresql/faq-portlet-create.sql 10 Jul 2002 16:55:06 -0000 1.1 @@ -0,0 +1,176 @@ +-- +-- 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. +-- + +-- +-- Creates FAQ portlet +-- +-- @author Arjun Sanyal (arjun@openforce.net) +-- @creation-date 2001-30-09 +-- @version $Id: faq-portlet-create.sql,v 1.1 2002/07/10 16:55:06 chak Exp $ +-- +-- +-- Postgresql port adarsh@symphinity.com +-- +-- 29 June 2002 + + +create function inline_0 () +returns integer as ' +declare + ds_id portal_datasources.datasource_id%TYPE; +begin + ds_id = portal_datasource__new( + ''faq_portlet'', + ''Displays a FAQ'' + ); + + +perform portal_datasource__set_def_param( + ds_id, + ''t'', + ''t'', + ''shadeable_p'', + ''t'' +); + +perform portal_datasource__set_def_param ( + ds_id, + ''t'', + ''t'', + ''hideable_p'', + ''t'' +); + +perform portal_datasource__set_def_param ( + ds_id, + ''t'', + ''t'', + ''user_editable_p'', + ''f'' +); + +perform portal_datasource__set_def_param ( + ds_id, + ''t'', + ''t'', + ''shaded_p'', + ''f'' +); + +perform portal_datasource__set_def_param ( + ds_id, + ''t'', + ''t'', + ''link_hideable_p'', + ''t'' +); + +perform portal_datasource__set_def_param ( + ds_id, + ''t'', + ''t'', + ''style'', + ''list'' +); + +perform portal_datasource__set_def_param ( + ds_id, + ''t'', + ''f'', + ''package_id'', + '' '' +); + +return 0; + +end; ' language 'plpgsql'; + +select inline_0 (); + +drop function inline_0 (); + +-- create the implementation +select acs_sc_impl__new( + 'portal_datasource', + 'faq_portlet', + 'faq_portlet' +); + + +-- add all the hooks +select acs_sc_impl_alias__new( + 'portal_datasource', + 'faq_portlet', + 'GetMyName', + 'faq_portlet::get_my_name', + 'TCL' +); + +select acs_sc_impl_alias__new( + 'portal_datasource', + 'faq_portlet', + 'GetPrettyName', + 'faq_portlet::get_pretty_name', + 'TCL' +); + +select acs_sc_impl_alias__new( + 'portal_datasource', + 'faq_portlet', + 'Link', + 'faq_portlet::link', + 'TCL' +); + +select acs_sc_impl_alias__new( + 'portal_datasource', + 'faq_portlet', + 'AddSelfToPage', + 'faq_portlet::add_self_to_page', + 'TCL' + ); + +select acs_sc_impl_alias__new( + 'portal_datasource', + 'faq_portlet', + 'Show', + 'faq_portlet::show', + 'TCL' + ); + +select acs_sc_impl_alias__new( + 'portal_datasource', + 'faq_portlet', + 'Edit', + 'faq_portlet::edit', + 'TCL' + ); + +select acs_sc_impl_alias__new( + 'portal_datasource', + 'faq_portlet', + 'RemoveSelfFromPage', + 'faq_portlet::remove_self_from_page', + 'TCL' + ); + + -- Add the binding +select acs_sc_binding__new ( + 'portal_datasource', + 'faq_portlet' +); + +\i faq-admin-portlet-create.sql Index: openacs-4/packages/faq-portlet/sql/postgresql/faq-portlet-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/faq-portlet/sql/postgresql/faq-portlet-drop.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/faq-portlet/sql/postgresql/faq-portlet-drop.sql 10 Jul 2002 16:55:06 -0000 1.1 @@ -0,0 +1,126 @@ +-- +-- 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. +-- + +-- +-- /faq-portlet/sql/oracle/faq-portlet-drop.sql +-- + +-- Drops faq portlet + +-- Copyright (C) 2001 Openforce, Inc. +-- @author Arjun Sanyal (arjun@openforce.net) +-- @creation-date 2001-30-09 + +-- $Id: faq-portlet-drop.sql,v 1.1 2002/07/10 16:55:06 chak 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 +-- +-- Postgresql port adarsh@symphinity.com +-- +-- 29 June 2002 + + +create function inline_0 () +returns integer as ' +declare + ds_id portal_datasources.datasource_id%TYPE; +begin + + select datasource_id into ds_id + from portal_datasources + where name = ''faq_portlet''; + +-- Exception handling? + + + if not found then + raise notice ''No datasource_id found here '', ds_id ; + ds_id := null; + end if; + + + if ds_id is NOT null then + perform portal_datasource__delete(ds_id); + end if; + +return 0; + +end;' language 'plpgsql'; + +select inline_0 (); + +drop function inline_0 (); + + +-- drop the hooks +select acs_sc_impl_alias__delete ( + 'portal_datasource', + 'faq_portlet', + 'GetMyName' +); + +select acs_sc_impl_alias__delete ( + 'portal_datasource', + 'faq_portlet', + 'GetPrettyName' + ); + + +select acs_sc_impl_alias__delete ( + 'portal_datasource', + 'faq_portlet', + 'Link' +); + +select acs_sc_impl_alias__delete ( + 'portal_datasource', + 'faq_portlet', + 'AddSelfToPage' +); + +select acs_sc_impl_alias__delete ( + 'portal_datasource', + 'faq_portlet', + 'Show' +); + +select acs_sc_impl_alias__delete ( + 'portal_datasource', + 'faq_portlet', + 'Edit' +); + +select acs_sc_impl_alias__delete ( + 'portal_datasource', + 'faq_portlet', + 'RemoveSelfFromPage' +); + +-- Drop the binding +select acs_sc_binding__delete ( + 'portal_datasource', + 'faq_portlet' +); + +-- drop the impl +select acs_sc_impl__delete ( + 'portal_datasource', + 'faq_portlet' +); + +\i faq-admin-portlet-drop.sql