ApdbSqlConfig¶

class lsst.dax.apdb.ApdbSqlConfig(*args, **kw)¶

Bases: ApdbConfig

APDB configuration class for SQL implementation (ApdbSql).

Attributes Summary

`connection_pool`	If False then disable SQLAlchemy connection pool.
`connection_timeout`	Maximum time to wait time for database lock to be released before exiting.
`db_url`	SQLAlchemy database connection URI (`str`)
`dia_object_columns`	List of columns to read from DiaObject, by default read all columns (`List`, default `[]`)
`dia_object_index`	Indexing mode for DiaObject table (`str`, default `'baseline'`)
`extra_schema_file`	Location of (YAML) configuration file with extra schema, definitions in this file are merged with the definitions in 'schema_file', extending or replacing parts of the schema.
`history`
`htm_index_column`	Name of a HTM index column for DiaObject and DiaSource tables (`str`, default `'pixelId'`)
`htm_level`	HTM indexing level (`int`, default `20`)
`htm_max_ranges`	Max number of ranges in HTM envelope (`int`, default `64`)
`isolation_level`	Transaction isolation level, if unset then backend-default value is used, except for SQLite backend where we use READ_UNCOMMITTED.
`namespace`	Namespace or schema name for all tables in APDB database.
`prefix`	Prefix to add to table names and index names (`str`, default `''`)
`ra_dec_columns`	Names of ra/dec columns in DiaObject table (`List`, default `['ra', 'dec']`)
`read_forced_sources_months`	Number of months of history to read from DiaForcedSource (`int`, default `12`)
`read_sources_months`	Number of months of history to read from DiaSource (`int`, default `12`)
`replica_chunk_seconds`	Time extent for replica chunks, new chunks are created every specified number of seconds.
`schema_file`	Location of (YAML) configuration file with standard schema (`str`, default `'${SDM_SCHEMAS_DIR}/yml/apdb.yaml'`)
`schema_name`	Name of the schema in YAML configuration file.
`sql_echo`	If True then pass SQLAlchemy echo option.
`timer`	If True then print/log timing information (`bool`, default `False`)
`use_insert_id`	If True, make and fill additional tables used for replication.

Methods Summary

`compare`(other[, shortcut, rtol, atol, output])	Compare this configuration to another `Config` for equality.
`formatHistory`(name, **kwargs)	Format a configuration field's history to a human-readable format.
`freeze`()	Make this config, and all subconfigs, read-only.
`items`()	Get configurations as `(field name, field value)` pairs.
`keys`()	Get field names.
`load`(filename[, root])	Modify this config in place by executing the Python code in a configuration file.
`loadFromStream`(stream[, root, filename, ...])	Modify this Config in place by executing the Python code in the provided stream.
`loadFromString`(code[, root, filename, ...])	Modify this Config in place by executing the Python code in the provided string.
`names`()	Get all the field names in the config, recursively.
`save`(filename[, root])	Save a Python script to the named file, which, when loaded, reproduces this config.
`saveToStream`(outfile[, root, skipImports])	Save a configuration file to a stream, which, when loaded, reproduces this config.
`saveToString`([skipImports])	Return the Python script form of this configuration as an executable string.
`setDefaults`()	Subclass hook for computing defaults.
`toDict`()	Make a dictionary of field names and their values.
`update`(**kw)	Update values of fields specified by the keyword arguments.
`validate`()	Validate the Config, raising an exception if invalid.
`values`()	Get field values.

Attributes Documentation

connection_pool¶: If False then disable SQLAlchemy connection pool. Do not use connection pool when forking. (bool, default True)

connection_timeout¶: Maximum time to wait time for database lock to be released before exiting. Defaults to sqlalchemy defaults if not set. (float, default None)

db_url¶: SQLAlchemy database connection URI (str)

dia_object_columns¶: List of columns to read from DiaObject, by default read all columns (List, default [])

dia_object_index¶

Indexing mode for DiaObject table (str, default 'baseline')

Allowed values:

'baseline': Index defined in baseline schema
'pix_id_iov': (pixelId, objectId, iovStart) PK
'last_object_table': Separate DiaObjectLast table
'None': Field is optional

extra_schema_file¶: Location of (YAML) configuration file with extra schema, definitions in this file are merged with the definitions in ‘schema_file’, extending or replacing parts of the schema. Deprecated: This field is deprecated, its value is not used. (str, default None)

history¶: Read-only history.

htm_index_column¶: Name of a HTM index column for DiaObject and DiaSource tables (str, default 'pixelId')

htm_level¶: HTM indexing level (int, default 20)

htm_max_ranges¶: Max number of ranges in HTM envelope (int, default 64)

isolation_level¶

Transaction isolation level, if unset then backend-default value is used, except for SQLite backend where we use READ_UNCOMMITTED. Some backends may not support every allowed value. (str, default None)

