steampipe plugin install github

Table: github_issue_comment - Query GitHub Issue Comments using SQL

GitHub Issue Comments are integral parts of the GitHub platform that enable users to discuss and provide feedback on particular issues within a repository. They serve as a platform for collaboration and can contain important information, updates, or solutions related to the issue at hand. GitHub Issue Comments are particularly useful for tracking the progress of issue resolution and fostering collaborative problem-solving.

Table Usage Guide

The github_issue_comment table provides in-depth insights into Issue Comments within GitHub. As a project manager or developer, explore comment-specific details through this table, including the author, creation time, body of the comment, and associated metadata. Utilize it to track user interactions, gather feedback, monitor issue resolution progress, and encourage collaborative problem-solving.

Important Notes

  • You must specify the repository_full_name column in where or join clause to query the table.

Examples

List comments for a specific issue

This query is useful for gaining insights into the discussion surrounding a specific issue within a specified GitHub repository. It helps identify the contributors, their comments, and the timeline of their interactions, which can be beneficial for understanding the development and resolution process of the issue.

select
id,
author_login,
author_association,
body_text,
created_at,
updated_at,
published_at,
last_edited_at,
editor_login,
url
from
github_issue_comment
where
repository_full_name = 'turbot/steampipe-plugin-github'
and number = 201;
select
id,
author_login,
author_association,
body_text,
created_at,
updated_at,
published_at,
last_edited_at,
editor_login,
url
from
github_issue_comment
where
repository_full_name = 'turbot/steampipe-plugin-github'
and number = 201;

List comments for your issues

Explore the dialogue associated with your issues on GitHub. This query helps you identify instances where a comment has been made on your issue, providing insights into who made the comment, the content of the comment, and when it was created.

select
c.repository_full_name,
c.number as issue,
i.author_login as issue_author,
c.author_login as comment_author,
c.body_text as content,
c.created_at as created,
c.url
from
github_issue_comment c
join github_my_issue i on i.repository_full_name = c.repository_full_name
and i.number = c.number;
select
c.repository_full_name,
c.number as issue,
i.author_login as issue_author,
c.author_login as comment_author,
c.body_text as content,
c.created_at as created,
c.url
from
github_issue_comment c
join github_my_issue i on i.repository_full_name = c.repository_full_name
and i.number = c.number;

List comments for a specific issue which match a certain body content

This query is useful when you want to pinpoint specific comments within a particular issue in a GitHub repository that contain a certain keyword in their content. It can help manage and analyze the discussion within the issue, especially when looking for mentions of a specific topic or term.

select
id,
number as issue,
author_login as comment_author,
author_association,
body_text as content,
created_at,
url
from
github_issue_comment
where
repository_full_name = 'turbot/steampipe-plugin-github'
and number = 201
and body_text ~~* '%branch%';
select
id,
number as issue,
author_login as comment_author,
author_association,
body_text as content,
created_at,
url
from
github_issue_comment
where
repository_full_name = 'turbot/steampipe-plugin-github'
and number = 201
and body_text like '%branch%';

Schema for github_issue_comment

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
authorjsonbThe actor who authored the comment.
author_associationtextAuthor's association with the subject of the issue/pr the comment was raised on.
author_logintextThe login of the comment author.
bodytextThe contents of the comment as markdown.
body_texttextThe contents of the comment as text.
can_deletebooleanIf true, user can delete the comment.
can_minimizebooleanIf true, user can minimize the comment.
can_reactbooleanIf true, user can react to the comment.
can_updatebooleanIf true, user can update the comment.
cannot_update_reasonsjsonbA list of reasons why user cannot update the comment.
created_attimestamp with time zoneTimestamp when comment was created.
created_via_emailbooleanIf true, comment was created via email.
did_authorbooleanIf true, user authored the comment.
editorjsonbThe actor who edited the comment.
editor_logintextThe login of the comment editor.
idbigintThe ID of the comment.
includes_created_editbooleanIf true, comment was edited and includes an edit with the creation data.
is_minimizedbooleanIf true, comment has been minimized.
last_edited_attimestamp with time zoneTimestamp when comment was last edited.
login_idtext=, !=, ~~, ~~*, !~~, !~~*Unique identifier for the user login.
minimized_reasontextThe reason for comment being minimized.
node_idtextThe node ID of the comment.
numberbigint=The issue/pr number.
published_attimestamp with time zoneTimestamp when comment was published.
repository_full_nametext=The full name of the repository (login/repo-name).
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
updated_attimestamp with time zoneTimestamp when comment was last updated.
urltextURL for the comment.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- github

You can pass the configuration to the command with the --config argument:

steampipe_export_github --config '<your_config>' github_issue_comment