github.com/turbot/steampipe@v1.7.0-rc.0.0.20240517123944-7cef272d4458/tests/manual_testing/dashboard_container_inputs/inputs.sp (about)

     1  
     2  query "aws_iam_users_by_mfa_enabled" {
     3    sql = <<-EOQ
     4      with mfa as (
     5        select
     6          case when mfa_enabled then 'Enabled' else 'Disabled' end as mfa_status
     7        from
     8          aws_iam_user
     9      )
    10      select
    11        mfa_status,
    12        count(mfa_status) as "Total"
    13      from
    14        mfa
    15      group by
    16        mfa_status
    17    EOQ
    18  }
    19  
    20  query "aws_region_input" {
    21    sql = <<EOQ
    22  select
    23    title as label,
    24    region as value
    25  from
    26    aws_region
    27  where
    28    account_id = '876515858155'
    29  order by
    30    title;
    31  EOQ
    32  }
    33  
    34  query "aws_s3_buckets_by_versioning_enabled" {
    35    sql = <<-EOQ
    36      with versioning as (
    37        select
    38          case when versioning_enabled then 'Enabled' else 'Disabled' end as versioning_status,
    39          region
    40        from
    41          aws_s3_bucket
    42      )
    43      select
    44        versioning_status,
    45        count(versioning_status) as "Total"
    46      from
    47        versioning
    48      where
    49        region = $1
    50      group by
    51        versioning_status
    52  EOQ
    53    param "region" {
    54      default = "us-east-1"
    55    }
    56  }
    57  
    58  dashboard "inputs" {
    59    title = "Inputs Test"
    60  
    61    text {
    62      value = "dasboard input"
    63    }
    64    input "region" {
    65      sql   = query.aws_region_input.sql
    66      width = 3
    67    }
    68  
    69    container {
    70      container {
    71        container {
    72          text {
    73            value = "container input"
    74          }
    75          input "region2" {
    76            sql = query.aws_region_input.sql
    77            width = 3
    78          }
    79  
    80          chart {
    81            type = "donut"
    82            width = 5
    83            query = query.aws_s3_buckets_by_versioning_enabled
    84            args = {
    85              "region" = self.input.region.value
    86            }
    87            title = "AWS IAM Users MFA Status"
    88  
    89            series "Total" {
    90              point "Disabled" {
    91                color = "red"
    92              }
    93  
    94              point "Enabled" {
    95                color = "green"
    96              }
    97            }
    98          }
    99  
   100          chart {
   101            type = "pie"
   102            width = 3
   103            query = query.aws_s3_buckets_by_versioning_enabled
   104            args = {
   105              "region" = self.input.region2.value
   106            }
   107            title = "AWS IAM Users MFA Status"
   108          }
   109        }
   110      }
   111    }
   112  }