2025/4/8 から 2025/4/18 にやったこと

create table public.tables (
  id uuid not null default gen_random_uuid(),
  created_at timestamp with time zone not null default now(),
  updated_at timestamp with time zone not null default now(),
  user_id uuid not null ,
  name varchar(128) not null ,
  description varchar(2048),
  is_public boolean not null default false,
  public_at timestamp with time zone,
  num_users int8 not null default 0,
  num_cols int8 not null default 0,
  constraint tables_pkey primary key (id)
) tablespace pg_default;

select
isc.table_name
, isc.ordinal_position
, isc.column_name
, isc.data_type
, isc.character_maximum_length
, isc.column_default
, isc.is_nullable
from
information_schema.columns isc
where
isc.table_schema = 'public'    /* ここは可変 */
and isc.table_name = 'tables'  /* ここも可変 */
order by isc.ordinal_position;

[
  {
    "table_name": "tables",
    "ordinal_position": 1,
    "column_name": "id",
    "data_type": "uuid",
    "character_maximum_length": null,
    "column_default": "gen_random_uuid()",
    "is_nullable": "NO"
  },
  {
    "table_name": "tables",
    "ordinal_position": 2,
    "column_name": "created_at",
    "data_type": "timestamp with time zone",
    "character_maximum_length": null,
    "column_default": "now()",
    "is_nullable": "NO"
  },
  {
    "table_name": "tables",
    "ordinal_position": 3,
    "column_name": "updated_at",
    "data_type": "timestamp with time zone",
    "character_maximum_length": null,
    "column_default": "now()",
    "is_nullable": "NO"
  },
  {
    "table_name": "tables",
    "ordinal_position": 4,
    "column_name": "user_id",
    "data_type": "uuid",
    "character_maximum_length": null,
    "column_default": null,
    "is_nullable": "NO"
  },
  {
    "table_name": "tables",
    "ordinal_position": 5,
    "column_name": "name",
    "data_type": "character varying",
    "character_maximum_length": 128,
    "column_default": null,
    "is_nullable": "NO"
  },
  {
    "table_name": "tables",
    "ordinal_position": 6,
    "column_name": "description",
    "data_type": "character varying",
    "character_maximum_length": 2048,
    "column_default": null,
    "is_nullable": "YES"
  },
  {
    "table_name": "tables",
    "ordinal_position": 7,
    "column_name": "is_public",
    "data_type": "boolean",
    "character_maximum_length": null,
    "column_default": "false",
    "is_nullable": "NO"
  },
  {
    "table_name": "tables",
    "ordinal_position": 8,
    "column_name": "public_at",
    "data_type": "timestamp with time zone",
    "character_maximum_length": null,
    "column_default": null,
    "is_nullable": "YES"
  },
  {
    "table_name": "tables",
    "ordinal_position": 9,
    "column_name": "num_users",
    "data_type": "bigint",
    "character_maximum_length": null,
    "column_default": "0",
    "is_nullable": "NO"
  },
  {
    "table_name": "tables",
    "ordinal_position": 10,
    "column_name": "num_cols",
    "data_type": "bigint",
    "character_maximum_length": null,
    "column_default": "0",
    "is_nullable": "NO"
  }
]

supabase stop

supabase start

         API URL: http://127.0.0.1:54321
     GraphQL URL: http://127.0.0.1:54321/graphql/v1
  S3 Storage URL: http://127.0.0.1:54321/storage/v1/s3
          DB URL: postgresql://postgres:postgres@127.0.0.1:54322/postgres
      Studio URL: http://127.0.0.1:54323
    Inbucket URL: http://127.0.0.1:54324
      JWT secret: super-secret-jwt-token-with-at-least-32-characters-long
        anon key: eyJhbGciOiJI......Tn_I0
service_role key: eyJhbGciOiJI......N81IU
   S3 Access Key: 625729a08b95......a23c
   S3 Secret Key: 850181e4652d......25907
       S3 Region: local

% pwd
/Users/m/Dev/supabase
%
% supabase init
Generate VS Code settings for Deno? [y/N] y
Generated VS Code settings in .vscode/settings.json. Please install the recommended extension!
Finished supabase init.
/Users/m/Dev/supabase
%
% ls -la
total 0
drwxr-xr-x  4 m  staff  128  4  9 21:33 .
drwxr-xr-x@ 8 m  staff  256  4  9 21:28 ..
drwxr-xr-x@ 4 m  staff  128  4  9 21:33 .vscode
drwxr-xr-x@ 5 m  staff  160  4  9 21:33 supabase
%

% pwd
/Users/m/Dev/supabase
% supabase functions new hello
Created new Function at supabase/functions/hello
%

% curl --request POST 'http://localhost:54321/functions/v1/hello' \
  --header 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsIn......' \
  --header 'Content-Type: application/json' \
  --data '{ "name":"Functions" }'
{"message":"Hello Functions!"}%
%

% supabase login
Using workdir /Users/m/Dev/supabase
Hello from Supabase! Press Enter to open browser and login automatically.

Here is your login link in case browser did not open https://supabase.com/dashboard/cli/login?session_id=12c6714d-db0b-4939-be0f-dd4eff5882f5&token_name=cli_m@mopnoMac-mini.local_1744247012&public_key=0434e8adec......

Enter your verification code: edaa0e1d
Token cli_m@mopnoMac-mini.local_1744247012 created successfully.

You are now logged in. Happy coding!
% supabase projects list
Using workdir /Users/m/Dev/supabase
Cannot find project ref. Have you run supabase link?


   LINKED | ORG ID               | REFERENCE ID         | NAME       | REGION                 | CREATED AT (UTC)
  --------|----------------------|----------------------|------------|------------------------|---------------------
          | sflwwkgnxfcjqphbllcx | wpxn................ | bkiban_dev | Northeast Asia (Tokyo) | 2024-05-06 05:38:35
          | sflwwkgnxfcjqphbllcx | jkon................ | db.bkibam  | Northeast Asia (Tokyo) | 2025-04-07 22:08:11

%
% supabase link --project-ref jkon......

(snip)

% supabase functions deploy hello

(snip)

%
% curl --request POST 'https://jkon.......supabase.co/functions/v1/hello' \
  --header 'Authorization: Bearer eyJhbG......' \
  --header 'Content-Type: application/json' \
  --data '{ "name":"Functions" }'
{"message":"Hello Functions!"}%
%
% curl --request POST 'https://jkon.......supabase.co/functions/v1/hello' \
  --header 'Authorization: Bearer eyJhbG......' \
  --header 'Content-Type: application/json' \
  --data '{ "name":"db.bkiban!" }'
{"message":"Hello db.bkiban!!"}%
%