PpdbConfig¶

class lsst.dax.ppdb.PpdbConfig¶

Bases: lsst.pex.config.Config

Attributes Summary

`cardinality_hint`	If non-zero then use cardinality hint (`int`, default `0`)
`column_map`	Location of (YAML) configuration file with column mapping (`str`, default `'/opt/lsst/software/stack/stack/miniconda3-4.5.4-fcd27eb/Linux64/dax_ppdb/master-gd73dc1d098+4/data/ppdb-afw-map.yaml'`)
`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'`)
`dia_object_nightly`	Use separate nightly table for DiaObject (`bool`, default `False`)
`diaobject_index_hint`	Name of the index to use with Oracle index hint (`str`)
`dynamic_sampling_hint`	If non-zero then use dynamic_sampling hint (`int`, default `0`)
`explain`	If True then run EXPLAIN SQL command on each executed query (`bool`, default `False`)
`extra_schema_file`	Location of (YAML) configuration file with extra schema (`str`, default `'/opt/lsst/software/stack/stack/miniconda3-4.5.4-fcd27eb/Linux64/dax_ppdb/master-gd73dc1d098+4/data/ppdb-schema-extra.yaml'`)
`history`
`isolation_level`	Transaction isolation level (`str`, default `'READ_COMMITTED'`)
`object_last_replace`	If True (default) then use “upsert” for DiaObjectsLast table (`bool`, default `True`)
`prefix`	Prefix to add to table names and index names (`str`, default `''`)
`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`)
`schema_file`	Location of (YAML) configuration file with standard schema (`str`, default `'/opt/lsst/software/stack/stack/miniconda3-4.5.4-fcd27eb/Linux64/dax_ppdb/master-gd73dc1d098+4/data/ppdb-schema.yaml'`)
`sql_echo`	If True then pass SQLAlchemy echo option.
`timer`	If True then print/log timing information (`bool`, default `False`)

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.
`iteritems`()	Iterate over (field name, field value) pairs.
`iterkeys`()	Iterate over field names
`itervalues`()	Iterate over field values.
`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.
`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])	Save a configuration file to a stream, which, when loaded, reproduces this config.
`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

cardinality_hint¶: If non-zero then use cardinality hint (int, default 0)

column_map¶: Location of (YAML) configuration file with column mapping (str, default '/opt/lsst/software/stack/stack/miniconda3-4.5.4-fcd27eb/Linux64/dax_ppdb/master-gd73dc1d098+4/data/ppdb-afw-map.yaml')

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 sqlachemy defaults if not set. (float)

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

dia_object_nightly¶: Use separate nightly table for DiaObject (bool, default False)

diaobject_index_hint¶: Name of the index to use with Oracle index hint (str)

dynamic_sampling_hint¶: If non-zero then use dynamic_sampling hint (int, default 0)

explain¶: If True then run EXPLAIN SQL command on each executed query (bool, default False)

extra_schema_file¶: Location of (YAML) configuration file with extra schema (str, default '/opt/lsst/software/stack/stack/miniconda3-4.5.4-fcd27eb/Linux64/dax_ppdb/master-gd73dc1d098+4/data/ppdb-schema-extra.yaml')

history¶

isolation_level¶

Transaction isolation level (str, default 'READ_COMMITTED')

Allowed values:

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

object_last_replace¶: If True (default) then use “upsert” for DiaObjectsLast table (bool, default True)

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

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)

schema_file¶: Location of (YAML) configuration file with standard schema (str, default '/opt/lsst/software/stack/stack/miniconda3-4.5.4-fcd27eb/Linux64/dax_ppdb/master-gd73dc1d098+4/data/ppdb-schema.yaml')

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

timer¶: If True then print/log timing information (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:

other : lsst.pex.config.Config: Other Config object to compare against this config.
shortcut : bool, optional: If True, return as soon as an inequality is found. Default is True.
rtol : float, optional: Relative tolerance for floating point comparisons.
atol : float, optional: Absolute tolerance for floating point comparisons.
output : callable, optional: A callable that takes a string, used (possibly repeatedly) to report inequalities.

Returns:

isEqual : bool: 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:	name : `str` Name of a `Field` in this config. kwargs Keyword arguments passed to `lsst.pex.config.history.format`.
Returns:	history : `str` 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:	items : `list` List of tuples for each configuration. Tuple items are: Field name. Field value.

See also

lsst.pex.config.Config.iteritems

iteritems()¶

Iterate over (field name, field value) pairs.

Yields:	item : `tuple` Tuple items are: Field name. Field value.

See also

lsst.pex.config.Config.items

iterkeys()¶

Iterate over field names

Yields:	key : `str` A field’s key (attribute name).

See also

lsst.pex.config.Config.values

itervalues()¶

Iterate over field values.

Yields:	value : obj A field value.

See also

lsst.pex.config.Config.values

keys()¶

Get field names.

Returns:	names : `list` List of `lsst.pex.config.Field` names.

See also

lsst.pex.config.Config.iterkeys

load(filename, root='config')¶

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

Parameters:

filename : str

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

root : str, 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.

Deprecated: For backwards compatibility, older config files that use root="root" instead of root="config" will be loaded with a warning printed to sys.stderr. This feature will be removed at some point.

See also

lsst.pex.config.Config.loadFromStream, lsst.pex.config.Config.save, lsst.pex.config.Config.saveFromStream

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

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

Parameters:

stream : file-like object, str, or compiled string

Stream containing configuration override code.

root : str, 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.

Deprecated: For backwards compatibility, older config files that use root="root" instead of root="config" will be loaded with a warning printed to sys.stderr. This feature will be removed at some point.

filename : str, optional

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

See also

lsst.pex.config.Config.load, lsst.pex.config.Config.save, lsst.pex.config.Config.saveFromStream

names()¶

Get all the field names in the config, recursively.

Returns:	names : `list` of `str` Field names.

save(filename, root='config')¶

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

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

saveToStream(outfile, root='config')¶

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

Parameters:	outfile : file-like object Destination file object write the config into. Accepts strings not bytes. root Name to use for the root config variable. The same value must be used when loading (see `lsst.pex.config.Config.load`).

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()¶

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:	values : `list` List of field values.

See also

lsst.pex.config.Config.itervalues

Navigation

PpdbConfig¶