Integrate the Cloudflare R2 API with the PostgreSQL API

import { S3 } from "@aws-sdk/client-s3";
import { ListBucketsCommand } from "@aws-sdk/client-s3";

export default defineComponent({
  props: {
    cloudflare_r2: {
      type: "app",
      app: "cloudflare_r2",
    }
  },
  async run({ steps, $ }) {
    const cloudflare_r2 = {
      account_id: this.cloudflare_r2.$auth.account_id
    };

    const s3Client = new S3({
        forcePathStyle: false, 
        endpoint: `https://${cloudflare_r2.account_id}.r2.cloudflarestorage.com`, 
        region: "auto",
        credentials: {
          accessKeyId: this.cloudflare_r2.$auth.access_key_id,
          secretAccessKey: this.cloudflare_r2.$auth.access_key_secret
        }
    });

    const data = await s3Client.send(new ListBucketsCommand({}));
    return data.Buckets;
    }
  }
)

import postgresql from "@pipedream/postgresql"

export default defineComponent({
  props: {
    postgresql,
  },
  async run({ steps, $ }) {
    // Component source code:
    // https://github.com/PipedreamHQ/pipedream/tree/master/components/postgresql

    const queryObj = {
      text: "SELECT NOW()",
      values: [], // Ignored since query does not contain placeholders
    };
    return await this.postgresql.executeQuery(queryObj);
  },
})