LSST Applications g013ef56533+7c9321ec0f,g042eb84c57+c6cfa41bc3,g199a45376c+0ba108daf9,g1fd858c14a+fcad0d0313,g210f2d0738+c0f94c6586,g262e1987ae+a7e710680e,g29ae962dfc+fb55f2edb0,g2ac17093b6+61d6563b1e,g2b1d02342f+df6f932764,g2cef7863aa+aef1011c0b,g2f7ad74990+c0f94c6586,g35bb328faa+8c5ae1fdc5,g3fd5ace14f+53cf87ae69,g47891489e3+4316d04fff,g511e8cfd20+baa56acf6c,g53246c7159+8c5ae1fdc5,g54cd7ddccb+fd7ad03fde,g64539dfbff+c0f94c6586,g67b6fd64d1+4316d04fff,g67fd3c3899+c0f94c6586,g6985122a63+4316d04fff,g74acd417e5+ca833bee28,g786e29fd12+668abc6043,g81db2e9a8d+b2ec8e584f,g87389fa792+8856018cbb,g89139ef638+4316d04fff,g8d7436a09f+0a24083b20,g8ea07a8fe4+760ca7c3fc,g90f42f885a+033b1d468d,g97be763408+11eb8fd5b8,gbf99507273+8c5ae1fdc5,gcdda8b9158+e4c84c9d5c,gce8aa8abaa+8c5ae1fdc5,gd7ef33dd92+4316d04fff,gdab6d2f7ff+ca833bee28,ge410e46f29+4316d04fff,geaed405ab2+c4bbc419c6,gf9a733ac38+8c5ae1fdc5,w.2025.40
LSST Data Management Base Package
Loading...
Searching...
No Matches
create_sql.py
Go to the documentation of this file.
1# This file is part of dax_apdb
2#
3# Developed for the LSST Data Management System.
4# This product includes software developed by the LSST Project
5# (https://www.lsst.org).
6# See the COPYRIGHT file at the top-level directory of this distribution
7# for details of code ownership.
8#
9# This program is free software: you can redistribute it and/or modify
10# it under the terms of the GNU General Public License as published by
11# the Free Software Foundation, either version 3 of the License, or
12# (at your option) any later version.
13#
14# This program is distributed in the hope that it will be useful,
15# but WITHOUT ANY WARRANTY; without even the implied warranty of
16# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17# GNU General Public License for more details.
18#
19# You should have received a copy of the GNU General Public License
20# along with this program. If not, see <https://www.gnu.org/licenses/>.
21
22from __future__ import annotations
23
24__all__ = ["create_sql"]
25
26import warnings
27from typing import Any
28
29from ..sql import ApdbSql
30
31
32def create_sql(output_config: str, ra_dec_columns: str | None, **kwargs: Any) -> None:
33 """Create new APDB instance in SQL database.
34
35 Parameters
36 ----------
37 output_config : `str`
38 Name of the file to write APDB configuration.
39 ra_dec_columns : `str` or `None`
40 Comma-separated list of names for ra/dec columns in DiaObject table.
41 **kwargs
42 Keyword arguments passed to `ApdbSql.init_database` method.
43 """
44 ra_dec_tuple: tuple[str, str] | None = None
45 if ra_dec_columns:
46 ra_dec_list = ra_dec_columns.split(",")
47 if len(ra_dec_list) != 2:
48 raise ValueError(f"--ra-dec-columns must specify exactly two columns: {ra_dec_columns}")
49 ra_dec_tuple = (ra_dec_list[0], ra_dec_list[1])
50 config = ApdbSql.init_database(ra_dec_columns=ra_dec_tuple, **kwargs)
51 config.save(output_config)
52 if output_config.endswith(".py"):
53 warnings.warn(
54 "APDB configuration is now saved in YAML format, "
55 "output file should use .yaml extension instead of .py."
56 )