Forum OpenACS Development: Oracle upgrade script needed

Collapse
1: Oracle upgrade script needed
Posted by Malte Sussdorff on 05/10/06 08:44 PM
Here is the postgres version, can someone please put the oracle version into CVS ?

/openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.2.0d3-1.3d1.sql

-- Update the package ids for projects
create function inline_0 ()
returns integer as '
declare
ct RECORD;
begin
for ct in select package_id, forum_id from forums_forums
loop
update acs_objects set package_id = ct.package_id where object_id = ct.forum_id;
end loop;

return null;
end;' language 'plpgsql';

select inline_0();
drop function inline_0();

Collapse
2: Re: Oracle upgrade script needed (response to 1)
Posted by Emmanuelle Raffenne on 05/11/06 02:04 PM
I've committed oracle script /openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.2.0d4-1.3d1.sql

-- Update the package ids for projects
declare
cursor ct is
select package_id, forum_id from forums_forums;
begin
for v_ct in ct loop
update acs_objects set package_id = v_ct.package_id where object_id = v_ct.forum_id;
end loop;
end;
/
show errors