Coder Social home page Coder Social logo

turbot / steampipe-plugin-digitalocean Goto Github PK

View Code? Open in Web Editor NEW
9.0 12.0 0.0 527 KB

Use SQL to instantly query droplets, VPCs, users and more from DigitalOcean. Open source CLI. No DB required.

Home Page: https://hub.steampipe.io/plugins/turbot/digitalocean

License: Apache License 2.0

Makefile 0.11% Go 99.61% PLSQL 0.28%
digitalocean digitalocean-api steampipe sql postgresql postgresql-fdw doctl steampipe-plugin hacktoberfest backup

steampipe-plugin-digitalocean's Issues

Add table digitalocean_droplet_disk_i/o

References
Add any related links that will help us understand the resource, including vendor documentation, related GitHub issues, and Go SDK documentation.

Add table digitalocean_app

References
Add any related links that will help us understand the resource, including vendor documentation, related GitHub issues, and Go SDK documentation.

cannot list droplets

hi,
when i try to list my droplets i get an error. listing my k8s-clusters or accountdata works.

> select * from do_test.digitalocean_account;
+----------------------------+---------------+----------------+-------------------+--------+----------------+------------------------------------------+--------------+---------------------------------------------------------+------+----------->
| email                      | droplet_limit | email_verified | floating_ip_limit | status | status_message | uuid                                     | volume_limit | akas                                                    | tags | title     >
+----------------------------+---------------+----------------+-------------------+--------+----------------+------------------------------------------+--------------+---------------------------------------------------------+------+----------->
...
> select * from do_test.digitalocean_kubernetes_cluster;
+--------------------------------------+-------------+---------+---------------------+--------------+----------------+---------------------------------------------------------------------+---------------+-------------+------------------+------>
| id                                   | name        | status  | created_at          | auto_upgrade | cluster_subnet | endpoint                                                            | ipv4          | region_slug | registry_enabled | servi>
+--------------------------------------+-------------+---------+---------------------+--------------+----------------+---------------------------------------------------------------------+---------------+-------------+------------------+------>
...
> select * from do_prod.digitalocean_droplet;
Error: failed to populate column 'next_backup_window_start': rpc error: code = Internal desc = transform timestampToIsoTimestamp failed with panic interface conversion: interface {} is nil, not *godo.Timestamp

this is my environment:

❯ steampipe --version
steampipe version 0.7.0
❯ steampipe plugin list
+-----------------------------------------------------+---------+-----------------+
| Name                                                | Version | Connections     |
+-----------------------------------------------------+---------+-----------------+
| hub.steampipe.io/plugins/theapsgroup/gitlab@latest  | 0.0.2   | gitlab          |
| hub.steampipe.io/plugins/turbot/digitalocean@latest | 0.4.0   | do_prod,do_test |
+-----------------------------------------------------+---------+-----------------+

Add `firewall_rules` column and users & database info in digitalocean_database

Is your feature request related to a problem? Please describe.

  • The user and db_names columns are not populated in digitalocean_database.
  • Require the firewall_rules column for digitalocean_database_dashboard.

Describe the solution you'd like

Add firewall_rules column and users & database info in digitalocean_database

Add DigitalOcean account owner & project details across all tables

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Add table digitalocean_storage_spaces

References
Add any related links that will help us understand the resource, including vendor documentation, related GitHub issues, and Go SDK documentation.

Add project_id info in digitalocean_database

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Update digitalocean_droplet example doc to remove size_gigabytes

Describe the bug
Examples using size_gigabytes here breaks due to the non-existence of the required column.

size_gigabytes column exists in digitalocean_snapshot

Steampipe version (steampipe -v)
Example: v0.3.0

Plugin version (steampipe plugin list)
Example: v0.5.0

To reproduce
Steps to reproduce the behavior (please include relevant code and/or commands).

Expected behavior
A clear and concise description of what you expected to happen.

Additional context
Add any other context about the problem here.

v0.3.0

v0.3.0 [2021-03-11]

What's new?

Enhancements

  • Added private_ipv4, public_ipv4, public_ipv6 columns to digitalocean_droplet table
  • Renamed column size to size_slug in digitalocean_load_balancer table
  • Renamed column region to region_slug in digitalocean_load_balancer table
  • Updated columns using deprecated ColumnType_DATETIME type to instead use ColumnType_TIMESTAMP type

Update example query.

Describe the bug
Example query needs update for region col. https://hub.steampipe.io/plugins/turbot/digitalocean/tables/digitalocean_database

Steampipe version (steampipe -v)
Example: v0.3.0

Plugin version (steampipe plugin list)
Example: v0.5.0

To reproduce
Steps to reproduce the behavior (please include relevant code and/or commands).

Expected behavior
A clear and concise description of what you expected to happen.

Additional context
Add any other context about the problem here.

Getting error on doing a get call to table `digitalocean_snapshot`

Getting error on doing a get call to table digitalocean_snapshot:

> select title, regions, id, akas from digitalocean_snapshot where id = '125517051'

ERROR: rpc error: code = Unknown desc = failed to populate column 'akas': rpc error: code = Internal desc = transform snapshotToURN failed with panic interface conversion: interface {} is *godo.Snapshot, not godo.Snapshot (SQLSTATE HV000)

Add table digitalocean_domain

References
Add any related links that will help us understand the resource, including vendor documentation, related GitHub issues, and Go SDK documentation.

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.