# Supabase

A Supabase client for Elixir.

[![.github/workflows/ci.yml](]( [![Coverage Status](](

**Early work in progress.**

With this library you can work with [Supabase]( At the moment there's
functionality for

- **auth**
- **database/postgrest**
- **storage**

**auth** and **database** are implemented in different libraries.
[gotrue-elixir]( for **auth** and
[postgrest-ex]( for **database**.

**supabase-elixir** handles the correct initializtion from a common config.

## Installation

def deps do
    {:supabase, "~> 0.1.0"}

## Configuration

You can configure your Supabase project url and api anon key so that **supabase-elixir**
can handle the correct initialization of the different clients:

config :supabase,
  base_url: System.get_env("SUPABASE_URL"),
  api_key: System.get_env("SUPABASE_KEY")

## Auth / GoTrue

Uses [gotrue-elixir](

|> GoTrue.settings()

## Database / Postgrest

Uses [postgrest-ex](

import Supabase
import Postgrestex

|> from("profiles")
|> eq("Username", "Patrick")
|> call()
|> json()
  body: [
      "avatar_url" => "avatar.jpeg",
      "id" => "blabla7d-411d-4ead-83d0-452343b",
      "updated_at" => "2021-05-02T21:05:37.258616+00:00",
      "username" => "Patrick",
      "website" => ""
  status: 200

# Or when in a user context with available JWT
Supabase.init(access_token: session.access_token)

# To use another schema than 'public'
Supabase.init(schema: 'other_schema')

### Not depending on Application config

Supabase.init("", "my-api-key")

## Storage

The API tries to reflect the one of the offical [JS client](

{:ok, object} =
  |> Supabase.Storage.from("avatars")

# with user context
{:ok, object} =
  |> Supabase.Storage.from("avatars")


### Direct API

Implements the [storage]( OpenAPI [spec](, see examples below.

### Create a Connection

iex> conn =
  api_key: "***",
  base_url: "https://*************"

### Create a new Bucket

iex> {:ok, %{"name" => bucket_name}} = Supabase.Storage.Buckets.create(conn, "avatars")
{:ok, %{"name" => "avatars"}}
iex> {:ok, %Supabase.Storage.Bucket{} = bucket} = Supabase.Storage.Buckets.get(conn, "avatars")
   created_at: "2021-04-30T16:47:49.925325+00:00",
   id: "avatars",
   name: "avatars",
   owner: "",
   updated_at: "2021-04-30T16:47:49.925325+00:00"

### Upload an Image to the new Bucket

iex> {:ok, %{"Key" => object_key} = Supabase.Storage.Objects.create(conn, bucket, "images/avatar.jpg", "~/Pictures/avatar.png")
{:ok, %{"Key" => "avatars/images/avatar.jpg"}}
iex> {:ok, objects} = Supabase.Storage.Objects.list(conn, bucket, "images")
     bucket_id: nil,
     created_at: "2021-04-30T16:53:46.41036+00:00",
     id: "e1ff915f-b6b0-46ae-b1f0-a5e85adebdc8",
     last_accessed_at: "2021-04-30T16:53:46.41036+00:00",
     metadata: %{cacheControl: "no-cache", mimetype: "image/png", size: 83001},
     name: "avatar.jpg",
     owner: nil,
     updated_at: "2021-04-30T16:53:46.41036+00:00"

## Testing

The tests require a Supabase project (the **url** and **api key**) where **Row Level Security** is disabled for both, `BUCKET` and `OBJECT`.

export SUPABASE_TEST_URL="https://*********"
export SUPABASE_TEST_KEY="***"

mix test

# or with coverage
mix coveralls