turbot / steampipe-plugin-aws

Use SQL to instantly query AWS resources across regions and accounts. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/aws
Apache License 2.0
177 stars 89 forks source link

Add table aws_elastic_beanstalk_application_version. Closes #2147 #2150

Closed Priyanka-Chatterjee-2000 closed 3 months ago

Priyanka-Chatterjee-2000 commented 3 months ago

Integration test logs

Logs ``` No env file present for the current environment: staging Falling back to .env config No env file present for the current environment: staging customEnv TURBOT_TEST_EXPECTED_TIMEOUT undefined SETUP: tests/aws_elastic_beanstalk_application_version [] PRETEST: tests/aws_elastic_beanstalk_application_version TEST: tests/aws_elastic_beanstalk_application_version Running terraform Terraform used the selected providers to generate the following execution plan. Resource actions are indicated with the following symbols: + create Terraform will perform the following actions: # aws_elastic_beanstalk_application.test_application will be created + resource "aws_elastic_beanstalk_application" "test_application" { + arn = (known after apply) + description = "An application to test AWS Elastic Beanstalk Application Version." + id = (known after apply) + name = "tf-test-app" + tags_all = (known after apply) } # aws_elastic_beanstalk_application_version.test_application_version will be created + resource "aws_elastic_beanstalk_application_version" "test_application_version" { + application = "tf-test-app" + arn = (known after apply) + bucket = (known after apply) + description = "A version of the test application." + force_delete = false + id = (known after apply) + key = "beanstalk/go.zip" + name = "tf-test-app-version-28032024" + tags = { + "name" = "tf-test-app-version-28032024" } + tags_all = { + "name" = "tf-test-app-version-28032024" } } # aws_s3_bucket.application_version_bucket will be created + resource "aws_s3_bucket" "application_version_bucket" { + acceleration_status = (known after apply) + acl = (known after apply) + arn = (known after apply) + bucket = "tf-test-application-version-bucket-tf-test-app" + bucket_domain_name = (known after apply) + bucket_prefix = (known after apply) + bucket_regional_domain_name = (known after apply) + force_destroy = false + hosted_zone_id = (known after apply) + id = (known after apply) + object_lock_enabled = (known after apply) + policy = (known after apply) + region = (known after apply) + request_payer = (known after apply) + tags_all = (known after apply) + website_domain = (known after apply) + website_endpoint = (known after apply) } # aws_s3_object.application_version_object will be created + resource "aws_s3_object" "application_version_object" { + acl = (known after apply) + arn = (known after apply) + bucket = (known after apply) + bucket_key_enabled = (known after apply) + checksum_crc32 = (known after apply) + checksum_crc32c = (known after apply) + checksum_sha1 = (known after apply) + checksum_sha256 = (known after apply) + content_type = (known after apply) + etag = (known after apply) + force_destroy = false + id = (known after apply) + key = "beanstalk/go.zip" + kms_key_id = (known after apply) + server_side_encryption = (known after apply) + source = "/Users/priyankachatterjee/Downloads/go.zip" + storage_class = (known after apply) + tags_all = (known after apply) + version_id = (known after apply) } Plan: 4 to add, 0 to change, 0 to destroy. Changes to Outputs: + application_name = "tf-test-app" + application_version_arn = (known after apply) + aws_region = "us-east-1" + version_label = "tf-test-app-version-28032024" aws_elastic_beanstalk_application.test_application: Creating... aws_s3_bucket.application_version_bucket: Creating... aws_elastic_beanstalk_application.test_application: Creation complete after 3s [id=tf-test-app] aws_s3_bucket.application_version_bucket: Creation complete after 7s [id=tf-test-application-version-bucket-tf-test-app] aws_s3_object.application_version_object: Creating... aws_s3_object.application_version_object: Creation complete after 2s [id=beanstalk/go.zip] aws_elastic_beanstalk_application_version.test_application_version: Creating... aws_elastic_beanstalk_application_version.test_application_version: Creation complete after 1s [id=tf-test-app-version-28032024] Apply complete! Resources: 4 added, 0 changed, 0 destroyed. Outputs: application_name = "tf-test-app" application_version_arn = "arn:aws:elasticbeanstalk:us-east-1:888888888888:applicationversion/tf-test-app/tf-test-app-version-28032024" aws_region = "us-east-1" version_label = "tf-test-app-version-28032024" Running SQL query: test-get-query.sql [ { "application_name": "tf-test-app", "application_version_arn": "arn:aws:elasticbeanstalk:us-east-1:888888888888:applicationversion/tf-test-app/tf-test-app-version-28032024", "tags": { "name": "tf-test-app-version-28032024" } } ] ✔ PASSED Running SQL query: test-hydrate-query.sql [ { "application_version_arn": "arn:aws:elasticbeanstalk:us-east-1:888888888888:applicationversion/tf-test-app/tf-test-app-version-28032024", "tags_src": [ { "Key": "name", "Value": "tf-test-app-version-28032024" } ], "version_label": "tf-test-app-version-28032024" } ] ✔ PASSED Running SQL query: test-list-query.sql [ { "application_version_arn": "arn:aws:elasticbeanstalk:us-east-1:888888888888:applicationversion/tf-test-app/tf-test-app-version-28032024", "region": "us-east-1", "tags": { "name": "tf-test-app-version-28032024" }, "title": "tf-test-app-version-28032024", "version_label": "tf-test-app-version-28032024" } ] ✔ PASSED Running SQL query: test-not-found-query.sql [] ✔ PASSED Running SQL query: test-turbot-query.sql [ { "akas": [ "arn:aws:elasticbeanstalk:us-east-1:888888888888:applicationversion/tf-test-app/tf-test-app-version-28032024" ], "region": "us-east-1", "tags": { "name": "tf-test-app-version-28032024" }, "title": "tf-test-app-version-28032024", "version_label": "tf-test-app-version-28032024" } ] ✔ PASSED POSTTEST: tests/aws_elastic_beanstalk_application_version TEARDOWN: tests/aws_elastic_beanstalk_application_version SUMMARY: 1/1 passed. ```

