gatsby-node.js

/**
import publicLoader from './.cache/loader';
 * Implement Gatsby's Node APIs in this file.
 *
 * See: https://www.gatsbyjs.org/docs/node-apis/
 */
const fetch = require("node-fetch")
const csv2json = require("csvtojson")
const path = require("path")
const ae = require("./ae")
const gn = require("./gn")
// const GOOGLE_SPREADSHEET_ID = "14kreo2vRo1XCUXqFLcMApVtYmvkEzWBDm6b8fzJNKEc"
const LANGUAGES = ["zh", "en"]
const { request } = require("graphql-request")
const { getPath, getWarTipPath } = require("./src/utils/urlHelper")
const isDebug = process.env.DEBUG_MODE === "true"
const moment = require("moment")
const fs = require("fs")

const PUBLISHED_SPREADSHEET_I18N_URL =
  "https://docs.google.com/spreadsheets/d/e/2PACX-1vRTVp8L95wLd23_2CuA57V-lU6tCRhGAPWSCghGhBuV4xKV_XMVjniCEoDxZnBMXEJ2MPlAi6WzOxlp/pub?gid=0"
const PUBLISHED_SPREADSHEET_WARS_CASES_URLS = [
  "https://docs.google.com/spreadsheets/d/e/2PACX-1vSr2xYotDgnAq6bqm5Nkjq9voHBKzKNWH2zvTRx5LU0jnpccWykvEF8iB_0g7Tzo2pwzkTuM3ETlr_h/pub?gid=0",
  "https://docs.google.com/spreadsheets/d/e/2PACX-1vT-Xw-QHYydz_kJCJLBqTKGbb2OF8_gisdUsduPbdR6Dp3tLbWxy_mkfRx2tMmGJ0q64uNsLLv3bbfb/pub?gid=0",
]
const PUBLISHED_SPREADSHEET_DODGY_SHOPS_URL =
  "https://docs.google.com/spreadsheets/d/e/2PACX-1vT_CejomuSCl7198EZ7JgujiAfcxwao-4_X5d3V8VasBKGTvSVtfPrFCl3NGMEwo_a6wZbmKZcqV-sB/pub?gid=1018551822"
const PUBLISHED_SPREADSHEET_WARS_TIPS_URL =
  "https://docs.google.com/spreadsheets/d/e/2PACX-1vR6Zri9Rt6egCzKgs2PBdyCpEECI338XZ3UwqJqfEpffW6tnlterGLRne8uS1EKy6tS_Ba4u5OKitmP/pub?gid=0"
const PUBLISHED_SPREADSHEET_DISRUPTION_URL =
  "https://docs.google.com/spreadsheets/d/e/2PACX-1vS0gZ-QBC6JGMS28kYUMz90ZNXFb40CtoLtOIC-QzzlqhPKCIrAojuuN2GX6AXaECONvxJd84tpqzFd/pub?gid=0"
const PUBLISHED_SPREADSHEET_DISRUPTION_DESCRIPTION_URL =
  "https://docs.google.com/spreadsheets/d/e/2PACX-1vS0gZ-QBC6JGMS28kYUMz90ZNXFb40CtoLtOIC-QzzlqhPKCIrAojuuN2GX6AXaECONvxJd84tpqzFd/pub?gid=268131605"
const PUBLISHED_SPREADSHEET_WARS_CASES_LOCATION_URLS = [
  "https://docs.google.com/spreadsheets/d/e/2PACX-1vT6aoKk3iHmotqb5_iHggKc_3uAA901xVzwsllmNoOpGgRZ8VAA3TSxK6XreKzg_AUQXIkVX5rqb0Mo/pub?gid=0",
  "https://docs.google.com/spreadsheets/d/e/2PACX-1vQVRg6iiYOHZwLsXdZE6TVWBO7Cldi07NUnbeVY3nI97_IjyG3jiWnjaUS51HRNJI1fN3io1paMa6jZ/pub?gid=0",
]
const PUBLISHED_SPREADSHEET_BOT_WARS_LATEST_FIGURES_URL =
  "https://docs.google.com/spreadsheets/d/e/2PACX-1vTiCndDnXu6l5ZKq2aAVgU2xM3WGGW68XF-pEbLAloRbOzA1QwglLGJ6gTKjFbLQGhbH6GR2TsJKrO7/pub?gid=0"
