--
--  Copyright (C) 2001, 2002 MIT
--
--  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.3 2014/10/27 16:41:06 victorg Exp $
--
-- Postgresql port adarsh@symphinity.com
--  
-- 11th July 2002
--




--
-- procedure inline_0/0
--
CREATE OR REPLACE 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
);