-
Notifications
You must be signed in to change notification settings - Fork 0
/
fGetPartner.sql
28 lines (21 loc) · 1.01 KB
/
fGetPartner.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
DELIMITER $$
CREATE DEFINER=`root`@`%` FUNCTION `fGetPartner`(PersonIdIn INT) RETURNS int(11)
READS SQL DATA
DETERMINISTIC
COMMENT 'Function to get the PersonId of the parner of a person with PersonIdIn.'
BEGIN
DECLARE Partner INT;
DECLARE NewTranNo INT;
SET NewTranNo = GetTranNo("fGetPartner");
-- Schrijf start van deze SQL transactie naar log
INSERT INTO humans.testlog
SET TestLog = CONCAT('TransAction-', IFNULL(NewTranNo, 'null'), '. Start FUNC: fGetPartner() voor persoon: ', IFNULL(PersonIdIn, '')),
TestLogDateTime = NOW();
select RelationWithPerson INTO Partner from relations where RelationPerson= PersonIdIn and RelationName = "3";
-- Schrijf einde van deze SQL transactie naar log
INSERT INTO humans.testlog
SET TestLog = CONCAT('TransAction-', IFNULL(NewTranNo, 'null'), '. End FUNC: fGetPartner() voor persoon: ', IFNULL(PersonIdIn, ''), '. Partner found= ',IFNULL(Partner, '')),
TestLogDateTime = NOW();
RETURN Partner;
END$$
DELIMITER ;