Integrate the Kafka API with the MySQL API

import { Kafka } from "kafkajs"
export default defineComponent({
  props: {
    kafka: {
      type: "app",
      app: "kafka",
    }
  },
  async run({steps, $}) {

    const kafka = new Kafka({
      brokers: [`${this.kafka.$auth.host}:${this.kafka.$auth.port}`],
    });

    const consumer = kafka.consumer({ groupId: 'TestGroup' });
    await consumer.connect()
    await consumer.subscribe({ topic: 'SampleTopic', fromBeginning: true });
    let consumedMessage = "";
    const eachMessage = async function({ topic, partition, message }){
      consumedMessage = message.value.toString();
      return consumedMessage;
    };  

    await consumer.run({
      eachMessage,
    });

    const producer = kafka.producer();  
    await producer.connect()
    await producer.send({
      topic: 'SampleTopic',
      messages: [
        { value: 'Welcome KafkaJS + Pipedream users! '+ new Date().toISOString() },
      ],
    });
    await producer.disconnect();

    const data = await consumer.describeGroup();
    return { consumedMessage, groupDescription: data };
  },
})

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