Index: openacs-4/packages/invoices-portlet/sql/postgresql/invoices-list-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/invoices-portlet/sql/postgresql/invoices-list-create.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/invoices-portlet/sql/postgresql/invoices-list-create.sql	30 Nov 2005 16:01:58 -0000	1.1.1.1.2.2
@@ -0,0 +1,222 @@
+--
+--  Copyright (C) 2005 Cognovis
+--
+--  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.
+--
+
+--
+-- /invoices-portlet/sql/oracle/invoices-portlet-create.sql
+--
+
+-- Creates invoices portlet
+
+-- Copyright (C) 2005 Cognovis
+-- @author Bjoern Kiesbye (bjoern_kiesbye@web.de)
+-- @creation-date 2005-16-06
+
+
+-- 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
+
+create function inline_0()
+returns integer as '
+declare
+  ds_id portal_datasources.datasource_id%TYPE;
+begin
+  ds_id := portal_datasource__new(
+         ''invoices_portlet'',
+         ''Displays the Invoices Portlet''
+  );
+
+  
+  --  the standard 4 params
+
+  -- shadeable_p 
+  perform portal_datasource__set_def_param (
+	ds_id,
+	''t'',
+	''t'',
+	''shadeable_p'',
+	''t''
+);	
+
+
+  -- hideable_p 
+  perform portal_datasource__set_def_param (
+	ds_id,
+	''t'',
+	''t'',
+	''hideable_p'',
+	''t''
+);	
+
+  -- user_editable_p 
+  perform portal_datasource__set_def_param (
+	ds_id,
+	''t'',
+	''t'',
+	''user_editable_p'',
+	''t''
+);	
+
+  -- shaded_p 
+  perform portal_datasource__set_def_param (
+	ds_id,
+	''t'',
+	''t'',
+	''shaded_p'',
+	''f''
+);	
+
+  -- link_hideable_p 
+  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''
+    );
+
+
+
+
+
+   return 0;
+
+end;' language 'plpgsql';
+select inline_0();
+drop function inline_0();
+
+
+create function inline_0()
+returns integer as '
+declare
+	foo integer;
+begin
+	-- create the implementation
+	foo := acs_sc_impl__new (
+		''portal_datasource'',
+		''invoices_portlet'',
+		''invoices_portlet''
+	);
+
+   return 0;
+
+end;' language 'plpgsql';
+select inline_0();
+drop function inline_0();
+
+
+
+create function inline_0()
+returns integer as '
+declare
+	foo integer;
+begin
+
+	-- add all the hooks
+	foo := acs_sc_impl_alias__new (
+	       ''portal_datasource'',
+	       ''invoices_portlet'',
+	       ''GetMyName'',
+	       ''invoices_portlet::get_my_name'',
+	       ''TCL''
+	);
+
+	foo := acs_sc_impl_alias__new (
+	       ''portal_datasource'',
+	       ''invoices_portlet'',
+	       ''GetPrettyName'',
+	       ''invoices_portlet::get_pretty_name'',
+	       ''TCL''
+	);
+
+	foo := acs_sc_impl_alias__new (
+	       ''portal_datasource'',
+	       ''invoices_portlet'',
+	       ''Link'',
+	       ''invoices_portlet::link'',
+	       ''TCL''
+	);
+
+	foo := acs_sc_impl_alias__new (
+	       ''portal_datasource'',
+	       ''invoices_portlet'',
+	       ''AddSelfToPage'',
+	       ''invoices_portlet::add_self_to_page'',
+	       ''TCL''
+	);
+
+	foo := acs_sc_impl_alias__new (
+	       ''portal_datasource'',
+	       ''invoices_portlet'',
+	       ''Show'',
+	       ''invoices_portlet::show'',
+	       ''TCL''
+	);
+
+	foo := acs_sc_impl_alias__new (
+	       ''portal_datasource'',
+	       ''invoices_portlet'',
+	       ''Edit'',
+	       ''invoices_portlet::edit'',
+	       ''TCL''
+	);
+
+	foo := acs_sc_impl_alias__new (
+	       ''portal_datasource'',
+	       ''invoices_portlet'',
+	       ''RemoveSelfFromPage'',
+	       ''invoices_portlet::remove_self_from_page'',
+	       ''TCL''
+	);
+
+   return 0;
+
+end;' language 'plpgsql';
+select inline_0();
+drop function inline_0();
+
+
+
+create function inline_0()
+returns integer as '
+declare
+	foo integer;
+begin
+
+	-- Add the binding
+	perform acs_sc_binding__new (
+	    ''portal_datasource'',
+	    ''invoices_portlet''
+	);
+
+   return 0;
+
+end;' language 'plpgsql';
+select inline_0();
+drop function inline_0();
+
+
+
+
