Connect Keycloak users and AWS Redshift in our serverless environment

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

    async fetch(publish, done) {
        // TODO: Customize your find users payload
        // See possible options at: https://www.keycloak.org/docs-api/18.0/rest-api/#_users_resource
        const users = await this.keycloakClient.users.find({
            email: "yep",
            exact: false, // An example to search users with email containing "yep"
            max: 100,
        });

        // Each user is an object with content following the structure you can find at: 
        // https://www.keycloak.org/docs-api/18.0/rest-api/#_userrepresentation
        for (const user of users) {
            await publish(user);
        }
        done();
    }

    async close() {}
}

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

    async consume(item) {
        // TODO: Customize your sql query
        const sqlStatement = `INSERT INTO your-table-name VALUES (${item.someProp}, '${item.someStringProp}')`;

        // TODO: Customize the command to be executed
        // More info at https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/clients/client-redshift-data/interfaces/executestatementcommandinput.html
        this.awsRedshift.send(
            new ExecuteStatementCommand({
                ClusterIdentifier: "your-cluster-identifier",
                Database: "your-database",
                DbUser: "your-db-user",
                Sql: sqlStatement,
            })
        );
    }

    async close() {}
}