Function migrate

internal/appstate/store.go:65–77

migrate applies idempotent, additive schema changes to databases created by older versions. ADD COLUMN on an existing column returns a "duplicate column" error which we treat as already-applied.

(ctx context.Context, db *sql.DB)

// older versions. ADD COLUMN on an existing column returns a "duplicate column"
// error which we treat as already-applied.
func migrate(ctx context.Context, db *sql.DB) error {
	for _, stmt := range []string{
		`ALTER TABLE providers ADD COLUMN api_key TEXT NOT NULL DEFAULT ''`,
	} {
		if _, err := db.ExecContext(ctx, stmt); err != nil {
			if strings.Contains(err.Error(), "duplicate column name") {
				continue
			}
			return err
		}
	}
	return nil
}

// ImportProvidersJSON is a no-op. Providers were historically migrated from a
// legacy providers.json file into the SQLite store. That migration is complete