ApdbSqlSchema

class lsst.dax.apdb.ApdbSqlSchema(engine: Engine, dia_object_index: str, htm_index_column: str, schema_file: str, schema_name: str = 'ApdbSchema', prefix: str = '')

Bases: ApdbSchema

Class for management of APDB schema.

Parameters:

enginesqlalchemy.engine.Engine

SQLAlchemy engine instance

dia_object_indexstr

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

htm_index_columnstr

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

schema_filestr

Name of the YAML schema file.

schema_namestr, optional

Name of the schema in YAML files.

prefixstr, optional

Prefix to add to all scheam elements.

Attributes:

objectssqlalchemy.Table

DiaObject table instance

objects_lastsqlalchemy.Table

DiaObjectLast table instance, may be None

sourcessqlalchemy.Table

DiaSource table instance

forcedSourcessqlalchemy.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:

dropbool, optional

If True then drop tables before creating new ones.

mysql_enginestr, optional

MySQL engine type to use for new tables.