Add Support for DML Questions
Description
To cover all 3 types of graded exercises that we offer during ISDA (DML/DDL, DQL, Python(Streaming)) with moodle-tools, that is to make it possible to create YAML questions for all three types and to use moodle-tools to convert these YAML questions to moodle-xml that we can simply upload to ISIS, we need add support for DML questions. DML is an acronym for data manipulation language. In contrast to the data definition language (DDL) that is used to define tables (roughly speaking), DML is used to manipulate (insert, delete, update) existing tables. For references, you can check last years DDL/DML quiz on ISIS. Also, you can check the 'klausurfragen' repo and navigate to 'sql-ddl' and check the files.
Todo
-
design the YAML format for DML questions (add support for all questions that we used last year (2023) and talk to @rudip7, @lennart.behme, and @dusella.g on the design) -
add the DML question type to moodle-tools to its own file (should be done after, and following the design of the refactoring in #14 (closed)) -
add tests for the DML question type -
add support for the --help
flag (calling--help
on the DML question type should give you instructions on how to use it) -
add documentation (doc strings) to your code (issue #13 (closed) makes it so that doc strings are converted to documentation) -
make sure to use DuckDB (same version that is used on ISIS) during development!