postgres with tls

import * as wmill from "https://deno.land/x/windmill@v1.100.2/mod.ts";

export async function main(
  dbConfig: wmill.Resource<"postgresql">,
) {
  const caCert = await wmill.getVariable("f/invoicing/CA_CERT");
  dbConfig.tls.caCertificates = [caCert];

  const client = new Client(dbConfig);
  await client.connect();

  const res = await client.queryObject(
    `select * from youcandothis`,
  );

  await client.end();

  return res.rows;
}

import * as wmill from "https://deno.land/x/windmill@v1.100.2/mod.ts";

export async function main(
  dbConfig: wmill.Resource<"postgresql">,
) {
  const caCert = await wmill.getVariable("f/invoicing/CA_CERT");
  dbConfig.tls.caCertificates = [caCert];

  const client = new Client(dbConfig);
  await client.connect();

  const res = await client.queryObject(
    `select * from youcandothis`,
  );

  await client.end();

  return res.rows;
}