vital2 / Vital-development

MIT License
18 stars 11 forks source link

Create SQL scripts to get course statistics #39

Closed reg1reg1 closed 4 years ago

reg1reg1 commented 4 years ago

Functional Requirements

@treddington sent forth these requirements: 1) It takes a course ID and create a report on the number of students that were enrolled plus additional features.

2) Draft a second script that takes a course ID and clean out the following tables: vital_course, vital_local_network_mac_addresses, vital_network_configuration, vital_registered_course, vital_user_bridge, vital_user_network_configuration, vital_virtual_machine. In addition it a also removes bridges and IPtabes rules.

Technical Requirements

1) This will involve a likely code addition in the django management commands. It may involve the addition of more than 1 script. 2) The IPtables part needs to be a bash script. 3) It can be tried out on development before moving onto production.