ApdbSchema¶
- class lsst.dax.apdb.ApdbSchema(engine, dia_object_index, dia_object_nightly, schema_file, extra_schema_file=None, column_map=None, afw_schemas=None, prefix='')¶
Bases:
object
Class for management of APDB schema.
- Parameters:
- engine
sqlalchemy.engine.Engine
SQLAlchemy engine instance
- dia_object_index
str
Indexing mode for DiaObject table, see
ApdbConfig.dia_object_index
for details.- dia_object_nightly
bool
If
True
then create per-night DiaObject table as well.- schema_file
str
Name of the YAML schema file.
- extra_schema_file
str
, optional Name of the YAML schema file with extra column definitions.
- column_map
str
, optional Name of the YAML file with column mappings.
- afw_schemas
dict
, optional Dictionary with table name for a key and
afw.table.Schema
for a value. Columns in schema will be added to standard APDB schema (only if standard schema does not have matching column).- prefix
str
, optional Prefix to add to all scheam elements.
- engine
- Attributes:
- objects
sqlalchemy.Table
DiaObject table instance
- objects_nightly
sqlalchemy.Table
DiaObjectNightly table instance, may be None
- objects_last
sqlalchemy.Table
DiaObjectLast table instance, may be None
- sources
sqlalchemy.Table
DiaSource table instance
- forcedSources
sqlalchemy.Table
DiaForcedSource table instance
- visits
sqlalchemy.Table
ApdbProtoVisits table instance
- objects
Methods Summary
getAfwColumns
(table_name)Returns mapping of afw column names to Column definitions.
getAfwSchema
(table_name[, columns])Return afw schema for given table.
getColumnMap
(table_name)Returns mapping of column names to Column definitions.
makeSchema
([drop, mysql_engine, ...])Create or re-create all tables.
Methods Documentation
- getAfwColumns(table_name)¶
Returns mapping of afw column names to Column definitions.
- getAfwSchema(table_name, columns=None)¶
Return afw schema for given table.
- Parameters:
- Returns:
- schema
lsst.afw.table.Schema
- column_map
dict
Mapping of the table/result column names into schema key.
- schema
- getColumnMap(table_name)¶
Returns mapping of column names to Column definitions.
- makeSchema(drop=False, mysql_engine='InnoDB', oracle_tablespace=None, oracle_iot=False)¶
Create or re-create all tables.