Overview
Expand the SQLGame with support for Insert queries. Add explanations and interactive components for Insert statements, similar to the Select query section.
- Add a new entry in the main menu for Insert queries.
- Include Dutch explanations on how to write Insert statements, with interactive datatable exercises.
- Use a separate namespace for Insert-related viewmodels and views, mirroring the Select structure.
- Insert viewmodels should inherit from BaseExplanationViewmodel.
- Provide exercises to test user understanding of Insert queries.
Additionally, add a menu option to reset the database:
- New menu item to reset the database to defaults.
- Show a confirmation dialog before resetting.
- Reset should undo and redo all migrations to fully recreate the database.
Objectives
- Implement Insert query support (viewmodels, views, menu entry)
- Create Dutch language Insert query explanations
- Add datatable interactions and exercises
- Implement database reset feature with confirmation
- Ensure all new Insert code is in a dedicated namespace
Acceptance Criteria
- Users can access and interact with Insert query exercises from the main menu
- Dutch explanations and exercises for Insert queries are present
- Database can be reset via the new menu item and confirmation dialog
- All Insert-related code is organized in a new namespace and follows the style of Select query components
Additional Notes
- Ensure safe handling of the database reset feature
- Maintain consistency with the Select query user experience
Overview
Expand the SQLGame with support for Insert queries. Add explanations and interactive components for Insert statements, similar to the Select query section.
Additionally, add a menu option to reset the database:
Objectives
Acceptance Criteria
Additional Notes