Skip to main content

stats_punch_cards

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

Overview

Namestats_punch_cards
TypeResource
Idgithub.repos.stats_punch_cards

Fields

The following fields are returned by SELECT queries:

For example, [2, 14, 25] indicates that there were 25 total commits, during the 2:00pm hour on Tuesdays. All times are based on the time zone of individual commits.

NameDatatypeDescription

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_punch_card_statsselectowner, repoEach array contains the day number, hour number, and number of commits:

* 0-6: Sunday - Saturday
* 0-23: Hour of day
* Number of commits

For example, [2, 14, 25] indicates that there were 25 total commits, during the 2:00pm hour on Tuesdays. All times are based on the time zone of individual commits.

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.

NameDatatypeDescription
ownerstringThe account owner of the repository. The name is not case sensitive.
repostringThe name of the repository without the .git extension. The name is not case sensitive.

SELECT examples

Each array contains the day number, hour number, and number of commits:

* 0-6: Sunday - Saturday
* 0-23: Hour of day
* Number of commits

For example, [2, 14, 25] indicates that there were 25 total commits, during the 2:00pm hour on Tuesdays. All times are based on the time zone of individual commits.

SELECT
*
FROM github.repos.stats_punch_cards
WHERE owner = '{{ owner }}' -- required
AND repo = '{{ repo }}' -- required
;