[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_223":224,"_225":226},"routes/_app.x.$handle.$name",{"_96":95,"_32":44,"_104":86,"_26":36,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":24,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":24},"version",18,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":29},"file",{"_30":31,"_32":27,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","new-file-3946.ts","latestPath","setup.ts","fileId","7a2366be-d46c-11f0-9529-42dde27851f2","name","fileType","script","content","","createdAt",["D",1765222281910],"branchVersion","branchId","7da38c7c-d464-11f0-a05c-42dde27851f2","id","7da33fa6-d464-11f0-a05c-42dde27851f2","the-playbook",["D",1765218851812],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","open-source demo by Banks (jabanks@gmail.com)","imageUrl","019af6f6-fda3-778e-a508-5639a1468e03","pinnedFileId","7da5a502-d464-11f0-a05c-42dde27851f2","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019af6f6-fda3-778e-a508-5b6cc66d79d5","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":24},"branch",{"_13":85,"_32":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"isOwned",37,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","axiom","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzM2VjdZZnVOblV5ZUFaZlRaS3RQdVVHbzhYTiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_42":43,"_32":44,"_37":219,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":220,"_80":221,"_82":222,"_84":24},"tree",[190,191,192,193,194,195,196],"files",[190,191,192,193,194,195,196],"counts",{"_180":62,"_181":148,"_182":148,"_183":184,"_185":186},"contents",[125,126,127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":173,"_32":174,"_30":175,"_135":-5,"_40":41,"_39":176,"_137":58,"_37":177,"_13":156,"_33":34,"_35":178,"_23":24,"_141":-5,"_26":179},{"_42":166,"_32":167,"_30":168,"_135":-5,"_40":41,"_39":169,"_137":58,"_37":170,"_13":156,"_33":34,"_35":171,"_23":24,"_141":-5,"_26":172},{"_42":159,"_32":160,"_30":161,"_135":-5,"_40":41,"_39":162,"_137":58,"_37":163,"_13":156,"_33":34,"_35":164,"_23":24,"_141":-5,"_26":165},{"_42":151,"_32":152,"_30":153,"_135":-5,"_40":41,"_39":154,"_137":58,"_37":155,"_13":156,"_33":34,"_35":157,"_23":24,"_141":-5,"_26":158},{"_42":146,"_32":147,"_30":56,"_135":-5,"_40":41,"_39":148,"_137":24,"_37":149,"_13":62,"_33":34,"_35":36,"_23":24,"_141":-5,"_26":150},{"_42":143,"_32":27,"_30":31,"_135":-5,"_40":41,"_39":14,"_137":24,"_37":144,"_13":62,"_33":34,"_35":36,"_23":24,"_141":-5,"_26":145},{"_42":132,"_32":133,"_30":134,"_135":-5,"_40":41,"_39":136,"_137":58,"_37":138,"_13":139,"_33":34,"_35":140,"_23":24,"_141":-5,"_26":142},"dbe30fea-d46b-11f0-b4b2-42dde27851f2","types.ts","ffd504d2-d464-11f0-88d5-42dde27851f2","parentId",8,"latest",["D",1765222016405],3,"/**\n * @fileoverview TypeScript type definitions for The Playbook application.\n * Contains all interfaces, types, and type guards used throughout the codebase.\n *\n * @author The Playbook Team\n * @version 3.0.0\n */\n\nimport type {\n DEFENSIVE_LENSES,\n MASCOTS,\n OFFENSIVE_LENSES,\n TIER_IDS,\n} from \"./config.ts\";\n\n// =============================================================================\n// PRIMITIVE TYPES & ENUMS\n// =============================================================================\n\n/** Valid tier identifier strings */\nexport type TierId = typeof TIER_IDS[number];\n\n/** Valid squad types */\nexport type Squad = \"phoenix\" | \"fortress\";\n\n/** Document processing status */\nexport type DocumentStatus = \"pending\" | \"processing\" | \"ready\" | \"error\";\n\n/** Analysis types available */\nexport type AnalysisType = \"offensive\" | \"defensive\" | \"phoenix_fortress\";\n\n// =============================================================================\n// USER TYPES\n// =============================================================================\n\n/**\n * Represents an authenticated user in the system.\n */\nexport interface User {\n /** Unique user identifier (format: usr_xxxxx) */\n id: string;\n /** User's email address */\n email: string;\n /** Optional display name */\n name: string | null;\n /** Current subscription tier */\n tier: TierId;\n /** Optional avatar URL */\n avatarUrl?: string;\n /** Account creation timestamp */\n createdAt: string;\n}\n\n/**\n * Session data stored in the database.\n */\nexport interface Session {\n /** Unique session identifier (format: sess_xxxxx) */\n id: string;\n /** Associated user ID */\n userId: string;\n /** Session expiration timestamp (ISO string) */\n expiresAt: string;\n /** User agent string from request */\n userAgent?: string;\n /** IP address from request */\n ipAddress?: string;\n /** Session creation timestamp */\n createdAt: string;\n}\n\n/**\n * Data required to create a new session.\n */\nexport interface CreateSessionInput {\n userId: string;\n userAgent?: string;\n ipAddress?: string;\n}\n\n// =============================================================================\n// DOCUMENT TYPES\n// =============================================================================\n\n/**\n * Represents an uploaded document for analysis.\n */\nexport interface Document {\n /** Unique document identifier (format: doc_xxxxx) */\n id: string;\n /** Owner user ID */\n userId: string;\n /** Document title */\n title: string;\n /** Full text content */\n textContent: string;\n /** Calculated word count */\n wordCount: number;\n /** Processing status */\n status: DocumentStatus;\n /** Upload timestamp */\n createdAt: string;\n}\n\n/**\n * Lightweight document representation for lists.\n */\nexport interface DocumentSummary {\n id: string;\n title: string;\n wordCount: number;\n status: DocumentStatus;\n createdAt: string;\n}\n\n/**\n * Input data for creating a new document.\n */\nexport interface CreateDocumentInput {\n title: string;\n text: string;\n}\n\n// =============================================================================\n// LENS TYPES\n// =============================================================================\n\n/**\n * Represents an analysis lens (perspective).\n */\nexport interface Lens {\n /** Unique lens identifier */\n id: string;\n /** Display name */\n name: string;\n /** Emoji icon */\n emoji: string;\n /** Which squad this lens belongs to */\n squad: Squad;\n /** Brief description of what this lens does */\n description: string;\n /** The lens's perspective/bias statement */\n bias: string;\n /** List of analysis focus areas */\n focus: readonly string[];\n /** Minimum tier required to use this lens */\n requiredTier: TierId;\n}\n\n/** Type for offensive lens IDs */\nexport type OffensiveLensId = typeof OFFENSIVE_LENSES[number][\"id\"];\n/** Type for defensive lens IDs */\nexport type DefensiveLensId = typeof DEFENSIVE_LENSES[number][\"id\"];\n\n/** Combined lens ID type */\nexport type LensId = OffensiveLensId | DefensiveLensId;\n\n// =============================================================================\n// ANALYSIS TYPES\n// =============================================================================\n\n/**\n * Core beliefs extracted from a document.\n */\nexport interface BeliefExtraction {\n /** Array of positioning beliefs found in the document */\n beliefs: string[];\n /** Overall clarity score (0-100) */\n score: number;\n}\n\n/**\n * Result from an offensive (Phoenix) analysis.\n */\nexport interface OffensiveAnalysisResult {\n /** Offensive power score (0-100) */\n score: number;\n /** Things the document does well offensively */\n strengths: string[];\n /** Missed opportunities and gaps */\n gaps: string[];\n /** Specific offensive plays/actions to implement */\n plays: string[];\n /** Markdown-formatted executive summary */\n summary: string;\n}\n\n/**\n * Result from a defensive (Fortress) analysis.\n */\nexport interface DefensiveAnalysisResult {\n /** Defensive strength score (0-100) */\n score: number;\n /** Well-defended areas */\n protected: string[];\n /** Exposed vulnerabilities */\n exposed: string[];\n /** Defensive fortifications to build */\n fortifications: string[];\n /** Markdown-formatted executive summary */\n summary: string;\n}\n\n/**\n * Result from a combined Phoenix Fortress analysis.\n */\nexport interface PhoenixFortressResult {\n /** Offensive subscore (0-100) */\n offensiveScore: number;\n /** Defensive subscore (0-100) */\n defensiveScore: number;\n /** Combined readiness score (0-100) */\n combinedScore: number;\n /** Markdown-formatted strategic overview */\n executiveSummary: string;\n /** Top 5 offensive plays, prioritized */\n topPlays: string[];\n /** Top 5 defensive priorities, prioritized */\n criticalFortifications: string[];\n /** The \"cheat code\" - one transformative insight */\n ultimateStrategy: string;\n}\n\n/**\n * Stored analysis record in the database.\n */\nexport interface StoredAnalysis {\n /** Unique analysis identifier */\n id: string;\n /** Associated document ID */\n documentId: string;\n /** Lens used for this analysis */\n lensId: string;\n /** Which squad (phoenix/fortress) */\n squad: Squad | \"combined\";\n /** JSON-encoded analysis result */\n analysisJson: string;\n /** Numeric score for quick access */\n score: number;\n /** When this analysis was created */\n createdAt: string;\n}\n\n// =============================================================================\n// API REQUEST/RESPONSE TYPES\n// =============================================================================\n\n/**\n * Standard API error response.\n */\nexport interface ApiError {\n /** Error message */\n error: string;\n /** Optional error code for programmatic handling */\n code?: string;\n /** Optional additional details */\n details?: unknown;\n}\n\n/**\n * Standard API success response wrapper.\n */\nexport interface ApiSuccess {\n /** Indicates success */\n success: true;\n /** Optional success message */\n message?: string;\n /** Response payload */\n data: T;\n}\n\n/**\n * Login/register request body.\n */\nexport interface AuthRequest {\n email: string;\n}\n\n/**\n * Document upload request body.\n */\nexport interface DocumentUploadRequest {\n title: string;\n text: string;\n}\n\n/**\n * Analysis request body.\n */\nexport interface AnalysisRequest {\n documentId: string;\n lensId?: string;\n}\n\n/**\n * Upgrade request body.\n */\nexport interface UpgradeRequest {\n tier: TierId;\n}\n\n// =============================================================================\n// SETUP WIZARD TYPES\n// =============================================================================\n\n/**\n * Setup wizard configuration stored in database.\n */\nexport interface SetupConfig {\n /** Whether initial setup has been completed */\n isComplete: boolean;\n /** When setup was completed */\n completedAt?: string;\n /** Admin user ID created during setup */\n adminUserId?: string;\n /** Optional custom branding */\n branding?: {\n companyName?: string;\n primaryColor?: string;\n logoUrl?: string;\n };\n}\n\n/**\n * Setup wizard step definition.\n */\nexport interface SetupStep {\n /** Step identifier */\n id: string;\n /** Display title */\n title: string;\n /** Step description */\n description: string;\n /** Whether this step is required */\n required: boolean;\n /** Order in the wizard flow */\n order: number;\n}\n\n/**\n * Setup wizard form data.\n */\nexport interface SetupFormData {\n /** Admin email address */\n adminEmail: string;\n /** Admin display name */\n adminName?: string;\n /** Optional company/organization name */\n companyName?: string;\n /** Acknowledge terms */\n acceptTerms: boolean;\n}\n\n// =============================================================================\n// UI STATE TYPES\n// =============================================================================\n\n/**\n * Toast notification state.\n */\nexport interface ToastState {\n /** Toast message */\n message: string;\n /** Toast type for styling */\n type: \"success\" | \"error\" | \"warning\" | \"info\";\n /** Whether toast is visible */\n visible: boolean;\n}\n\n/**\n * Modal state.\n */\nexport interface ModalState {\n /** Which modal is open (null = none) */\n activeModal: \"pricing\" | \"upload\" | \"settings\" | null;\n}\n\n/**\n * Application UI state.\n */\nexport interface AppState {\n /** Current authenticated user (null if logged out) */\n user: User | null;\n /** List of user's documents */\n documents: DocumentSummary[];\n /** Currently selected document ID */\n selectedDocumentId: string | null;\n /** Extracted beliefs for selected document */\n beliefs: BeliefExtraction | null;\n /** Currently selected belief for analysis */\n selectedBelief: string | null;\n /** Index of selected belief */\n selectedBeliefIndex: number | null;\n /** Current toast notification */\n toast: ToastState | null;\n /** Current modal state */\n modal: ModalState;\n /** Loading states */\n loading: {\n documents: boolean;\n beliefs: boolean;\n analysis: boolean;\n upload: boolean;\n };\n}\n\n// =============================================================================\n// TYPE GUARDS\n// =============================================================================\n\n/**\n * Type guard to check if a value is a valid TierId.\n */\nexport function isTierId(value: unknown): value is TierId {\n return (\n typeof value === \"string\" &&\n [\"tier_rookie\", \"tier_starter\", \"tier_mvp\"].includes(value)\n );\n}\n\n/**\n * Type guard to check if a value is a valid Squad.\n */\nexport function isSquad(value: unknown): value is Squad {\n return value === \"phoenix\" || value === \"fortress\";\n}\n\n/**\n * Type guard to check if a value is a valid DocumentStatus.\n */\nexport function isDocumentStatus(value: unknown): value is DocumentStatus {\n return (\n typeof value === \"string\" &&\n [\"pending\", \"processing\", \"ready\", \"error\"].includes(value)\n );\n}\n\n/**\n * Type guard for API error responses.\n */\nexport function isApiError(value: unknown): value is ApiError {\n return (\n typeof value === \"object\" &&\n value !== null &&\n \"error\" in value &&\n typeof (value as ApiError).error === \"string\"\n );\n}\n\n// =============================================================================\n// UTILITY TYPES\n// =============================================================================\n\n/** Make all properties optional recursively */\nexport type DeepPartial = {\n [P in keyof T]?: T[P] extends object ? DeepPartial : T[P];\n};\n\n/** Extract the resolved type from a Promise */\nexport type Awaited = T extends Promise ? U : T;\n\n/** Database row type (can be array or object depending on sqlite driver) */\nexport type DatabaseRow = Record | unknown[];\n\n/** Safe extraction helper type */\nexport type SafeExtract = T extends Record ? V\n : never;","label",[133],"7a2365c4-d46c-11f0-9529-42dde27851f2",["D",1765222281910],[27],"7da5a41c-d464-11f0-a05c-42dde27851f2","main.ts",1,["D",1765218851823],[147],"6e20dcde-d46c-11f0-8b8d-42dde27851f2","engine.ts","5566990e-d46c-11f0-885c-42dde27851f2",17,["D",1765222261751],2,"/**\n * @fileoverview The Playbook AI Analysis Engine.\n * Handles all AI-powered analysis including belief extraction,\n * offensive/defensive analysis, and combined Phoenix Fortress reports.\n *\n * @author The Playbook Team\n * @version 3.0.0\n */\n\nimport { OpenAI } from \"https://esm.town/v/std/openai?v=5\";\nimport {\n APP_TAGLINES,\n DEFENSIVE_LENSES,\n MASCOTS,\n OFFENSIVE_LENSES,\n} from \"./config.ts\";\nimport type {\n BeliefExtraction,\n DefensiveAnalysisResult,\n Lens,\n OffensiveAnalysisResult,\n PhoenixFortressResult,\n} from \"./types.ts\";\n\n// =============================================================================\n// CONSTANTS\n// =============================================================================\n\n/** Default model for analysis */\nconst DEFAULT_MODEL = \"gpt-4o\";\n\n/** Temperature for creative analysis */\nconst ANALYSIS_TEMPERATURE = 0.7;\n\n/** Maximum tokens for analysis responses */\nconst MAX_TOKENS = 4000;\n\n// =============================================================================\n// PROMPT TEMPLATES\n// =============================================================================\n\n/**\n * System prompt for belief extraction.\n */\nconst BELIEF_EXTRACTION_PROMPT =\n `You are an elite positioning strategist who has coached Fortune 500 CEOs and championship-winning teams.\n\nYour expertise: Extracting the CORE POSITIONING BELIEFS from business copy — the fundamental assumptions, claims, promises, and value propositions embedded in the text.\n\nYou speak with confidence and precision. You see what others miss. You're the coach everyone wants but few can afford.\n\nTASK: Extract 5-7 CORE POSITIONING BELIEFS from the provided copy.\n\nThese beliefs should be:\n- Specific and concrete (not generic fluff)\n- The actual claims being made (explicit or implicit)\n- The value propositions presented\n- The differentiators claimed\n- The promises made to the reader\n\nAlso provide an overall CLARITY SCORE (0-100) based on:\n- Target audience clarity (who is this for?)\n- Differentiation strength (why you vs. anyone else?)\n- Proof and credibility (can they back it up?)\n- Emotional resonance (does it hit different?)\n- Action orientation (do I know what to do next?)\n\nIMPORTANT: Be specific. Generic beliefs like \"we help businesses grow\" are worthless. Dig deeper. Find the real positioning.\n\nReturn ONLY valid JSON in this exact format:\n{\n \"beliefs\": [\"belief 1\", \"belief 2\", \"belief 3\", \"belief 4\", \"belief 5\"],\n \"score\": 75\n}`;\n\n/**\n * Generates the system prompt for offensive analysis.\n *\n * @param lens - The offensive lens to use\n * @returns Complete system prompt\n */\nfunction generateOffensivePrompt(lens: Lens): string {\n return `You are ${lens.name} ${lens.emoji}, an elite OFFENSIVE positioning strategist on The Phoenix Squad 🔥.\n\nTHE PHOENIX: ${MASCOTS.PHOENIX.description}\nBATTLE CRY: \"${MASCOTS.PHOENIX.battleCry}\"\n\nYOUR ROLE: ${lens.description}\nYOUR BIAS: \"${lens.bias}\"\n\nYou analyze positioning to find ATTACK OPPORTUNITIES. You're here to help them WIN, not just survive.\n\nYour analysis focuses on:\n${lens.focus.map((f, i) => `${i + 1}. ${f}`).join(\"\\n\")}\n\nBRAND VOICE - Channel these taglines:\n- \"${APP_TAGLINES.primary}\"\n- \"${APP_TAGLINES.tertiary}\"\n- \"${APP_TAGLINES.quinary}\"\n\nTONE: You're a $10,000/day consultant who genuinely wants them to dominate. Be direct, specific, and actionable. No fluff. No generic advice. Every recommendation should be something they can implement THIS WEEK.\n\nReturn ONLY valid JSON in this exact format:\n{\n \"score\": <0-100 offensive power score>,\n \"strengths\": [\n \"\",\n \"\",\n \"\"\n ],\n \"gaps\": [\n \"\",\n \"\",\n \"\"\n ],\n \"plays\": [\n \"\",\n \"\",\n \"\",\n \"\",\n \"\"\n ],\n \"summary\": \"<2-3 paragraph executive summary in markdown. Start with what's working (be specific), then the gaps (be direct), then the killer insight that changes everything. Use **bold** for emphasis and > for key insights.>\"\n}`;\n}\n\n/**\n * Generates the system prompt for defensive analysis.\n *\n * @param lens - The defensive lens to use\n * @returns Complete system prompt\n */\nfunction generateDefensivePrompt(lens: Lens): string {\n return `You are ${lens.name} ${lens.emoji}, an elite DEFENSIVE positioning strategist on The Fortress Squad 🏰.\n\nTHE FORTRESS: ${MASCOTS.FORTRESS.description}\nBATTLE CRY: \"${MASCOTS.FORTRESS.battleCry}\"\n\nYOUR ROLE: ${lens.description}\nYOUR BIAS: \"${lens.bias}\"\n\nYou analyze positioning to find VULNERABILITIES before the market does. You're here to help them SURVIVE and PROTECT what they've built.\n\nYour analysis focuses on:\n${lens.focus.map((f, i) => `${i + 1}. ${f}`).join(\"\\n\")}\n\nBRAND VOICE - Channel these taglines:\n- \"${APP_TAGLINES.primary}\"\n- \"${APP_TAGLINES.quaternary}\"\n- \"${APP_TAGLINES.quinary}\"\n\nTONE: You're a battle-hardened strategist who has seen companies fail from the exact vulnerabilities you're identifying. Be direct, specific, and protective. No sugarcoating. Every fortification should address a REAL risk.\n\nReturn ONLY valid JSON in this exact format:\n{\n \"score\": <0-100 defensive strength score>,\n \"protected\": [\n \"\",\n \"\",\n \"\"\n ],\n \"exposed\": [\n \"\",\n \"\",\n \"\"\n ],\n \"fortifications\": [\n \"\",\n \"\",\n \"\",\n \"\",\n \"\"\n ],\n \"summary\": \"<2-3 paragraph executive summary in markdown. Start with what's protected (be specific), then the exposures (be direct about risks), then the critical insight they MUST act on. Use **bold** for emphasis and > for key warnings.>\"\n}`;\n}\n\n/**\n * System prompt for Phoenix Fortress combined analysis.\n */\nconst PHOENIX_FORTRESS_PROMPT =\n `You are THE PHOENIX FORTRESS ⚔️🛡️ — the ultimate fusion of offensive firepower and defensive invincibility.\n\n${MASCOTS.PHOENIX_FORTRESS.description}\n\nBATTLE CRY: \"${MASCOTS.PHOENIX_FORTRESS.battleCry}\"\n\nWhen the Unstoppable Force meets the Immovable Object, you get TOTAL MARKET DOMINANCE.\n\nYou provide the COMPLETE strategic picture:\n\n🔥 OFFENSIVE (The Phoenix):\n- Market opportunities they're missing\n- Conversion optimization gaps\n- Viral and referral potential\n- Premium positioning opportunities\n\n🏰 DEFENSIVE (The Fortress):\n- Skeptic-proofing requirements\n- Competitor attack vectors\n- Risk and compliance issues\n- Retention and churn risks\n\nBRAND VOICE - You embody ALL the taglines:\n- \"${APP_TAGLINES.primary}\"\n- \"${APP_TAGLINES.secondary}\"\n- \"${APP_TAGLINES.tertiary}\"\n- \"${APP_TAGLINES.quaternary}\"\n- \"${APP_TAGLINES.quinary}\"\n\nTONE: You're the $50,000 strategic engagement. The boardroom-level insight. The game-changing perspective that justifies the investment. Be comprehensive, be specific, and deliver the \"cheat code\" — the ONE insight that changes everything.\n\nReturn ONLY valid JSON in this exact format:\n{\n \"offensiveScore\": <0-100>,\n \"defensiveScore\": <0-100>,\n \"combinedScore\": <0-100 overall readiness score>,\n \"executiveSummary\": \"<3-4 paragraph strategic overview in markdown. This is the boardroom-ready brief. What's the situation? What's the opportunity? What's the risk? What's the play? Use headers (##), **bold**, and > for key insights.>\",\n \"topPlays\": [\n \"<#1 highest-impact OFFENSIVE move - specific and actionable>\",\n \"<#2 offensive priority>\",\n \"<#3 offensive priority>\",\n \"<#4 offensive priority>\",\n \"<#5 offensive priority>\"\n ],\n \"criticalFortifications\": [\n \"<#1 most urgent DEFENSIVE priority - specific and actionable>\",\n \"<#2 defensive priority>\",\n \"<#3 defensive priority>\",\n \"<#4 defensive priority>\",\n \"<#5 defensive priority>\"\n ],\n \"ultimateStrategy\": \"\"\n}`;\n\n// =============================================================================\n// PLAYBOOK ENGINE CLASS\n// =============================================================================\n\n/**\n * The Playbook Engine - AI-powered positioning analysis.\n *\n * Provides three types of analysis:\n * 1. Belief Extraction - Core positioning beliefs from copy\n * 2. Offensive Analysis (Phoenix) - Market attack opportunities\n * 3. Defensive Analysis (Fortress) - Vulnerability identification\n * 4. Phoenix Fortress - Combined full-spectrum analysis\n *\n * @example\n * ```typescript\n * const engine = new PlaybookEngine();\n * const beliefs = await engine.extractBeliefs(documentText);\n * const offense = await engine.runOffensiveAnalysis(documentText, lens);\n * ```\n */\nexport class PlaybookEngine {\n private openai: OpenAI;\n\n /**\n * Creates a new PlaybookEngine instance.\n */\n constructor() {\n this.openai = new OpenAI();\n }\n\n // ===========================================================================\n // BELIEF EXTRACTION\n // ===========================================================================\n\n /**\n * Extracts core positioning beliefs from document text.\n *\n * @param text - The document text to analyze\n * @returns Extracted beliefs and clarity score\n *\n * @example\n * ```typescript\n * const { beliefs, score } = await engine.extractBeliefs(copyText);\n * console.log(`Clarity Score: ${score}/100`);\n * beliefs.forEach((belief, i) => console.log(`${i + 1}. ${belief}`));\n * ```\n */\n async extractBeliefs(text: string): Promise {\n try {\n const completion = await this.openai.chat.completions.create({\n model: DEFAULT_MODEL,\n temperature: ANALYSIS_TEMPERATURE,\n max_tokens: MAX_TOKENS,\n messages: [\n { role: \"system\", content: BELIEF_EXTRACTION_PROMPT },\n { role: \"user\", content: text },\n ],\n response_format: { type: \"json_object\" },\n });\n\n const content = completion.choices[0]?.message?.content;\n\n if (!content) {\n throw new Error(\"No content in response\");\n }\n\n const parsed = JSON.parse(content);\n\n return {\n beliefs: Array.isArray(parsed.beliefs) ? parsed.beliefs : [],\n score: typeof parsed.score === \"number\" ? parsed.score : 0,\n };\n } catch (error) {\n console.error(\"[PlaybookEngine] Belief extraction failed:\", error);\n\n return {\n beliefs: [\n \"Unable to extract beliefs. Please try again with different content.\",\n ],\n score: 0,\n };\n }\n }\n\n // ===========================================================================\n // OFFENSIVE ANALYSIS (PHOENIX SQUAD)\n // ===========================================================================\n\n /**\n * Runs an offensive analysis using a Phoenix Squad lens.\n *\n * @param text - The document text to analyze\n * @param lensId - The offensive lens ID to use\n * @returns Offensive analysis result\n * @throws Error if lens not found\n *\n * @example\n * ```typescript\n * const result = await engine.runOffensiveAnalysis(copyText, \"MarketDisruptor\");\n * console.log(`Offensive Score: ${result.score}/100`);\n * result.plays.forEach(play => console.log(`→ ${play}`));\n * ```\n */\n async runOffensiveAnalysis(\n text: string,\n lensId: string,\n ): Promise {\n const lens = OFFENSIVE_LENSES.find((l) => l.id === lensId);\n\n if (!lens) {\n throw new Error(`Unknown offensive lens: ${lensId}`);\n }\n\n try {\n const completion = await this.openai.chat.completions.create({\n model: DEFAULT_MODEL,\n temperature: ANALYSIS_TEMPERATURE,\n max_tokens: MAX_TOKENS,\n messages: [\n { role: \"system\", content: generateOffensivePrompt(lens as Lens) },\n { role: \"user\", content: text },\n ],\n response_format: { type: \"json_object\" },\n });\n\n const content = completion.choices[0]?.message?.content;\n\n if (!content) {\n throw new Error(\"No content in response\");\n }\n\n const parsed = JSON.parse(content);\n\n return {\n score: typeof parsed.score === \"number\" ? parsed.score : 0,\n strengths: Array.isArray(parsed.strengths) ? parsed.strengths : [],\n gaps: Array.isArray(parsed.gaps) ? parsed.gaps : [],\n plays: Array.isArray(parsed.plays) ? parsed.plays : [],\n summary: typeof parsed.summary === \"string\"\n ? parsed.summary\n : \"Analysis unavailable.\",\n };\n } catch (error) {\n console.error(\n `[PlaybookEngine] Offensive analysis (${lensId}) failed:`,\n error,\n );\n\n return {\n score: 0,\n strengths: [],\n gaps: [],\n plays: [],\n summary: \"Unable to generate offensive analysis. Please try again.\",\n };\n }\n }\n\n // ===========================================================================\n // DEFENSIVE ANALYSIS (FORTRESS SQUAD)\n // ===========================================================================\n\n /**\n * Runs a defensive analysis using a Fortress Squad lens.\n *\n * @param text - The document text to analyze\n * @param lensId - The defensive lens ID to use\n * @returns Defensive analysis result\n * @throws Error if lens not found\n *\n * @example\n * ```typescript\n * const result = await engine.runDefensiveAnalysis(copyText, \"SkepticalProspect\");\n * console.log(`Defensive Score: ${result.score}/100`);\n * result.fortifications.forEach(fort => console.log(`🛡️ ${fort}`));\n * ```\n */\n async runDefensiveAnalysis(\n text: string,\n lensId: string,\n ): Promise {\n const lens = DEFENSIVE_LENSES.find((l) => l.id === lensId);\n\n if (!lens) {\n throw new Error(`Unknown defensive lens: ${lensId}`);\n }\n\n try {\n const completion = await this.openai.chat.completions.create({\n model: DEFAULT_MODEL,\n temperature: ANALYSIS_TEMPERATURE,\n max_tokens: MAX_TOKENS,\n messages: [\n { role: \"system\", content: generateDefensivePrompt(lens as Lens) },\n { role: \"user\", content: text },\n ],\n response_format: { type: \"json_object\" },\n });\n\n const content = completion.choices[0]?.message?.content;\n\n if (!content) {\n throw new Error(\"No content in response\");\n }\n\n const parsed = JSON.parse(content);\n\n return {\n score: typeof parsed.score === \"number\" ? parsed.score : 0,\n protected: Array.isArray(parsed.protected) ? parsed.protected : [],\n exposed: Array.isArray(parsed.exposed) ? parsed.exposed : [],\n fortifications: Array.isArray(parsed.fortifications)\n ? parsed.fortifications\n : [],\n summary: typeof parsed.summary === \"string\"\n ? parsed.summary\n : \"Analysis unavailable.\",\n };\n } catch (error) {\n console.error(\n `[PlaybookEngine] Defensive analysis (${lensId}) failed:`,\n error,\n );\n\n return {\n score: 0,\n protected: [],\n exposed: [],\n fortifications: [],\n summary: \"Unable to generate defensive analysis. Please try again.\",\n };\n }\n }\n\n // ===========================================================================\n // PHOENIX FORTRESS COMBINED ANALYSIS\n // ===========================================================================\n\n /**\n * Runs a full Phoenix Fortress combined analysis.\n * This is the premium analysis that covers both offense and defense.\n *\n * @param text - The document text to analyze\n * @returns Combined Phoenix Fortress result\n *\n * @example\n * ```typescript\n * const result = await engine.runPhoenixFortressAnalysis(copyText);\n * console.log(`Combined Score: ${result.combinedScore}/100`);\n * console.log(`Ultimate Strategy: ${result.ultimateStrategy}`);\n * ```\n */\n async runPhoenixFortressAnalysis(\n text: string,\n ): Promise {\n try {\n const completion = await this.openai.chat.completions.create({\n model: DEFAULT_MODEL,\n temperature: ANALYSIS_TEMPERATURE,\n max_tokens: MAX_TOKENS,\n messages: [\n { role: \"system\", content: PHOENIX_FORTRESS_PROMPT },\n { role: \"user\", content: text },\n ],\n response_format: { type: \"json_object\" },\n });\n\n const content = completion.choices[0]?.message?.content;\n\n if (!content) {\n throw new Error(\"No content in response\");\n }\n\n const parsed = JSON.parse(content);\n\n return {\n offensiveScore: typeof parsed.offensiveScore === \"number\"\n ? parsed.offensiveScore\n : 0,\n defensiveScore: typeof parsed.defensiveScore === \"number\"\n ? parsed.defensiveScore\n : 0,\n combinedScore: typeof parsed.combinedScore === \"number\"\n ? parsed.combinedScore\n : 0,\n executiveSummary: typeof parsed.executiveSummary === \"string\"\n ? parsed.executiveSummary\n : \"Executive summary unavailable.\",\n topPlays: Array.isArray(parsed.topPlays) ? parsed.topPlays : [],\n criticalFortifications: Array.isArray(parsed.criticalFortifications)\n ? parsed.criticalFortifications\n : [],\n ultimateStrategy: typeof parsed.ultimateStrategy === \"string\"\n ? parsed.ultimateStrategy\n : \"Unable to generate ultimate strategy.\",\n };\n } catch (error) {\n console.error(\n \"[PlaybookEngine] Phoenix Fortress analysis failed:\",\n error,\n );\n\n return {\n offensiveScore: 0,\n defensiveScore: 0,\n combinedScore: 0,\n executiveSummary:\n \"Unable to generate combined analysis. Please try again.\",\n topPlays: [],\n criticalFortifications: [],\n ultimateStrategy: \"Analysis failed. Please retry.\",\n };\n }\n }\n}\n\n// =============================================================================\n// SINGLETON INSTANCE\n// =============================================================================\n\n/** Singleton engine instance for reuse across requests */\nlet engineInstance: PlaybookEngine | null = null;\n\n/**\n * Gets or creates the PlaybookEngine singleton instance.\n *\n * @returns The PlaybookEngine instance\n */\nexport function getEngine(): PlaybookEngine {\n if (!engineInstance) {\n engineInstance = new PlaybookEngine();\n }\n return engineInstance;\n}\n\n// =============================================================================\n// UTILITY FUNCTIONS\n// =============================================================================\n\n/**\n * Validates that text meets minimum requirements for analysis.\n *\n * @param text - The text to validate\n * @param minWords - Minimum word count (default 50)\n * @returns Validation result with message\n */\nexport function validateTextForAnalysis(\n text: string,\n minWords: number = 50,\n): { valid: boolean; message: string; wordCount: number } {\n const words = text.split(/\\s+/).filter((word) => word.length > 0);\n const wordCount = words.length;\n\n if (wordCount < minWords) {\n return {\n valid: false,\n message:\n `Document needs at least ${minWords} words for meaningful analysis. Current: ${wordCount} words.`,\n wordCount,\n };\n }\n\n if (text.trim().length < 200) {\n return {\n valid: false,\n message:\n \"Document content is too short. Please provide more detailed positioning copy.\",\n wordCount,\n };\n }\n\n return {\n valid: true,\n message: \"Document is ready for analysis.\",\n wordCount,\n };\n}\n\n/**\n * Calculates a combined score from offensive and defensive scores.\n * Uses weighted average favoring the lower score to encourage balance.\n *\n * @param offensiveScore - Score from offensive analysis\n * @param defensiveScore - Score from defensive analysis\n * @returns Combined score (0-100)\n */\nexport function calculateCombinedScore(\n offensiveScore: number,\n defensiveScore: number,\n): number {\n // Weight the lower score more heavily to encourage balance\n const minScore = Math.min(offensiveScore, defensiveScore);\n const maxScore = Math.max(offensiveScore, defensiveScore);\n\n // 60% weight to lower score, 40% to higher\n const combined = (minScore * 0.6) + (maxScore * 0.4);\n\n return Math.round(combined);\n}",[152],"10a6dfc2-d46c-11f0-97f4-42dde27851f2","database.ts","f56798f0-d46b-11f0-a466-42dde27851f2",11,["D",1765222104931],"/**\n * @fileoverview Database schema, migrations, and CRUD operations for The Playbook.\n * Handles all SQLite interactions with type-safe wrappers.\n *\n * @author The Playbook Team\n * @version 3.0.0\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite?v=6\";\nimport { nanoid } from \"npm:nanoid@5.0.7\";\nimport { DB_VERSION, SETUP_COMPLETE_KEY } from \"./config.ts\";\nimport type {\n CreateSessionInput,\n DatabaseRow,\n Document,\n DocumentStatus,\n DocumentSummary,\n Session,\n SetupConfig,\n StoredAnalysis,\n TierId,\n User,\n} from \"./types.ts\";\n\n// =============================================================================\n// DATABASE INITIALIZATION & MIGRATIONS\n// =============================================================================\n\n/**\n * SQL statements for creating database tables.\n * Executed in order during initialization.\n */\nconst SCHEMA_MIGRATIONS: string[] = [\n // Users table\n `CREATE TABLE IF NOT EXISTS users (\n id TEXT PRIMARY KEY,\n email TEXT UNIQUE NOT NULL,\n name TEXT,\n tier TEXT DEFAULT 'tier_rookie',\n avatar_url TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n\n // Sessions table\n `CREATE TABLE IF NOT EXISTS sessions (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n expires_at DATETIME NOT NULL,\n user_agent TEXT,\n ip_address TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE\n )`,\n\n // Documents table\n `CREATE TABLE IF NOT EXISTS documents (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n title TEXT NOT NULL,\n text_content TEXT NOT NULL,\n word_count INTEGER DEFAULT 0,\n status TEXT DEFAULT 'pending',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE\n )`,\n\n // Analyses table\n `CREATE TABLE IF NOT EXISTS analyses (\n id TEXT PRIMARY KEY,\n document_id TEXT NOT NULL,\n lens_id TEXT NOT NULL,\n squad TEXT NOT NULL,\n analysis_json TEXT,\n score INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(document_id) REFERENCES documents(id) ON DELETE CASCADE\n )`,\n\n // Playbook reports (combined analyses)\n `CREATE TABLE IF NOT EXISTS playbook_reports (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n document_id TEXT NOT NULL,\n report_json TEXT,\n offensive_score INTEGER,\n defensive_score INTEGER,\n combined_score INTEGER,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE,\n FOREIGN KEY(document_id) REFERENCES documents(id) ON DELETE CASCADE\n )`,\n\n // System configuration (for setup wizard, etc.)\n `CREATE TABLE IF NOT EXISTS system_config (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n\n // Usage logs for analytics\n `CREATE TABLE IF NOT EXISTS usage_logs (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id TEXT NOT NULL,\n action TEXT NOT NULL,\n metadata_json TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n\n // Create indexes for performance\n `CREATE INDEX IF NOT EXISTS idx_sessions_user ON sessions(user_id)`,\n `CREATE INDEX IF NOT EXISTS idx_sessions_expires ON sessions(expires_at)`,\n `CREATE INDEX IF NOT EXISTS idx_documents_user ON documents(user_id)`,\n `CREATE INDEX IF NOT EXISTS idx_analyses_document ON analyses(document_id)`,\n `CREATE INDEX IF NOT EXISTS idx_usage_user ON usage_logs(user_id)`,\n];\n\n/**\n * Initializes the database schema.\n * Runs all migrations in sequence, skipping any that already exist.\n *\n * @returns Promise that resolves when initialization is complete\n * @throws Error if a critical migration fails\n */\nexport async function initializeDatabase(): Promise {\n console.log(`[Database] Initializing schema v${DB_VERSION}...`);\n\n for (const migration of SCHEMA_MIGRATIONS) {\n try {\n await sqlite.execute(migration);\n } catch (error) {\n // Log but don't throw for \"already exists\" errors\n const errorMessage = error instanceof Error\n ? error.message\n : String(error);\n if (!errorMessage.includes(\"already exists\")) {\n console.error(`[Database] Migration error:`, errorMessage);\n }\n }\n }\n\n console.log(`[Database] Schema initialization complete.`);\n}\n\n// =============================================================================\n// ROW PARSING HELPERS\n// =============================================================================\n\n/**\n * Safely extracts a value from a database row.\n * Handles both array and object row formats from sqlite driver.\n *\n * @param row - The database row\n * @param key - The column name (for object format)\n * @param index - The column index (for array format)\n * @returns The extracted value or undefined\n */\nfunction extractValue(row: DatabaseRow, key: string, index: number): unknown {\n if (Array.isArray(row)) {\n return row[index];\n }\n if (typeof row === \"object\" && row !== null) {\n return (row as Record)[key];\n }\n return undefined;\n}\n\n/**\n * Parses a database row into a User object.\n */\nfunction parseUserRow(row: DatabaseRow): User {\n return {\n id: String(extractValue(row, \"id\", 0)),\n email: String(extractValue(row, \"email\", 1)),\n name: extractValue(row, \"name\", 2) as string | null,\n tier: String(extractValue(row, \"tier\", 3)) as TierId,\n avatarUrl: extractValue(row, \"avatar_url\", 4) as string | undefined,\n createdAt: String(extractValue(row, \"created_at\", 5)),\n };\n}\n\n/**\n * Parses a database row into a Document object.\n */\nfunction parseDocumentRow(row: DatabaseRow): Document {\n return {\n id: String(extractValue(row, \"id\", 0)),\n userId: String(extractValue(row, \"user_id\", 1)),\n title: String(extractValue(row, \"title\", 2)),\n textContent: String(extractValue(row, \"text_content\", 3)),\n wordCount: Number(extractValue(row, \"word_count\", 4)) || 0,\n status: String(extractValue(row, \"status\", 5)) as DocumentStatus,\n createdAt: String(extractValue(row, \"created_at\", 6)),\n };\n}\n\n/**\n * Parses a database row into a DocumentSummary object.\n */\nfunction parseDocumentSummaryRow(row: DatabaseRow): DocumentSummary {\n return {\n id: String(extractValue(row, \"id\", 0)),\n title: String(extractValue(row, \"title\", 1)),\n wordCount: Number(extractValue(row, \"word_count\", 2)) || 0,\n status: String(extractValue(row, \"status\", 3)) as DocumentStatus,\n createdAt: String(extractValue(row, \"created_at\", 4)),\n };\n}\n\n// =============================================================================\n// SETUP CONFIGURATION OPERATIONS\n// =============================================================================\n\n/**\n * Checks if the initial setup wizard has been completed.\n *\n * @returns Promise - true if setup is complete\n */\nexport async function isSetupComplete(): Promise {\n try {\n const result = await sqlite.execute({\n sql: `SELECT value FROM system_config WHERE key = ?`,\n args: [SETUP_COMPLETE_KEY],\n });\n\n if (result.rows.length === 0) {\n return false;\n }\n\n const value = extractValue(result.rows[0], \"value\", 0);\n return value === \"true\";\n } catch {\n // Table might not exist yet\n return false;\n }\n}\n\n/**\n * Marks the setup wizard as complete.\n *\n * @param config - Optional configuration to store\n */\nexport async function completeSetup(\n config?: Partial,\n): Promise {\n const now = new Date().toISOString();\n\n await sqlite.execute({\n sql:\n `INSERT OR REPLACE INTO system_config (key, value, updated_at) VALUES (?, ?, ?)`,\n args: [SETUP_COMPLETE_KEY, \"true\", now],\n });\n\n if (config?.adminUserId) {\n await sqlite.execute({\n sql:\n `INSERT OR REPLACE INTO system_config (key, value, updated_at) VALUES (?, ?, ?)`,\n args: [\"admin_user_id\", config.adminUserId, now],\n });\n }\n}\n\n/**\n * Gets the current setup configuration.\n */\nexport async function getSetupConfig(): Promise {\n const result = await sqlite.execute({\n sql: `SELECT key, value FROM system_config WHERE key IN (?, ?, ?)`,\n args: [SETUP_COMPLETE_KEY, \"admin_user_id\", \"completed_at\"],\n });\n\n const config: SetupConfig = { isComplete: false };\n\n for (const row of result.rows) {\n const key = extractValue(row, \"key\", 0);\n const value = extractValue(row, \"value\", 1);\n\n if (key === SETUP_COMPLETE_KEY) {\n config.isComplete = value === \"true\";\n } else if (key === \"admin_user_id\") {\n config.adminUserId = String(value);\n } else if (key === \"completed_at\") {\n config.completedAt = String(value);\n }\n }\n\n return config;\n}\n\n// =============================================================================\n// USER OPERATIONS\n// =============================================================================\n\n/**\n * Finds a user by their email address.\n *\n * @param email - The email to search for\n * @returns The user if found, null otherwise\n */\nexport async function findUserByEmail(email: string): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT id, email, name, tier, avatar_url, created_at FROM users WHERE email = ?`,\n args: [email],\n });\n\n if (result.rows.length === 0) {\n return null;\n }\n\n return parseUserRow(result.rows[0]);\n}\n\n/**\n * Finds a user by their ID.\n *\n * @param id - The user ID\n * @returns The user if found, null otherwise\n */\nexport async function findUserById(id: string): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT id, email, name, tier, avatar_url, created_at FROM users WHERE id = ?`,\n args: [id],\n });\n\n if (result.rows.length === 0) {\n return null;\n }\n\n return parseUserRow(result.rows[0]);\n}\n\n/**\n * Creates a new user.\n *\n * @param email - User's email address\n * @param name - Optional display name\n * @param tier - Initial tier (defaults to rookie)\n * @returns The created user\n */\nexport async function createUser(\n email: string,\n name?: string,\n tier: TierId = \"tier_rookie\",\n): Promise {\n const id = `usr_${nanoid(16)}`;\n const now = new Date().toISOString();\n\n await sqlite.execute({\n sql:\n `INSERT INTO users (id, email, name, tier, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?)`,\n args: [id, email, name || null, tier, now, now],\n });\n\n return {\n id,\n email,\n name: name || null,\n tier,\n createdAt: now,\n };\n}\n\n/**\n * Updates a user's tier.\n *\n * @param userId - The user's ID\n * @param tier - The new tier\n */\nexport async function updateUserTier(\n userId: string,\n tier: TierId,\n): Promise {\n const now = new Date().toISOString();\n\n await sqlite.execute({\n sql: `UPDATE users SET tier = ?, updated_at = ? WHERE id = ?`,\n args: [tier, now, userId],\n });\n}\n\n/**\n * Updates a user's profile information.\n *\n * @param userId - The user's ID\n * @param updates - Fields to update\n */\nexport async function updateUserProfile(\n userId: string,\n updates: { name?: string; avatarUrl?: string },\n): Promise {\n const now = new Date().toISOString();\n const setClauses: string[] = [\"updated_at = ?\"];\n const args: (string | null)[] = [now];\n\n if (updates.name !== undefined) {\n setClauses.push(\"name = ?\");\n args.push(updates.name);\n }\n\n if (updates.avatarUrl !== undefined) {\n setClauses.push(\"avatar_url = ?\");\n args.push(updates.avatarUrl);\n }\n\n args.push(userId);\n\n await sqlite.execute({\n sql: `UPDATE users SET ${setClauses.join(\", \")} WHERE id = ?`,\n args,\n });\n}\n\n// =============================================================================\n// SESSION OPERATIONS\n// =============================================================================\n\n/**\n * Creates a new session for a user.\n *\n * @param input - Session creation parameters\n * @returns The session ID\n */\nexport async function createSession(\n input: CreateSessionInput,\n): Promise {\n const { userId, userAgent, ipAddress } = input;\n const sessionId = `sess_${nanoid(32)}`;\n const now = new Date();\n const expiresAt = new Date(now.getTime() + 30 * 24 * 60 * 60 * 1000); // 30 days\n\n await sqlite.execute({\n sql:\n `INSERT INTO sessions (id, user_id, expires_at, user_agent, ip_address, created_at) \n VALUES (?, ?, ?, ?, ?, ?)`,\n args: [\n sessionId,\n userId,\n expiresAt.toISOString(),\n userAgent || null,\n ipAddress || null,\n now.toISOString(),\n ],\n });\n\n return sessionId;\n}\n\n/**\n * Validates a session and returns the associated user.\n *\n * @param sessionId - The session ID to validate\n * @returns The user if session is valid, null otherwise\n */\nexport async function validateSession(sessionId: string): Promise {\n const result = await sqlite.execute({\n sql: `\n SELECT u.id, u.email, u.name, u.tier, u.avatar_url, u.created_at, s.expires_at\n FROM sessions s\n JOIN users u ON s.user_id = u.id\n WHERE s.id = ?\n `,\n args: [sessionId],\n });\n\n if (result.rows.length === 0) {\n return null;\n }\n\n const row = result.rows[0];\n const expiresAt = new Date(String(extractValue(row, \"expires_at\", 6)));\n\n if (expiresAt < new Date()) {\n // Session expired, clean it up\n await deleteSession(sessionId);\n return null;\n }\n\n return parseUserRow(row);\n}\n\n/**\n * Deletes a session.\n *\n * @param sessionId - The session ID to delete\n */\nexport async function deleteSession(sessionId: string): Promise {\n await sqlite.execute({\n sql: `DELETE FROM sessions WHERE id = ?`,\n args: [sessionId],\n });\n}\n\n/**\n * Deletes all sessions for a user.\n *\n * @param userId - The user ID\n */\nexport async function deleteUserSessions(userId: string): Promise {\n await sqlite.execute({\n sql: `DELETE FROM sessions WHERE user_id = ?`,\n args: [userId],\n });\n}\n\n/**\n * Cleans up expired sessions.\n *\n * @returns Number of sessions deleted\n */\nexport async function cleanupExpiredSessions(): Promise {\n const result = await sqlite.execute({\n sql: `DELETE FROM sessions WHERE expires_at < datetime('now')`,\n args: [],\n });\n\n return result.rowsAffected || 0;\n}\n\n// =============================================================================\n// DOCUMENT OPERATIONS\n// =============================================================================\n\n/**\n * Creates a new document.\n *\n * @param userId - Owner's user ID\n * @param title - Document title\n * @param textContent - Full text content\n * @returns The created document\n */\nexport async function createDocument(\n userId: string,\n title: string,\n textContent: string,\n): Promise {\n const id = `doc_${nanoid(24)}`;\n const now = new Date().toISOString();\n const wordCount =\n textContent.split(/\\s+/).filter((word) => word.length > 0).length;\n\n await sqlite.execute({\n sql:\n `INSERT INTO documents (id, user_id, title, text_content, word_count, status, created_at, updated_at)\n VALUES (?, ?, ?, ?, ?, 'pending', ?, ?)`,\n args: [id, userId, title, textContent, wordCount, now, now],\n });\n\n return {\n id,\n userId,\n title,\n textContent,\n wordCount,\n status: \"pending\",\n createdAt: now,\n };\n}\n\n/**\n * Gets a document by ID with ownership verification.\n *\n * @param documentId - The document ID\n * @param userId - The expected owner's ID\n * @returns The document if found and owned by user, null otherwise\n */\nexport async function getDocument(\n documentId: string,\n userId: string,\n): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT id, user_id, title, text_content, word_count, status, created_at\n FROM documents WHERE id = ? AND user_id = ?`,\n args: [documentId, userId],\n });\n\n if (result.rows.length === 0) {\n return null;\n }\n\n return parseDocumentRow(result.rows[0]);\n}\n\n/**\n * Gets all documents for a user.\n *\n * @param userId - The user's ID\n * @returns Array of document summaries\n */\nexport async function getUserDocuments(\n userId: string,\n): Promise {\n const result = await sqlite.execute({\n sql: `SELECT id, title, word_count, status, created_at\n FROM documents WHERE user_id = ? ORDER BY created_at DESC`,\n args: [userId],\n });\n\n return result.rows.map(parseDocumentSummaryRow);\n}\n\n/**\n * Counts documents created by a user in the current month.\n *\n * @param userId - The user's ID\n * @returns Number of documents this month\n */\nexport async function countUserDocumentsThisMonth(\n userId: string,\n): Promise {\n const result = await sqlite.execute({\n sql: `SELECT COUNT(id) as count FROM documents \n WHERE user_id = ? AND created_at > date('now', '-30 days')`,\n args: [userId],\n });\n\n if (result.rows.length === 0) {\n return 0;\n }\n\n const count = extractValue(result.rows[0], \"count\", 0);\n return Number(count) || 0;\n}\n\n/**\n * Updates a document's status.\n *\n * @param documentId - The document ID\n * @param status - The new status\n */\nexport async function updateDocumentStatus(\n documentId: string,\n status: DocumentStatus,\n): Promise {\n const now = new Date().toISOString();\n\n await sqlite.execute({\n sql: `UPDATE documents SET status = ?, updated_at = ? WHERE id = ?`,\n args: [status, now, documentId],\n });\n}\n\n/**\n * Deletes a document and all associated analyses.\n *\n * @param documentId - The document ID\n * @param userId - The owner's ID for verification\n * @returns true if deleted, false if not found\n */\nexport async function deleteDocument(\n documentId: string,\n userId: string,\n): Promise {\n // First verify ownership\n const doc = await getDocument(documentId, userId);\n if (!doc) {\n return false;\n }\n\n // Delete associated analyses first\n await sqlite.execute({\n sql: `DELETE FROM analyses WHERE document_id = ?`,\n args: [documentId],\n });\n\n // Delete associated reports\n await sqlite.execute({\n sql: `DELETE FROM playbook_reports WHERE document_id = ?`,\n args: [documentId],\n });\n\n // Delete the document\n await sqlite.execute({\n sql: `DELETE FROM documents WHERE id = ?`,\n args: [documentId],\n });\n\n return true;\n}\n\n// =============================================================================\n// ANALYSIS OPERATIONS\n// =============================================================================\n\n/**\n * Stores an analysis result.\n *\n * @param documentId - The analyzed document's ID\n * @param lensId - The lens used\n * @param squad - Which squad (phoenix/fortress/combined)\n * @param analysisJson - JSON-encoded analysis result\n * @param score - Numeric score\n * @returns The analysis ID\n */\nexport async function storeAnalysis(\n documentId: string,\n lensId: string,\n squad: \"phoenix\" | \"fortress\" | \"combined\",\n analysisJson: string,\n score: number,\n): Promise {\n const id = `anl_${nanoid(20)}`;\n const now = new Date().toISOString();\n\n await sqlite.execute({\n sql:\n `INSERT INTO analyses (id, document_id, lens_id, squad, analysis_json, score, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [id, documentId, lensId, squad, analysisJson, score, now],\n });\n\n return id;\n}\n\n/**\n * Gets all analyses for a document.\n *\n * @param documentId - The document ID\n * @returns Array of stored analyses\n */\nexport async function getDocumentAnalyses(\n documentId: string,\n): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT id, document_id, lens_id, squad, analysis_json, score, created_at\n FROM analyses WHERE document_id = ? ORDER BY created_at DESC`,\n args: [documentId],\n });\n\n return result.rows.map((row) => ({\n id: String(extractValue(row, \"id\", 0)),\n documentId: String(extractValue(row, \"document_id\", 1)),\n lensId: String(extractValue(row, \"lens_id\", 2)),\n squad: String(extractValue(row, \"squad\", 3)) as\n | \"phoenix\"\n | \"fortress\"\n | \"combined\",\n analysisJson: String(extractValue(row, \"analysis_json\", 4)),\n score: Number(extractValue(row, \"score\", 5)) || 0,\n createdAt: String(extractValue(row, \"created_at\", 6)),\n }));\n}\n\n/**\n * Gets the core beliefs analysis for a document.\n *\n * @param documentId - The document ID\n * @returns Beliefs and score, or null if not found\n */\nexport async function getDocumentBeliefs(\n documentId: string,\n): Promise<{ beliefs: string[]; score: number } | null> {\n const result = await sqlite.execute({\n sql: `SELECT analysis_json, score FROM analyses \n WHERE document_id = ? AND lens_id = 'core_beliefs' \n ORDER BY created_at DESC LIMIT 1`,\n args: [documentId],\n });\n\n if (result.rows.length === 0) {\n return null;\n }\n\n const row = result.rows[0];\n const analysisJson = String(extractValue(row, \"analysis_json\", 0));\n const score = Number(extractValue(row, \"score\", 1)) || 0;\n\n try {\n const beliefs = JSON.parse(analysisJson);\n return { beliefs: Array.isArray(beliefs) ? beliefs : [], score };\n } catch {\n return { beliefs: [], score };\n }\n}\n\n/**\n * Stores a Phoenix Fortress combined report.\n *\n * @param userId - The user's ID\n * @param documentId - The document ID\n * @param reportJson - JSON-encoded full report\n * @param scores - Individual and combined scores\n * @returns The report ID\n */\nexport async function storePlaybookReport(\n userId: string,\n documentId: string,\n reportJson: string,\n scores: { offensive: number; defensive: number; combined: number },\n): Promise {\n const id = `rpt_${nanoid(20)}`;\n const now = new Date().toISOString();\n\n await sqlite.execute({\n sql: `INSERT INTO playbook_reports \n (id, user_id, document_id, report_json, offensive_score, defensive_score, combined_score, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n id,\n userId,\n documentId,\n reportJson,\n scores.offensive,\n scores.defensive,\n scores.combined,\n now,\n ],\n });\n\n return id;\n}\n\n// =============================================================================\n// USAGE LOGGING\n// =============================================================================\n\n/**\n * Logs a user action for analytics.\n *\n * @param userId - The user's ID\n * @param action - Action identifier\n * @param metadata - Optional metadata object\n */\nexport async function logUsage(\n userId: string,\n action: string,\n metadata?: Record,\n): Promise {\n await sqlite.execute({\n sql: `INSERT INTO usage_logs (user_id, action, metadata_json, created_at)\n VALUES (?, ?, ?, datetime('now'))`,\n args: [userId, action, metadata ? JSON.stringify(metadata) : null],\n });\n}\n\n/**\n * Gets usage statistics for a user.\n *\n * @param userId - The user's ID\n * @param days - Number of days to look back\n * @returns Usage counts by action type\n */\nexport async function getUserUsageStats(\n userId: string,\n days: number = 30,\n): Promise> {\n const result = await sqlite.execute({\n sql: `SELECT action, COUNT(*) as count FROM usage_logs \n WHERE user_id = ? AND created_at > date('now', '-' || ? || ' days')\n GROUP BY action`,\n args: [userId, days],\n });\n\n const stats: Record = {};\n\n for (const row of result.rows) {\n const action = String(extractValue(row, \"action\", 0));\n const count = Number(extractValue(row, \"count\", 1)) || 0;\n stats[action] = count;\n }\n\n return stats;\n}",[160],"e05b2ec4-d464-11f0-9124-42dde27851f2","config.ts","d92426c4-d464-11f0-999d-42dde27851f2",4,["D",1765219017427],"/**\n * @fileoverview Core configuration for The Playbook application.\n * Contains all constants, mascot definitions, tier structures, and lens catalogs.\n *\n * @author The Playbook Team\n * @version 3.0.0\n */\n\n// =============================================================================\n// APPLICATION METADATA\n// =============================================================================\n\n/** Application display name */\nexport const APP_NAME = \"The Playbook\" as const;\n\n/** Application version following semver */\nexport const APP_VERSION = \"3.0.0\" as const;\n\n/** Database schema version for migrations */\nexport const DB_VERSION = 15 as const;\n\n/**\n * Collection of brand taglines used throughout the application.\n * Each represents a core value proposition.\n */\nexport const APP_TAGLINES = {\n /** Primary brand message - the core promise */\n primary: \"Attack the market. Armor the business.\",\n /** Secondary - emphasizes comprehensive coverage */\n secondary: \"Every angle. Every outcome. Every advantage.\",\n /** Tertiary - speaks to insider knowledge */\n tertiary: \"The plays they don't teach. The defense they can't break.\",\n /** Quaternary - outcome focused */\n quaternary: \"Win the deal. Survive the scrutiny.\",\n /** Quinary - tribal knowledge angle */\n quinary: \"Tribal knowledge, weaponized.\",\n} as const;\n\n// =============================================================================\n// SESSION CONFIGURATION\n// =============================================================================\n\n/** Session duration in seconds (30 days) */\nexport const SESSION_DURATION_SECONDS = 60 * 60 * 24 * 30;\n\n/** Cookie name for session storage */\nexport const SESSION_COOKIE_NAME = \"playbook_session_v3\";\n\n/** Key used in database to track setup completion */\nexport const SETUP_COMPLETE_KEY = \"playbook_setup_complete\";\n\n// =============================================================================\n// 🎭 MASCOT DEFINITIONS\n// =============================================================================\n\n/**\n * The Phoenix - Offensive mascot representing the Unstoppable Force.\n * Specializes in finding market opportunities and attack vectors.\n */\nexport const PHOENIX = {\n id: \"phoenix\",\n name: \"The Phoenix\",\n emoji: \"🔥\",\n title: \"The Unstoppable Force\",\n domain: \"OFFENSE\",\n colors: {\n primary: \"#f59e0b\",\n secondary: \"#dc2626\",\n glow: \"rgba(245, 158, 11, 0.4)\",\n },\n gradient: \"linear-gradient(135deg, #f59e0b, #dc2626)\",\n description:\n \"Rising from every setback, striking with precision. The Phoenix finds \" +\n \"opportunities others miss and turns your positioning into a weapon.\",\n battleCry: \"Rise. Strike. Dominate.\",\n} as const;\n\n/**\n * The Fortress - Defensive mascot representing the Immovable Object.\n * Specializes in protecting positioning and finding vulnerabilities.\n */\nexport const FORTRESS = {\n id: \"fortress\",\n name: \"The Fortress\",\n emoji: \"🏰\",\n title: \"The Immovable Object\",\n domain: \"DEFENSE\",\n colors: {\n primary: \"#0ea5e9\",\n secondary: \"#3b82f6\",\n glow: \"rgba(14, 165, 233, 0.4)\",\n },\n gradient: \"linear-gradient(135deg, #0ea5e9, #3b82f6)\",\n description:\n \"Walls that don't break. Strategy that doesn't fail. The Fortress \" +\n \"protects your position from every angle of attack.\",\n battleCry: \"Stand. Shield. Survive.\",\n} as const;\n\n/**\n * Phoenix Fortress - Combined mascot for premium full-spectrum analysis.\n * Represents the fusion of offensive and defensive capabilities.\n */\nexport const PHOENIX_FORTRESS = {\n id: \"phoenix_fortress\",\n name: \"Phoenix Fortress\",\n emoji: \"⚔️🛡️\",\n title: \"Total Market Dominance\",\n domain: \"FULL SPECTRUM\",\n colors: {\n primary: \"#a855f7\",\n secondary: \"#6366f1\",\n glow: \"rgba(168, 85, 247, 0.4)\",\n },\n gradient: \"linear-gradient(135deg, #f59e0b, #a855f7, #0ea5e9)\",\n description:\n \"When the Unstoppable Force and Immovable Object unite. Complete \" +\n \"offensive + defensive strategic command.\",\n battleCry: \"Total. Market. Dominance.\",\n} as const;\n\n/** Aggregated mascot collection for easy access */\nexport const MASCOTS = {\n PHOENIX,\n FORTRESS,\n PHOENIX_FORTRESS,\n} as const;\n\n// =============================================================================\n// 💰 TIER DEFINITIONS\n// =============================================================================\n\n/**\n * Rookie Tier - Free tier for new users.\n * Limited access to test the platform.\n */\nexport const TIER_ROOKIE = {\n id: \"tier_rookie\",\n name: \"Rookie\",\n price: 0,\n priceDisplay: \"Free\",\n badge: \"🌱\",\n description:\n \"Perfect for testing the waters. Get a taste of elite positioning intelligence.\",\n limits: {\n docsPerMonth: 3,\n offensiveLenses: [\"MarketDisruptor\"] as string[],\n defensiveLenses: [\"SkepticalProspect\"] as string[],\n phoenixFortress: false,\n exportPdf: false,\n teamSeats: 1,\n prioritySupport: false,\n },\n} as const;\n\n/**\n * Starter Tier - Professional tier for serious practitioners.\n * Full lens access and combined analysis.\n */\nexport const TIER_STARTER = {\n id: \"tier_starter\",\n name: \"Starter\",\n price: 7900,\n priceDisplay: \"$79/mo\",\n badge: \"⭐\",\n description:\n \"The essential toolkit for consultants and solo practitioners ready to dominate.\",\n limits: {\n docsPerMonth: 50,\n offensiveLenses: \"ALL\" as const,\n defensiveLenses: \"ALL\" as const,\n phoenixFortress: true,\n exportPdf: true,\n teamSeats: 1,\n prioritySupport: false,\n },\n} as const;\n\n/**\n * MVP Tier - Premium tier for agencies and teams.\n * Everything unlocked plus team features.\n */\nexport const TIER_MVP = {\n id: \"tier_mvp\",\n name: \"MVP\",\n price: 19900,\n priceDisplay: \"$199/mo\",\n badge: \"🏆\",\n description:\n \"Full-scale platform for teams. White-label reporting and priority support.\",\n limits: {\n docsPerMonth: 500,\n offensiveLenses: \"ALL\" as const,\n defensiveLenses: \"ALL\" as const,\n phoenixFortress: true,\n exportPdf: true,\n teamSeats: 10,\n prioritySupport: true,\n whiteLabel: true,\n },\n} as const;\n\n/** Aggregated tier collection */\nexport const TIERS = {\n ROOKIE: TIER_ROOKIE,\n STARTER: TIER_STARTER,\n MVP: TIER_MVP,\n} as const;\n\n/** Tier IDs as a type-safe array */\nexport const TIER_IDS = [\n TIER_ROOKIE.id,\n TIER_STARTER.id,\n TIER_MVP.id,\n] as const;\n\n// =============================================================================\n// 🔥 OFFENSIVE LENSES - THE PHOENIX SQUAD\n// =============================================================================\n\n/**\n * Offensive lens definitions for market attack analysis.\n * Each lens provides a unique perspective on positioning opportunities.\n */\nexport const OFFENSIVE_LENSES = [\n {\n id: \"MarketDisruptor\",\n name: \"The Market Disruptor\",\n emoji: \"💥\",\n squad: \"phoenix\" as const,\n description:\n \"Finds blue ocean opportunities and gaps your competitors are blind to.\",\n bias: \"If you're not zigging while they zag, you're invisible.\",\n focus: [\n \"Unique positioning opportunities\",\n \"Competitor blind spots to exploit\",\n \"Differentiation gaps in messaging\",\n \"Blue ocean vs red ocean strategy\",\n \"First-mover advantages being missed\",\n ],\n requiredTier: \"tier_rookie\",\n },\n {\n id: \"TheCloser\",\n name: \"The Closer\",\n emoji: \"🎯\",\n squad: \"phoenix\" as const,\n description:\n \"Identifies conversion killers, urgency gaps, and CTA weakness.\",\n bias: \"Every word either sells or stalls. There is no neutral.\",\n focus: [\n \"Call-to-action strength and clarity\",\n \"Urgency and scarcity triggers\",\n \"Objection handling in copy\",\n \"Decision friction points\",\n \"The 'why now' factor\",\n ],\n requiredTier: \"tier_starter\",\n },\n {\n id: \"ViralArchitect\",\n name: \"The Viral Architect\",\n emoji: \"🚀\",\n squad: \"phoenix\" as const,\n description:\n \"Evaluates shareability, referral hooks, and organic growth loops.\",\n bias:\n \"If they can't explain you in 10 seconds, they won't explain you at all.\",\n focus: [\n \"Word-of-mouth trigger points\",\n \"Referral-ready messaging\",\n \"Social proof integration\",\n \"Shareable soundbites and hooks\",\n \"Network effect potential\",\n ],\n requiredTier: \"tier_starter\",\n },\n {\n id: \"PremiumPositioner\",\n name: \"The Premium Positioner\",\n emoji: \"👑\",\n squad: \"phoenix\" as const,\n description:\n \"Audits value justification, pricing psychology, and exclusivity signals.\",\n bias:\n \"Cheap is a strategy. Expensive is a strategy. Confused is a disaster.\",\n focus: [\n \"Price-to-value perception\",\n \"Premium positioning signals\",\n \"Exclusivity and scarcity framing\",\n \"ROI and outcome articulation\",\n \"Luxury vs commodity positioning\",\n ],\n requiredTier: \"tier_starter\",\n },\n] as const;\n\n// =============================================================================\n// 🏰 DEFENSIVE LENSES - THE FORTRESS SQUAD\n// =============================================================================\n\n/**\n * Defensive lens definitions for vulnerability and risk analysis.\n * Each lens identifies potential weaknesses before the market does.\n */\nexport const DEFENSIVE_LENSES = [\n {\n id: \"SkepticalProspect\",\n name: \"The Skeptical Prospect\",\n emoji: \"🤨\",\n squad: \"fortress\" as const,\n description: \"Hunts for vague claims, missing proof, and trust gaps.\",\n bias: \"Prove it or lose it. I've been burned before.\",\n focus: [\n \"Unsubstantiated claims\",\n \"Missing social proof\",\n \"Credibility gaps\",\n \"Trust signal weaknesses\",\n \"Specificity vs vagueness\",\n ],\n requiredTier: \"tier_rookie\",\n },\n {\n id: \"CompetitorStrategist\",\n name: \"The Competitor's Strategist\",\n emoji: \"🕵️\",\n squad: \"fortress\" as const,\n description:\n \"Thinks like your rival — finds how they'd attack your positioning.\",\n bias: \"I see your flank. Trust me, they see it too.\",\n focus: [\n \"Competitive vulnerabilities\",\n \"Positioning gaps rivals will exploit\",\n \"Defensive messaging weaknesses\",\n \"Market position defensibility\",\n \"Counter-positioning risks\",\n ],\n requiredTier: \"tier_starter\",\n },\n {\n id: \"RiskAuditor\",\n name: \"The Risk Auditor\",\n emoji: \"⚠️\",\n squad: \"fortress\" as const,\n description:\n \"Spots compliance gaps, legal landmines, and reputation risks.\",\n bias: \"What can go wrong, will go wrong. Let's find it first.\",\n focus: [\n \"Overpromise and underdeliver risks\",\n \"Compliance and regulatory flags\",\n \"Reputation vulnerability points\",\n \"Crisis scenario triggers\",\n \"Legal exposure in claims\",\n ],\n requiredTier: \"tier_starter\",\n },\n {\n id: \"ChurnProphet\",\n name: \"The Churn Prophet\",\n emoji: \"🔮\",\n squad: \"fortress\" as const,\n description:\n \"Predicts retention risks, expectation mismatches, and buyer's remorse triggers.\",\n bias: \"Winning the deal means nothing if you lose the client in 90 days.\",\n focus: [\n \"Expectation vs delivery gaps\",\n \"Onboarding friction signals\",\n \"Long-term value clarity\",\n \"Buyer's remorse triggers\",\n \"Retention risk factors\",\n ],\n requiredTier: \"tier_starter\",\n },\n] as const;\n\n/** Combined lens catalog */\nexport const ALL_LENSES = [...OFFENSIVE_LENSES, ...DEFENSIVE_LENSES] as const;\n\n// =============================================================================\n// VALIDATION CONSTRAINTS\n// =============================================================================\n\n/** Document upload constraints */\nexport const DOCUMENT_CONSTRAINTS = {\n /** Minimum word count for meaningful analysis */\n minWords: 50,\n /** Maximum word count to prevent abuse */\n maxWords: 50000,\n /** Minimum character count */\n minChars: 200,\n /** Maximum character count */\n maxChars: 250000,\n /** Maximum title length */\n maxTitleLength: 255,\n} as const;",[167],"2fd48fc0-d46c-11f0-b4b2-42dde27851f2","auth.ts","216abe0a-d46c-11f0-b028-42dde27851f2",14,["D",1765222157243],"/**\n * @fileoverview Authentication service for The Playbook.\n * Handles user registration, session management, and access control.\n *\n * @author The Playbook Team\n * @version 3.0.0\n */\n\nimport { deleteCookie, getCookie, setCookie } from \"npm:hono@4.4.12/cookie\";\nimport type { Context } from \"npm:hono@4.4.12\";\nimport {\n SESSION_COOKIE_NAME,\n SESSION_DURATION_SECONDS,\n TIERS,\n} from \"./config.ts\";\nimport {\n createSession,\n createUser,\n deleteSession,\n findUserByEmail,\n findUserById,\n validateSession,\n} from \"./database.ts\";\nimport type { Lens, TierId, User } from \"./types.ts\";\n\n// =============================================================================\n// SESSION MANAGEMENT\n// =============================================================================\n\n/**\n * Cookie options for session storage.\n */\nconst SESSION_COOKIE_OPTIONS = {\n httpOnly: true,\n secure: true,\n sameSite: \"Lax\" as const,\n maxAge: SESSION_DURATION_SECONDS,\n path: \"/\",\n};\n\n/**\n * Extracts the session ID from the request cookies.\n *\n * @param c - Hono context\n * @returns Session ID or undefined\n */\nexport function getSessionId(c: Context): string | undefined {\n return getCookie(c, SESSION_COOKIE_NAME);\n}\n\n/**\n * Sets the session cookie on the response.\n *\n * @param c - Hono context\n * @param sessionId - The session ID to set\n */\nexport function setSessionCookie(c: Context, sessionId: string): void {\n setCookie(c, SESSION_COOKIE_NAME, sessionId, SESSION_COOKIE_OPTIONS);\n}\n\n/**\n * Clears the session cookie from the response.\n *\n * @param c - Hono context\n */\nexport function clearSessionCookie(c: Context): void {\n deleteCookie(c, SESSION_COOKIE_NAME, { path: \"/\" });\n}\n\n// =============================================================================\n// AUTHENTICATION FUNCTIONS\n// =============================================================================\n\n/**\n * Authenticates a user by email, creating an account if needed.\n * Sets the session cookie on the response.\n *\n * @param c - Hono context\n * @param email - User's email address\n * @param name - Optional display name for new users\n * @returns The authenticated user\n */\nexport async function authenticateByEmail(\n c: Context,\n email: string,\n name?: string,\n): Promise {\n // Normalize email\n const normalizedEmail = email.toLowerCase().trim();\n\n // Find or create user\n let user = await findUserByEmail(normalizedEmail);\n\n if (!user) {\n user = await createUser(normalizedEmail, name);\n }\n\n // Create session\n const sessionId = await createSession({\n userId: user.id,\n userAgent: c.req.header(\"User-Agent\"),\n ipAddress: c.req.header(\"X-Forwarded-For\") || c.req.header(\"X-Real-IP\"),\n });\n\n // Set cookie\n setSessionCookie(c, sessionId);\n\n return user;\n}\n\n/**\n * Validates the current session from cookies.\n *\n * @param c - Hono context\n * @returns The authenticated user or null\n */\nexport async function getCurrentUser(c: Context): Promise {\n const sessionId = getSessionId(c);\n\n if (!sessionId) {\n return null;\n }\n\n const user = await validateSession(sessionId);\n\n if (!user) {\n // Invalid session, clear the cookie\n clearSessionCookie(c);\n return null;\n }\n\n return user;\n}\n\n/**\n * Logs out the current user by destroying their session.\n *\n * @param c - Hono context\n * @returns true if logged out, false if no session existed\n */\nexport async function logout(c: Context): Promise {\n const sessionId = getSessionId(c);\n\n if (!sessionId) {\n return false;\n }\n\n await deleteSession(sessionId);\n clearSessionCookie(c);\n\n return true;\n}\n\n/**\n * Refreshes the user data from the database.\n * Useful after tier upgrades or profile updates.\n *\n * @param userId - The user's ID\n * @returns Updated user or null\n */\nexport async function refreshUser(userId: string): Promise {\n return findUserById(userId);\n}\n\n// =============================================================================\n// AUTHORIZATION HELPERS\n// =============================================================================\n\n/**\n * Gets the tier configuration for a user.\n *\n * @param user - The user object\n * @returns The tier configuration\n */\nexport function getUserTier(user: User): typeof TIERS[keyof typeof TIERS] {\n const tierKey = Object.keys(TIERS).find(\n (key) => TIERS[key as keyof typeof TIERS].id === user.tier,\n ) as keyof typeof TIERS | undefined;\n\n return tierKey ? TIERS[tierKey] : TIERS.ROOKIE;\n}\n\n/**\n * Checks if a user has access to a specific lens.\n *\n * @param user - The user object\n * @param lens - The lens to check\n * @returns true if user can access the lens\n */\nexport function canAccessLens(user: User, lens: Lens): boolean {\n const tier = getUserTier(user);\n const limits = tier.limits;\n\n if (lens.squad === \"phoenix\") {\n if (limits.offensiveLenses === \"ALL\") {\n return true;\n }\n return (limits.offensiveLenses as string[]).includes(lens.id);\n }\n\n if (lens.squad === \"fortress\") {\n if (limits.defensiveLenses === \"ALL\") {\n return true;\n }\n return (limits.defensiveLenses as string[]).includes(lens.id);\n }\n\n return false;\n}\n\n/**\n * Checks if a user can access Phoenix Fortress combined analysis.\n *\n * @param user - The user object\n * @returns true if user can access combined analysis\n */\nexport function canAccessPhoenixFortress(user: User): boolean {\n const tier = getUserTier(user);\n return tier.limits.phoenixFortress;\n}\n\n/**\n * Checks if a user can upload more documents this month.\n *\n * @param user - The user object\n * @param currentCount - Current document count this month\n * @returns true if user can upload more\n */\nexport function canUploadDocument(user: User, currentCount: number): boolean {\n const tier = getUserTier(user);\n return currentCount < tier.limits.docsPerMonth;\n}\n\n/**\n * Gets the remaining document uploads for a user this month.\n *\n * @param user - The user object\n * @param currentCount - Current document count this month\n * @returns Number of remaining uploads\n */\nexport function getRemainingUploads(user: User, currentCount: number): number {\n const tier = getUserTier(user);\n return Math.max(0, tier.limits.docsPerMonth - currentCount);\n}\n\n// =============================================================================\n// MIDDLEWARE FACTORY\n// =============================================================================\n\n/**\n * Creates a Hono middleware that requires authentication.\n * Sets user on context if authenticated, returns 401 otherwise.\n *\n * @returns Hono middleware function\n */\nexport function requireAuth() {\n return async (c: Context, next: () => Promise) => {\n const user = await getCurrentUser(c);\n\n if (!user) {\n return c.json(\n {\n error: \"Authentication required\",\n code: \"UNAUTHORIZED\",\n redirect: \"/login\",\n },\n 401,\n );\n }\n\n // Attach user to context for downstream handlers\n c.set(\"user\", user);\n\n await next();\n };\n}\n\n/**\n * Creates a Hono middleware that requires a minimum tier.\n * Must be used after requireAuth().\n *\n * @param minimumTier - The minimum tier required\n * @returns Hono middleware function\n */\nexport function requireTier(minimumTier: TierId) {\n const tierOrder: TierId[] = [\"tier_rookie\", \"tier_starter\", \"tier_mvp\"];\n const minimumIndex = tierOrder.indexOf(minimumTier);\n\n return async (c: Context, next: () => Promise) => {\n const user = c.get(\"user\") as User;\n\n if (!user) {\n return c.json({ error: \"Authentication required\" }, 401);\n }\n\n const userTierIndex = tierOrder.indexOf(user.tier);\n\n if (userTierIndex < minimumIndex) {\n return c.json(\n {\n error: `This feature requires ${\n minimumTier.replace(\"tier_\", \"\").toUpperCase()\n } tier or higher`,\n code: \"UPGRADE_REQUIRED\",\n currentTier: user.tier,\n requiredTier: minimumTier,\n },\n 403,\n );\n }\n\n await next();\n };\n}\n\n/**\n * Optional authentication middleware.\n * Sets user on context if authenticated, but doesn't block if not.\n *\n * @returns Hono middleware function\n */\nexport function optionalAuth() {\n return async (c: Context, next: () => Promise) => {\n const user = await getCurrentUser(c);\n\n if (user) {\n c.set(\"user\", user);\n }\n\n await next();\n };\n}",[174],"pulls","branches","forks","envVars",{"_187":62,"_189":62},"connections",{"_187":62,"_188":62},"count","unfilledCount","emptyCount",{"_42":173,"_32":174,"_30":175,"_135":-5,"_40":41,"_39":176,"_137":58,"_37":216,"_13":156,"_33":34,"_35":178,"_23":24,"_141":-5,"_198":217,"_26":218},{"_42":166,"_32":167,"_30":168,"_135":-5,"_40":41,"_39":169,"_137":58,"_37":213,"_13":156,"_33":34,"_35":171,"_23":24,"_141":-5,"_198":214,"_26":215},{"_42":159,"_32":160,"_30":161,"_135":-5,"_40":41,"_39":162,"_137":58,"_37":210,"_13":156,"_33":34,"_35":164,"_23":24,"_141":-5,"_198":211,"_26":212},{"_42":151,"_32":152,"_30":153,"_135":-5,"_40":41,"_39":154,"_137":58,"_37":207,"_13":156,"_33":34,"_35":157,"_23":24,"_141":-5,"_198":208,"_26":209},{"_42":146,"_32":147,"_30":56,"_135":-5,"_40":41,"_39":148,"_137":24,"_37":204,"_13":62,"_33":34,"_35":36,"_23":24,"_141":-5,"_198":205,"_26":206},{"_42":143,"_32":27,"_30":31,"_135":-5,"_40":41,"_39":14,"_137":24,"_37":201,"_13":62,"_33":34,"_35":36,"_23":24,"_141":-5,"_198":202,"_26":203},{"_42":132,"_32":133,"_30":134,"_135":-5,"_40":41,"_39":136,"_137":58,"_37":197,"_13":139,"_33":34,"_35":140,"_23":24,"_141":-5,"_198":199,"_26":200},["D",1765222016405],"children",[],[133],["D",1765222281910],[],[27],["D",1765218851823],[],[147],["D",1765222261751],[],[152],["D",1765222104931],[],[160],["D",1765219017427],[],[167],["D",1765222157243],[],[174],["D",1765218851812],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":24},{"_13":85,"_32":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"ctx",{"_78":-5,"_122":256,"_257":258,"_259":260,"_261":24,"_262":24,"_263":24,"_264":58,"_265":-5,"_266":-7,"_267":-7,"_268":62,"_269":24,"_270":24,"_271":-5,"_272":24,"_273":24,"_274":24,"_275":-5},"ENV",{"_227":228,"_229":230,"_231":86,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v18