Summary

This PR adds the ability to update existing database and cloud storage connections, complementing the existing create functionality. The implementation includes backend logic to handle partial updates (especially for sensitive fields like passwords/secrets) and frontend UI improvements to support edit mode.

Key Changes

Backend (flowfile_core)

• Database Connections: Added update_database_connection() function that updates connection details while allowing optional password updates (keeps existing password if not provided)
• Cloud Connections: Added update_cloud_connection() function with helper _update_cloud_secret() to handle selective secret field updates for AWS and Azure credentials
• API Routes: Added PUT endpoints for both /db_connection_lib and /cloud_connection to expose update functionality
• Imports: Added encrypt_secret import to support re-encrypting updated secrets

Frontend (flowfile_frontend)

• API Layer: Added updateDatabaseConnectionApi() and updateCloudStorageConnectionApi() functions to call the new backend endpoints
• Database Connection UI:
  • Disabled connection name field in edit mode (prevents renaming)
  • Made password field optional when editing with "Leave blank to keep existing" placeholder
  • Updated validation to allow empty password in edit mode
• Cloud Connection UI:
  • Disabled connection name field in edit mode
  • Updated secret field placeholders to indicate optional updates in edit mode
  • Modified validation logic to allow empty secret fields when editing
• View Components: Updated DatabaseView.vue and CloudConnectionView.vue to route submissions to create or update APIs based on edit mode, and pass isEditing prop to form components

Implementation Details

• Secret fields use a "keep existing if empty" pattern to avoid requiring users to re-enter sensitive credentials during updates
• Connection names are immutable (disabled in edit mode) to maintain referential integrity
• The backend validates that connections exist before attempting updates, returning 404 errors for missing connections
• All secret updates are properly encrypted using the existing encrypt_secret() function

https://claude.ai/code/session_01823mem4d6LxDCJAHuWkpFR