LSST Applications g042eb84c57+730a74494b,g04e9c324dd+8c5ae1fdc5,g134cb467dc+1f1e3e7524,g199a45376c+0ba108daf9,g1fd858c14a+fa7d31856b,g210f2d0738+f66ac109ec,g262e1987ae+83a3acc0e5,g29ae962dfc+d856a2cb1f,g2cef7863aa+aef1011c0b,g35bb328faa+8c5ae1fdc5,g3fd5ace14f+a1e0c9f713,g47891489e3+0d594cb711,g4d44eb3520+c57ec8f3ed,g4d7b6aa1c5+f66ac109ec,g53246c7159+8c5ae1fdc5,g56a1a4eaf3+fd7ad03fde,g64539dfbff+f66ac109ec,g67b6fd64d1+0d594cb711,g67fd3c3899+f66ac109ec,g6985122a63+0d594cb711,g74acd417e5+3098891321,g786e29fd12+668abc6043,g81db2e9a8d+98e2ab9f28,g87389fa792+8856018cbb,g89139ef638+0d594cb711,g8d7436a09f+80fda9ce03,g8ea07a8fe4+760ca7c3fc,g90f42f885a+033b1d468d,g97be763408+a8a29bda4b,g99822b682c+e3ec3c61f9,g9d5c6a246b+0d5dac0c3d,ga41d0fce20+9243b26dd2,gbf99507273+8c5ae1fdc5,gd7ef33dd92+0d594cb711,gdab6d2f7ff+3098891321,ge410e46f29+0d594cb711,geaed405ab2+c4bbc419c6,gf9a733ac38+8c5ae1fdc5,w.2025.38
LSST Data Management Base Package
Loading...
Searching...
No Matches
lsst.dax.apdb.sql.apdbSql Namespace Reference

Classes

class  ApdbSql
 

Functions

pandas.DataFrame _coerce_uint64 (pandas.DataFrame df)
 
float _make_midpointMjdTai_start (astropy.time.Time visit_time, int months)
 
None _onSqlite3Connect (sqlite3.Connection dbapiConnection, sqlalchemy.pool._ConnectionRecord connectionRecord)
 

Variables

 _LOG = logging.getLogger(__name__)
 
 _MON = MonAgent(__name__)
 
 VERSION = VersionTuple(1, 1, 0)
 

Detailed Description

Module defining Apdb class and related methods.

Function Documentation

◆ _coerce_uint64()

pandas.DataFrame lsst.dax.apdb.sql.apdbSql._coerce_uint64 ( pandas.DataFrame df)
protected
Change the type of uint64 columns to int64, and return copy of data
frame.

Definition at line 80 of file apdbSql.py.

80def _coerce_uint64(df: pandas.DataFrame) -> pandas.DataFrame:
81 """Change the type of uint64 columns to int64, and return copy of data
82 frame.
83 """
84 names = [c[0] for c in df.dtypes.items() if c[1] == np.uint64]
85 return df.astype(dict.fromkeys(names, np.int64))
86
87

◆ _make_midpointMjdTai_start()

float lsst.dax.apdb.sql.apdbSql._make_midpointMjdTai_start ( astropy.time.Time visit_time,
int months )
protected
Calculate starting point for time-based source search.

Parameters
----------
visit_time : `astropy.time.Time`
    Time of current visit.
months : `int`
    Number of months in the sources history.

Returns
-------
time : `float`
    A ``midpointMjdTai`` starting point, MJD time.

Definition at line 88 of file apdbSql.py.

88def _make_midpointMjdTai_start(visit_time: astropy.time.Time, months: int) -> float:
89 """Calculate starting point for time-based source search.
90
91 Parameters
92 ----------
93 visit_time : `astropy.time.Time`
94 Time of current visit.
95 months : `int`
96 Number of months in the sources history.
97
98 Returns
99 -------
100 time : `float`
101 A ``midpointMjdTai`` starting point, MJD time.
102 """
103 # TODO: Use of MJD must be consistent with the code in ap_association
104 # (see DM-31996)
105 return float(visit_time.mjd - months * 30)
106
107

◆ _onSqlite3Connect()

None lsst.dax.apdb.sql.apdbSql._onSqlite3Connect ( sqlite3.Connection dbapiConnection,
sqlalchemy.pool._ConnectionRecord connectionRecord )
protected

Definition at line 108 of file apdbSql.py.

110) -> None:
111 # Enable foreign keys
112 with closing(dbapiConnection.cursor()) as cursor:
113 cursor.execute("PRAGMA foreign_keys=ON;")
114
115

Variable Documentation

◆ _LOG

lsst.dax.apdb.sql.apdbSql._LOG = logging.getLogger(__name__)
protected

Definition at line 69 of file apdbSql.py.

◆ _MON

lsst.dax.apdb.sql.apdbSql._MON = MonAgent(__name__)
protected

Definition at line 71 of file apdbSql.py.

◆ VERSION

lsst.dax.apdb.sql.apdbSql.VERSION = VersionTuple(1, 1, 0)

Definition at line 73 of file apdbSql.py.