Example query results

Results ``` select application_name, application_version_arn, version_label, description, date_created, date_updated, source_bundle from aws_elastic_beanstalk_application_version; +------------------+----------------------------------------------------------------------------------------+---------------+-------------+---------------------------+-------------> | application_name | application_version_arn | version_label | description | date_created | date_updated> +------------------+----------------------------------------------------------------------------------------+---------------+-------------+---------------------------+-------------> | app-test-1 | arn:aws:elasticbeanstalk:us-east-1:555555555555:applicationversion/app-test-1/test1234 | test1234 | | 2024-03-28T00:30:07+05:30 | 2024-03-28T0> | tes5t6 | arn:aws:elasticbeanstalk:us-east-1:555555555555:applicationversion/tes5t6/test9999 | test9999 | | 2024-03-28T00:31:16+05:30 | 2024-03-28T0> | TESTNO | arn:aws:elasticbeanstalk:us-east-1:555555555555:applicationversion/TESTNO/test4444 | test4444 | | 2024-03-28T00:34:34+05:30 | 2024-03-28T0> +------------------+----------------------------------------------------------------------------------------+---------------+-------------+---------------------------+------------- select application_name, application_version_arn, version_label, date_updated from aws_elastic_beanstalk_application_version order by date_updated desc; +------------------+----------------------------------------------------------------------------------------+---------------+---------------------------+ | application_name | application_version_arn | version_label | date_updated | +------------------+----------------------------------------------------------------------------------------+---------------+---------------------------+ | TESTNO | arn:aws:elasticbeanstalk:us-east-1:555555555555:applicationversion/TESTNO/test4444 | test4444 | 2024-03-28T00:34:34+05:30 | | tes5t6 | arn:aws:elasticbeanstalk:us-east-1:555555555555:applicationversion/tes5t6/test9999 | test9999 | 2024-03-28T00:31:16+05:30 | | app-test-1 | arn:aws:elasticbeanstalk:us-east-1:555555555555:applicationversion/app-test-1/test1234 | test1234 | 2024-03-28T00:30:07+05:30 | +------------------+----------------------------------------------------------------------------------------+---------------+---------------------------+ select application_name, application_version_arn, version_label, status from aws_elastic_beanstalk_application_version where status = 'PROCESSED'; +------------------+-------------------------+---------------+--------+ | application_name | application_version_arn | version_label | status | +------------------+-------------------------+---------------+--------+ +------------------+-------------------------+---------------+--------+ select application_name, application_version_arn, version_label, status from aws_elastic_beanstalk_application_version where status = 'UNPROCESSED'; +------------------+----------------------------------------------------------------------------------------+---------------+-------------+ | application_name | application_version_arn | version_label | status | +------------------+----------------------------------------------------------------------------------------+---------------+-------------+ | app-test-1 | arn:aws:elasticbeanstalk:us-east-1:555555555555:applicationversion/app-test-1/test1234 | test1234 | UNPROCESSED | | tes5t6 | arn:aws:elasticbeanstalk:us-east-1:555555555555:applicationversion/tes5t6/test9999 | test9999 | UNPROCESSED | | TESTNO | arn:aws:elasticbeanstalk:us-east-1:555555555555:applicationversion/TESTNO/test4444 | test4444 | UNPROCESSED | +------------------+----------------------------------------------------------------------------------------+---------------+-------------+ select application_name, application_version_arn, version_label, description, date_created, date_updated, source_bundle from aws_elastic_beanstalk_application_version where application_name = 'tes5t6'; +------------------+------------------------------------------------------------------------------------+---------------+-------------+---------------------------+-----------------> | application_name | application_version_arn | version_label | description | date_created | date_updated > +------------------+------------------------------------------------------------------------------------+---------------+-------------+---------------------------+-----------------> | tes5t6 | arn:aws:elasticbeanstalk:us-east-1:555555555555:applicationversion/tes5t6/test9999 | test9999 | | 2024-03-28T00:31:16+05:30 | 2024-03-28T00:31> +------------------+------------------------------------------------------------------------------------+---------------+-------------+---------------------------+-----------------> select application_name, application_version_arn, version_label, tags from aws_elastic_beanstalk_application_version where tags ->> 'test' = '123333'; +------------------+------------------------------------------------------------------------------------+---------------+-------------------+ | application_name | application_version_arn | version_label | tags | +------------------+------------------------------------------------------------------------------------+---------------+-------------------+ | TESTNO | arn:aws:elasticbeanstalk:us-east-1:555555555555:applicationversion/TESTNO/test4444 | test4444 | {"test":"123333"} | +------------------+------------------------------------------------------------------------------------+---------------+-------------------+ select application_name, application_version_arn, version_label from aws_elastic_beanstalk_application_version where source_build_information ->> 'SourceRepository' = 'CodeCommit'; +------------------+-------------------------+---------------+ | application_name | application_version_arn | version_label | +------------------+-------------------------+---------------+ +------------------+-------------------------+---------------+ select application_name, application_version_arn, version_label from aws_elastic_beanstalk_application_version where source_build_information ->> 'SourceRepository' = 'CodeCommit'; +------------------+-------------------------+---------------+ | application_name | application_version_arn | version_label | +------------------+-------------------------+---------------+ +------------------+-------------------------+---------------+ select application_name, application_version_arn, version_label from aws_elastic_beanstalk_application_version where source_build_information ->> 'SourceRepository' = 'S3'; +------------------+----------------------------------------------------------------------------------------+---------------+ | application_name | application_version_arn | version_label | +------------------+----------------------------------------------------------------------------------------+---------------+ | TESTNO | arn:aws:elasticbeanstalk:us-east-1:555555555555:applicationversion/TESTNO/test4444 | test4444 | | tes5t6 | arn:aws:elasticbeanstalk:us-east-1:555555555555:applicationversion/tes5t6/test9999 | test9999 | | app-test-1 | arn:aws:elasticbeanstalk:us-east-1:555555555555:applicationversion/app-test-1/test1234 | test1234 | +------------------+----------------------------------------------------------------------------------------+---------------+ ```
misraved commented 3 months ago

@Priyanka-Chatterjee-2000 please take a look at the following questions/suggestions for this PR:

Priyanka-Chatterjee-2000 commented 3 months ago