Loading [MathJax]/extensions/tex2jax.js
LSST Applications g04a91732dc+cc8870d3f5,g07dc498a13+5aa0b8792f,g0fba68d861+80045be308,g1409bbee79+5aa0b8792f,g1a7e361dbc+5aa0b8792f,g1fd858c14a+f64bc332a9,g208c678f98+1ae86710ed,g35bb328faa+fcb1d3bbc8,g4d2262a081+47ad8a29a8,g4d39ba7253+9633a327c1,g4e0f332c67+5d362be553,g53246c7159+fcb1d3bbc8,g60b5630c4e+9633a327c1,g668ecb457e+25d63fd678,g78460c75b0+2f9a1b4bcd,g786e29fd12+cf7ec2a62a,g7b71ed6315+fcb1d3bbc8,g8852436030+8b64ca622a,g89139ef638+5aa0b8792f,g89e1512fd8+04325574d3,g8d6b6b353c+9633a327c1,g9125e01d80+fcb1d3bbc8,g989de1cb63+5aa0b8792f,g9f33ca652e+b196626af7,ga9baa6287d+9633a327c1,gaaedd4e678+5aa0b8792f,gabe3b4be73+1e0a283bba,gb1101e3267+71e32094df,gb58c049af0+f03b321e39,gb90eeb9370+2807b1ad02,gcf25f946ba+8b64ca622a,gd315a588df+a39986a76f,gd6cbbdb0b4+c8606af20c,gd9a9a58781+fcb1d3bbc8,gde0f65d7ad+4e42d81ab7,ge278dab8ac+932305ba37,ge82c20c137+76d20ab76d,gfe73954cf8+a1301e4c20,w.2025.11
LSST Data Management Base Package
All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Properties Friends Macros Modules Pages
list_cassandra.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__ = ["list_cassandra"]
25
26from astropy.table import Table
27
28from ..cassandra import ApdbCassandra
29
30
31def list_cassandra(host: str, verbose: bool) -> None:
32 """List APDB instances in Cassandra cluster.
33
34 Parameters
35 ----------
36 host : `str`
37 Name of one of the hosts in Cassandra cluster.
38 verbose : `bool`
39 If `True` provide detailed output.
40 """
41 databases = ApdbCassandra.list_databases(host=host)
42 if databases:
43 if verbose:
44 table = Table(names=["Keyspace", "Role", "Permissions"], dtype=[str, str, str])
45 for database in databases:
46 if database.permissions is None:
47 # Can't access auth info.
48 table.add_row([database.name, "N/A", ""])
49 elif database.permissions:
50 for role, perm_list in database.permissions.items():
51 permissions = ", ".join(sorted(perm_list))
52 table.add_row([database.name, role, permissions])
53 else:
54 # Anonymous access should have all permissions, do not
55 # list any specific permissions for that. Anon access
56 # should not be enabled in production.
57 table.add_row([database.name, "anonymous", ""])
58 table.sort(["Keyspace", "Role"])
59 else:
60 table = Table(names=["Keyspace", "Roles[access]"], dtype=[str, str])
61 for database in databases:
62 if database.permissions is None:
63 # Can't access auth info.
64 table.add_row([database.name, "N/A"])
65 elif database.permissions:
66 roles = []
67 for role, perm_list in database.permissions.items():
68 access = _access(perm_list)
69 roles.append(f"{role}[{access}]")
70 table.add_row([database.name, ", ".join(sorted(roles))])
71 else:
72 table.add_row([database.name, "anonymous"])
73 table.sort("Keyspace")
74
75 table.pprint_all(align="<")
76
77
78def _access(permissions: set[str]) -> str:
79 """Convert list of Cassandra permissions into access mode string"""
80 if {"CREATE", "DROP"} & permissions:
81 return "manage"
82 elif "MODIFY" in permissions:
83 return "update"
84 elif "SELECT" in permissions:
85 return "read"
86 else:
87 return "none"
str _access(set[str] permissions)