RWTH Aachen Computer Science i5/dbis assets for Lecture Datenbanken und Informationssysteme
Project description
DBIS SQL Exercise Generator
Installation
Install via pip:
# Not yet available on PyPI
pip install dbis-sql-exercise-generator
Most notably, following required packages are also installed:
Usage
from rc_exercise_generator import generate_exercise
# set the solution as SQLite query (string)
solution_sql_query = "SELECT a, c FROM R;"
from excmanager.Task import Exercise, Task, SubTask
exercise1 = Exercise(1)
task1 = Task(exercise1, "1.1")
subtask1 = SubTask(task1, "a", points=2)
# task description
description = "Select the attributes a and c from the relation R."
generated_cells = generate_exercise(
subtask1,
description,
solution_sql_query,
correct_attributes_score_perc=0.1,
)
# generated_cells is a dictionary of cells, which can be used to generate a Jupyter Notebook
# format:
# filename (str) -> cell content (str)
:warning: Guidelines
In order to directly use the generated cells in an exercise Jupyter notebook, one should follow the following guidelines:
- tasks should be named
task1
,task2
, ... - The SQLite Connection has to be made beforehand. This connection should be stored in the variable
sql_con
.
View the templates and this test for more information on what cells are generated and how one can incorporate them into an exercise Jupyter notebook.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for dbis-sql-exercise-generator-0.0.1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 348f013693055a2fed3cb8f2adf8c25985dca94409b6e9e1e6c2ed03cd6ade3a |
|
MD5 | 8cbffc4403ab80481d43876e77b51191 |
|
BLAKE2b-256 | b12849d4a3b1ee8f24815bec5b8d47518452de2788c938978d0b5c0d66a20f57 |
Close
Hashes for dbis_sql_exercise_generator-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 711d5347652f33614ebb3bb2905bfe74daf71f855708ad5dfdf68f8b7811de63 |
|
MD5 | b0712152e9b5f4fffb95d947f44522f7 |
|
BLAKE2b-256 | 0fd2360edff3ad67c5cbfbf2f65b0e81eb4a7f0f1a7bb0751b94eabe8775d41b |