Integrate the PostgreSQL API with the Oracle Cloud Infrastructure API

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);
  },
})

import * as common from "oci-common";
import * as identity from "oci-identity";

export default defineComponent({
  props: {
    oracle_cloud_infrastructure: {
      type: "app",
      app: "oracle_cloud_infrastructure",
    },
  },
  async run({ steps, $ }) {
    const tenancyId = this.oracle_cloud_infrastructure.$auth.tenancy_id;
    const userId = this.oracle_cloud_infrastructure.$auth.user_id;
    const fingerprint = this.oracle_cloud_infrastructure.$auth.fingerprint;
    const regionStr = this.oracle_cloud_infrastructure.$auth.region;
    const privateKey = this.oracle_cloud_infrastructure.$auth.private_key;

    // Convert the region string into a Region object
    const region = common.Region.fromRegionId(regionStr);

    // Create a simple authentication provider using your credentials.
    // If your private key has a passphrase, replace null with the passphrase.
    const provider = new common.SimpleAuthenticationDetailsProvider(
      tenancyId,
      userId,
      fingerprint,
      privateKey,
      null, // passphrase (if needed)
      region
    );

    // Create an IdentityClient using the provider.
    const identityClient = new identity.IdentityClient({
      authenticationDetailsProvider: provider,
    });

    // Prepare a request to list compartments for your tenancy.
    const listCompartmentsRequest = {
      compartmentId: tenancyId,
    };

    // Call the OCI API to list compartments.
    const response = await identityClient.listCompartments(listCompartmentsRequest);
    
    // The response object contains details such as items (the list of compartments).
    return response;
  },
});