Connect Microsoft SQL Server and Kafka in our serverless environment

class MssqlSourceSelect {
    async init() {
        // TODO: Create your mssql credential
        // More info at https://yepcode.io/docs/integrations/mssql/#credential-configuration
        const mssqlConnectionPool = yepcode.integration.mssql(
            "your-mssql-credential-name"
        );
        this.pool = await mssqlConnectionPool.connect();
    }

    async fetch(publish, done) {
        // TODO: Customize your sql query
        const {
            recordset
        } = await this.pool.query(
            "SELECT * FROM your_table LIMIT 10"
        );
        for (const row of recordset) {
            await publish(row);
        }
        done();
    }

    async close() {
        await this.pool.close();
    }
}

class KafkaTargetSendMessage {
    async init() {
        // TODO: Create your kafka credential
        // More info at https://yepcode.io/docs/integrations/kafka/#credential-configuration
        const kafka = yepcode.integration.kafka("your-kafka-credential-name");
        this.producer = kafka.producer();
        await this.producer.connect();
    }

    async consume(item) {
        // TODO: customize your message and topic
        const message = `Your message content ${item.name}`;
        await this.producer.send({
            topic: "your-topic",
            messages: [{
                value: message
            }],
        });
    }

    async close() {
        await this.producer.disconnect();
    }
}