Iteration 5 Plan - TAGCH/Workflow-Automation GitHub Wiki

Goal

Enhance data handling and relational structure by optimizing database operations, supporting MySQL, restructuring models, and improving user-to-workflow associations.

Milestone

Implement data looping for Excel imports, switch from SQLite to MySQL, restructure models to better support relational integrity, and establish user-workflow relationships.

Features

• Enable looping through data from Excel imports for dynamic data handling.
• Migrate database from SQLite to MySQL for enhanced scalability and performance.
• Restructure database models to optimize relations and data integrity, including workflows and imports.
• Link users to their workflows within the database to improve association and data tracking.

Acceptance Criteria

• Data looping for Excel imports functions correctly, allowing dynamic data processing for workflows.
• MySQL database setup is complete, with tables and data successfully migrated and accessible.
• Database model restructuring is finished, supporting optimized relational integrity between tables.
• User-to-workflow associations are established, ensuring each workflow is properly linked to its respective user.