Allowed values:

'READ_COMMITTED': Read committed
'READ_UNCOMMITTED': Read uncommitted
'REPEATABLE_READ': Repeatable read
'SERIALIZABLE': Serializable
'None': Field is optional

namespace¶: Namespace or schema name for all tables in APDB database. Presently only works for PostgreSQL backend. If schema with this name does not exist it will be created when APDB tables are created. (str, default None)

prefix¶: Prefix to add to table names and index names (str, default '')

ra_dec_columns¶: Names of ra/dec columns in DiaObject table (List, default ['ra', 'dec'])

read_forced_sources_months¶: Number of months of history to read from DiaForcedSource (int, default 12)

read_sources_months¶: Number of months of history to read from DiaSource (int, default 12)

replica_chunk_seconds¶: Time extent for replica chunks, new chunks are created every specified number of seconds. (int, default 600)

schema_file¶: Location of (YAML) configuration file with standard schema (str, default '${SDM_SCHEMAS_DIR}/yml/apdb.yaml')

schema_name¶: Name of the schema in YAML configuration file. (str, default 'ApdbSchema')

sql_echo¶: If True then pass SQLAlchemy echo option. (bool, default False)

timer¶: If True then print/log timing information (bool, default False)

use_insert_id¶: If True, make and fill additional tables used for replication. Databases created with earlier versions of APDB may not have these tables, and corresponding methods will not work for them. (bool, default False)

Methods Documentation

compare(other, shortcut=True, rtol=1e-08, atol=1e-08, output=None)¶

Compare this configuration to another Config for equality.

Parameters:

otherlsst.pex.config.Config: Other Config object to compare against this config.
shortcutbool, optional: If True, return as soon as an inequality is found. Default is True.
rtolfloat, optional: Relative tolerance for floating point comparisons.
atolfloat, optional: Absolute tolerance for floating point comparisons.
outputcallable, optional: A callable that takes a string, used (possibly repeatedly) to report inequalities.

Returns:

isEqualbool: True when the two lsst.pex.config.Config instances are equal. False if there is an inequality.

See also

lsst.pex.config.compareConfigs

Notes

Unselected targets of RegistryField fields and unselected choices of ConfigChoiceField fields are not considered by this method.

Floating point comparisons are performed by numpy.allclose.

formatHistory(name, **kwargs)¶

Format a configuration field’s history to a human-readable format.

Parameters:

namestr: Name of a Field in this config.
**kwargs: Keyword arguments passed to lsst.pex.config.history.format.

Returns:

historystr: A string containing the formatted history.

See also

lsst.pex.config.history.format

freeze()¶: Make this config, and all subconfigs, read-only.

items()¶

Get configurations as (field name, field value) pairs.

Returns:

itemsItemsView

Iterator of tuples for each configuration. Tuple items are:

Field name.
Field value.

keys()¶

Get field names.

Returns:

namesKeysView: List of lsst.pex.config.Field names.

load(filename, root='config')¶

Modify this config in place by executing the Python code in a configuration file.

Parameters:

filenamestr

Name of the configuration file. A configuration file is Python module.

rootstr, optional

Name of the variable in file that refers to the config being overridden.

For example, the value of root is "config" and the file contains:

config.myField = 5

Then this config’s field myField is set to 5.

See also

lsst.pex.config.Config.loadFromStream
lsst.pex.config.Config.loadFromString
lsst.pex.config.Config.save
lsst.pex.config.Config.saveToStream
lsst.pex.config.Config.saveToString

loadFromStream(stream, root='config', filename=None, extraLocals=None)¶

Modify this Config in place by executing the Python code in the provided stream.

Parameters:

streamfile-like object, str, bytes, or CodeType

Stream containing configuration override code. If this is a code object, it should be compiled with mode="exec".

rootstr, optional

Name of the variable in file that refers to the config being overridden.

For example, the value of root is "config" and the file contains:

config.myField = 5

Then this config’s field myField is set to 5.

filenamestr, optional

Name of the configuration file, or None if unknown or contained in the stream. Used for error reporting.

extraLocalsdict of str to object, optional

Any extra variables to include in local scope when loading.

See also

lsst.pex.config.Config.load
lsst.pex.config.Config.loadFromString
lsst.pex.config.Config.save
lsst.pex.config.Config.saveToStream
lsst.pex.config.Config.saveToString

Notes

For backwards compatibility reasons, this method accepts strings, bytes and code objects as well as file-like objects. New code should use loadFromString instead for most of these types.

loadFromString(code, root='config', filename=None, extraLocals=None)¶

Modify this Config in place by executing the Python code in the provided string.

Parameters:

codestr, bytes, or CodeType

Stream containing configuration override code.

