---
id: 42
name: Test
requestPath: /demo/jdbc
requestMethod: POST
requestType: JSON
requestVariableName: request
steps:
  - _type: adapter
    adapterLanguage: GROOVY
    variableName: parsed
    adapterScript: |
      fromJson request
  - _type: conditional
    conditions:
      - _type: when
        expression: a == 'test'
        steps:
          - _type: jdbc
            type: SELECT
            url: jdbc:postgresql://localhost:5432/test
            username: test
            password: pass
            variableName: rd
            script: |
              SELECT *
              FROM test_table
              <#if id??>
              WHERE id = :id
              </#if>
          - _type: conditional
            conditions:
              - _type: when
                expression: false
                steps:
                  - _type: call
                    requestUrl: http://localhost:8888/do
                    requestMethod: POST
                    requestVariableName: test
                    responseVariableName: bla
                  - _type: jdbc
                     type: UPDATE
                     url: jdbc:postgresql://localhost:5432/test
                     username: test
                     password: pass
                     variableName: rd
                     script: |
                       INSERT INTO test_table (value)
                       VALUES(:value)
                       </#if>