Function checkDatabaseIntegrity

apps/desktop/main/database/migrations.ts:51–66

(db: DatabaseAdapter)

)

function checkDatabaseIntegrity(db: DatabaseAdapter): { valid: boolean; error?: string } {
  try {
    const tables = db.prepare("SELECT name FROM sqlite_master WHERE type='table' AND name='meta'").all() as Array<{
      name: string
    }>
    if (tables.length === 0) {
      return { valid: false, error: t('database.integrityError') }
    }
    return { valid: true }
  } catch (error) {
    return {
      valid: false,
      error: t('database.checkFailed', { error: error instanceof Error ? error.message : String(error) }),
    }
  }
}

/**
 * Execute database migrations.