oppijanumerorekisteri
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
insertkayttooikeus(character varying, character varying, character varying)
Parameters
Name
Type
Mode
character varying
IN
character varying
IN
character varying
IN
Definition
declare palvelu_name alias for $1; kayttooikeus_rooli alias for $2; kayttooikeus_text_fi alias for $3; _kayttooikeus_exists bigint; begin select count(*) into _kayttooikeus_exists from kayttooikeus k inner join palvelu p on p.id = k.palvelu_id where k.rooli = kayttooikeus_rooli and p.name = palvelu_name; IF _kayttooikeus_exists = 0 THEN insert into text_group (id, version) values (nextval('public.hibernate_sequence'), 1); insert into text (id, version, lang, text, textgroup_id) values (nextval('public.hibernate_sequence'), 1, 'FI', kayttooikeus_text_fi, (select max(id) from text_group)); insert into text (id, version, lang, text, textgroup_id) values (nextval('public.hibernate_sequence'), 1, 'SV', kayttooikeus_text_fi, (select max(id) from text_group)); insert into text (id, version, lang, text, textgroup_id) values (nextval('public.hibernate_sequence'), 1, 'EN', kayttooikeus_text_fi, (select max(id) from text_group)); insert into kayttooikeus (id, version, palvelu_id, rooli, textgroup_id) values (nextval('public.hibernate_sequence'), 1, (select id from palvelu where name = palvelu_name), kayttooikeus_rooli, (select max(id) from text_group)); end if; return 1; end;