import osfrom supabase import create_client, Clienturl: str = os.environ.get("SUPABASE_URL")key: str = os.environ.get("SUPABASE_KEY")supabase: Client = create_client(url, key)
response = ( supabase.table("planets") .select("*") .execute())
response = ( supabase.table("planets") .insert({"id": 1, "name": "Pluto"}) .execute())
response = ( supabase.table("instruments") .update({"name": "piano"}) .eq("id", 1) .execute())
response = ( supabase.table("instruments") .upsert({"id": 1, "name": "piano"}) .execute())
response = ( supabase.table("countries") .delete() .eq("id", 1) .execute())
response = ( supabase.rpc("hello_world") .execute())
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
# Correctresponse = ( supabase.table("instruments") .select("name, section_id") .eq("name", "flute") .execute())# Incorrectresponse = ( supabase.table("instruments") .eq("name", "flute") .select("name, section_id") .execute())
response = ( supabase.table("planets") .select("*") .eq("name", "Earth") .execute())
response = ( supabase.table("planets") .select("*") .neq("name", "Earth") .execute())
response = ( supabase.table("planets") .select("*") .gt("id", 2) .execute())
response = ( supabase.table("planets") .select("*") .gte("id", 2) .execute())
response = ( supabase.table("planets") .select("*") .lt("id", 2) .execute())
response = ( supabase.table("planets") .select("*") .lte("id", 2) .execute())
response = ( supabase.table("planets") .select("*") .like("name", "%Ea%") .execute())
response = ( supabase.table("planets") .select("*") .ilike("name", "%ea%") .execute())
response = ( supabase.table("planets") .select("*") .is_("name", "null") .execute())
response = ( supabase.table("planets") .select("*") .in_("name", ["Earth", "Mars"]) .execute())
response = ( supabase.table("issues") .select("*") .contains("tags", ["is:open", "priority:low"]) .execute())
response = ( supabase.table("classes") .select("name") .contained_by("days", ["monday", "tuesday", "wednesday", "friday"]) .execute())
response = ( supabase.table("reservations") .select("*") .range_gt("during", ["2000-01-02 08:00", "2000-01-02 09:00"]) .execute())
response = ( supabase.table("reservations") .select("*") .range_gte("during", ["2000-01-02 08:30", "2000-01-02 09:30"]) .execute())
response = ( supabase.table("reservations") .select("*") .range_lt("during", ["2000-01-01 15:00", "2000-01-01 16:00"]) .execute())
response = ( supabase.table("reservations") .select("*") .range_lte("during", ["2000-01-01 14:00", "2000-01-01 16:00"]) .execute())
response = ( supabase.table("reservations") .select("*") .range_adjacent("during", ["2000-01-01 12:00", "2000-01-01 13:00"]) .execute())
response = ( supabase.table("issues") .select("title") .overlaps("tags", ["is:closed", "severity:high"]) .execute())
response = ( supabase.table("texts") .select("content") .text_search( "content", "'eggs' & 'ham'", options={"config": "english"}, ) .execute())
response = ( supabase.table("planets") .select("*") .match({"id": 2, "name": "Earth"}) .execute())
response = ( supabase.table("planets") .select("*") .not_.is_("name", "null") .execute())
response = ( supabase.table("planets") .select("name") .or_("id.eq.2,name.eq.Mars") .execute())
response = ( supabase.table("planets") .select("*") .filter("name", "in", '("Mars","Tatooine")') .execute())
response = ( supabase.table("planets") .select("*") .order("name", desc=True) .execute())
response = ( supabase.table("planets") .select("name") .limit(1) .execute())
response = ( supabase.table("planets") .select("name") .range(0, 1) .execute())
response = ( supabase.table("planets") .select("name") .limit(1) .single() .execute())
response = ( supabase.table("planets") .select("*") .eq("name", "Earth") .maybe_single() .execute())
response = ( supabase.table("planets") .select("*") .csv() .execute())
response = ( supabase.table("planets") .select("*") .explain() .execute())
response = supabase.auth.sign_up( { "email": "email@example.com", "password": "password", })
response = supabase.auth.sign_in_anonymously( {"options": {"captcha_token": ""}})
response = supabase.auth.sign_in_with_password( { "email": "email@example.com", "password": "example-password", })
response = supabase.auth.sign_in_with_id_token( { "provider": "google", "token": "your-id-token", })
response = supabase.auth.sign_in_with_otp( { "email": "email@example.com", "options": { "email_redirect_to": "https://example.com/welcome", }, })
response = supabase.auth.sign_in_with_oauth( {"provider": "github"})
response = supabase.auth.sign_in_with_sso( {"domain": "company.com"})
response = supabase.auth.get_claims()
response = supabase.auth.sign_out()
supabase.auth.reset_password_for_email( email, { "redirect_to": "https://example.com/update-password", })
response = supabase.auth.verify_otp( { "email": "email@example.com", "token": "123456", "type": "email", })
response = supabase.auth.get_session()
response = supabase.auth.refresh_session()
response = supabase.auth.get_user()
response = supabase.auth.update_user( {"email": "new@email.com"})
response = supabase.auth.get_user_identities()
response = supabase.auth.link_identity( {provider: "github"})
# retrieve all identites linked to a userresponse = supabase.auth.get_user_identities()# find the google identitygoogle_identity = list( filter(lambda identity: identity.provider == "google", res.identities)).pop()# unlink the google identityresponse = supabase.auth.unlink_identity(google_identity)
response = supabase.auth.reauthenticate()
response = supabase.auth.resend( { "type": "signup", "email": "email@example.com", "options": { "email_redirect_to": "https://example.com/welcome", }, })
response = supabase.auth.set_session(access_token, refresh_token)
response = supabase.auth.exchange_code_for_session( {"auth_code": "34e770dd-9ff9-416c-87fa-43b31d7ef225"})
response = supabase.auth.mfa.enroll( { "factor_type": "totp", "friendly_name": "your_friendly_name", })
response = supabase.auth.mfa.challenge( {"factor_id": "34e770dd-9ff9-416c-87fa-43b31d7ef225"})
response = supabase.auth.mfa.verify( { "factor_id": "34e770dd-9ff9-416c-87fa-43b31d7ef225", "challenge_id": "4034ae6f-a8ce-4fb5-8ee5-69a5863a7c15", "code": "123456", })
response = supabase.auth.mfa.challenge_and_verify( { "factor_id": "34e770dd-9ff9-416c-87fa-43b31d7ef225", "code": "123456", })
response = supabase.auth.mfa.unenroll( {"factor_id": "34e770dd-9ff9-416c-87fa-43b31d7ef225"})
response = supabase.auth.mfa.get_authenticator_assurance_level()
1
2
3
4
5
6
7
8
9
10
11
12
13
14
from supabase import create_clientfrom supabase.lib.client_options import ClientOptionssupabase = create_client( supabase_url, service_role_key, options=ClientOptions( auto_refresh_token=False, persist_session=False, ))# Access auth admin apiadmin_auth_client = supabase.auth.admin
response = supabase.auth.admin.get_user_by_id(1)
response = supabase.auth.admin.list_users()
response = supabase.auth.admin.create_user( { "email": "user@email.com", "password": "password", "user_metadata": {"name": "Yoda"}, })
supabase.auth.admin.delete_user( "715ed5db-f090-4b8c-a067-640ecee36aa0")
response = supabase.auth.admin.invite_user_by_email("email@example.com")
response = supabase.auth.admin.generate_link( { "type": "signup", "email": "email@example.com", "password": "secret", })
response = supabase.auth.admin.update_user_by_id( "11111111-1111-1111-1111-111111111111", { "email": "new@email.com", })
response = supabase.auth.admin.mfa.delete_factor( { "id": "34e770dd-9ff9-416c-87fa-43b31d7ef225", "user_id": "a89baba7-b1b7-440f-b4bb-91026967f66b" })
response = supabase.functions.invoke( "hello-world", invoke_options={ "body": {"name": "Functions"}, },)
import osimport asynciofrom supabase import acreate_client, AsyncClienturl: str = os.environ.get("SUPABASE_URL")key: str = os.environ.get("SUPABASE_KEY")async def create_supabase(): supabase: AsyncClient = await acreate_client(url, key) return supabase
1
2
3
4
5
6
7
8
9
10
11
12
13
channel = supabase.channel("room1")def on_subscribe(status, err): if status == RealtimeSubscribeStates.SUBSCRIBED: asyncio.create_task(channel.send_broadcast( "cursor-pos", {"x": random.random(), "y": random.random()} ))def handle_broadcast(payload): print("Cursor position received!", payload)await channel.on_broadcast(event="cursor-pos", callback=handle_broadcast).subscribe(on_subscribe)
await supabase.remove_channel(myChannel)
await supabase.remove_all_channels()
channels = supabase.get_channels()
channel = supabase.channel("room1")def on_subscribe(status, err): if status == RealtimeSubscribeStates.SUBSCRIBED: asyncio.create_task(channel.send_broadcast('cursor-pos', {"x": random.random(), "y": random.random()}))await channel.subscribe(on_subscribe)
response = ( supabase.storage .create_bucket( "avatars", options={ "public": False, "allowed_mime_types": ["image/png"], "file_size_limit": 1024, } ))
response = supabase.storage.get_bucket("avatars")
response = supabase.storage.list_buckets()
response = ( supabase.storage .update_bucket( "avatars", options={ "public": False, "allowed_mime_types": ["image/png"], "file_size_limit": 1024, } ))
response = supabase.storage.delete_bucket("avatars")
response = supabase.storage.empty_bucket("avatars")
with open("./public/avatar1.png", "rb") as f: response = ( supabase.storage .from_("avatars") .upload( file=f, path="public/avatar1.png", file_options={"cache-control": "3600", "upsert": "false"} ) )
with open("./myfolder/avatar1.png", "wb+") as f: response = ( supabase.storage .from_("avatars") .download("folder/avatar1.png") ) f.write(response)
1
2
3
4
5
6
7
8
9
10
11
12
response = ( supabase.storage .from_("avatars") .list( "folder", { "limit": 100, "offset": 0, "sortBy": {"column": "name", "order": "desc"}, } ))
with open("./public/avatar1.png", "rb") as f: response = ( supabase.storage .from_("avatars") .update( file=f, path="public/avatar1.png", file_options={"cache-control": "3600", "upsert": "true"} ) )
response = ( supabase.storage .from_("avatars") .move( "public/avatar1.png", "private/avatar2.png" ))
response = ( supabase.storage .from_("avatars") .copy( "public/avatar1.png", "private/avatar2.png" ))
response = ( supabase.storage .from_("avatars") .remove(["folder/avatar1.png"]))
response = ( supabase.storage .from_("avatars") .create_signed_url( "folder/avatar1.png", 60 ))
response = ( supabase.storage .from_("avatars") .create_signed_urls( ["folder/avatar1.png", "folder/avatar2.png"], 60 ))
response = ( supabase.storage .from_("avatars") .create_signed_upload_url("folder/avatar1.png"))
with open("./public/avatar1.png", "rb") as f: response = ( supabase.storage .from_("avatars") .upload_to_signed_url( path="folder/cat.jpg", token="token-from-create_signed_upload_url", file=f, ) )
response = ( supabase.storage .from_("avatars") .get_public_url("folder/avatar1.jpg"))
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4