Add Support for DDL 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 DDL questions. DDL is an acronym for data manipulation language. DDL encompasses CREATE, DROP, ALTER, TRUNCATE statements. 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 DDL 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 DDL 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 DDL question type -
add support for the --help
flag (calling--help
on the DDL 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 ISIS uses) during development!