assignment_accepted_assignments

Creates, updates, deletes, gets or lists an assignment_accepted_assignments resource.

Overview

Name	assignment_accepted_assignments
Type	Resource
Id	github.classroom.assignment_accepted_assignments

Fields

The following fields are returned by SELECT queries:

list_accepted_assignments_for_an_assignment

Response

Name	Datatype	Description
id	integer	Unique identifier of the repository.
assignment	object	A GitHub Classroom assignment (title: Simple Classroom Assignment)
commit_count	integer	Count of student commits.
grade	string	Most recent grade. (example: 10/10)
passing	boolean	Whether a submission passed.
repository	object	A GitHub repository view for Classroom (title: Simple Classroom Repository)
students	array
submitted	boolean	Whether an accepted assignment has been submitted.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_accepted_assignments_for_an_assignment	select	assignment_id	page, per_page	Lists any assignment repositories that have been created by students accepting a GitHub Classroom assignment. Accepted assignments will only be returned if the current user is an administrator of the GitHub Classroom for the assignment.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
assignment_id	integer	The unique identifier of the classroom assignment.
page	integer	The page number of the results to fetch. For more information, see "Using pagination in the REST API."
per_page	integer	The number of results per page (max 100). For more information, see "Using pagination in the REST API."

SELECT examples

list_accepted_assignments_for_an_assignment

Lists any assignment repositories that have been created by students accepting a GitHub Classroom assignment. Accepted assignments will only be returned if the current user is an administrator of the GitHub Classroom for the assignment.

SELECT
id,
assignment,
commit_count,
grade,
passing,
repository,
students,
submitted
FROM github.classroom.assignment_accepted_assignments
WHERE assignment_id = '{{ assignment_id }}' -- required
AND page = '{{ page }}'
AND per_page = '{{ per_page }}'
;