Changelog

This document records the main changes to the sdssdb code.

Next release

• [Feature]: New framework for writing tests against databases

• [Bug] #28: Temporarily remove SQLAlchemy implementation of sds5db since it’s not maintained. We may reintroduce it later once the schema is stable.

• Add PeeweeDatabaseConnection.get_model to retrieve the model for a given table.

• New tools for database maintenance/internals.

• New tools for table ingestion.

• Changes to the schema display tools.

• Reimplementation of most catalogdb PeeWee model classes for catalogdb using reflection.

• A new ReflectMeta metaclass that provides reflection for PeeWee models (with some caveats).

• Many changes to the catalogdb schema files and PeeWee implementation to match the contents to SDSS-V v0 target selection.

• Write tests either for peewee or sqlalchemy databases

• Adds ability to test against real or fake databases

• Adds ability to generate fake data based on real database models for tests

• Test suite only runs where existing local databases found. Optionally run only peewee or sqlalchemy tests.

0.3.2 2020-03-10

• New schema and models for sdss5db.targetdb.

• Change operations-test profile to operations using the new machine hostname.

0.3.1 2020-02-24

• Fix import of mangadb schema in Plate.mangadb_plate.

• [Bug] #18: Fixed Travis built after migration to using setup.cfg.

• Added archive database with sas schema.

0.3.0 2019-09-23

• [Feature] #15: New CLI file2db and associated tools to create and load a table from a file. Also added Numpy adaptors.

• [Feature] #14: Add support for table DR14Q_v4_4 in catalogdb.

• [Feature] #16: Changed the package internals to use setup.cfg.

• [Feature] #13: Add support for schema apogeeqldb in operationsdb.

• connect now accepts user, host, and port to override the default profile parameters.

• Updated schema for mangadb.Plate.

• Added TIC v8.

• Removed TIC v6.

0.2.2 2019-07-24

• Update PyYAML requirement to 5.1 and use explicit loader.

• Improved descriptions in setup.py and README.rst.

• Added operationsdb SQL schemas.

• Fixed import of database connections when Peewee or SQLAlchemy are not available.

0.2.1 2018-12-14

• [Bug]: Remove bin/sdssdb from the list of scripts to install. This was making the build process fail.

0.2.0 2018-12-14

• [Feature] #7: Added create_schema_graph function to generate schema graphs and use it to auto-generate graphs in the documentation for the supported databases.

• Improve model __repr__.

• Use pts_key for fk relationship between TwoMassClean and TwoMassPsc.

• Use tmass_pts_key for fk relationship between GaiaDR2TmassBestNeighbour and TwoMassPsc.

• Added mangadb schema for SQLA.

• Fixed command line example about how to install with sdss_install.

• Removed some unused files from the template.

0.1.1 2018-12-10

• Set python_requires='>=3.6'.

0.1.0 2018-12-10

• Basic documentation.

• Implemented database connection switching in SQLAlchemy.

• Support for sdss5db, operationsdb (apodb/lcodb), and manga (only in SQLAlchemy).

• DatabaseConnection class with Peewee and SQLA subclasses.

• Initial version.