-- -- 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 file-storage portlet -- -- @author Arjun Sanyal(arjun@openforce.net) -- @creation-date 2001-30-09 -- @version $Id: fs-portlet-create.sql,v 1.4 2014/10/27 16:41:41 victorg Exp $ -- -- @author dan chak (chak@openforce.net) -- ported to postgres 2002-07-09 \i fs-contents-portlet-create.sql \i fs-admin-portlet-create.sql -- -- procedure inline_0/0 -- CREATE OR REPLACE FUNCTION inline_0( ) RETURNS integer AS $$ DECLARE ds_id portal_datasources.datasource_id%TYPE; foo integer; BEGIN ds_id := portal_datasource__new( 'fs_portlet', 'Displays the given folder_id' ); 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', 'f', 'scoped_p', 't' ); perform portal_datasource__set_def_param( ds_id, 't', 'f', 'folder_id', '' ); perform portal_datasource__set_def_param( ds_id, 't', 'f', 'contents_url', '' ); -- create the implementation foo := acs_sc_impl__new( 'portal_datasource', 'fs_portlet', 'fs_portlet' ); -- add all the hooks foo := acs_sc_impl_alias__new( 'portal_datasource', 'fs_portlet', 'GetMyName', 'fs_portlet::get_my_name', 'TCL' ); foo := acs_sc_impl_alias__new( 'portal_datasource', 'fs_portlet', 'GetPrettyName', 'fs_portlet::get_pretty_name', 'TCL' ); foo := acs_sc_impl_alias__new( 'portal_datasource', 'fs_portlet', 'Link', 'fs_portlet::link', 'TCL' ); foo := acs_sc_impl_alias__new( 'portal_datasource', 'fs_portlet', 'AddSelfToPage', 'fs_portlet::add_self_to_page', 'TCL' ); foo := acs_sc_impl_alias__new( 'portal_datasource', 'fs_portlet', 'Show', 'fs_portlet::show', 'TCL' ); foo := acs_sc_impl_alias__new( 'portal_datasource', 'fs_portlet', 'Edit', 'fs_portlet::edit', 'TCL' ); foo := acs_sc_impl_alias__new( 'portal_datasource', 'fs_portlet', 'RemoveSelfFromPage', 'fs_portlet::remove_self_from_page', 'TCL' ); -- Add the binding perform acs_sc_binding__new( 'portal_datasource', 'fs_portlet' ); return 0; END; $$ LANGUAGE plpgsql; select inline_0(); drop function inline_0();