We should figure out how to get data from the existing spreadsheets provided by Rose into the D1 instance.
This probably is going to be some combination of
- Download Rose's excel file
- Excel magic to format it into a nice CSV
- Parse that CSV into rows of SQL inserts
- SQL insert that into the database
You can test this by cloning the worker repo locally, then running npx wrangler dev to run a local SQLlite instance.
once it's done, ping @some-molasses and i'll replicate on prod (if we're ready to)
We should figure out how to get data from the existing spreadsheets provided by Rose into the D1 instance.
This probably is going to be some combination of
You can test this by cloning the worker repo locally, then running
npx wrangler devto run a local SQLlite instance.once it's done, ping @some-molasses and i'll replicate on prod (if we're ready to)