ApdbSqlSchema

class lsst.dax.apdb.ApdbSqlSchema(engine: sqlalchemy.engine.base.Engine, dia_object_index: str, htm_index_column: str, schema_file: str, extra_schema_file: Optional[str] = None, prefix: str = '')

Bases: lsst.dax.apdb.ApdbSchema

Class for management of APDB schema.

Parameters:

engine : sqlalchemy.engine.Engine

SQLAlchemy engine instance

dia_object_index : str

Indexing mode for DiaObject table, see ApdbSqlConfig.dia_object_index for details.

htm_index_column : str

Name of a HTM index column for DiaObject and DiaSource tables.

schema_file : str

Name of the YAML schema file.

extra_schema_file : str, optional

Name of the YAML schema file with extra column definitions.

prefix : str, optional

Prefix to add to all scheam elements.

Attributes:

objects : sqlalchemy.Table

DiaObject table instance

objects_last : sqlalchemy.Table

DiaObjectLast table instance, may be None

sources : sqlalchemy.Table

DiaSource table instance

forcedSources : sqlalchemy.Table

DiaForcedSource table instance

Methods Summary

makeSchema(drop, mysql_engine)

Create or re-create all tables.

Methods Documentation

makeSchema(drop: bool = False, mysql_engine: str = 'InnoDB') → None

Create or re-create all tables.

Parameters:

drop : bool, optional

If True then drop tables before creating new ones.

mysql_engine : str, optional

MySQL engine type to use for new tables.