Skip to content

Expand game with Insert queries, explanations, and database reset feature #17

Description

@ASPE-Summa

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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions