Integrate the Lightpanda API with the PostgreSQL API

import puppeteer from "puppeteer-core";

export default defineComponent({
  props: {
    lightpanda: {
      type: "app",
      app: "lightpanda",
    }
  },
  async run({ steps, $ }) {
      const browser = await puppeteer.connect({
        browserWSEndpoint: `wss://cloud.lightpanda.io/ws?token=${this.lightpanda.$auth.api_token}`,
      });
      const page = await browser.newPage();
      await page.goto('https://pipedream.com/');
      const title = await page.title();
      const content = await page.content();
      await browser.close();// The browser needs to be closed, otherwise the step will hang
      return { title, content }
  },
})

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