PpdbConfig

class lsst.dax.ppdb.PpdbConfig

Bases: lsst.pex.config.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-g5768c874b9/data/ppdb-afw-map.yaml')
connection_pool	If False then disable SQLAlchemy connection pool.
db_url	SQLAlchemy database connection URI (str, default None)
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, default None)
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-g5768c874b9/data/ppdb-schema-extra.yaml')
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-g5768c874b9/data/ppdb-schema.yaml')
sql_echo	If True then pass SQLAlchemy echo option.
timer	If True then print/log timing information (bool, default False)

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-g5768c874b9/data/ppdb-afw-map.yaml')

connection_pool

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

db_url

SQLAlchemy database connection URI (str, default None)

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, default None)

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-g5768c874b9/data/ppdb-schema-extra.yaml')

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-g5768c874b9/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)