feat: add support for project migration with Phinx #566
Conversation
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Integrated a new migration system using the Phinx library and its dependencies. Added a `Bridge` class to handle project transfers and a new `/bridge` route in the main application. Updated `composer.json` and `composer.lock` to include required packages for database migration and configuration handling.
Introduce MySQL driver class to handle database connections and queries. Refactor Bridge class to manage source projects, including new methods for setting and retrieving source project data. Update routing logic in `index.php` and modify `docker-compose.yaml` port mapping.
Add support for a second database for mapping preparation and update database connection logic accordingly. Introduce `ApplicationBootstrapper` to centralize application initialization and streamline request handling. Modify HTTP endpoints to include additional functionalities and improve error handling.
Added `addPreparedProject` method to handle dynamic mapping of projects and introduced centralized input validation. Refactored database connection logic for reusability and enhanced error handling across the bridge layer.
Introduced support for manual migration mode (`mgr_manual`) and enhanced project page handling, along with relevant updates to the migration platform and core configuration. Added APIs to fetch project UUID, check page changes, and manage mappings, improving flexibility and traceability in the migration process.
Add `RequestHandler` classes for GET, POST, and DELETE, improving request handling modularity. Enhance migration logic by enabling manual migration labeling and expanding functionality for bulk operations. Refactor database interactions and improve project/page change checks for more granular control and reporting.
Introduce `phinx.php` to manage database migrations and seeds. The file specifies paths for migration and seed files and configures a production environment with MySQL settings.
Updated `ApplicationBootstrapper` to refine the migration flow logic and introduce restructuring for project data management. Added centralized logging initialization and enhanced error handling. Additionally, updated dependencies in `composer.lock` to include the latest versions of libraries for better compatibility and performance.
Relocated the `/health` endpoint logic to the primary application handler. This improves code organization by consolidating request handling in one place.
Refactored manual migration logic to use dynamic dataVersion settings, improving clarity and flexibility. Adjusted database environment configuration to load from `.env` files, and replaced hardcoded values with environment variables to enhance security. Fixed suffix handling for dimensions and improved error logging across multiple components.
Introduce '/app' and '/addTagManualMigration' endpoints in the API. Enhance `setLabelManualMigration` to accept an optional project ID. Add methods to handle manual migration tagging via database and refine related logic in BrizyAPI interactions.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
Integrated a new migration system using the Phinx library and its dependencies. Added a
Bridgeclass to handle project transfers and a new/bridgeroute in the main application. Updatedcomposer.jsonandcomposer.lockto include required packages for database migration and configuration handling.