pears.NetOwnerRemoveFromFavs

CREATE PROCEDURE "pears"."NetOwnerRemoveFromFavs"( IN "pWebUserID" CHAR(20),IN "FavID" CHAR(20) ) 
/*RESULT( column_name column_type, ... ) */
BEGIN
  IF((SELECT "count"() FROM "iqxnetuser" WHERE "iqxnetuserid" = "pWebUserID") = 0) THEN
    SELECT '99:~invalid user';
    RETURN
  END IF;
  DELETE FROM "Favourites" WHERE "FavouritesID" = "FavID";
  SELECT '0:~Success'
END /* DOC
2016-12-01 PC test and doc
added check on pWebUserID
 
Inputs:
pWebUserID
FavID
 
Outputs:
undefined
 
Tests:
invalid pWebUserID
valid pWebUserID invalid FavID
valid pWebUserID, FavID
 
*/
/* TEST
call NetTestSetup('');
update iqxnetuserlink set employmentid=null where IQXNetUserLinkID in ('test.client','test.agency','test.candidate','test.owner');
update iqxnetuserlink set employmentid='TEST' where IQXNetUserLinkID='test.owner';
insert into Favourites (FavouritesID, Parent, ID, Staffid, Description, Type) on existing skip values ('TEST', null, null, 'TEST', '', 'H');
insert into Favourites (FavouritesID, Parent, ID, Staffid, Description, Type) on existing skip values ('TEST2', 'TEST', 'TEST', 'TEST', 'test', 'P');
select * from NetOwnerIsFav(null,null);
expect 99*;
select * from NetOwnerRemoveFromFavs('test.owner',null);
expect 0*;
select * from NetOwnerRemoveFromFavs('test.owner','TEST');
expect 0*;
select * from favourites where staffid='TEST';
expect FavouritesID=TEST2,ID=TEST,Staffid=TEST,description=test;
expect EOF;
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerRemoveFromFavs" IS 
{CREATE PROCEDURE pears."NetOwnerRemoveFromFavs"( IN "pWebUserID" CHAR(20),IN "FavID" CHAR(20) )
/*RESULT( column_name column_type, ... ) */
BEGIN
    IF ((SELECT COUNT(*) FROM iqxnetuser WHERE iqxnetuserid=pWebUserID)=0) THEN
        SELECT '99:~invalid user';
        RETURN;
    END IF;
	DELETE FROM Favourites WHERE FavouritesID=FavID;
    SELECT '0:~Success';
END
 
/* DOC
2016-12-01 PC test and doc
    added check on pWebUserID
 
Inputs:
    pWebUserID
    FavID
 
Outputs:
    undefined
 
Tests:
    invalid pWebUserID
    valid pWebUserID invalid FavID
    valid pWebUserID, FavID
 
*/
 
/* TEST
call NetTestSetup('');
update iqxnetuserlink set employmentid=null where IQXNetUserLinkID in ('test.client','test.agency','test.candidate','test.owner');
update iqxnetuserlink set employmentid='TEST' where IQXNetUserLinkID='test.owner';
insert into Favourites (FavouritesID, Parent, ID, Staffid, Description, Type) on existing skip values ('TEST', null, null, 'TEST', '', 'H');
insert into Favourites (FavouritesID, Parent, ID, Staffid, Description, Type) on existing skip values ('TEST2', 'TEST', 'TEST', 'TEST', 'test', 'P');
select * from NetOwnerIsFav(null,null);
expect 99*;
select * from NetOwnerRemoveFromFavs('test.owner',null);
expect 0*;
select * from NetOwnerRemoveFromFavs('test.owner','TEST');
expect 0*;
select * from favourites where staffid='TEST';
expect FavouritesID=TEST2,ID=TEST,Staffid=TEST,description=test;
expect EOF;
*/
}