OpenACS

victorg
committed
oacs-5-5:victorg:20090724141231
on 24 Jul 09
Providing upgrade logic for removing Xinha invalid plugins from the parameter XinhaDefaultPlugins.
/postgresql/dotlrn-tasks-create.sql (deleted)
1   --
2   --  Copyright (C) 2001, 2002 MIT
3   --
4   --  This file is part of dotLRN.
5   --
6   --  dotLRN is free software; you can redistribute it and/or modify it under the
7   --  terms of the GNU General Public License as published by the Free Software
8   --  Foundation; either version 2 of the License, or (at your option) any later
9   --  version.
10   --
11   --  dotLRN is distributed in the hope that it will be useful, but WITHOUT ANY
12   --  WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
13   --  FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more
14   --  details.
15   --
16  
17   -- create the implementation
18  
19  
20   create function inline_0()
21   returns integer as '
22   declare
23           foo integer;
24   begin
25           -- create the implementation
26           foo := acs_sc_impl__new (
27                   ''dotlrn_applet'',
28                   ''dotlrn_tasks'',
29                   ''dotlrn_tasks''
30           );
31  
32           -- GetPrettyName
33           foo := acs_sc_impl_alias__new (
34                  ''dotlrn_applet'',
35                  ''dotlrn_tasks'',
36                  ''GetPrettyName'',
37                  ''dotlrn_tasks::get_pretty_name'',
38                  ''TCL''
39           );
40  
41           -- AddApplet
42           foo := acs_sc_impl_alias__new (
43                  ''dotlrn_applet'',
44                  ''dotlrn_tasks'',
45                  ''AddApplet'',
46                  ''dotlrn_tasks::add_applet'',
47                  ''TCL''
48           );
49  
50           -- RemoveApplet
51           foo := acs_sc_impl_alias__new (
52                  ''dotlrn_applet'',
53                  ''dotlrn_tasks'',
54                  ''RemoveApplet'',
55                  ''dotlrn_tasks::remove_applet'',
56                  ''TCL''
57           );
58  
59           -- AddAppletToCommunity
60           foo := acs_sc_impl_alias__new (
61                  ''dotlrn_applet'',
62                  ''dotlrn_tasks'',
63                  ''AddAppletToCommunity'',
64                  ''dotlrn_tasks::add_applet_to_community'',
65                  ''TCL''
66           );
67  
68           -- RemoveAppletFromCommunity
69           foo := acs_sc_impl_alias__new (
70                  ''dotlrn_applet'',
71                  ''dotlrn_tasks'',
72                  ''RemoveAppletFromCommunity'',
73                  ''dotlrn_tasks::remove_applet_from_community'',
74                  ''TCL''
75           );
76  
77           -- AddUser
78           foo := acs_sc_impl_alias__new (
79                  ''dotlrn_applet'',
80                  ''dotlrn_tasks'',
81                  ''AddUser'',
82                  ''dotlrn_tasks::add_user'',
83                  ''TCL''
84           );
85  
86           -- RemoveUser
87           foo := acs_sc_impl_alias__new (
88                  ''dotlrn_applet'',
89                  ''dotlrn_tasks'',
90                  ''RemoveUser'',
91                  ''dotlrn_tasks::remove_user'',
92                  ''TCL''
93           );
94  
95           -- AddUserToCommunity
96           foo := acs_sc_impl_alias__new (
97                  ''dotlrn_applet'',
98                  ''dotlrn_tasks'',
99                  ''AddUserToCommunity'',
100                  ''dotlrn_tasks::add_user_to_community'',
101                  ''TCL''
102           );
103  
104           -- RemoveUserFromCommunity
105           foo := acs_sc_impl_alias__new (
106                  ''dotlrn_applet'',
107                  ''dotlrn_tasks'',
108                  ''RemoveUserFromCommunity'',
109                  ''dotlrn_tasks::remove_user_from_community'',
110                  ''TCL''
111           );
112  
113       -- AddPortlet
114       foo := acs_sc_impl_alias__new (
115           ''dotlrn_applet'',
116           ''dotlrn_tasks'',
117           ''AddPortlet'',
118           ''dotlrn_tasks::add_portlet'',
119           ''TCL''
120       );
121  
122       -- RemovePortlet
123       foo := acs_sc_impl_alias__new (
124           ''dotlrn_applet'',
125           ''dotlrn_tasks'',
126           ''RemovePortlet'',
127           ''dotlrn_tasks::remove_portlet'',
128           ''TCL''
129       );
130  
131       -- Clone
132       foo := acs_sc_impl_alias__new (
133           ''dotlrn_applet'',
134           ''dotlrn_tasks'',
135           ''Clone'',
136           ''dotlrn_tasks::clone'',
137           ''TCL''
138       );
139  
140       foo := acs_sc_impl_alias__new (
141           ''dotlrn_applet'',
142           ''dotlrn_tasks'',
143           ''ChangeEventHandler'',
144           ''dotlrn_tasks::change_event_handler'',
145           ''TCL''
146       );
147  
148           -- Add the binding
149           perform acs_sc_binding__new (
150               ''dotlrn_applet'',
151               ''dotlrn_tasks''
152           );
153  
154           return 0;
155  
156   end;' language 'plpgsql';
157   select inline_0();
158   drop function inline_0();