[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_200":201,"_202":203},"routes/_app.x.$handle.$name",{"_97":96,"_32":45,"_105":87,"_27":36,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":25,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",14,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","auth.ts","latestPath","fileId","216abe0a-d46c-11f0-b028-42dde27851f2","name","fileType","script","content","","/**\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}","createdAt",["D",1765222157243],"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",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"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",{"_43":44,"_32":45,"_38":196,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":197,"_81":198,"_83":199,"_85":25},"tree",[175,176,177,178,179],"files",[175,176,177,178,179],"counts",{"_165":63,"_166":144,"_167":144,"_168":169,"_170":171},"contents",[126,127,128,129,130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":162,"_32":28,"_30":31,"_134":-5,"_41":42,"_40":14,"_136":59,"_38":163,"_13":152,"_33":34,"_35":37,"_24":25,"_140":-5,"_27":164},{"_43":155,"_32":156,"_30":157,"_134":-5,"_41":42,"_40":158,"_136":59,"_38":159,"_13":152,"_33":34,"_35":160,"_24":25,"_140":-5,"_27":161},{"_43":147,"_32":148,"_30":149,"_134":-5,"_41":42,"_40":150,"_136":59,"_38":151,"_13":152,"_33":34,"_35":153,"_24":25,"_140":-5,"_27":154},{"_43":142,"_32":143,"_30":57,"_134":-5,"_41":42,"_40":144,"_136":25,"_38":145,"_13":63,"_33":34,"_35":36,"_24":25,"_140":-5,"_27":146},{"_43":131,"_32":132,"_30":133,"_134":-5,"_41":42,"_40":135,"_136":59,"_38":137,"_13":138,"_33":34,"_35":139,"_24":25,"_140":-5,"_27":141},"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",[132],"7da5a41c-d464-11f0-a05c-42dde27851f2","main.ts",1,["D",1765218851823],[143],"10a6dfc2-d46c-11f0-97f4-42dde27851f2","database.ts","f56798f0-d46b-11f0-a466-42dde27851f2",11,["D",1765222104931],2,"/**\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}",[148],"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;",[156],"2fd48fc0-d46c-11f0-b4b2-42dde27851f2",["D",1765222157243],[28],"pulls","branches","forks","envVars",{"_172":63,"_174":63},"connections",{"_172":63,"_173":63},"count","unfilledCount","emptyCount",{"_43":162,"_32":28,"_30":31,"_134":-5,"_41":42,"_40":14,"_136":59,"_38":193,"_13":152,"_33":34,"_35":37,"_24":25,"_140":-5,"_181":194,"_27":195},{"_43":155,"_32":156,"_30":157,"_134":-5,"_41":42,"_40":158,"_136":59,"_38":190,"_13":152,"_33":34,"_35":160,"_24":25,"_140":-5,"_181":191,"_27":192},{"_43":147,"_32":148,"_30":149,"_134":-5,"_41":42,"_40":150,"_136":59,"_38":187,"_13":152,"_33":34,"_35":153,"_24":25,"_140":-5,"_181":188,"_27":189},{"_43":142,"_32":143,"_30":57,"_134":-5,"_41":42,"_40":144,"_136":25,"_38":184,"_13":63,"_33":34,"_35":36,"_24":25,"_140":-5,"_181":185,"_27":186},{"_43":131,"_32":132,"_30":133,"_134":-5,"_41":42,"_40":135,"_136":59,"_38":180,"_13":138,"_33":34,"_35":139,"_24":25,"_140":-5,"_181":182,"_27":183},["D",1765222016405],"children",[],[132],["D",1765218851823],[],[143],["D",1765222104931],[],[148],["D",1765219017427],[],[156],["D",1765222157243],[],[28],["D",1765218851812],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_79":-5,"_123":233,"_234":235,"_236":237,"_238":25,"_239":25,"_240":25,"_241":59,"_242":-5,"_243":-7,"_244":-7,"_245":63,"_246":25,"_247":25,"_248":-5,"_249":25,"_250":25,"_251":25,"_252":-5},"ENV",{"_204":205,"_206":207,"_208":87,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232},"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 · v14