const PUBLISHED_OVERRIDE_MASTER_URL =
  "https://docs.google.com/spreadsheets/d/e/2PACX-1vQc-XdUlx2VuIqZ71qze1Mg5m11OwA8wL5fYLdlU1VC1PcEqrRrKL6fL5_FbtihOtmeAi7t1puDXOvG/pub?gid=0"
const PUBLISHED_SPREADSHEET_FRIENDLY_LINK_URL =
  "https://docs.google.com/spreadsheets/d/e/2PACX-1vRrwN4gNtogizNkYKGzMXpa7GTNJhE_vkZuYiFraU7f-N7ZKiT-araG-0jb586kczxc9Ua6oht8SVcE/pub?gid=0"
// const PUBLISHED_SPREADSHEET_WARS_CASES_LOCATION_599C_URL =
//   "https://docs.google.com/spreadsheets/d/e/2PACX-1vQcfO-bjeNxNSJ2AFQdv-a855leMyzgO7Q7QXwgCGGmCAx7PwUxgrfcuJM8BLDCQL-nwnt123OZ4_mT/pub?gid=456240224"
const PUBLISHED_SPREADSHEET_TRAVEL_ALERT_URL =
  "https://docs.google.com/spreadsheets/u/1/d/e/2PACX-1vQOnfZtGysW5qVe9FferSvhSODKa9ASH7SeqCGAGJSz8ZV7POm3kzFqfkbVAgryHKdj9WwLKXJai332/pub?gid=0"
const PUBLISHED_SPREADSHEET_IMPORTANT_INFORMATION_URL =
  "https://docs.google.com/spreadsheets/d/e/2PACX-1vShepjZrGpn8QlN8R3QFrIVhWLg9l0F99wYR9khAnhmoydOP7hkS2_L1imCjH9nHkqVQf3xGrUAi8Na/pub?gid=257173560"
// const PUBLISHED_SPREADSHEET_SITE_CONFIG_URL =
//   "https://docs.google.com/spreadsheets/d/e/2PACX-1vRUN7eL0XjPbkcmxnWKPH9_AOiRiIVcH25nLkOgbfRN7y1gk9tBucufIcLWTFFjjgMJNQmOxIFeU_Sk/pub?gid=0"
const PUBLISHED_SPREADSHEET_WARS_CASES_RELATIONSHIP_URL =
  "https://docs.google.com/spreadsheets/d/e/2PACX-1vQS7Aay-dZbemZAxbW1oVrC5QKnT9wPjd55hSGGnXGj8_jdZJa9dsKYI--dTv4EU--xt_HGIDZsdNEw/pub?gid=0"
const PUBLISHED_SPREADSHEET_ALERT_URL =
  "https://docs.google.com/spreadsheets/d/e/2PACX-1vRWN6o99FDJN4KsnAyq9KeWKEerF2_v1Z0wWbKiHPI0_Whuf00ZLW2n-GfoXciKgVXkBSoBEz6IhreC/pub?gid=0"
const PUBLISHED_SPREADSHEET_UPDATES_URL =
  "https://docs.google.com/spreadsheets/d/e/2PACX-1vRY5OHr2hX8Xl_tJR1BgrffhoiVxqjngCu9W262MgyW5ZCXuZFaj1Od0PQJqNeRJ7ocUacI2WnodeTT/pub?gid=257173560"
const GRAPHQL_URL = "https://api2.vote4.hk/v1/graphql"

