Git Product home page Git Product logo

Comments (2)

misraved avatar misraved commented on August 19, 2024

Additional Observations:

  1. I looked up the JSON type columns in the github_commit table and found out that the commit column is causing the problem here(commented out other JSON type columns) https://github.com/turbot/steampipe-plugin-github/blob/main/github/table_github_commit.go#L36.
  2. This issue seems to be around the API response for this particular repository. I did not find this issue in other repositories like steampipe-plugin-github, steampipe-mod-github-sherlock, steampipe-mod-aws-compliance.

from steampipe-plugin-github.

ParthaI avatar ParthaI commented on August 19, 2024

Not able to replicate the issue.

select * from github_commit where repository_full_name='turbot/steampipe'
+----------------------+------------------------------------------+---------------+---------------------+---------------------------------------------------------------------------------------------------
| repository_full_name | sha                                      | author_login  | author_date         | comments_url                                                                                      
+----------------------+------------------------------------------+---------------+---------------------+---------------------------------------------------------------------------------------------------
| turbot/steampipe     | 63518e0fbbb1e7582f950390598b84e49124b4ae | kaidaguerre   | 2021-10-07 10:37:37 | https://api.github.com/repos/turbot/steampipe/commits/63518e0fbbb1e7582f950390598b84e49124b4ae/com
| turbot/steampipe     | 4505caecdf9d1a4373623e1268ba4d08011c8bbb | kaidaguerre   | 2021-10-18 09:24:05 | https://api.github.com/repos/turbot/steampipe/commits/4505caecdf9d1a4373623e1268ba4d08011c8bbb/com
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | 0a7b63ae7e7d34d8c5c7fb97e9969b4bfd261674 | kaidaguerre   | 2021-10-07 11:05:52 | https://api.github.com/repos/turbot/steampipe/commits/0a7b63ae7e7d34d8c5c7fb97e9969b4bfd261674/com
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | 6cc3951ca0c9132476c84273c1d7d77f68296211 | pskrbasu      | 2021-10-07 14:37:03 | https://api.github.com/repos/turbot/steampipe/commits/6cc3951ca0c9132476c84273c1d7d77f68296211/com
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | 667c3aacecf1651738a5b9b4632fdedcedccb0ba | binaek        | 2021-10-07 15:57:55 | https://api.github.com/repos/turbot/steampipe/commits/667c3aacecf1651738a5b9b4632fdedcedccb0ba/com
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | 8b9672592bcf48e87f0fb73c2b7f3aaebdf9dcc5 | binaek        | 2021-10-06 10:36:18 | https://api.github.com/repos/turbot/steampipe/commits/8b9672592bcf48e87f0fb73c2b7f3aaebdf9dcc5/com
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | 52458e6216ef9fe25355044e3f858c133ddb8106 | pskrbasu      | 2021-10-07 11:57:41 | https://api.github.com/repos/turbot/steampipe/commits/52458e6216ef9fe25355044e3f858c133ddb8106/com
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | a495d7a8430d5616b1855cce724f694c37e7c045 | pskrbasu      | 2021-10-08 13:11:44 | https://api.github.com/repos/turbot/steampipe/commits/a495d7a8430d5616b1855cce724f694c37e7c045/com
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | 549f4a7a20d20e26e9bb48d212d85971e828b31d | kaidaguerre   | 2021-09-28 15:46:41 | https://api.github.com/repos/turbot/steampipe/commits/549f4a7a20d20e26e9bb48d212d85971e828b31d/com
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | 1d857931c70c3f8c2e3e128b553ac5516e14d461 | pskrbasu      | 2021-09-03 14:22:30 | https://api.github.com/repos/turbot/steampipe/commits/1d857931c70c3f8c2e3e128b553ac5516e14d461/com
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | b453188f572a73fe1a19bfcda7ce034c954c276c | kaidaguerre   | 2021-09-27 12:50:25 | https://api.github.com/repos/turbot/steampipe/commits/b453188f572a73fe1a19bfcda7ce034c954c276c/com
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | c65e116a3175d36040b964a08ed72d2bea62f60f | binaek        | 2021-10-05 12:43:16 | https://api.github.com/repos/turbot/steampipe/commits/c65e116a3175d36040b964a08ed72d2bea62f60f/com
|                      |                                          |               |                     |                                                          
select * from github_commit where repository_full_name='turbot/steampipe'
+----------------------+------------------------------------------+---------------+---------------------+---------------------------------------------------------------------------------------------------
| repository_full_name | sha                                      | author_login  | author_date         | comments_url                                                                                      
+----------------------+------------------------------------------+---------------+---------------------+---------------------------------------------------------------------------------------------------
| turbot/steampipe     | cb6b4d25b8efb59bf949f66f92f7fa2da8de4c6c | kaidaguerre   | 2021-10-05 11:58:10 | https://api.github.com/repos/turbot/steampipe/commits/cb6b4d25b8efb59bf949f66f92f7fa2da8de4c6c/com
| turbot/steampipe     | 52458e6216ef9fe25355044e3f858c133ddb8106 | pskrbasu      | 2021-10-07 11:57:41 | https://api.github.com/repos/turbot/steampipe/commits/52458e6216ef9fe25355044e3f858c133ddb8106/com
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | a495d7a8430d5616b1855cce724f694c37e7c045 | pskrbasu      | 2021-10-08 13:11:44 | https://api.github.com/repos/turbot/steampipe/commits/a495d7a8430d5616b1855cce724f694c37e7c045/com
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | 6cc3951ca0c9132476c84273c1d7d77f68296211 | pskrbasu      | 2021-10-07 14:37:03 | https://api.github.com/repos/turbot/steampipe/commits/6cc3951ca0c9132476c84273c1d7d77f68296211/com
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | 4505caecdf9d1a4373623e1268ba4d08011c8bbb | kaidaguerre   | 2021-10-18 09:24:05 | https://api.github.com/repos/turbot/steampipe/commits/4505caecdf9d1a4373623e1268ba4d08011c8bbb/com
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | a826f9fc0171a54b704c29503f7aa6f2f393e087 | kaidaguerre   | 2021-09-29 20:07:56 | https://api.github.com/repos/turbot/steampipe/commits/a826f9fc0171a54b704c29503f7aa6f2f393e087/com
| turbot/steampipe     | 0cbb6be8f83bd7f04e7f0534c4bfed978fd9cc99 | pskrbasu      | 2021-09-30 11:09:09 | https://api.github.com/repos/turbot/steampipe/commits/0cbb6be8f83bd7f04e7f0534c4bfed978fd9cc99/com
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | 77fbee36092023b2c8dc1c5e4c44b490662c8f79 | kaidaguerre   | 2021-10-07 10:30:57 | https://api.github.com/repos/turbot/steampipe/commits/77fbee36092023b2c8dc1c5e4c44b490662c8f79/com
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | 667c3aacecf1651738a5b9b4632fdedcedccb0ba | binaek        | 2021-10-07 15:57:55 | https://api.github.com/repos/turbot/steampipe/commits/667c3aacecf1651738a5b9b4632fdedcedccb0ba/com
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | 38e3d5908f30e68ef389c01f5bd25837e8edfcae | kaidaguerre   | 2021-09-28 11:27:03 | https://api.github.com/repos/turbot/steampipe/commits/38e3d5908f30e68ef389c01f5bd25837e8edfcae/com
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | 86798a764749eb45eb5081524f6ab14fa8dde597 | kaidaguerre   | 2021-09-20 11:53:01 | https://api.github.com/repos/turbot/steampipe/commits/86798a764749eb45eb5081524f6ab14fa8dde597/com
|                      |                                          |               |                     |                                                                                                   
> select * from github_commit where repository_full_name='turbot/steampipe'
+----------------------+------------------------------------------+---------------+---------------------+---------------------------------------------------------------------------------------------------
| repository_full_name | sha                                      | author_login  | author_date         | comments_url                                                                                      
+----------------------+------------------------------------------+---------------+---------------------+---------------------------------------------------------------------------------------------------
| turbot/steampipe     | 63518e0fbbb1e7582f950390598b84e49124b4ae | kaidaguerre   | 2021-10-07 10:37:37 | https://api.github.com/repos/turbot/steampipe/commits/63518e0fbbb1e7582f950390598b84e49124b4ae/com
| turbot/steampipe     | a0494168bd5d5678d4258a52e1f855a8f06b6ca4 | pskrbasu      | 2021-10-08 14:18:21 | https://api.github.com/repos/turbot/steampipe/commits/a0494168bd5d5678d4258a52e1f855a8f06b6ca4/com
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
| turbot/steampipe     | 48c1041c9cfa52ae2104371a7d0024709740e659 | binaek        | 2021-10-04 15:43:16 | https://api.github.com/repos/turbot/steampipe/commits/48c1041c9cfa52ae2104371a7d0024709740e659/com
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                          |               |                     |                                                                                                   
|                      |                                        

from steampipe-plugin-github.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.