egdb3_14_1
.config
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
z3950_source_credentials_apply(src text, org integer, uname text, passwd text)
Parameters
Name
Type
Mode
src
text
IN
org
integer
IN
uname
text
IN
passwd
text
IN
Definition
BEGIN PERFORM 1 FROM config.z3950_source_credentials WHERE owner = org AND source = src; IF FOUND THEN IF COALESCE(uname, '') = '' AND COALESCE(passwd, '') = '' THEN DELETE FROM config.z3950_source_credentials WHERE owner = org AND source = src; ELSE UPDATE config.z3950_source_credentials SET username = uname, password = passwd WHERE owner = org AND source = src; END IF; ELSE IF COALESCE(uname, '') <> '' OR COALESCE(passwd, '') <> '' THEN INSERT INTO config.z3950_source_credentials (source, owner, username, password) VALUES (src, org, uname, passwd); END IF; END IF; END;