is_app_owner -> is_allowed_action

[WcaleNieWolny]

The is_app_owner fn is defined as

CREATE OR REPLACE FUNCTION "public"."is_app_owner"("userid" "uuid", "appid" character varying) RETURNS boolean
    LANGUAGE "plpgsql" SECURITY DEFINER
    AS $$
Begin
  RETURN (SELECT EXISTS (SELECT 1
  FROM apps
  WHERE app_id=appid
  AND user_id=userid));
End;  
$$;

But the CLI calls it as is_app_owner(apikey, appid) This causes the following postgress error

By migrating to is_allowed_action everything works as it should. The is_allowed_action is defined as

CREATE OR REPLACE FUNCTION "public"."is_allowed_action"(apikey text, appid character varying)

[sonarcloud[bot]]

Kudos, SonarCloud Quality Gate passed!   

0 Bugs
0 Vulnerabilities
0 Security Hotspots
0 Code Smells

No Coverage information
0.0% Duplication

[riderx]

is is_allowed_action was a temporary test the right function is is_app_owner, it was not added to the seed but present in prod