kestra-io / plugin-jdbc

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

Added support for postgres tsvector type #361

Closed iNikitaGricenko closed 2 weeks ago

iNikitaGricenko commented 3 weeks ago

What changes are being made and why?

How the changes have been QAed?

  - id: update
    type: io.kestra.plugin.jdbc.postgresql.Batch
    from: \"{{ outputs.query.uri }}\"
    url: jdbc:postgresql://prod:56982/
    username: pg_user
    password: pg_passwd
    sql: |
      insert into pgsql_types
      (
        concert_id,
        available,
        a,
        b,
        c,
        d,
        play_time,
        library_record,
        floatn_test,
        double_test,
        real_test,
        numeric_test,
        date_type,
        time_type,
        timez_type,
        timestamp_type,
        timestampz_type,
        interval_type,
        pay_by_quarter,
        schedule,
        json_type,
        jsonb_type,
        blob_type,
        tsvector_col
      )
      values
      (

        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?::jsonb,
        ?,
        ?::tsvector
      )