search

bastislack / highline-freestyle

Webapp for Highline Freestyle
GNU General Public License v3.0
10 stars 9 forks source link

feat(ci): Create script to fetch Tricks and Combos from a Google Sheet to store them in YAML Files #315

Closed WaldemarLehner closed 7 months ago

WaldemarLehner commented 8 months ago

Okay… after way too many commits to try to fix the pipeline… here it is :D

There might still be some weird edge-cases, but I believe that this should work as is.

Pipeline has a manual trigger, could add cron jobs on a daily basis or whatnot later on.

There are two ts scripts that form the "heart" of the PR:

fetchFromSheet.ts - Calls Google Sheet's API to retrieve TSV Tables. Deletes old YAML files and replaces with the new set inferred from the Sheet.

createPrForSheetsIfNeeded.ts - Checks the Git Diff and creates, updates or deleted a PR as needed.

Oh… and one more thing: Here's the Link to the sheet :) https://docs.google.com/spreadsheets/d/1h1PGIrOPx16KH8IOiMh3SD1bSh1xIWFFrSL84Xyxj38/edit

JulianDietzel commented 8 months ago

When merging we should remember to updated the appropriate section in the Wiki (it still has a note, that this script is not written and it is undefined when / how the script is triggered): https://github.com/bastislack/highline-freestyle/wiki/Backend-Overview#1-from-the-google-sheet-to-the-app

WaldemarLehner commented 7 months ago

When merging we should remember to updated the appropriate section in the Wiki (it still has a note, that this script is not written and it is undefined when / how the script is triggered): https://github.com/bastislack/highline-freestyle/wiki/Backend-Overview-(WIP)#1-from-the-google-sheet-to-the-app — @JulianDietzel

This links me to an empty page. Was that expected? The (WIP) would make me believe that there is already a page set up.

JulianDietzel commented 7 months ago

When merging we should remember to updated the appropriate section in the Wiki (it still has a note, that this script is not written and it is undefined when / how the script is triggered): https://github.com/bastislack/highline-freestyle/wiki/Backend-Overview-(WIP)#1-from-the-google-sheet-to-the-app — @JulianDietzel

This links me to an empty page. Was that expected? The (WIP) would make me believe that there is already a page set up.

Yes, the page already exists. I changed the the name of the page recently though so the link went dead. I updated the link in the original comment.