Connect SAP HANA Cloud and OpenAI prompt in our serverless environment

class SapHanaSourceSelect {
    async init() {
        // TODO: Create your SAP HANA credential:
        // More info at https://yepcode.io/docs/integrations/sap-hana#credential-configuration
        this.connection = yepcode.integration.sapHana(
            "your-sap-hana-credential-name"
        );
    }

    async fetch(publish, done) {
        // TODO: Customize your sql query
        // https://help.sap.com/docs/SAP_HANA_CLIENT/f1b440ded6144a54ada97ff95dac7adf/a5c332936d9f47d8b820a4ecc427352c.html?locale=en-US
        const sql = "SELECT * FROM your_table";
        const rows = this.connection.exec(sql);
        for (const row of rows) {
            await publish(row);
        }
        done();
    }

    async close() {
        this.connection.disconnect();
    }
}

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

    async consume(item) {
        // TODO: Configure your prompt
        // More info at: https://platform.openai.com/docs/api-reference/completions/create
        const completion = await this.openai.completions.create({
            model: item.model,
            prompt: item.prompt,
            max_tokens: item.maxTokens,
            temperature: item.temperature,
        });

        // Use the completion for whatever you want
        console.log(completion.data.choices[0].text);
    }

    async close() {}
}