-
Notifications
You must be signed in to change notification settings - Fork 2
Commands
This page is an overview of all commands that can be currently executed using the command line interface of the application.
Usage:
>>>exit
Ends program execution.
Usage:
>>>help
Prints a list of available commands
Usage:
>>>sql-update (sql statement)
Executes an update (e. g. UPDATE, DELETE,...) statement on the underlying SQLite database
Usage:
>>>add-admin (username) (password)
Adds a new admin login to the web interface.
Usage:
>>>remove-admin (username)
Removes the given admin from the database
Usage:
>>>get-level-ratio (level:i)
Prints the ratio in percent belonging to the given level:
| Level | Ratio |
|---|---|
| 1 | 45.0% |
| 2 | 30.0% |
| 3 | 25.0% |
Usage:
>>>list-rooms
Prints a list of rooms in the database
Usage:
>>>get-room-level (room)
Prints the minimum graduation level needed for the given room
Usage:
>>>set-room-level (room) (level)
Sets the minimum graduation level needed for the given room to (level)
Usage:
>>>add-room (room) (level)
Adds the given room to the database
Usage:
>>>remove-room (room)
Removes the given room from the database
Usage:
>>>list-classes
Prints a list of classes in the database
Usage:
>>>add-subject-to-class (subject) (class)
Adds the given subject to the given class
Usage:
>>>set-class-label (old label) (new label)
Renames the given class
Usage:
>>>set-class-grade (class) (grade:i)
Sets the grade of the class to grade
Usage:
>>>add-class (class label)
Adds a class with the given label if it does not yet exist. Leading zeros will be removed, and the letters are converted to lowercase.
Example:
-
"05A"->"5a"
Usage:
>>>remove-class (class)
Removes the given class from the database
Usage:
>>>list-school-years
Lists all school years in the database
Usage:
>>>get-current-school-year
Prints data to the current school year. The current school year is always the last school year, sorted by the school year label.
Example:
"2025/2026" > "2024/2025
Usage:
>>>get-current-week
Prints the current week count of the active school year.
Usage:
>>>set-current-week (week count)
Sets the current week count of the active school year to week count
Usage:
>>>inc-week
Increases the current week count of the active school year by one.
Usage:
>>>add-school-year (label) (week count)
Adds a new school year with the given label and week count to the database. (If it already exists, the week count is updated)
Usage:
>>>remove-school-year (school year)
Removes the given school year from the database
Usage:
>>>regenerate-user-password (user)
Generates a new password for user, changes the password of user to the generated password, and prints it afterwards.
Usage:
>>>generate-password [seed=0]
Generates a random seed using system time and seed (seed can be any string, or an integer inside of long bounds), and generates a new password from the generated seed.
Usage:
>>>change-user-password (user) (new password)
Changes user's password to new password.
Usage:
>>>list-subjects
Lists all subjects in the database.
Usage:
>>>add-subject (subject)
Adds the given subject to the database.
Usage:
>>>rename-subject (subject) : (new name)
Renames subject to new name.
Usage:
>>>remove-subject (subject)
Removes the given subject from the database.