Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Update github_issue & github_my_issue tables to use GraphQL API #260

Closed
graza-io opened this issue May 17, 2023 · 2 comments
Closed

Update github_issue & github_my_issue tables to use GraphQL API #260

graza-io opened this issue May 17, 2023 · 2 comments
Assignees
Labels
enhancement New feature or request

Comments

@graza-io
Copy link
Contributor

graza-io commented May 17, 2023

Is your feature request related to a problem? Please describe.
I'd like to use the GraphQL API when querying the table

Describe the solution you'd like
Update the table to use the GraphQL API

Describe alternatives you've considered
n/a

Additional context
For any fields that have paging, consider implementing that field as another table to avoid excess API calls (as per https://steampipe.io/docs/develop/plugin-release-checklist#data-ingestion).

New columns

  • active_lock_reason
  • author
  • body_url
  • closed
  • created_via_email
  • editor
  • full_database_id
  • includes_created_edit
  • is_pinned
  • is_read_by_user
  • last_edited_at
  • milestone
  • published_at
  • state_reason
  • user_can_close
  • user_can_react
  • user_can_reopen
  • user_can_subscribe
  • user_can_update
  • user_cannot_update_reasons
  • user_did_author
  • user_subscription
  • assignees_total_count
  • labels_total_count

Renamed columns

  • issue_number => number
  • comments => comments_total_count

Removed columns

  • assignee_logins - pageable response, should be moved to another table.
  • comments_url - rest api endpoint.
  • events_url - rest api endpoint.
  • html_url - now moved to url
  • labels - pageable response.
  • labels_url - rest api endpoint.
  • milestone_id - now included in milestone
  • milestone_title - now included in milestone
  • repository_url - rest api endpoint.
  • reactions - pageable response
  • tags

Columns with data changes

  • url now contains content previously found in html_url instead of a rest api endpoint.
@graza-io graza-io added the enhancement New feature or request label May 17, 2023
@graza-io graza-io self-assigned this May 17, 2023
@graza-io graza-io changed the title Update github_issue table to use GraphQL API Update github_issue & github_my_issue tables to use GraphQL API May 17, 2023
@graza-io
Copy link
Contributor Author

Initial: 23ab389
Additional for comments_total_count: 00a86b8

@cbruno10
Copy link
Contributor

cbruno10 commented Jun 16, 2023

Completed in 42680ef

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

When branches are created from issues, their pull requests are automatically linked.

2 participants