[BEAM-12693] WriteToJdbc does not respect 'statement' parameter in python

• Type: Bug
• Status: Open
• Priority: P3
• Resolution: Unresolved
• Affects Version/s: 2.31.0
• Component/s: io-java-jdbc, io-py-common
• Flags: Important

Language

Python

• Assignee: Unassigned
• Reporter: ege ucak
• Created: 30/Jul/21 11:26
• Updated: 04/Jun/22 21:34

Description

I need to insert geometry into my postgresql database. My pipeline stage is a follows;

// code placeholder
| 'Write jdbc' >> WriteToJdbc(                  jdbc_url='jdbc:postgresql://localhost:5432/postgre',                    driver_class_name='org.postgresql.Driver', table_name='test',                username='postgres', password='postgres',
statement="""INSERT INTO test
VALUES(?, ?, ?, ST_GeomFromText(?), ?, ?, ?, ?, ?, ?)"""

I expect this code to write data to database and cast my text into geometry type while inserting. But it does not work.