sudo -u postgres psql

-- 데이터베이스 생성
CREATE DATABASE notion_blog;
 
-- 사용자 생성
CREATE USER myuser WITH PASSWORD 'mypassword';
 
-- 권한 부여
GRANT ALL PRIVILEGES ON DATABASE notion_blog TO myuser;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO myuser;
 
-- 확인
\l  -- 데이터베이스 목록
\q  -- 종료

-- 1) 상태 테이블
CREATE TABLE IF NOT EXISTS statuses (
  id            text PRIMARY KEY,
  name          text NOT NULL UNIQUE,
  color         text
);
 
-- 2) 태그 테이블
CREATE TABLE IF NOT EXISTS tags (
  id            text PRIMARY KEY,
  name          text NOT NULL,
  color         text
);
CREATE INDEX IF NOT EXISTS idx_tags_name ON tags (name);
 
-- 3) 페이지 테이블
CREATE TABLE IF NOT EXISTS notion_pages (
  id                      text PRIMARY KEY,
  database_id             text NOT NULL,
  url                     text,
  public_url              text,
  created_time            timestamptz NOT NULL,
  last_edited_time        timestamptz NOT NULL,
  created_by_user_id      text,
  last_edited_by_user_id  text,
  archived                boolean NOT NULL DEFAULT false,
  in_trash                boolean NOT NULL DEFAULT false,
  cover_url               text,
  cover_expiry_time       timestamptz,
  icon                    text,
  pin                     boolean NOT NULL DEFAULT false,
  status_id               text REFERENCES statuses(id) ON DELETE SET NULL,
  slug                    text,
  title                   text,
  written_date            date,
  raw_properties          jsonb NOT NULL DEFAULT '{}'::jsonb,
  synced_at               timestamptz NOT NULL DEFAULT now()
);
 
-- 4) 페이지-태그(M:N)
CREATE TABLE IF NOT EXISTS page_tags (
  page_id  text NOT NULL REFERENCES notion_pages(id) ON DELETE CASCADE,
  tag_id   text NOT NULL REFERENCES tags(id)         ON DELETE CASCADE,
  PRIMARY KEY (page_id, tag_id)
);
 
-- 5) 페이지 관계(관련 글)
CREATE TABLE IF NOT EXISTS page_relations (
  from_page_id  text NOT NULL REFERENCES notion_pages(id) ON DELETE CASCADE,
  to_page_id    text NOT NULL REFERENCES notion_pages(id) ON DELETE CASCADE,
  PRIMARY KEY (from_page_id, to_page_id)
);

from fastapi.staticfiles import StaticFiles
from pathlib import Path
Path("static").mkdir(parents=True, exist_ok=True)
app.mount("/static", StaticFiles(directory="static"), name="static")

local_cover_path = None
if cover_url:
    try:
        resp = requests.get(cover_url, timeout=15)
        resp.raise_for_status()
        content_type = resp.headers.get("Content-Type", "")
        ext = ""
        if "image/" in content_type:
            ext = "." + content_type.split("/")[-1].split(";")[0]
        else:
            ext = ".jpg"
        filename = f"{page_id}{ext}"
        file_path = static_dir / filename
        with open(file_path, "wb") as f:
            f.write(resp.content)
        local_cover_path = f"/static/covers/{filename}"
    except Exception:
        local_cover_path = None

@app.middleware("http")
async def log_process_time(request: Request, call_next):
    start = perf_counter()
    response = await call_next(request)
    duration = perf_counter() - start
    response.headers["X-Process-Time"] = f"{duration:.3f}s"
    try:
        print(f"{request.method} {request.url.path} {response.status_code} - {duration*1000:.1f} ms")
    except Exception:
        pass
    return response