Connect Clickhouse and Monday in our serverless environment

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

    async fetch(publish, done) {
        // TODO: customize your sql query
        const sql = "SELECT * FROM your_table_name";

        const resultSet = await this.clickhouse.query({
            query: sql,
            format: "CSV",
        });
        const stream = resultSet.stream();
        stream.on("data", (rows) => {
            rows.forEach(publish);
        });
        stream.on("end", done);
    }

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

class GraphqlTargetMondayCreateItem {
    async init() {
        // TODO: Create your GraphQL credential with monday information and base url: https://api.monday.com/v2/
        // More info at https://yepcode.io/docs/integrations/http/#credential-configuration
        // Official docs: https://developer.monday.com/api-reference/docs/authentication
        this.monday = yepcode.integration.graphql("your-monday-credential-name");
    }
    async consume(item) {
        // TODO: Customize your GraphQL query
        // IMPORTANT: This example uses the api version "2023-10" recommended by Monday. Some fields could change between versions, so check the official docs for more info.
        // More info: https://developer.monday.com/api-reference/docs/items
        try {
            const data = await this.monday.request(
                gql`
          mutation createItem(
            $boardId: ID!
            $groupId: String!
            $itemName: String!
            $columnValues: JSON!
          ) {
            id
          }
        `, {
                    boardId: item.boardId,
                    groupId: item.groupId,
                    itemName: item.itemName,
                    columnValues: JSON.stringify(item.values),
                }
            );

            console.log(JSON.stringify(data, null, 2));
        } catch (error) {
            console.log(JSON.stringify(error, null, 2));
        }
    }

    async close() {}
}