Files
impactflow_discovery/alembic/versions/003_add_goals.py
Joel Salmon 33674f92f4 Complete Phase 1: goals, cookie auth, profile editing
Close the remaining Phase 1 DoD gaps and reconcile the browser flow with
the auth layer.

Goals (5 -> 7 prompts):
- Add near-term (6-12mo) and long-term (3-5yr) goal prompts; collect raw
  text on the conversation and store AI-articulated goal summaries on the
  profile. Extractor articulates the person's own stated goals (mirror,
  not compass) and never fabricates. Alembic 003 adds the four columns.

Cookie-based browser sessions (fixes frontend<->auth desync):
- OAuth callback now sets httpOnly session cookies and redirects into the
  app instead of returning JSON. get_current_user gains a cookie fallback
  (X-API-Key -> Bearer -> cookie). refresh/logout read the refresh cookie
  and set/clear cookies. New shared auth.js (authedFetch) sends cookies and
  silently refreshes on 401. Static pages drop the bogus user_id and call
  the correct /me endpoints.

Profile editing (read/edit/affirm):
- PATCH /discovery/profile/me edits the prose (Ikigai summaries, overlap
  narrative, goals); owner-scoped, partial update, 409 when locked. Edit
  mode in profile.html with Save/Cancel.

Also: bump default model to claude-sonnet-4-6, align ports to 8011
(OAuth redirect, CORS), add COOKIE_SECURE/POST_LOGIN_REDIRECT config, and
refresh the README to match the shipped behavior.

Tests: 33 passing (added cookie-auth, profile-edit, goal-extraction cases;
factored a shared app_client fixture into conftest.py).

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
2026-06-15 18:26:08 -05:00

46 lines
1.4 KiB
Python

"""add goal-articulation columns to discovery_conversation and discovery_profile
Revision ID: 003
Revises: 002
Create Date: 2026-06-15
Phase 1 goal articulation: two new narrative prompts capture the person's own
near- and long-term goals (on the conversation), and two AI-articulated goal
summaries are stored alongside the Ikigai/enneagram profile.
"""
from typing import Sequence, Union
import sqlalchemy as sa
from alembic import op
revision: str = "003"
down_revision: Union[str, None] = "002"
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None
def upgrade() -> None:
op.add_column(
"discovery_conversation",
sa.Column("prompt_goals_short", sa.Text(), nullable=True),
)
op.add_column(
"discovery_conversation",
sa.Column("prompt_goals_long", sa.Text(), nullable=True),
)
op.add_column(
"discovery_profile",
sa.Column("short_term_goals", sa.Text(), nullable=True),
)
op.add_column(
"discovery_profile",
sa.Column("long_term_goals", sa.Text(), nullable=True),
)
def downgrade() -> None:
op.drop_column("discovery_profile", "long_term_goals")
op.drop_column("discovery_profile", "short_term_goals")
op.drop_column("discovery_conversation", "prompt_goals_long")
op.drop_column("discovery_conversation", "prompt_goals_short")