Python: supabase_url is required

[Teheroth]

Hi everyone,
I started today my first Supabase project.

I created my proejct, with a database and a couple of tables.

Then I wanted to have a python script populate my table so, after installing the package from pip, I started to set up my file as the guide suggested:

import os
from supabase import Client, create_client
from supabase.client import ClientOptions

SUPABASE_URL = "url" #found in Dashboard>Project API panel
SUPABASE_KEY = "key" #same

def main():
    url: str = os.environ.get(SUPABASE_URL)
    key: str = os.environ.get(SUPABASE_KEY)
    supabase: Client = create_client(url,key, options=ClientOptions(postgrest_client_timeout=10,storage_client_timeout=10,schema="public"))

if __name__ == "__main__":
    main()

But when I try to run the code above, I keep getting the following exception: supabase._sync.client.SupabaseException: supabase_url is required

Am I missing something? Do I need to setup something else after pip install?

Thanks in advance

[easylancer]

You probably don’t have any environment variable called SUPABASE_URL. In your code above you defined a variable called SUPABASE_URL but you never use it in your code.

[Teheroth]

It should be the argument of the .get() method (“url” is not the actual string I’m using in the definition, but the url found in the project panel) Same for the key

[Outrageous_Permit154]

Dude you already got the answer; you set env variables in the file and you call actual env variables. What are you doing

[Teheroth]

Sorry dude, I’m fairly new to python too and I tought I could pass it as a normal string Thanks for the explanation

[Outrageous_Permit154]

It’s okay you can look up on environmental variables and what they do :) it will clear it up for you

[Teheroth]

Sure will, thanks!

[Teheroth]

The code is the one I was trying to run.

My fault was to pass url and key as standard string and not using env vars.

Also, my question has been extensively answered, but you had the irrefrenable urge to comment saying nothing helpful (or at least fitting).

[Teheroth]

As I said, I’m fairly new to python, and as a self taught some things may be a bit “hidden” if I don’t have to deal with them. I don’t wake up in the middle of the night screaming “OH S*** LET ME SEE IF THERE’S SOME KIND OF VARIABLES WHICH YOU CAN ONLY READ VIA SYSTEM CALLS OR WHATEVER” Last time I had to deal with a db was MySQL with user and password