sdks/python/apache_beam/yaml/extended_tests/databases/sqlserver.yaml

#
# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements.  See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License.  You may obtain a copy of the License at
#
#    http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#

fixtures:
  - name: TEMP_DB
    type: "apache_beam.yaml.integration_tests.temp_sqlserver_database"

pipelines:
  # SqlServer write pipeline
  - pipeline:
      type: chain
      transforms:
        - type: Create
          config:
            elements:
              - {value: 123, rank: 0}
              - {value: 456, rank: 1}
              - {value: 789, rank: 2}
        - type: WriteToSqlServer
          config:
            url: "{TEMP_DB}"
            query: "INSERT INTO tmp_table (value, rank) VALUES(?,?)"

  # SqlServer read pipeline
  - pipeline:
      type: chain
      transforms:
        - type: ReadFromSqlServer
          config:
            url: "{TEMP_DB}"
            query: "SELECT * FROM tmp_table"
            driver_class_name: "com.microsoft.sqlserver.jdbc.SQLServerDriver"
        - type: AssertEqual
          config:
            elements:
              - {value: 123, rank: 0}
              - {value: 456, rank: 1}
              - {value: 789, rank: 2}