--
--  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 the bulk-mail portlet
--
-- @author yon (yon@openforce.net)
-- @creation-date 2002-05-13
-- @version $Id: bm-portlet-create.sql,v 1.1 2002/07/15 20:43:41 chak Exp $
--
-- Postgresql port adarsh@symphinity.com
--  
-- 11th July 2002
--


create function inline_0 ()
returns integer as '
declare
  ds_id 	portal_datasources.datasource_id%TYPE;
begin
	ds_id = portal_datasource__new(
        		''bm_portlet'',
        		''Displays spam info for the given package''
	);

perform portal_datasource__set_def_param(
        ds_id,							--datasource_id
        ''t'',							--config_required_p
        ''t'',							--configured_p
        ''shadeable_p'',				--key
        ''t''							--value
);

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'',
        ''f'',
        ''package_id'',
        ''''
);

perform portal_datasource__set_def_param(
	ds_id,
 	''t'',
  	''f'',
   	''scoped_p'',
    	''t''
);

return 0;

end; ' language 'plpgsql';

select inline_0 ();

drop function inline_0 ();


-- create the implementation
select acs_sc_impl__new(
        'portal_datasource',
        'bm_portlet',
        'bm_portlet'
    );

    -- add all the hooks
select acs_sc_impl_alias__new(
        'portal_datasource',
        'bm_portlet',
        'GetMyName',
        'bm_portlet::get_my_name',
        'TCL'
);

select acs_sc_impl_alias__new(
        'portal_datasource',
        'bm_portlet',
        'GetPrettyName',
        'bm_portlet::get_pretty_name',
        'TCL'
);

select acs_sc_impl_alias__new(
        'portal_datasource',
        'bm_portlet',
        'Link',
        'bm_portlet::link',
        'TCL'
);

select acs_sc_impl_alias__new(
        'portal_datasource',
        'bm_portlet',
        'AddSelfToPage',
        'bm_portlet::add_self_to_page',
        'TCL'
);

select acs_sc_impl_alias__new(
        'portal_datasource',
        'bm_portlet',
        'Show',
        'bm_portlet::show',
        'TCL'
);

select acs_sc_impl_alias__new(
        'portal_datasource',
        'bm_portlet',
        'Edit',
        'bm_portlet::edit',
        'TCL'
);

select acs_sc_impl_alias__new(
        'portal_datasource',
        'bm_portlet',
        'RemoveSelfFromPage',
        'bm_portlet::remove_self_from_page',
        'TCL'
);

select acs_sc_binding__new(
        'portal_datasource',				--contract_name
        'bm_portlet'						--impl_name
);