Connect Github repository files and Clickhouse in our serverless environment

class GithubSourceRepositoryFiles {
    async init() {
        // More info at https://www.npmjs.com/package/octokit
        // TODO: Create team variables. More info at https://yepcode.io/docs/processes/team-variables
        this.github = new Octokit({
            auth: yepcode.env.GITHUB_TOKEN,
        });
        // TODO: Customize the repo name and owner
        this.repositoryOwner = "your-github-username";
        this.repositoryName = "your-repository-name";
    }

    async fetch(publish, done) {
        // TODO: Customize the path you want to obtain all files in it and its subdirectories (if has)
        // It can also be a file path to only obtain one file
        // If you pass undefined you will obtain the entire repository content
        await this._publishPathContent("/path-in-repo", publish);
        done();
    }

    _isFileContent = isString;
    _isDirectoryInfo = isObject;

    _publishPathContent = async (path, publishCallback) => {
        // More info of this request at: https://docs.github.com/en/rest/repos/contents#get-repository-content
        const response = await this.github.rest.repos.getContent({
            mediaType: {
                format: "raw",
            },
            owner: this.repositoryOwner,
            repo: this.repositoryName,
            path: path,
        });
        const {
            data
        } = response;

        if (this._isFileContent(data)) {
            // TODO: Customize the item to publish for each file in the repository
            publishCallback({
                path,
                content: data
            });
            return;
        }

        if (this._isDirectoryInfo(data)) {
            for (const directoryEntry of data) {
                await this._publishPathContent(directoryEntry.path, publishCallback);
            }
            return;
        }

        console.error("Unexpected data type: ", response.headers["content-type"]);
    };

    async close() {}
}

class ClickhouseTargetInsert {
    async init() {
        // More info at https://clickhouse.com/docs/integrations/javascript
        // TODO: Create team variables. More info at https://yepcode.io/docs/processes/team-variables
        this.clickhouse = createClient({
            url: yepcode.env.CLICKHOUSE_HOST,
            username: yepcode.env.CLICKHOUSE_USERNAME,
            password: yepcode.env.CLICKHOUSE_PASSWORD,
        });
        // TODO: customize your sql query
        // This opens insert stream for your table
        this.stream = new Stream.Readable({
            objectMode: true
        });
        this.ws = client.insert({
            table: "your_table_name",
            values: stream,
            format: "JSONCompactEachRow",
        });
    }

    async consume(item) {
        // TODO: Map your item to row
        this.stream.push(item);
    }

    async close() {
        // wait stream to finish
        this.stream.push(null);
        await this.ws;
        await this.clickhouse.close();
    }
}