stats_participation

Creates, updates, deletes, gets or lists a stats_participation resource.

Overview

Name	stats_participation
Type	Resource
Id	github.repos.stats_participation

Fields

The following fields are returned by SELECT queries:

get_participation_stats

The array order is oldest week (index 0) to most recent week.

Name	Datatype	Description
all	array
owner	array

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_participation_stats	select	owner, repo		Returns the total commit counts for the owner and total commit counts in all. all is everyone combined, including the owner in the last 52 weeks. If you'd like to get the commit counts for non-owners, you can subtract owner from all. The array order is oldest week (index 0) to most recent week. The most recent week is seven days ago at UTC midnight to today at UTC midnight.

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
owner	string	The account owner of the repository. The name is not case sensitive.
repo	string	The name of the repository without the .git extension. The name is not case sensitive.

SELECT examples

get_participation_stats

Returns the total commit counts for the owner and total commit counts in all. all is everyone combined, including the owner in the last 52 weeks. If you'd like to get the commit counts for non-owners, you can subtract owner from all.

The array order is oldest week (index 0) to most recent week.

The most recent week is seven days ago at UTC midnight to today at UTC midnight.

SELECT
all,
owner
FROM github.repos.stats_participation
WHERE owner = '{{ owner }}' -- required
AND repo = '{{ repo }}' -- required
;