const createIMMDNode = async ({
  actions: { createNode },
  createNodeId,
  createContentDigest,
}) => {
  const type = "Immd"
  const addNodeByGate = async gate => {
    const query = `{
      wars_immd(order_by: {date: desc}, limit: 2, where: {location: {_eq: "${gate}"}}) {
        arrival_hong_kong
        arrival_mainland
        arrival_other
        arrival_total
        date
        departure_hong_kong
        departure_mainland
        departure_other
        departure_total
        location
      }
    }`
    const data = await request(GRAPHQL_URL, query)
    data.wars_immd.forEach((p, i) => {
      const gateKey = gate.replace(/[- ]/g, "")
      const meta = {
        id: createNodeId(`${type}${gateKey}-${i}`),
        parent: null,
        children: [],
        internal: {
          type: `${type}${gateKey}`,
          contentDigest: createContentDigest(p),
        },
      }
      const node = Object.assign({}, p, meta)
      createNode(node)
    })
  }
  addNodeByGate("Airport")
  addNodeByGate("Hong Kong-Zhuhai-Macao Bridge")
  addNodeByGate("Shenzhen Bay")
  addNodeByGate("Total")
}

const createWorldCasesNode = async ({
  actions: { createNode },
  createNodeId,
  createContentDigest,
}) => {
  const lastWeek = moment()
    .add(-15, "days") // temp fix as we lost some baidu data
    .format("YYYY-MM-DD")
  const type = "BaiduInternationalData"

  const query = `{
    wars_BaiduInternationalData (
      where: {
        date: { 
          _gt: "${lastWeek}"
        }
      }
      distinct_on: [date, area]
      order_by: [
        {date: desc},
        {area: desc},
        {time: desc},
      ]
    ) {
      area
      date
      time
      confirmed
      died
      crued
    }
  }`

  const baiduChinaQuery = `{
    wars_BaiduChinaData (
      where: {
        date: { 
          _gt: "${lastWeek}"
        }
      }
      distinct_on: [date, area, city]
        order_by: [
          {date: desc},
          {area: desc},
          {city: desc},
          {time: desc},
        ]
      ) {
        area
        city
        date
        time
        confirmed
        died
        crued
      }
  }`

  const data = await request(GRAPHQL_URL, query)
  const baiduChinaData = await request(GRAPHQL_URL, baiduChinaQuery)

  data.wars_BaiduInternationalData.forEach((p, i) => {
    const meta = {
      id: createNodeId(`${type}-${i}`),
      parent: null,
      children: [],
      internal: {
        type,
        contentDigest: createContentDigest(p),
      },
    }
    const node = Object.assign({}, p, meta)
    createNode(node)
  })

  let count = data.wars_BaiduInternationalData.length
  let chinaCured = {}
  let chinaDied = {}
  let chinaConfirmed = {}
  let availableDate = []
  let dateTimeMapping = {}

  baiduChinaData.wars_BaiduChinaData.forEach(p => {
    if (
      p.area === "香港" ||
      p.area === "颱灣" ||
      p.area === "台灣" ||
      p.area === "澳門"
    ) {
      const node_data = {
        area: p.area === "颱灣" ? "台灣" : p.area,
        date: p.date,
        time: p.time,
        confirmed: p.confirmed,
        died: p.died,
        crued: p.crued,
      }
      const meta = {
        id: createNodeId(`${type}-${count}`),
        parent: null,
        children: [],
        internal: {
          type,
          contentDigest: createContentDigest(node_data),
        },
      }
      const node = Object.assign({}, node_data, meta)
      createNode(node)
      count += 1
    } else if (p.city === "") {
      if (availableDate.includes(p.date)) {
        chinaCured[p.date] += p.crued
        chinaDied[p.date] += p.died
        chinaConfirmed[p.date] += p.confirmed
      } else {
        availableDate.push(p.date)
        dateTimeMapping[p.date] = p.time
        chinaCured[p.date] = p.crued
        chinaDied[p.date] = p.died
        chinaConfirmed[p.date] = p.confirmed
      }
    }
  })

  availableDate.forEach(date => {
    const node_data = {
      area: "中国",
      date: date,
      time: dateTimeMapping[date],
      confirmed: chinaConfirmed[date],
      died: chinaDied[date],
      crued: chinaCured[date],
    }
    const meta = {
      id: createNodeId(`${type}-${count}`),
      parent: null,
      children: [],
      internal: {
        type,
        contentDigest: createContentDigest(node_data),
      },
    }
    const node = Object.assign({}, node_data, meta)
    createNode(node)
    count += 1
  })
}

