How to log input parameters inside a database function?

Staffan Solin · 2023-12-12T21:12:28.243Z

I have a database function that takes two input parameters. I want to log whatever the users inputs to that function? How do I do that?

K

KOnOO•12/12/23, 9:15 PM

You can use the this

RAISE LOG 'param1: %, param2: %', param1, param2;

RAISE LOG 'param1: %, param2: %', param1, param2;

RAISE LOG 'param1: %, param2: %', param1, param2;

RAISE LOG 'param1: %, param2: %', param1, param2;

KKOnOO You can use the this ```sql RAISE LOG 'param1: %, param2: %', param1, param2; `...

S

Staffan SolinOP•12/12/23, 9:21 PM

And then where can I read the logs?

K

KOnOO•12/12/23, 9:21 PM

are you on local setup ?

S

Staffan SolinOP•12/12/23, 9:21 PM

nope only cloud

S

Staffan SolinOP•12/12/23, 9:22 PM

Is it under Logs > Postgres?

K

KOnOO•12/12/23, 9:22 PM

Yep

S

Staffan SolinOP•12/12/23, 9:22 PM

it really was that easy...

S

Staffan SolinOP•12/12/23, 9:23 PM

S

Staffan SolinOP•12/12/23, 9:23 PM

Let me take it for a spin and I will come back if it works

K

KOnOO•12/12/23, 9:23 PM

ahah np

S

Staffan SolinOP•12/12/23, 9:27 PM

How would I do to get the Display Name of the person doing the request?

S

Staffan SolinOP•12/12/23, 9:28 PM

it works btw

thanks

K

KOnOO•12/12/23, 9:30 PM

You can get if from

auth.jwt() ->> 'full_name'

auth.jwt() ->> 'full_name'

auth.jwt() ->> 'full_name'

auth.jwt() ->> 'full_name' i think

S

Staffan SolinOP•12/12/23, 9:34 PM

RAISE LOG 'full_name: %, input: %', auth.jwt() ->> 'full_name', input;

RAISE LOG 'full_name: %, input: %', auth.jwt() ->> 'full_name', input;

RAISE LOG 'full_name: %, input: %', auth.jwt() ->> 'full_name', input;

RAISE LOG 'full_name: %, input: %', auth.jwt() ->> 'full_name', input;

This is just giving me <NULL> in the logs

G

garyaustin•12/12/23, 9:34 PM

There is no display name standard.

G

garyaustin•12/12/23, 9:35 PM

What name are you looking for?

S

Staffan SolinOP•12/12/23, 9:35 PM

The name after authentication

S

Staffan SolinOP•12/12/23, 9:35 PM

I have in the Authentication Table one column called Display Name

G

garyaustin•12/12/23, 9:36 PM

You can log auth.jwt() by itself and see if the info in the user jwt.

G

garyaustin•12/12/23, 9:37 PM

I'm not sure what that column is, I don't remember it being there before and the name had to be created by the signIn process somehow.

G

garyaustin•12/12/23, 9:39 PM

Does the column have any names for you? Mine are all blank, but I don't use OAuth signIn. Like I said I really don't think that was there a few days ago, but this is launch week.

S

Staffan SolinOP•12/12/23, 9:41 PM

After i press Authentication in the side-menu. I have all users that have signed in with OAuth. In that table there is one column called Display Name

G

garyaustin•12/12/23, 9:41 PM

It was added last week and says for user impersentation.

G

garyaustin•12/12/23, 9:41 PM

Are their OAuth names in it.

Ggaryaustin It was added last week and says for user impersentation.

S

Staffan SolinOP•12/12/23, 9:42 PM

oh really, was it only email before? I am pretty sure I have been seeing this field last 2 weeks

Ggaryaustin Are their OAuth names in it.

S

Staffan SolinOP•12/12/23, 9:42 PM

Yes, the name is coming from OAuth

G

garyaustin•12/12/23, 9:42 PM

G

garyaustin•12/12/23, 9:43 PM

Then it will be in the auth_metadata json in the jwt.

S

Staffan SolinOP•12/12/23, 9:43 PM

Seems to correspond to:

user_metadata -> custom_claims -> global_name

user_metadata -> custom_claims -> global_name

user_metadata -> custom_claims -> global_name

user_metadata -> custom_claims -> global_name

S

Staffan SolinOP•12/12/23, 9:43 PM

in the jwt

G

garyaustin•12/12/23, 9:44 PM

Never seen that before. So is very new.

G

garyaustin•12/12/23, 9:44 PM

Maybe part of upcoming announcement....

S

Staffan SolinOP•12/12/23, 9:44 PM

oh really xd

S

Staffan SolinOP•12/12/23, 9:45 PM

How would I go to get that property from the jwt?

S

Staffan SolinOP•12/12/23, 9:45 PM

Because it is int here

G

garyaustin•12/12/23, 9:45 PM

normally user metadata is null unless you put something in it.

S

Staffan SolinOP•12/12/23, 9:46 PM

auth.jwt() ->> 'user_metadata' ->> 'custom_claims' ->> 'global_name'

auth.jwt() ->> 'user_metadata' ->> 'custom_claims' ->> 'global_name'

auth.jwt() ->> 'user_metadata' ->> 'custom_claims' ->> 'global_name'

auth.jwt() ->> 'user_metadata' ->> 'custom_claims' ->> 'global_name'

S

Staffan SolinOP•12/12/23, 9:46 PM

would that work?

G

garyaustin•12/12/23, 9:46 PM

If you log out auth.jwt() you will get all you have access to.

G

garyaustin•12/12/23, 9:46 PM

use -> except for last ->>

G

garyaustin•12/12/23, 9:46 PM

->> means text

G

garyaustin•12/12/23, 9:46 PM

-> means use json

S

Staffan SolinOP•12/12/23, 9:47 PM

auth.jwt() -> 'user_metadata' -> 'custom_claims' ->> 'global_name'

auth.jwt() -> 'user_metadata' -> 'custom_claims' ->> 'global_name'

auth.jwt() -> 'user_metadata' -> 'custom_claims' ->> 'global_name'

auth.jwt() -> 'user_metadata' -> 'custom_claims' ->> 'global_name'

S

Staffan SolinOP•12/12/23, 9:47 PM

so liek this then

S

Staffan SolinOP•12/12/23, 9:47 PM

Will, try thanks!

S

Staffan SolinOP•12/12/23, 9:47 PM

Worked like a charm

S

Staffan SolinOP•12/12/23, 9:47 PM

thanks

How to log input parameters inside a database function?

Similar Threads

Similar Threads

Similar Threads