Queries
course_instance_active_enrollments
|
Course instances that are active within a given date range. |
course_instance_compute_time
|
Course instances compute time within a given date range. |
course_instances_usage
|
Course instances usage data. |
current_activity_by_assessment
|
Assessments that have had submissions within a recent time interval. |
current_activity_by_course_instance
|
Course instances that have had submissions within a recent time interval. |
db_query_cancel
|
Cancel a running query (graceful kill). |
db_query_terminate
|
Terminate a running query (hard kill). |
db_running_queries
|
Queries currently running in the DB. |
find_courses_by_user
|
Finds users and their courses. |
generate_and_enroll_users
|
Generate random users and enroll them in a course instance |
generate_assessment_instances
|
Simulates all students enrolled in a course starting an assessment. For group assessments, groups must have been created. |
generate_submissions
|
Creates a random submission for each assessment instance in an assessment. Assessment instances must already exist and be open. Submission is saved, but not graded. |
institutions_usage
|
Institutions usage data. |
instructors_by_institution
|
Return a list of instructors by institution |
lti13_roster_sync_readiness
|
Inventory active LTI 1.3 instances, institution identity prerequisites, and UIN backfill gaps before roster-sync rollout. |
select_or_insert_user
|
Select or insert a user from the users table. |
workspace_hosts_update_state
|
Update the state of a workspace host. |