sdks/python/apache_beam/yaml/extended_tests/databases/oracle.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_oracle_database"

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

  # Oracle read pipeline
  # Need a separate read pipeline to make sure the write pipeline is flushed
  - pipeline:
      type: chain
      transforms:
        - type: ReadFromOracle
          config:
            url: "{TEMP_DB}"
            query: "SELECT * FROM tmp_table"
            driver_class_name: "oracle.jdbc.OracleDriver"
        - type: MapToFields
          config:
            language: python
            fields:
              value:
                callable: "lambda x: int(x.VALUE)"
                output_type: integer
              rank:
                callable: "lambda x: int(x.RANK)"
                output_type: integer
        - type: AssertEqual
          config:
            elements:
              - {value: 123, rank: 0}
              - {value: 456, rank: 1}
              - {value: 789, rank: 2}