kestra-io / plugin-jdbc

https://kestra.io/plugins/
Apache License 2.0
10 stars 7 forks source link

Improved the Batch tasks to not require an explicit columns specification #358

Closed iNikitaGricenko closed 3 weeks ago

iNikitaGricenko commented 4 weeks ago

What changes are being made and why?

How the changes have been QAed?

tasks:
  - id: query
    type: io.kestra.plugin.jdbc.mysql.Query
    url: jdbc:mysql://127.0.0.1:3306/
    username: mysql_user
    password: mysql_passwd
    sql: |
      SELECT *
      FROM xref
      LIMIT 1500;
    store: true
  - id: update
    type: io.kestra.plugin.jdbc.mysql.Batch
    from: "{{ outputs.query.uri }}"
    url: jdbc:mysql://127.0.0.1:3306/
    username: mysql_user
    password: mysql_passwd
    table: xref
loicmathieu commented 3 weeks ago

@iNikitaGricenko Postgres tests are failing, can you have a look?

loicmathieu commented 3 weeks ago

@iNikitaGricenko Vectorwize tests also fail, can you have a look?

iNikitaGricenko commented 3 weeks ago

@loicmathieu Could you help me with this one, please (Provide exceptions details or something)? As i didn't manage to download Actian Vector (Vectorwize)?