[{"_1":2,"_175":-5,"_176":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","4e95bd6daa62c168df8a46377c79ffe4dc8381ed","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_149":150,"_171":172,"_173":174},"handle","dcm31","name","charBuildSuperapp","path","projects/ideaScore/database.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":113,"_114":115,"_116":117,"_118":32,"_14":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":129,"_132":133,"_135":136,"_148":20},"id","0e1a69b8-04c4-11f0-9e0a-569c3dd06744","createdAt",["D",1742390054517],"deletedAt","legacyEnvVars","privacy","unlisted","description","imageUrl","9319c175-2593-4f88-ba21-04f2ef7b1c28","pinnedFileId","d2cc7eea-04c4-11f0-bf57-569c3dd06744","pinPreview",true,"screenshotVersion",210,"likeCount","d663a026-6449-42f6-9156-1d4a2d64d38c","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_130":131},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ3SGtIMlhlMGwwT0JoSXZJckVVTXJuajN1YyJ9","org",{"_93":94,"_134":131,"_12":111},"avatar","branch",{"_137":138,"_95":43,"_101":139,"_140":102,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},"version",213,"0e1ab846-04c4-11f0-9e0a-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":151,"_95":152,"_153":154,"_155":156,"_157":139,"_158":159,"_160":115,"_103":161,"_137":162,"_163":149,"_164":165,"_166":20,"_167":-5,"_97":168},"f5e7a966-06ba-11f0-954e-569c3dd06744","database.ts","fileId","7444977a-04f3-11f0-ac0c-569c3dd06744","parentId","172a5c90-04c7-11f0-bc84-569c3dd06744","branchId","branchVersion",102,"latest",["D",1742606050758],1,"fileType","content","/**\n * Database utilities for IdeaScore\n * \n * This module provides database initialization and utility functions\n * for the IdeaScore application.\n */\n\n// Schema version - increment when making breaking changes\nconst SCHEMA_VERSION = 1;\n\ninterface IdeaData {\n title: string;\n description?: string;\n effortScore: number;\n payoffScore: number;\n}\n\ninterface IdeaRecord extends IdeaData {\n id: number;\n effort_score: number;\n payoff_score: number;\n created_at: string;\n updated_at: string;\n ratio: number;\n}\n\ninterface IdeaStats {\n total_ideas: number;\n avg_effort: number;\n avg_payoff: number;\n avg_ratio: number;\n}\n\ninterface QueryOptions {\n sortBy?: string;\n sortOrder?: string;\n limit?: number;\n offset?: number;\n}\n\n/**\n * Initialize the IdeaScore database schema\n * @param {Object} sqlite - The SQLite instance from the context\n * @returns {Promise}\n */\nexport async function initializeDatabase(sqlite: any): Promise {\n console.log(\"Initializing IdeaScore database...\");\n\n try {\n // Create ideas table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ideascore_ideas_v${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT,\n effort_score INTEGER NOT NULL CHECK(effort_score BETWEEN 1 AND 10),\n payoff_score INTEGER NOT NULL CHECK(payoff_score BETWEEN 1 AND 10),\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n user_email TEXT NOT NULL,\n is_deleted BOOLEAN DEFAULT 0\n )\n `);\n \n // Create index for user isolation\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_ideascore_ideas_user_email \n ON ideascore_ideas_v${SCHEMA_VERSION}(user_email)\n `);\n \n console.log(\"IdeaScore database initialized successfully\");\n } catch (error) {\n console.error(\"IdeaScore database initialization error:\", error);\n throw error;\n }\n}\n\n/**\n * Add a new idea to the database\n * @param {Object} sqlite - The SQLite instance from the context\n * @param {string} userEmail - The user's email address\n * @param {Object} idea - The idea object to add\n * @param {string} idea.title - The idea title\n * @param {string} idea.description - The idea description\n * @param {number} idea.effortScore - The effort score (1-10)\n * @param {number} idea.payoffScore - The payoff score (1-10)\n * @returns {Promise