{"record":{"id":"9c6201d85f03dc43","repo":"diegosouzapw/OmniRoute","slug":"no-sqlite-driver-available-for-assessment-migratio","errorCode":null,"errorMessage":"No SQLite driver available for assessment migration","messagePattern":"No SQLite driver available for assessment migration","errorType":"exception","errorClass":null,"httpStatus":null,"severity":"error","filePath":"src/domain/assessment/migration.ts","lineNumber":92,"sourceCode":"-- Indexes for common queries\nCREATE INDEX IF NOT EXISTS idx_model_assessments_status ON model_assessments(status);\nCREATE INDEX IF NOT EXISTS idx_model_assessments_provider ON model_assessments(provider_id);\nCREATE INDEX IF NOT EXISTS idx_model_assessments_tier ON model_assessments(tier);\nCREATE INDEX IF NOT EXISTS idx_model_assessments_last_tested ON model_assessments(last_tested);\nCREATE INDEX IF NOT EXISTS idx_combo_health_health_score ON combo_health(health_score);\nCREATE INDEX IF NOT EXISTS idx_heal_actions_combo_id ON heal_actions(combo_id);\nCREATE INDEX IF NOT EXISTS idx_heal_actions_timestamp ON heal_actions(timestamp);\n`;\n\nexport async function runAssessmentMigration(dbPath: string): Promise<void> {\n  const dir = dirname(dbPath);\n  if (!existsSync(dir)) {\n    mkdirSync(dir, { recursive: true });\n  }\n\n  const { tryOpenSync } = await import(\"@/lib/db/adapters/driverFactory\");\n  const db = tryOpenSync(dbPath);\n  if (!db) throw new Error(\"No SQLite driver available for assessment migration\");\n\n  db.pragma(\"journal_mode = WAL\");\n  db.pragma(\"foreign_keys = ON\");\n\n  db.exec(MIGRATION_SQL);\n\n  const versionRow = db\n    .prepare(\"SELECT COUNT(*) as count FROM _omniroute_migrations WHERE name = ?\")\n    .get(\"assessment_engine\") as { count: number };\n  if (versionRow.count === 0) {\n    db.prepare(\n      \"INSERT INTO _omniroute_migrations (name, applied_at) VALUES (?, datetime('now'))\"\n    ).run(\"assessment_engine\");\n  }\n\n  db.close();\n}\n","sourceCodeStart":74,"sourceCodeEnd":110,"githubUrl":"https://github.com/diegosouzapw/OmniRoute/blob/a179ffed5bb2e0b883b9ae7214ce8717b2a94c4d/src/domain/assessment/migration.ts#L74-L110","documentation":"Error \"No SQLite driver available for assessment migration\" thrown in diegosouzapw/OmniRoute.","triggerScenarios":"Thrown at src/domain/assessment/migration.ts:92 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":[],"exampleFix":null,"handlingStrategy":null,"validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"a179ffed5bb2e0b883b9ae7214ce8717b2a94c4d","analyzedAt":"2026-08-25T18:35:09.898Z","schemaVersion":2},"datasetVersion":"2026-08-25T21:54:21.419Z"}