const createAENode = async ({
  actions: { createNode },
  createNodeId,
  createContentDigest,
}) => {
  const type = "AEWaitingTime"
  const output = await ae.fetchAEWaitingTime()
  const { records } = output
  records.forEach((p, i) => {
    const meta = {
      id: createNodeId(`${type.toLowerCase()}-${i}`),
      parent: null,
      children: [],
      internal: {
        type,
        contentDigest: createContentDigest(p),
      },
    }
    const node = Object.assign({}, p, meta)
    createNode(node)
  })
}

const createGovNewsNode = async ({
  actions: { createNode, createTypes },
  createNodeId,
  createContentDigest,
}) => {
  const type = "GovNews"
  const output = await gn.fetchGovNews()
  const { records } = output

  const typeTemplate = `
    type ${type} implements Node {
      title_en: String
      title_zh: String
      link_en: String
      link_zh: String
      date: String
    }
  `
  createTypes(typeTemplate)

  records.forEach((p, i) => {
    const meta = {
      id: createNodeId(`${type.toLowerCase()}-${i}`),
      parent: null,
      children: [],
      internal: {
        type,
        contentDigest: createContentDigest(p),
      },
    }
    const node = Object.assign({}, p, meta)
    createNode(node)
  })
}

// const createNode = async (
//   { actions: { createNode }, createNodeId, createContentDigest },
//   sheetName,
//   type
// ) => {
//   // All table has first row reserved
//   const result = await fetch(
//     `https://docs.google.com/spreadsheets/d/${GOOGLE_SPREADSHEET_ID}/gviz/tq?tqx=out:csv&sheet=${sheetName}&range=A2:ZZ&headers=0`
//   )
//   const data = await result.text()
//   const records = await csv2json().fromString(data)
//   records.forEach((p, i) => {
//     // create node for build time data example in the docs
//     const meta = {
//       // required fields
//       id: createNodeId(`${type.toLowerCase()}-${i}`),
//       parent: null,
//       children: [],
//       internal: {
//         type,
//         contentDigest: createContentDigest(p),
//       },
//     }
//     const node = Object.assign({}, p, meta)
//     createNode(node)
//   })
// }

const createPublishedGoogleSpreadsheetNode = async (
  { actions: { createNode, createTypes }, createNodeId, createContentDigest },
  publishedURLs,
  type,
  { skipFirstLine = false, alwaysEnabled = false, subtype = null }
) => {
  // All table has first row reserved

  let urls = publishedURLs
  if (typeof publishedURLs === "string") {
    urls = [publishedURLs]
  }

  const requests = urls.map(url => {
    return fetch(
      `${url}&single=true&output=csv&headers=0${
        skipFirstLine ? "&range=A2:ZZ" : ""
      }&q=${Math.floor(new Date().getTime(), 1000)}`
    )
      .then(result => result.text())
      .then(data => csv2json().fromString(data))
  })

  const records = await Promise.all(requests)

  const filteredRecords = records
    .flat()
    .filter(
      r => alwaysEnabled || (isDebug && r.enabled === "N") || r.enabled === "Y"
    )

  if (filteredRecords.length > 0) {
    filteredRecords.forEach((p, i) => {
      // create node for build time data example in the docs
      const meta = {
        // required fields
        id: createNodeId(
          `${type.toLowerCase()}${subtype ? `-${subtype}` : ""}-${i}`
        ),
        parent: null,
        children: [],
        internal: {
          type,
          contentDigest: createContentDigest(p),
        },
      }
      const node = { ...p, subtype, ...meta }
      createNode(node)
    })
  } else if (records.length > 0) {
    // So if filtered rows is empty,
    // we manually create the type here.

    // TODO: handle not even a single row ...
    const fields = Object.keys(records[0])
    const fieldString = fields.map(field => `${field}: String`).join("\n")
    const typeTemplate = `
      type ${type} implements Node {
        ${fieldString}
      }
    `
    createTypes(typeTemplate)
  }
}