rootstr, optional

Name of the variable in file that refers to the config being overridden.

For example, the value of root is "config" and the file contains:

config.myField = 5

Then this config’s field myField is set to 5.

filenamestr, optional

Name of the configuration file, or None if unknown or contained in the stream. Used for error reporting.

extraLocalsdict of str to object, optional

Any extra variables to include in local scope when loading.

Raises:

ValueError: Raised if a key in extraLocals is the same value as the value of the root argument.

See also

lsst.pex.config.Config.load
lsst.pex.config.Config.loadFromStream
lsst.pex.config.Config.save
lsst.pex.config.Config.saveToStream
lsst.pex.config.Config.saveToString

names()¶

Get all the field names in the config, recursively.

Returns:

nameslist of str: Field names.

save(filename, root='config')¶

Save a Python script to the named file, which, when loaded, reproduces this config.

Parameters:

filenamestr: Desination filename of this configuration.
rootstr, optional: Name to use for the root config variable. The same value must be used when loading (see lsst.pex.config.Config.load).

See also

lsst.pex.config.Config.saveToStream
lsst.pex.config.Config.saveToString
lsst.pex.config.Config.load
lsst.pex.config.Config.loadFromStream
lsst.pex.config.Config.loadFromString

saveToStream(outfile, root='config', skipImports=False)¶

Save a configuration file to a stream, which, when loaded, reproduces this config.

Parameters:

outfilefile-like object: Destination file object write the config into. Accepts strings not bytes.
rootstr, optional: Name to use for the root config variable. The same value must be used when loading (see lsst.pex.config.Config.load).
skipImportsbool, optional: If True then do not include import statements in output, this is to support human-oriented output from pipetask where additional clutter is not useful.

See also

lsst.pex.config.Config.save
lsst.pex.config.Config.saveToString
lsst.pex.config.Config.load
lsst.pex.config.Config.loadFromStream
lsst.pex.config.Config.loadFromString

saveToString(skipImports=False)¶

Return the Python script form of this configuration as an executable string.

Parameters:

skipImportsbool, optional: If True then do not include import statements in output, this is to support human-oriented output from pipetask where additional clutter is not useful.

Returns:

codestr: A code string readable by loadFromString.

See also

lsst.pex.config.Config.save
lsst.pex.config.Config.saveToStream
lsst.pex.config.Config.load
lsst.pex.config.Config.loadFromStream
lsst.pex.config.Config.loadFromString

setDefaults()¶

Subclass hook for computing defaults.

Notes

Derived Config classes that must compute defaults rather than using the Field instances’s defaults should do so here. To correctly use inherited defaults, implementations of setDefaults must call their base class’s setDefaults.

toDict()¶

Make a dictionary of field names and their values.

Returns:

dict_dict: Dictionary with keys that are Field names. Values are Field values.

See also

lsst.pex.config.Field.toDict

Notes

This method uses the toDict method of individual fields. Subclasses of Field may need to implement a toDict method for this method to work.

update(**kw)¶

Update values of fields specified by the keyword arguments.

Parameters:

**kw: Keywords are configuration field names. Values are configuration field values.

Notes

The __at and __label keyword arguments are special internal keywords. They are used to strip out any internal steps from the history tracebacks of the config. Do not modify these keywords to subvert a Config instance’s history.

Examples

This is a config with three fields:

>>> from lsst.pex.config import Config, Field
>>> class DemoConfig(Config):
...     fieldA = Field(doc='Field A', dtype=int, default=42)
...     fieldB = Field(doc='Field B', dtype=bool, default=True)
...     fieldC = Field(doc='Field C', dtype=str, default='Hello world')
...
>>> config = DemoConfig()

These are the default values of each field:

>>> for name, value in config.iteritems():
...     print(f"{name}: {value}")
...
fieldA: 42
fieldB: True
fieldC: 'Hello world'

Using this method to update fieldA and fieldC:

>>> config.update(fieldA=13, fieldC='Updated!')

Now the values of each field are:

>>> for name, value in config.iteritems():
...     print(f"{name}: {value}")
...
fieldA: 13
fieldB: True
fieldC: 'Updated!'

validate() → None¶

Validate the Config, raising an exception if invalid.

Raises:

lsst.pex.config.FieldValidationError: Raised if verification fails.

Notes

The base class implementation performs type checks on all fields by calling their validate methods.

Complex single-field validation can be defined by deriving new Field types. For convenience, some derived lsst.pex.config.Field-types (ConfigField and ConfigChoiceField) are defined in lsst.pex.config that handle recursing into subconfigs.

Inter-field relationships should only be checked in derived Config classes after calling this method, and base validation is complete.

values()¶

Get field values.

Returns:

valuesValuesView: Iterator of field values.

Navigation

ApdbSqlConfig¶