Modify the schema with a new Regimes table

SIMPLE-AstroDB / SIMPLE-db

BSD 3-Clause "New" or "Revised" License

11 stars 21 forks source link

Closed kelle closed 4 months ago

kelle commented 5 months ago

Add a new Regimes table. Closes #271
Make SpectralTypes, Spectra, and Gravities use Regimes.regime as a foreign key. CLoses #271
Implement conftest.py to create the database fixtures used by the tests. Closes #467.
Moved REFERENCE_TABLE to schema.py Closes #460

~~Waiting for #470~~ - Done

kelle commented 5 months ago

~~If I load the new schema, I can make a new database connection, but when I try to save it, I get this error:~~ I fixed this.

kelle commented 5 months ago

I made a bunch of changes to the tests by implementing a conftest.py to initiate the test databases. @dr-rodriguez , could you take a look?

I also don't know how to make the ParallaxView test work. New issue #474 .

Once #470 gets merged with the cleaned up regimes, I'll try (again) to make the Regimes table a Foreign Key on the Spectra and SpectralTypes tables.

kelle commented 5 months ago

Not sure why I needed to add the home directory by hand to the paths, but it made the github tests pass!