/
Ged52
/
DomainInfo
Обзор
Документация
Войти
/
Ged52
/
DomainInfo
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
values_api.py
17 строк
845 B
Oleg Korshunov
* что-то рабочее
13 июл 2026, 11:45
13 июл 2026, 11:45
cf6a9cc
Код
Авторство
О чём код?
from flask import jsonify from storage import _connect def get_values(): with _connect() as conn: responsible = conn.execute("SELECT DISTINCT responsible FROM domains WHERE responsible != '' ORDER BY responsible").fetchall() organization = conn.execute("SELECT DISTINCT organization FROM domains WHERE organization != '' ORDER BY organization").fetchall() hoster = conn.execute("SELECT DISTINCT hoster FROM domains WHERE hoster != '' ORDER BY hoster").fetchall() groups = conn.execute("SELECT DISTINCT `group` FROM domains WHERE `group` != '' ORDER BY `group`").fetchall() return jsonify({ "responsible": [row[0] for row in responsible], "organization": [row[0] for row in organization], "hoster": [row[0] for row in hoster], "group": [row[0] for row in groups], })