/*
  =============== Gatsby API starts =================
*/

exports.onCreatePage = async ({ page, actions }) => {
  const { createPage, deletePage } = actions
  return new Promise(resolve => {
    // If it is already eng path we skip to re-generate the locale
    if (!page.path.match(/^\/en/)) {
      deletePage(page)
      LANGUAGES.forEach(lang => {
        const path = getPath(lang, page.path)
        createPage({
          ...page,
          matchPath: page.path.includes("cases")
            ? (path + "/*").replace(/[/]+\*/, "/*")
            : page.matchPath,
          path,
          context: {
            ...page.context,
            locale: lang,
          },
        })
      })
    }

    resolve()
  })
}

exports.onCreateWebpackConfig = ({ stage, loaders, actions, getConfig }) => {
  if (stage === "build-html") {
    const regex = [
      /node_modules\/leaflet/,
      /node_modules\\leaflet/,
      /node_modules\/pixi.js/,
      /node_modules\\pixi.js/,
    ]
    actions.setWebpackConfig({
      module: {
        rules: [
          {
            test: regex,
            use: loaders.null(),
          },
        ],
      },
    })
  }
  if (getConfig().mode === "production") {
    actions.setWebpackConfig({
      devtool: false,
    })
  }
}

exports.sourceNodes = async props => {
  await Promise.all([
    createPublishedGoogleSpreadsheetNode(
      props,
      PUBLISHED_SPREADSHEET_I18N_URL,
      "i18n",
      { skipFirstLine: false, alwaysEnabled: true }
    ),
    createPublishedGoogleSpreadsheetNode(
      props,
      PUBLISHED_SPREADSHEET_WARS_CASES_URLS,
      "WarsCase",
      { skipFirstLine: true }
    ),
    createPublishedGoogleSpreadsheetNode(
      props,
      PUBLISHED_SPREADSHEET_WARS_CASES_LOCATION_URLS,
      "WarsCaseLocation",
      {
        skipFirstLine: true,
        subtype: "default",
      }
    ),
    // createPublishedGoogleSpreadsheetNode(
    //   props,
    //   PUBLISHED_SPREADSHEET_WARS_CASES_LOCATION_599C_URL,
    //   "WarsCaseLocation",
    //   {
    //     skipFirstLine: true,
    //     subtype: "599c",
    //   }
    // ),
    createPublishedGoogleSpreadsheetNode(
      props,
      PUBLISHED_SPREADSHEET_DODGY_SHOPS_URL,
      "DodgyShop",
      { skipFirstLine: true }
    ),
    createPublishedGoogleSpreadsheetNode(
      props,
      PUBLISHED_SPREADSHEET_WARS_TIPS_URL,
      "WarsTip",
      { skipFirstLine: true }
    ),
    createPublishedGoogleSpreadsheetNode(
      props,
      PUBLISHED_SPREADSHEET_DISRUPTION_URL,
      "Disruption",
      { skipFirstLine: true }
    ),
    createPublishedGoogleSpreadsheetNode(
      props,
      PUBLISHED_SPREADSHEET_DISRUPTION_DESCRIPTION_URL,
      "DisruptionDescription",
      { skipFirstLine: true }
    ),
    createPublishedGoogleSpreadsheetNode(
      props,
      PUBLISHED_SPREADSHEET_BOT_WARS_LATEST_FIGURES_URL,
      "BotWarsLatestFigures",
      { skipFirstLine: true, alwaysEnabled: true }
    ),
    createPublishedGoogleSpreadsheetNode(
      props,
      PUBLISHED_OVERRIDE_MASTER_URL,
      "WarsLatestFiguresOverride",
      { skipFirstLine: true, alwaysEnabled: true }
    ),
    createPublishedGoogleSpreadsheetNode(
      props,
      PUBLISHED_SPREADSHEET_FRIENDLY_LINK_URL,
      "FriendlyLink",
      { skipFirstLine: true }
    ),
    createPublishedGoogleSpreadsheetNode(
      props,
      PUBLISHED_SPREADSHEET_TRAVEL_ALERT_URL,
      "BorderShutdown",
      { skipFirstLine: true }
    ),
    createPublishedGoogleSpreadsheetNode(
      props,
      PUBLISHED_SPREADSHEET_ALERT_URL,
      "Alert",
      { skipFirstLine: true }
    ),
    createPublishedGoogleSpreadsheetNode(
      props,
      PUBLISHED_SPREADSHEET_IMPORTANT_INFORMATION_URL,
      "ImportantInformation",
      { skipFirstLine: true }
    ),
    createPublishedGoogleSpreadsheetNode(
      props,
      PUBLISHED_SPREADSHEET_UPDATES_URL,
      "Updates",
      { skipFirstLine: true }
    ),
    // createPublishedGoogleSpreadsheetNode(
    //   props,
    //   PUBLISHED_SPREADSHEET_SITE_CONFIG_URL,
    //   "SiteConfig",
    //   { skipFirstLine: true }
    // ),
    createPublishedGoogleSpreadsheetNode(
      props,
      PUBLISHED_SPREADSHEET_WARS_CASES_RELATIONSHIP_URL,
      "WarsCaseRelation",
      { skipFirstLine: true }
    ),
    createAENode(props),
    createIMMDNode(props),
    createGovNewsNode(props),
    createWorldCasesNode(props),
  ])
}

