search

codeforboston / home-energy-analysis-tool

https://www.codeforboston.org/projects/
MIT License
12 stars 31 forks source link

Set up a database. #243

Closed AdamFinkle closed 1 month ago

AdamFinkle commented 2 months ago

Created a schema.prisma for SQLite, containing a model of a NormalizedBillingPeriodRecord, and generated a database in a separate stack folder.

thadk commented 2 months ago

Thank you for this first stab at a database with rules-engine shaped tables, Adam and team.

I'm going to make this a draft PR for now. As we talked through during hacknight, please ultimately use the existing https://github.com/codeforboston/home-energy-analysis-tool/blob/main/heat-stack/prisma/schema.prisma and other prisma database setup files so we can easily deploy to Fly.io and docker.