Integrate the RabbitMQ API with the MySQL API

import amqp from "amqplib";

export default defineComponent({
  props: {
    rabbitmq: {
      type: "app",
      app: "rabbitmq",
    }
  },
  async run({ steps, $ }) {
    const url = `amqp://${this.rabbitmq.$auth.username}:${this.rabbitmq.$auth.password}@${this.rabbitmq.$auth.host}:${this.rabbitmq.$auth.port}`;
    const connection = await amqp.connect(url);
    const channel = await connection.createChannel();
    const queue = 'Sample Queue';
    await channel.assertQueue(queue, { durable: true });
    const message = 'Welcome RabbitMQ + Pipedream users! ' + new Date().toISOString()
    channel.sendToQueue(queue, Buffer.from(message), { persistent: true });
    console.log(`Sent: ${message}`);
    const queueInfo = await channel.checkQueue(queue);
    return queueInfo;
  },
})

import mysql from '@pipedream/mysql';

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

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