Static site for viewing cocktails
TODO:
- simple syrup and recipe pages, ignore others
- scale up, price out
- create "events pages" with certain recipes: I think just have events in tags
- have page mapping generic spirits to brands
- allow recipes to specify generic spirits or lists of spirits (with default)
- public and private recipes (with tags)
Comments: can use utterances, but any of the "bot automatically creates issue" options for how to match issue and page will have the bot post the link to the specific page, which defeats the purpose of having the site behind the password. works fine if we create issues, but then if issue doesn't exist, the comment thing just doesn't load, so we'd need to manually create issues for every page. could probably do that using github api but ... doesn't seem ideal.
looking on the issues, it looks like it's possible to get it working with a private repo, but then the bot and everyone who wants to post needs to be added as contributors (so one extra step involved).
This repo has several python scripts which are used to grab data from Sheets and
format it before building the website. To use, install dependencies found in
scripts/requirements.txt.
download_csv.py and convert_old_csv.py are only used to get the data into
the proper format and don't need to be run regularly, while write_markdown.py
is used to get the data ready for the website and so needs to be run everytime
the site is built.
scripts/download_csv.py: downloads all sheets from specified Google Spreadsheet as csvs in a single directory.- This accepts the spreadsheet ID and path to the credentials json file as inputs
- spreadsheet_id can be found in the url of the google spreadsheet, between
/d/and/edit - For how to create the credentials file of a service account and give them access, see first two steps of: https://github.com/marketplace/actions/gsheet-action#setup-of-credentials
scripts/convert_old_csv.py: convert old csvs (as created bydownload_csv.py) into new format and upload them to a new spreadsheet.- Getting this to run on the outputs of the above required some manual editing.
- Each csv file has a
sheet_titlefield; we will clear any sheet found with this name in the target spreadsheet and then write the new contents. - This accepts the spreadsheet ID and path to the credentials json file as
inputs. Note that the spreadsheet ID should be to a different sheet than
download_csv.py! - spreadsheet_id can be found in the url of the google spreadsheet, between
/d/and/edit - For how to create the credentials file of a service account and give them access, see first two steps of: https://github.com/marketplace/actions/gsheet-action#setup-of-credentials
scripts/write_markdown.py: download all sheets from Google Spreadsheet as markdown files in a single directory. Unlikedownload_csv.py, this makes assumptions about how they're formatted.- This accepts the spreadsheet ID and path to the credentials json file as
inputs. The spreadsheet ID should be the same as from
convet_old_csv.py - spreadsheet_id can be found in the url of the google spreadsheet, between
/d/and/edit - For how to create the credentials file of a service account and give them access, see first two steps of: https://github.com/marketplace/actions/gsheet-action#setup-of-credentials
- This accepts the spreadsheet ID and path to the credentials json file as
inputs. The spreadsheet ID should be the same as from