github.com/turbot/steampipe@v1.7.0-rc.0.0.20240517123944-7cef272d4458/tests/acceptance/test_data/mods/functionality_test_mod/query/query_params.sp (about)

     1  query "query_params_with_all_defaults"{
     2    description = "query 1 - 3 params all with defaults"
     3    sql = "select 'ok' as status, 'steampipe' as resource, concat($1::text, ' ', $2::text, ' ', $3::text) as reason"
     4    param "p1"{
     5      description = "First parameter"
     6      default = "default_parameter_1"
     7    }
     8    param "p2"{
     9      description = "Second parameter"
    10      default = "default_parameter_2"
    11    }
    12    param "p3"{
    13      description = "Third parameter"
    14      default = "default_parameter_3"
    15    }
    16  }
    17  
    18  query "query_params_with_no_defaults"{
    19    description = "query 1 - 3 params with no defaults"
    20    sql = "select 'ok' as status, 'steampipe' as resource, concat($1::text, ' ', $2::text, ' ', $3::text) as reason"
    21    param "p1"{
    22      description = "First parameter"
    23    }
    24    param "p2"{
    25      description = "Second parameter"
    26    }
    27    param "p3"{
    28      description = "Third parameter"
    29    }
    30  }
    31  
    32  query "query_array_params_with_default"{
    33    description = "query an array parameter with default"
    34    sql = "select 'ok' as status, 'steampipe' as resource, $1::jsonb->1 as reason"
    35    param "p1"{
    36      description = "Array parameter"
    37      default = ["default_p1_element_01", "default_p1_element_02", "default_p1_element_03"]
    38    }
    39  }
    40  
    41  query "query_map_params_with_default"{
    42    description = "query a map parameter with default"
    43    sql = "select 'ok' as status, 'steampipe' as resource, $1::json->'default_property_01' as reason"
    44    param "p1"{
    45      description = "Map parameter"
    46      default = {"default_property_01": "default_property_value_01", "default_property_02": "default_property_value_02"}
    47    }
    48  }
    49  
    50  query "query_map_params_with_no_default"{
    51    description = "query a map parameter with no default"
    52    sql = "select 'ok' as status, 'steampipe' as resource, $1::json->'default_property_01' as reason"
    53    param "p1"{
    54      description = "Map parameter"
    55    }
    56  }