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

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

  # Postgres read pipeline with driver_class_name
  - pipeline:
      type: chain
      transforms:
        - type: ReadFromPostgres
          config:
            url: "{TEMP_DB}"
            query: "SELECT * FROM tmp_table"
            driver_class_name: "org.postgresql.Driver"
        - type: AssertEqual
          config:
            elements:
              - {value: 123, rank: 0}
              - {value: 456, rank: 1}
              - {value: 789, rank: 2}
    
  # Postgres read pipeline without driver_class_name
  # This is to prevent https://github.com/apache/beam/issues/35122 from
  # happening again.
  - pipeline:
      type: chain
      transforms:
        - type: ReadFromPostgres
          config:
            url: "{TEMP_DB}"
            query: "SELECT * FROM tmp_table"
        - type: AssertEqual
          config:
            elements:
              - {value: 123, rank: 0}
              - {value: 456, rank: 1}
              - {value: 789, rank: 2}