Skip to content

Scheduled Workflow #8671

Scheduled Workflow

Scheduled Workflow #8671

#
# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements. See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License. You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
name: Scheduled Workflow
on:
schedule:
# Runs every 5 minutes
- cron: '*/5 * * * *'
permissions:
statuses: write
pull-requests: read
issues: read
jobs:
process-new-and-updated-prs:
runs-on: ubuntu-latest
steps:
- name: Checkout repository
uses: actions/checkout@v4
- name: Process new and updated PRs
# We have to run any actions that require write permissions here
# since the workflow triggered by events from a PR in a fork
# (not apache/xtable but other_owner/xtable) does not run on a
# GITHUB_TOKEN with write permissions (this is prohibited by
# Apache).
uses: actions/github-script@v7
with:
github-token: ${{secrets.GITHUB_TOKEN}}
script: |
// Cron schedule may not be reliable so giving buffer time to avoid missing recent PRs
const since = new Date(new Date().getTime() - (900 * 1000)).toISOString();
const query = `repo:${context.repo.owner}/${context.repo.repo} type:pr state:open base:main updated:>=${since}`;
const openPrs = await github.paginate(github.rest.search.issuesAndPullRequests, {
q: query,
sort: 'updated',
order: 'desc',
per_page: 100
});
const checkAzureCiAndCreateCommitStatus = require(`${process.env.GITHUB_WORKSPACE}/.github/workflows/azure_ci.js`);
console.log(`Number of PRs to process: ${openPrs.length}`);
for (const pr of openPrs) {
console.log(`*** Processing PR: ${pr.title}, URL: ${pr.html_url}`);
const { data: pullRequest } = await github.rest.pulls.get({
owner: context.repo.owner,
repo: context.repo.repo,
pull_number: pr.number
});
const latestCommitHash = pullRequest.head.sha;
// Create commit status based on Azure CI report to PR
await checkAzureCiAndCreateCommitStatus({
github,
context,
prNumber: pr.number,
latestCommitHash: latestCommitHash
});
}