// https://www.gatsbyjs.org/docs/schema-customization/#foreign-key-fields
exports.createSchemaCustomization = ({ actions, schema }) => {
  const { createTypes } = actions
  const typeDefs = [
    `type WarsCase implements Node {
      locations: [WarsCaseLocation] @link(by: "case_no", from: "case_no") # easy back-ref
    }`,
    `type WarsCaseLocation implements Node {
      case: WarsCase @link(by: "case_no", from: "case_no")
    }`,
  ]
  createTypes(typeDefs)
}

exports.createPages = async ({ graphql, actions }) => {
  actions.createRedirect({
    fromPath: `/hygiene-tips`,
    toPath: `/wars-tips`,
    redirectInBrowser: false,
    isPermanent: true,
  })

  const result = await graphql(`
    query {
      allI18N {
        edges {
          node {
            key
            en
            zh
          }
        }
      }
      allWarsTip {
        edges {
          node {
            title
            text
            date
            image_url
            source_description
            source_url
            tags
            language
          }
        }
      }
      allWarsCase {
        edges {
          node {
            case_no
            onset_date
            confirmation_date
            gender
            age
            hospital_zh
            hospital_en
            status
            status_zh
            status_en
            type_zh
            type_en
            citizenship_zh
            citizenship_en
            detail_zh
            detail_en
            classification
            classification_zh
            classification_en
            source_url_1
            source_url_2
            source_url_3
            source_url_4
            source_url_5
          }
        }
      }
      allWarsCaseRelation {
        edges {
          node {
            case_no
            name_zh
            name_en
            description_zh
            description_en
          }
        }
      }
      patientTrack: allWarsCaseLocation(
        sort: { order: DESC, fields: end_date }
      ) {
        group(field: case___case_no) {
          fieldValue
          edges {
            node {
              case_no
              start_date
              end_date
              sub_district_zh
              sub_district_en
              location_zh
              location_en
              action_zh
              action_en
              remarks_zh
              remarks_en
              source_url_1
              source_url_2
            }
          }
        }
      }
    }
  `)

  // Generate i18n translation json file
  const translations = {
    zh: {},
    en: {},
  }
  result.data.allI18N.edges.forEach(edge => {
    const {
      node: { key, en, zh },
    } = edge
    translations["zh"][key] = zh
    translations["en"][key] = en
  })

  LANGUAGES.forEach(lang => {
    fs.mkdirSync(`src/locales/${lang}`, { recursive: true })
    fs.writeFileSync(
      `src/locales/${lang}/translation.json`,
      JSON.stringify(translations[lang])
    )
  })

  result.data.allWarsTip.edges.forEach(({ node }) => {
    // This will not trigger onCreatePage
    LANGUAGES.forEach(lang => {
      const uri = getWarTipPath(lang, node.title)
      if (node.language !== lang) {
        // actions.createRedirect not working here.. dont know why
        // so create a client side redirect here
        actions.createPage({
          path: uri,
          component: path.resolve(`./src/templates/redirect.js`),
          context: {
            uri,
            redirectURL: getPath(lang, "/wars-tips/"),
            locale: lang,
          },
        })
      } else {
        actions.createPage({
          path: uri,
          component: path.resolve(`./src/templates/wars-tip.js`),
          context: {
            // Data passed to context is available
            // in page queries as GraphQL variables.
            node,
            locale: lang,
            uri,
          },
        })
      }
    })
  })

  const groupArray = []
  result.data.allWarsCaseRelation.edges.forEach(({ node }, id) => {
    node.id = id + 1
    node.case_no.split(",").forEach(nodeCase => {
      groupArray.push({
        ...node,
        related_cases: node.case_no,
        case_no: parseInt(nodeCase),
      })
    })
  })
  return Promise.resolve(null)
}
exports.onPostBuild = async ({ graphql, reporter }) => {
  reporter.info("Injecting cases pages sitemap record")
  const fs = require("fs")
  const result = await graphql(`
    query {
      allWarsCase {
        edges {
          node {
            case_no
          }
        }
      }
    }
  `)
  const template = no =>
    `<url> <loc>https://wars.vote4.hk/cases/${no}</loc> <changefreq>daily</changefreq> <priority>0.7</priority> </url>
<url> <loc>https://wars.vote4.hk/en/cases/${no}</loc> <changefreq>daily</changefreq> <priority>0.7</priority> </url>`
  const caseNos = result.data.allWarsCase.edges.map(i => i.node.case_no)
  const sitemapXml = fs.readFileSync("./public/sitemap.xml", "utf-8")
  const caseNoSitemap = caseNos.map(template).join("\n")
  fs.writeFileSync(
    "./public/sitemap.xml",
    sitemapXml.replace("</urlset>", caseNoSitemap + "\n</urlset>")
  )
  reporter.info("Setup cases routes and symlink for github SPA fallback")
  for (const case_no of caseNos) {
    try {
      if (!fs.existsSync(`./public/cases/${case_no}`))
        fs.mkdirSync(`./public/cases/${case_no}`)
      if (!fs.existsSync(`./public/cases/${case_no}/index.html`))
        fs.symlinkSync("../index.html", `./public/cases/${case_no}/index.html`)
      if (!fs.existsSync(`./public/en/cases/${case_no}`))
        fs.mkdirSync(`./public/en/cases/${case_no}`)
      if (!fs.existsSync(`./public/en/cases/${case_no}/index.html`))
        fs.symlinkSync(
          "../index.html",
          `./public/en/cases/${case_no}/index.html`
        )
    } catch (error) {
      console.error(error)
    }
  }
}