Queries
course_instance_active_enrollments.sql
|
Course instances that are active within a given date range. |
course_instance_compute_time.sql
|
Course instances compute time within a given date range. |
courses_with_chunks.sql
|
Finds all courses that have chunks generated. |
courses_without_chunks.sql
|
Finds all courses that do NOT have chunks yet generated. |
current_active_student_exams.sql
|
Student exams that are being actively worked on at the moment. |
current_activity_by_assessment.sql
|
Assessments that have had submissions within a recent time interval. |
current_activity_by_course_instance.sql
|
Course instances that have had submissions within a recent time interval. |
db_query_cancel.sql
|
Cancel a running query (graceful kill). |
db_query_terminate.sql
|
Terminate a running query (hard kill). |
db_running_queries.sql
|
Queries currently running in the DB. |
find_courses_by_user.sql
|
Finds users and their courses. |
generate_and_enroll_users.sql
|
Generate random users and enroll them in a course instance |
generate_assessment_instances.sql
|
Simulates all students enrolled in a course starting an assessment (groupwork not supported) |
generate_assessment_instances_group.sql
|
Starts assessment instances for all groups in an assessment (groups must have been created) |
instructors_by_institution.sql
|
Return a list of instructors by institution |
select_or_insert_user.sql
|
Select or insert a user from the users table. |
upcoming_exams.sql
|
Exams currently running or about to start, with many students. |
workspace_hosts.sql
|
Select workspace hosts (currently active or recently terminated). |
workspace_hosts_update_state.sql
|
Update the state of a workspace host. |
workspaces.sql
|
Select currently active workspaces, grouped by course and assessment. |