This repository has been archived by the owner on Jan 12, 2024. It is now read-only.
Add tests for pudl.sqlite
and ferc1.sqlite
#76
Labels
inframundo
sqlite
A file based relational database that we use for distributing much of the PUDL data.
testing
Automated software testing and data validation often done with CI / GitHub Actions
Right now CI only tests whether the EPA CEMS parquet data is working, but we've included the
pudl.sqlite
andferc1.sqlite
databases in the manifest as well, so they also need to be tested.Messing around with the
v2022.11.30
data I found that there were a variety of issues with some tables in the PUDL DB, and none of the data in the ferc1 DB was accessible so... there's work to be done here. I've implemented just the most basic tests as an example of some of these problems in #75 and marked the ones that aren't working withxfail
.Some potential tests to implement
urlpath
topudl.sqlite
looks reasonableurlpath
toferc1.sqlite
looks reasonablepudl.sqlite
ferc1.sqlite
pudl.sqlite
is at least some minimum.ferc1.sqlite
is at least some minimum.pudl.sqlite
and check that it has a reasonable shape and contents.ferc1.sqlite
and check that it has a reasonable shape and contents.The text was updated successfully, but these errors were encountered: