LSST Applications g013ef56533+63812263fb,g083dd6704c+a047e97985,g199a45376c+0ba108daf9,g1fd858c14a+fde7a7a78c,g210f2d0738+db0c280453,g262e1987ae+abed931625,g29ae962dfc+058d1915d8,g2cef7863aa+aef1011c0b,g35bb328faa+8c5ae1fdc5,g3fd5ace14f+64337f1634,g47891489e3+f459a6810c,g53246c7159+8c5ae1fdc5,g54cd7ddccb+890c8e1e5d,g5a60e81ecd+d9e514a434,g64539dfbff+db0c280453,g67b6fd64d1+f459a6810c,g6ebf1fc0d4+8c5ae1fdc5,g7382096ae9+36d16ea71a,g74acd417e5+c70e70fbf6,g786e29fd12+668abc6043,g87389fa792+8856018cbb,g89139ef638+f459a6810c,g8d7436a09f+1b779678e3,g8ea07a8fe4+81eaaadc04,g90f42f885a+34c0557caf,g97be763408+9583a964dd,g98a1a72a9c+028271c396,g98df359435+530b675b85,gb8cb2b794d+4e54f68785,gbf99507273+8c5ae1fdc5,gc2a301910b+db0c280453,gca7fc764a6+f459a6810c,gd7ef33dd92+f459a6810c,gdab6d2f7ff+c70e70fbf6,ge410e46f29+f459a6810c,ge41e95a9f2+db0c280453,geaed405ab2+e3b4b2a692,gf9a733ac38+8c5ae1fdc5,w.2025.43
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 )