issues
search
turbot
/
steampipe-plugin-github
Use SQL to instantly query repositories, users, gists and more from GitHub. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/github
Apache License 2.0
74
stars
30
forks
source link
Add table github_package and github_package_version
#459
Open
ParthaI
opened
3 weeks ago
ParthaI
commented
3 weeks ago
Example query results
Results
``` > select * from github_package_version where organization = 'turbot' and package_name = 'steampipe/plugins/turbot/aws' +----------------------+------------------------------+-----------+-------------------------------------------------------------------------+------------------------------------------------------------------------------------------------+---------------------------+---> | login_id | package_name | id | digest | html_url | tags | or> +----------------------+------------------------------+-----------+-------------------------------------------------------------------------+------------------------------------------------------------------------------------------------+---------------------------+---> | MDQ6VXNlcjQ3ODg3NTUy | steampipe/plugins/turbot/aws | 293319827 | sha256:91c6eeb0570b0229aba7c75628c7ada1015eeb727bef0ff44817a74744f4723a | https://github.com/orgs/turbot/packages/container/steampipe%2Fplugins%2Fturbot%2Faws/293319827 | ["11462847177","1.0.0"] | tu> | MDQ6VXNlcjQ3ODg3NTUy | steampipe/plugins/turbot/aws | 237235444 | sha256:69831633b99b174c86a968f2f60863f617a07b0f036d8d6ec12fcec9b35aa731 | https://github.com/orgs/turbot/packages/container/steampipe%2Fplugins%2Fturbot%2Faws/237235444 | ["9738491108","0.141.0"] | tu> | MDQ6VXNlcjQ3ODg3NTUy | steampipe/plugins/turbot/aws | 231280932 | sha256:217baa6355679212c7c13ccfb5994cbc6c36c1581a4475e08bedcc7f8576c5e0 | https://github.com/orgs/turbot/packages/container/steampipe%2Fplugins%2Fturbot%2Faws/231280932 | ["9554587442","0.139.0"] | tu> | MDQ6VXNlcjQ3ODg3NTUy | steampipe/plugins/turbot/aws | 214094141 | sha256:e37f0f833fc294ea5fce717364201456b38d89f76e505877bc138f19b7f83c25 | https://github.com/orgs/turbot/packages/container/steampipe%2Fplugins%2Fturbot%2Faws/214094141 | ["9016192446","0.138.0"] | tu> | MDQ6VXNlcjQ3ODg3NTUy | steampipe/plugins/turbot/aws | 203110114 | sha256:ed529dec9d3b7b36e7f49a5d78fe6953e81af7603dc511a33445d995ea3d9960 | https://github.com/orgs/turbot/packages/container/steampipe%2Fplugins%2Fturbot%2Faws/203110114 | ["8664910709","0.135.0"] | tu> > select * from github_package where organization = 'turbot' +----------------------+---------+---------------------------------------------------------------------------------------------------------------+--------------+--------------+-------------+----------+-------------------------------------+---------------------------+--> | login_id | id | name | package_type | organization | owner_login | owner_id | owner_url | owner_html_url | r> +----------------------+---------+---------------------------------------------------------------------------------------------------------------+--------------+--------------+-------------+----------+-------------------------------------+---------------------------+--> | MDQ6VXNlcjQ3ODg3NTUy | 6331189 | steampipe/plugins/turbot/docker | container | turbot | turbot | 38865304 | https://api.github.com/users/turbot | https://github.com/turbot | 3> | | | | | | | | | | > | | | | | | | | | | > | | | | | | | | | | > | | | | | | | | | | > | MDQ6VXNlcjQ3ODg3NTUy | 1494498 | steampipe-postgres-fdw/run-on-arch-turbot-steampipe-postgres-fdw-build-linux-arm-binary-aarch64-ubuntu-latest | container | turbot | turbot | 38865304 | https://api.github.com/users/turbot | https://github.com/turbot | 3> | | | | | | | | | | > | | | | | | | | | | > | | | | | | | | | | > | | | | | | | | | | > | MDQ6VXNlcjQ3ODg3NTUy | 6331177 | steampipe/plugins/turbot/digitalocean | container | turbot | turbot | 38865304 | https://api.github.com/users/turbot | https://github.com/turbot | 3> ```
Example query results
Results
``` > select * from github_package_version where organization = 'turbot' and package_name = 'steampipe/plugins/turbot/aws' +----------------------+------------------------------+-----------+-------------------------------------------------------------------------+------------------------------------------------------------------------------------------------+---------------------------+---> | login_id | package_name | id | digest | html_url | tags | or> +----------------------+------------------------------+-----------+-------------------------------------------------------------------------+------------------------------------------------------------------------------------------------+---------------------------+---> | MDQ6VXNlcjQ3ODg3NTUy | steampipe/plugins/turbot/aws | 293319827 | sha256:91c6eeb0570b0229aba7c75628c7ada1015eeb727bef0ff44817a74744f4723a | https://github.com/orgs/turbot/packages/container/steampipe%2Fplugins%2Fturbot%2Faws/293319827 | ["11462847177","1.0.0"] | tu> | MDQ6VXNlcjQ3ODg3NTUy | steampipe/plugins/turbot/aws | 237235444 | sha256:69831633b99b174c86a968f2f60863f617a07b0f036d8d6ec12fcec9b35aa731 | https://github.com/orgs/turbot/packages/container/steampipe%2Fplugins%2Fturbot%2Faws/237235444 | ["9738491108","0.141.0"] | tu> | MDQ6VXNlcjQ3ODg3NTUy | steampipe/plugins/turbot/aws | 231280932 | sha256:217baa6355679212c7c13ccfb5994cbc6c36c1581a4475e08bedcc7f8576c5e0 | https://github.com/orgs/turbot/packages/container/steampipe%2Fplugins%2Fturbot%2Faws/231280932 | ["9554587442","0.139.0"] | tu> | MDQ6VXNlcjQ3ODg3NTUy | steampipe/plugins/turbot/aws | 214094141 | sha256:e37f0f833fc294ea5fce717364201456b38d89f76e505877bc138f19b7f83c25 | https://github.com/orgs/turbot/packages/container/steampipe%2Fplugins%2Fturbot%2Faws/214094141 | ["9016192446","0.138.0"] | tu> | MDQ6VXNlcjQ3ODg3NTUy | steampipe/plugins/turbot/aws | 203110114 | sha256:ed529dec9d3b7b36e7f49a5d78fe6953e81af7603dc511a33445d995ea3d9960 | https://github.com/orgs/turbot/packages/container/steampipe%2Fplugins%2Fturbot%2Faws/203110114 | ["8664910709","0.135.0"] | tu> > select * from github_package where organization = 'turbot' +----------------------+---------+---------------------------------------------------------------------------------------------------------------+--------------+--------------+-------------+----------+-------------------------------------+---------------------------+--> | login_id | id | name | package_type | organization | owner_login | owner_id | owner_url | owner_html_url | r> +----------------------+---------+---------------------------------------------------------------------------------------------------------------+--------------+--------------+-------------+----------+-------------------------------------+---------------------------+--> | MDQ6VXNlcjQ3ODg3NTUy | 6331189 | steampipe/plugins/turbot/docker | container | turbot | turbot | 38865304 | https://api.github.com/users/turbot | https://github.com/turbot | 3> | | | | | | | | | | > | | | | | | | | | | > | | | | | | | | | | > | | | | | | | | | | > | MDQ6VXNlcjQ3ODg3NTUy | 1494498 | steampipe-postgres-fdw/run-on-arch-turbot-steampipe-postgres-fdw-build-linux-arm-binary-aarch64-ubuntu-latest | container | turbot | turbot | 38865304 | https://api.github.com/users/turbot | https://github.com/turbot | 3> | | | | | | | | | | > | | | | | | | | | | > | | | | | | | | | | > | | | | | | | | | | > | MDQ6VXNlcjQ3ODg3NTUy | 6331177 | steampipe/plugins/turbot/digitalocean | container | turbot | turbot | 38865304 | https://api.github.com/users/turbot | https://github.com/turbot | 3> ```