title | description |
---|---|
Steampipe Table: github_search_pull_request - Query GitHub Pull Requests using SQL |
Allows users to query GitHub Pull Requests. This table provides extensive details about pull requests across repositories, including the status, creator, and assignee information. |
GitHub Pull Requests is a feature within GitHub that allows developers to propose changes to a repository. It provides a platform for code review and discussion about the proposed changes before they are merged into the codebase. GitHub Pull Requests helps in maintaining the integrity and quality of the code in a repository by ensuring that all changes are reviewed and approved before they are incorporated.
The github_search_pull_request
table provides insights into pull requests within GitHub. As a developer or project manager, explore pull request-specific details through this table, including status, creator, assignee, and associated metadata. Utilize it to monitor the progress of proposed changes, manage code reviews, and ensure the quality of the code in your repositories.
Important Notes
- You must always include at least one search term when searching pull requests in the where or join clause using the
query
column. You can narrow the results using these search qualifiers in any combination. See Searching issues and pull requests for details on the GitHub query syntax.
Explore which GitHub pull requests match certain criteria within the title, body, or comments. This can be useful for identifying relevant discussions or changes related to specific topics or keywords.
select
title,
id,
state,
created_at,
repository_full_name,
url
from
github_search_pull_request
where
query = 'github_search_issue in:title in:body in:comments';
select
title,
id,
state,
created_at,
repository_full_name,
url
from
github_search_pull_request
where
query = 'github_search_issue in:title in:body in:comments';
Determine the areas in which a specific user has been assigned open pull requests for a particular repository. This is useful for project managers to track individual contributions and progress in a collaborative environment.
select
title,
id,
state,
created_at,
url
from
github_search_pull_request
where
query = 'is:open assignee:c0d3r-arnab repo:turbot/steampipe-plugin-github';
select
title,
id,
state,
created_at,
url
from
github_search_pull_request
where
query = 'is:open assignee:c0d3r-arnab repo:turbot/steampipe-plugin-github';
Determine the areas in which a specific user has been assigned public visibility pull requests in a particular GitHub repository. This can be useful to track a user's involvement and contribution to publicly visible projects.
select
title,
id,
state,
created_at,
url
from
github_search_pull_request
where
query = 'is:public assignee:c0d3r-arnab repo:turbot/steampipe-plugin-github';
select
title,
id,
state,
created_at,
url
from
github_search_pull_request
where
query = 'is:public assignee:c0d3r-arnab repo:turbot/steampipe-plugin-github';
Identify instances where open pull requests are not linked to an issue within the 'turbot/steampipe-plugin-github' repository. This can help to uncover potential oversights in issue tracking and ensure all code changes are properly documented.
select
title,
id,
state,
created_at,
url
from
github_search_pull_request
where
query = 'is:open -linked:issue repo:turbot/steampipe-plugin-github';
select
title,
id,
state,
created_at,
url
from
github_search_pull_request
where
query = 'is:open -linked:issue repo:turbot/steampipe-plugin-github';
Determine the areas in which pull requests have sparked significant discussion, by identifying those with over 50 comments. This can provide insights into contentious or complex issues within your organization's GitHub repositories.
select
title,
id,
total_comments_count,
state,
created_at,
url
from
github_search_pull_request
where
query = 'org:turbot comments:>50';
select
title,
id,
total_comments_count,
state,
created_at,
url
from
github_search_pull_request
where
query = 'org:turbot comments:>50';
Explore the open draft pull requests in your GitHub organization. This could be used to identify unfinished work and help prioritize tasks for your development team.
select
title,
id,
state,
created_at,
url
from
github_search_pull_request
where
query = 'org:turbot draft:true state:open';
select
title,
id,
state,
created_at,
url
from
github_search_pull_request
where
query = 'org:turbot draft:true state:open';
Determine the areas in which pull requests have taken more than a month to close. This can help in identifying bottlenecks in the code review process and provide insights for improving efficiency.
select
title,
id,
state,
created_at,
closed_at,
url
from
github_search_pull_request
where
query = 'org:turbot state:closed'
and closed_at > (created_at + interval '30' day);
select
title,
id,
state,
created_at,
closed_at,
url
from
github_search_pull_request
where
query = 'org:turbot state:closed'
and closed_at > datetime(created_at, '+30 days');