pears.NetOwnerRemoveFromFavs [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.NetOwnerRemoveFromFavs ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
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;
*/
}
</code>