Schnittstelle CampusOnline (TU Graz) zu SuperX-Modul COSTAGE
http://www.superx-projekt.de/doku/costage_modul/
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
69 lines
1.7 KiB
69 lines
1.7 KiB
|
|
--Unload Parameter und deren Defaults setzen |
|
|
|
--freemarker template |
|
<sqlvars> |
|
<sqlvar name="unload_params_exists"> |
|
select sp_table_exists('unload_params') from xdummy; |
|
|
|
</sqlvar> |
|
|
|
</sqlvars> |
|
<#if unload_params_exists=1> |
|
|
|
create temp table tmp_unload_params( |
|
tid SERIAL not null, |
|
param_id VARCHAR(255) not null, |
|
param_val VARCHAR(255) , |
|
default_val VARCHAR(255) , |
|
description VARCHAR(255) , |
|
systeminfo_id INTEGER |
|
); |
|
|
|
insert into tmp_unload_params(param_id, |
|
param_val, |
|
default_val, |
|
description, |
|
systeminfo_id) |
|
values ('EXTERNAL_SUBJECTS', |
|
'false', |
|
'false', |
|
'Übergabe externe Fächer von COSTAGE ans Studierenden-Modul', |
|
7); |
|
--description wird immer geändert: |
|
update unload_params set description=(select T.description |
|
from tmp_unload_params T |
|
where T.param_id=unload_params.param_id |
|
and T.systeminfo_id=unload_params.systeminfo_id) |
|
where systeminfo_id=7 |
|
and param_id in (select param_id from tmp_unload_params); |
|
|
|
--default_val wird immer geändert: |
|
update unload_params set default_val=(select T.default_val |
|
from tmp_unload_params T |
|
where T.param_id=unload_params.param_id |
|
and T.systeminfo_id=unload_params.systeminfo_id) |
|
where systeminfo_id=7 |
|
and param_id in (select param_id from tmp_unload_params); |
|
|
|
|
|
delete from tmp_unload_params where systeminfo_id || param_id in |
|
(select systeminfo_id || param_id from unload_params); |
|
|
|
insert into unload_params(param_id, |
|
param_val, |
|
default_val, |
|
description, |
|
systeminfo_id) |
|
select param_id, |
|
param_val, |
|
default_val, |
|
description, |
|
systeminfo_id |
|
from tmp_unload_params |
|
where param_id is not null; |
|
|
|
drop table tmp_unload_params; |
|
|
|
|
|
</#if>
|
|
|