SQL
Last updated
Last updated
To create a new assignment in SQL, click into one of your courses, and then click Add assignment
.
Choose SQL
from the drop-down list of available backend languages and set the the rest of your assignment's parameters (deadline, etc.).
Once the assignment is created, a new folder will be created in the private GitHub
/GitLab
template repository for the course in which you are added this assignment. This folder will contain a standard SQL
project structure.
If you would like to add tests that are automatically run by AssignmentOS against each student's solution to your assessment, you can add these as test classes in the tests/
directory.
All unit tests use the Jest
testing framework.
All unit test file names must end with .spec.js
and all unit test files with file names ending with .hidden.spec.js
will not be visible to the student.
If you want to add files that your hidden unit tests use and hence are also not visible to the student, the names of these files must begin with hidden
, e.g., hiddenFoo.json
, hiddenFoo.csv
, hidden-foo.js
, etc.
The package.json
file should only be modified in order to add any third-party dependencies required for your solution. The jest
, babel
and sqlite3
versions should not be changed.
The assignment must be compatible with Node.js version 15.5.1
.
GitHub Action & GitLab CI/CD
AssignmentOS uses either GitHub Actions
or GitLab CI/CD
(depending on whether you use with GitHub or GitLab) to run automated unit tests.
We provide the following GitHub Action & GitLab CI/CD file for SQL assignments. Note that this file is added dynamically to the repo of each student taking your assignment, so please do not include it in your template repo. This file also cannot be changed.
Coming soon!