Repository ranking by issues

Rank the GitHub repositories in the specified collection according to the number of issues.

Path Parameters

collection_id number required

The ID of collection

Query Parameters

period string

Possible values: [past_28_days, past_month]

Default value: past_28_days

The period of the range.

Responses

• 200

---

Default Response

application/json

Schema

Example (from schema)

---

Schema

type string required

Possible values: [sql_endpoint]

The type of the endpoint.

data object required
columns object[] required
Array [
col string required
The name of the column in the query result.
data_type string required
Possible values: [CHAR, BIGINT, DECIMAL, INT, UNSIGNED BIGINT, TINYINT, TIMESTAMP, TEXT, VARCHAR, DATETIME, DOUBLE, FLOAT, DATE, TIME, YEAR, MEDIUMINT, SMALLINT, BIT, BINARY, VARBINARY, JSON, ENUM, SET, TINYTEXT, MEDIUMTEXT, LONGTEXT, TINYBLOB, MEDIUMBLOB, BLOB, LONGBLOB]
The data type of the column.
nullable boolean required
Whether the column is nullable.
]
rows object[] required
Array [
repo_id string
The repository ID
repo_name string
The repository name
current_period_growth string
issues growth in the current period (past 28 days / current month)
past_period_growth string
issues growth in the past period (The 28 days before the past 28 days / past month)
growth_pop string
The period-over-period growth of issues
rank_pop string
The period-over-period rank changes of issues
total string
The current total issues of repository
]
result object required
code number
The code of the response.
message string
The message of the response.
start_ms number
The start time of the query in milliseconds.
end_ms number
The end time of the query in milliseconds.
latency string
The latency of the query.
row_count number
The number of rows in the query result.
row_affect number
The number of rows affected by the query.
limit number
The maximum number of rows in the query result.
databases string[]
The databases used in the query.
property name* any

{
  "type": "sql_endpoint",
  "data": {
    "columns": [
      {
        "col": "repo_id",
        "data_type": "BIGINT",
        "nullable": false
      },
      {
        "col": "repo_name",
        "data_type": "VARCHAR",
        "nullable": false
      },
      {
        "col": "current_period_growth",
        "data_type": "BIGINT",
        "nullable": false
      },
      {
        "col": "current_period_rank",
        "data_type": "BIGINT",
        "nullable": false
      },
      {
        "col": "past_period_growth",
        "data_type": "BIGINT",
        "nullable": false
      },
      {
        "col": "past_period_rank",
        "data_type": "BIGINT",
        "nullable": false
      },
      {
        "col": "growth_pop",
        "data_type": "DECIMAL",
        "nullable": false
      },
      {
        "col": "rank_pop",
        "data_type": "BIGINT",
        "nullable": false
      },
      {
        "col": "total",
        "data_type": "BIGINT",
        "nullable": false
      }
    ],
    "rows": [
      {
        "repo_id": "16563587",
        "repo_name": "cockroachdb/cockroach",
        "current_period_growth": "677",
        "past_period_growth": "729",
        "growth_pop": "-7.13",
        "rank_pop": "0",
        "total": "54541",
        "current_period_rank": "1",
        "past_period_rank": "1"
      },
      {
        "repo_id": "60246359",
        "repo_name": "clickhouse/clickhouse",
        "current_period_growth": "268",
        "past_period_growth": "296",
        "growth_pop": "-9.46",
        "rank_pop": "-1",
        "total": "16732",
        "current_period_rank": "2",
        "past_period_rank": "3"
      },
      {
        "repo_id": "41986369",
        "repo_name": "pingcap/tidb",
        "current_period_growth": "263",
        "past_period_growth": "214",
        "growth_pop": "22.90",
        "rank_pop": "-3",
        "total": "15622",
        "current_period_rank": "3",
        "past_period_rank": "6"
      },
      {
        "repo_id": "105944401",
        "repo_name": "yugabyte/yugabyte-db",
        "current_period_growth": "246",
        "past_period_growth": "298",
        "growth_pop": "-17.45",
        "rank_pop": "2",
        "total": "15079",
        "current_period_rank": "4",
        "past_period_rank": "2"
      },
      {
        "repo_id": "208728772",
        "repo_name": "milvus-io/milvus",
        "current_period_growth": "234",
        "past_period_growth": "237",
        "growth_pop": "-1.27",
        "rank_pop": "0",
        "total": "8675",
        "current_period_rank": "5",
        "past_period_rank": "5"
      },
      {
        "repo_id": "507775",
        "repo_name": "elastic/elasticsearch",
        "current_period_growth": "214",
        "past_period_growth": "144",
        "growth_pop": "48.61",
        "rank_pop": "-3",
        "total": "31578",
        "current_period_rank": "6",
        "past_period_rank": "9"
      }
    ],
    "result": {
      "code": 200,
      "message": "Query OK!",
      "start_ms": 1690957407469,
      "end_ms": 1690957407499,
      "latency": "30ms",
      "row_count": 7,
      "row_affect": 0,
      "limit": 50,
      "databases": [
        "gharchive_dev"
      ]
    }
  }
}

Loading...