sdssdb 0.4.8

• Fix name collision in previous version by changing the column_name of TIC_v8 foreign key.

sdssdb 0.4.7

• ✨ Update targetdb schema with changes to cadence, carton_to_target, and others (#66).
• 🐛 Use refection only if use_reflection=True.
• Multiple new tables for sdss5db.catalogdb related to SDSS-V target selection v0.5.
• Modifications to apogeedb dump.
• Change default FK in TIC_v8 for Tycho2.

sdssdb 0.4.6

• #43: Add a database registry
• Initial version of the sdss5db.opsdb schema.
• Added field value to carton_to_target.
• Fix reflection for catalogdb.skies_v1.
• Schema files for multiple catalogdb tables in preparation for SDSS-V target selection v0.5.
• Initial schema files for opsdb.

sdssdb 0.4.5

• Add ForeignKeyField from CatalogToSDSS_DR13_PhotoObj_Primary directly to SDSS_DR13_PhotoObj.

sdssdb 0.4.4

• Add ForeignKeyField to TIC_v8 where for all models in catalogdb connected to Gaia.
• Use autorollback=True by default in PeeweeDatabaseConnection.
• Ensure reflection assigns double type arrays.
• Clear metadata on reconnect.
• Add lite materialized views to catalogdb.
• Add catalogdb.gaia_assas_sn_cepheids table.
• Move deprecated tables to deprecated schema in sdss5db.
• Add DR16 versions of APOGEE tables.

sdssdb 0.4.3

• Add schema for gaia_dr2_ruwe.
• Rename targetdb.program to carton, and survey to mapper. Add priority field in carton_to_target.
• Add z column to targetdb.magnitude.
• Add position_angle column to targetdb.field.

sdssdb 0.4.2

• Add targetdb.version.tag column.
• Use schema-qualified keys for database.models.
• Modify targetdb schema so that magnitude references target instead of the other way around.
• Allow to use ReflectMeta.reflect manually even if use_reflection has not been set in Meta.

sdssdb 0.4.1

• Rename targetdb.Version.label and catalogdb.Version.version to plan.

sdssdb 0.4.0

• Test suite only runs where existing local databases found. Optionally run only peewee or sqlalchemy tests.
• Adds ability to generate fake data based on real database models for tests.
• Adds ability to test against real or fake databases.
• Write tests either for peewee or sqlalchemy databases.
• New framework for writing tests against databases.
• Many changes to the catalogdb schema files and PeeWee implementation to match the contents to SDSS-V v0 target selection.
• A new ReflectMeta metaclass that provides reflection for Peewee models (with some caveats).
• Reimplementation of most catalogdb Peewee model classes for catalogdb using reflection.
• Changes to the schema display tools.
• New tools for table ingestion.
• New tools for database maintenance / internals.
• Add PeeweeDatabaseConnection.get_model to retrieve the model for a given table.
• Temporarily remove SQLAlchemy implementation of sds5db since it's not maintained (#28). We may reintroduce it later once the schema is stable.
• Use host=localhost when a profile is being used on its own domain.
• Assume that both SQLAlchemy and Peewee will be installed and simplify code (#32).

sdssdb 0.3.2

• Change operations-test profile to operations using the new machine hostname.
• New schema and models for sdss5db.targetdb.