What do you want to automate

with YOURLS and PostgreSQL?

import crypto from "crypto";
import { axios } from "@pipedream/platform";

export default defineComponent({
  props: {
    yourls: {
      type: "app",
      app: "yourls",
    }
  },
  async run({ steps, $ }) {
    const timestamp = Math.floor(Date.now() / 1000)
    const signature = crypto
      .createHash('md5')
      .update(timestamp + this.yourls.$auth.signature_token)
      .digest('hex')

    return await axios($, {
      method: "get",
      url: `${this.yourls.$auth.api_url}/yourls-api.php`,
      params: {
        timestamp,
        signature,
        action: "shorturl",
        url: this.yourls.$auth.test_url,
        format: "json"
      },
    });
  },
})

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