Connect PostgreSQL and Send email in our serverless environment

class PostgresSourceSelect {
    async init() {
        // TODO: Create your postgres credential
        // More info at https://yepcode.io/docs/integrations/postgres/#credential-configuration
        this.postgresPool = yepcode.integration.postgres(
            "your-postgres-credential-name"
        );
    }

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

    async close() {
        await this.postgresPool.end();
    }
}

class SmtpTargetSendEmail {
    async init() {
        // TODO: Create your smtp credential
        // More info at https://yepcode.io/docs/integrations/smtp/#credential-configuration
        this.nodemailer = yepcode.integration.smtp("your-smtp-credential-name");
        this.items = [];
    }

    async consume(item) {
        // we save the items for later
        this.items.push(item);
        // we could send a mail per item here if we want to
    }

    async close() {
        // we want to send a resume mail so we send it at the end
        // TODO: Customize email content
        const text = `Here are the items we got:
    ${this.items.map((item) => ` * ${item.id}: ${item.name}`).join("\n")}`;
        // TODO: Customize email params: from, to and subject
        await this.nodemailer.sendMail({
            from: "your-email@example.com",
            to: "the-target@example.com",
            subject: `Choose your subject`,
            text,
        });
    }
}