🔌 API Reference

# Thay YOUR_ANON_KEY bằng publishable key thực tế
curl "https://mrgdawvdnofcxamjvcbl.supabase.co/rest/v1/patients?select=patient_code,full_name&limit=3" \
  -H "apikey: YOUR_ANON_KEY" \
  -H "Authorization: Bearer YOUR_ANON_KEY"

npm install @supabase/supabase-js @supabase/ssr

NEXT_PUBLIC_SUPABASE_URL=https://mrgdawvdnofcxamjvcbl.supabase.co
NEXT_PUBLIC_SUPABASE_PUBLISHABLE_KEY=sb_publishable_xxxxx

import { createClient } from "@/lib/supabase/server";

// Trong Server Component hoặc Server Action
const supabase = await createClient();

// Query dữ liệu
const { data, error } = await supabase
  .from("patients")
  .select("*")
  .limit(10);

import { createClient } from "@/lib/supabase/client";

// Trong Client Component
const supabase = createClient();

// Realtime subscription
supabase
  .channel("visits")
  .on("postgres_changes", { event: "INSERT", schema: "public", table: "visits" }, 
    (payload) => console.log("New visit:", payload)
  )
  .subscribe();

const { data, error } = await supabase
  .from("patients")
  .insert({
    patient_code: "BN-20260001",
    full_name: "Nguyễn Văn A",
    date_of_birth: "1990-05-15",
    gender: "Nam",
    phone: "0901234567",
    province: "Hồ Chí Minh",
    bhyt_number: "HS4010012345678"
  })
  .select()    // Trả về record vừa tạo
  .single();   // Chỉ 1 record

console.log(data);
// → { id: "uuid...", patient_code: "BN-20260001", full_name: "Nguyễn Văn A", ... }

const { data } = await supabase
  .from("patients")
  .select("patient_code, full_name, bhyt_number, bhyt_expiry")
  .not("bhyt_number", "is", null)
  .lte("bhyt_expiry", "2026-03-31")
  .gte("bhyt_expiry", "2026-02-01")
  .order("bhyt_expiry", { ascending: true });

// → Danh sách BN có BHYT hết hạn trong tháng 2-3/2026

const { data } = await supabase
  .from("visits")
  .select(`
    visit_code,
    visit_date,
    status,
    diagnosis,
    patients ( patient_code, full_name, phone ),
    doctors ( full_name, degree ),
    departments ( name ),
    icd_codes ( code, name_vi )
  `)
  .eq("status", "hoan_thanh")
  .order("visit_date", { ascending: false })
  .limit(20);

// → Tự động JOIN 4 bảng liên quan qua Foreign Keys

const { data } = await supabase
  .from("visits")
  .select("status")
  .gte("visit_date", "2026-02-01")
  .lte("visit_date", "2026-02-28");

// Hoặc dùng RPC function cho aggregate phức tạp:
const { data: summary } = await supabase.rpc("fn_dashboard_summary", {
  p_start_date: "2026-02-01",
  p_end_date: "2026-02-28"
});

// Client Component ("use client")
const supabase = createClient();

const channel = supabase
  .channel("realtime-visits")
  .on(
    "postgres_changes",
    { event: "INSERT", schema: "public", table: "visits" },
    (payload) => {
      console.log("Lượt khám mới:", payload.new);
      // Update UI...
    }
  )
  .subscribe();

// Cleanup
return () => { supabase.removeChannel(channel); };

# Lấy 5 bệnh nhân
curl "https://mrgdawvdnofcxamjvcbl.supabase.co/rest/v1/patients?limit=5&select=patient_code,full_name" \
  -H "apikey: YOUR_ANON_KEY" \
  -H "Authorization: Bearer YOUR_ANON_KEY"

# Gọi RPC function
curl -X POST "https://mrgdawvdnofcxamjvcbl.supabase.co/rest/v1/rpc/fn_dashboard_summary" \
  -H "apikey: YOUR_ANON_KEY" \
  -H "Authorization: Bearer YOUR_ANON_KEY" \
  -H "Content-Type: application/json" \
  -d '{"p_start_date":"2026-01-01","p_end_date":"2026-02-28"}'

# OpenAPI JSON spec (public với apikey)
curl "https://mrgdawvdnofcxamjvcbl.supabase.co/rest/v1/" \
  -H "apikey: YOUR_ANON_KEY" \
  | python -m json.tool > openapi-spec.json

# Mở bằng Swagger UI online:
# 1. Vào https://editor.swagger.io
# 2. File → Import File → chọn openapi-spec.json
# → Xem tất cả endpoints, schemas, try it live

# Cách 1: Import URL trực tiếp trong Postman
# Collections → Import → Link → paste:
# https://mrgdawvdnofcxamjvcbl.supabase.co/rest/v1/
# (thêm header apikey = YOUR_ANON_KEY)

# Cách 2: Import file
curl -o openapi.json "https://mrgdawvdnofcxamjvcbl.supabase.co/rest/v1/" \
  -H "apikey: YOUR_ANON_KEY"
# → Postman → Import → Upload Files → openapi.json