[{"_1":2,"_173":-5,"_174":-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","77fda040d260e43e66e3017d68686b51ac04eda6","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,"_147":148,"_170":171,"_172":-5},"handle","spooky","name","winn","path","backend/database/queries.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":-5,"_113":20,"_114":-5,"_115":116,"_14":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":127,"_130":131,"_133":134,"_146":20},"id","569f9fb4-6df1-11f0-900f-0224a6c84d84","createdAt",["D",1753954375629],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","d9951e10-16dc-11f0-9d61-bf534f47ce53","pinnedFileId","pinPreview","screenshotVersion","likeCount",1,"a87ae3da-e311-4bfb-919e-aa8beb34d11f","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_128":129},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydmFPZkZqOVNkRDN1cTJPUEZJZGtDUHpkNGYifQ","org",{"_93":94,"_132":129},"avatar","branch",{"_135":136,"_95":43,"_101":137,"_138":102,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":96,"_145":94},"version",24,"569ff86a-6df1-11f0-900f-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":149,"_95":150,"_151":152,"_153":154,"_155":137,"_156":157,"_158":159,"_103":160,"_135":32,"_161":162,"_163":164,"_165":20,"_166":-5,"_97":167},"b2dbb9e8-6df1-11f0-8579-0224a6c84d84","queries.ts","fileId","b2dbbac4-6df1-11f0-8579-0224a6c84d84","parentId","da990314-77d9-4b09-965b-98a4b476cd25","branchId","branchVersion",4,"latest",true,["D",1753954530371],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { VineyardBlock, WineBlend, BlendComponent, ChemicalAnalysis, UploadedData } from \"../../shared/types.ts\";\n\n// Vineyard Block Queries\nexport async function getAllVineyardBlocks(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM vineyard_blocks ORDER BY name\");\n return result.rows as VineyardBlock[];\n}\n\nexport async function getVineyardBlockById(id: string): Promise {\n const result = await sqlite.execute(\"SELECT * FROM vineyard_blocks WHERE id = ?\", [id]);\n return result.rows[0] as VineyardBlock || null;\n}\n\nexport async function getVineyardBlocksByIds(ids: string[]): Promise {\n if (ids.length === 0) return [];\n const placeholders = ids.map(() => '?').join(',');\n const result = await sqlite.execute(\n `SELECT * FROM vineyard_blocks WHERE id IN (${placeholders})`,\n ids\n );\n return result.rows as VineyardBlock[];\n}\n\nexport async function createVineyardBlock(block: Omit): Promise {\n await sqlite.execute(`\n INSERT INTO vineyard_blocks \n (id, name, varietal, vintage, alcohol, ph, acidity, tannins, sugar, notes, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, datetime('now'))\n `, [\n block.id, block.name, block.varietal, block.vintage,\n block.alcohol, block.ph, block.acidity, block.tannins,\n block.sugar, block.notes || null\n ]);\n}\n\n// Wine Blend Queries\nexport async function getAllWineBlends(): Promise {\n const blendsResult = await sqlite.execute(`\n SELECT * FROM wine_blends ORDER BY created_at DESC\n `);\n \n const blends: WineBlend[] = [];\n \n for (const row of blendsResult.rows) {\n const componentsResult = await sqlite.execute(`\n SELECT * FROM blend_components WHERE blend_id = ?\n `, [row.id]);\n \n const blend: WineBlend = {\n id: row.id,\n name: row.name,\n target_style: row.target_style,\n predicted_sensory: JSON.parse(row.predicted_sensory),\n market_analysis: JSON.parse(row.market_analysis),\n created_at: row.created_at,\n winemaker_notes: row.winemaker_notes,\n actual_results: row.actual_results ? JSON.parse(row.actual_results) : undefined,\n components: componentsResult.rows as BlendComponent[]\n };\n \n blends.push(blend);\n }\n \n return blends;\n}\n\nexport async function getWineBlendById(id: string): Promise {\n const blendResult = await sqlite.execute(\"SELECT * FROM wine_blends WHERE id = ?\", [id]);\n if (blendResult.rows.length === 0) return null;\n \n const row = blendResult.rows[0];\n const componentsResult = await sqlite.execute(`\n SELECT * FROM blend_components WHERE blend_id = ?\n `, [id]);\n \n return {\n id: row.id,\n name: row.name,\n target_style: row.target_style,\n predicted_sensory: JSON.parse(row.predicted_sensory),\n market_analysis: JSON.parse(row.market_analysis),\n created_at: row.created_at,\n winemaker_notes: row.winemaker_notes,\n actual_results: row.actual_results ? JSON.parse(row.actual_results) : undefined,\n components: componentsResult.rows as BlendComponent[]\n };\n}\n\nexport async function createWineBlend(blend: Omit): Promise {\n // Insert the main blend record\n await sqlite.execute(`\n INSERT INTO wine_blends \n (id, name, target_style, predicted_sensory, market_analysis, created_at, winemaker_notes, actual_results)\n VALUES (?, ?, ?, ?, ?, datetime('now'), ?, ?)\n `, [\n blend.id,\n blend.name,\n blend.target_style,\n JSON.stringify(blend.predicted_sensory),\n JSON.stringify(blend.market_analysis),\n blend.winemaker_notes || null,\n blend.actual_results ? JSON.stringify(blend.actual_results) : null\n ]);\n \n // Insert blend components\n for (const component of blend.components) {\n await sqlite.execute(`\n INSERT INTO blend_components (blend_id, block_id, block_name, varietal, percentage)\n VALUES (?, ?, ?, ?, ?)\n `, [blend.id, component.block_id, component.block_name, component.varietal, component.percentage]);\n }\n}\n\nexport async function updateWineBlendResults(\n id: string, \n results: { sensory_feedback: string; market_performance: number; would_make_again: boolean }\n): Promise {\n await sqlite.execute(`\n UPDATE wine_blends \n SET actual_results = ?\n WHERE id = ?\n `, [JSON.stringify(results), id]);\n}\n\n// Chemical Analysis Queries\nexport async function getChemicalAnalysesByBlockId(blockId: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM chemical_analyses WHERE block_id = ? ORDER BY analysis_date DESC\n `, [blockId]);\n return result.rows as ChemicalAnalysis[];\n}\n\nexport async function createChemicalAnalysis(analysis: Omit): Promise {\n await sqlite.execute(`\n INSERT INTO chemical_analyses \n (block_id, analysis_date, alcohol, ph, total_acidity, volatile_acidity, \n tannins, residual_sugar, sulfites, color_intensity, phenolic_compounds, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, datetime('now'))\n `, [\n analysis.block_id, analysis.analysis_date, analysis.alcohol, analysis.ph,\n analysis.total_acidity, analysis.volatile_acidity, analysis.tannins,\n analysis.residual_sugar, analysis.sulfites, analysis.color_intensity || null,\n analysis.phenolic_compounds || null\n ]);\n}\n\n// Uploaded Data Queries\nexport async function getAllUploadedData(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM uploaded_data ORDER BY uploaded_at DESC\");\n return result.rows as UploadedData[];\n}\n\nexport async function createUploadedDataRecord(data: Omit): Promise {\n await sqlite.execute(`\n INSERT INTO uploaded_data (id, filename, type, uploaded_at, processed, records_count)\n VALUES (?, ?, ?, datetime('now'), ?, ?)\n `, [data.id, data.filename, data.type, data.processed, data.records_count || null]);\n}\n\nexport async function markDataAsProcessed(id: string, recordsCount: number): Promise {\n await sqlite.execute(`\n UPDATE uploaded_data \n SET processed = TRUE, records_count = ?\n WHERE id = ?\n `, [recordsCount, id]);\n}","deleted","label",[168,169,150],"backend","database","permalink","https://www.val.town/x/spooky/winn/code/backend/database/queries.ts","extension","actionData","errors"]