-- 
-- packages/lams2int-portlet/sql/postgresql/lams2int-admin-portlet-create.sql
-- 
-- @author Ernie Ghiglione (ErnieG@melcoe.mq.edu.au)
-- @creation-date 2007-04-17
-- @cvs-id lams2int-admin-portlet-create.sql,v 1.1 2007/09/12 06:37:02 ernieg Exp
--

create function inline_0 ()
returns integer as '
declare
  ds_id         portal_datasources.datasource_id%TYPE;
begin
        ds_id = portal_datasource__new(
                        ''lams2int_admin_portlet'',
                        ''Displays a folder_id''
                        );

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

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

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

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

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

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

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

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

-- Add the binding
select acs_sc_binding__new(
        'portal_datasource',
        'lams2int_admin_portlet'
);