/
rinter
/
1c-kafka-postgres
Обзор
Документация
Войти
/
rinter
/
1c-kafka-postgres
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
main
sql/check_data.sql
15 строк
469 B
rinter
Initial commit: 1C -> Kafka -> PostgreSQL integration
16 июл 2026, 10:49
16 июл 2026, 10:49
0a929fc
Код
Авторство
О чём код?
SELECT 'ownership_forms' AS table_name, count(*) AS total, count(*) FILTER (WHERE deleted) AS deleted_count FROM ownership_forms UNION ALL SELECT 'counterparties', count(*), count(*) FILTER (WHERE deleted) FROM counterparties; SELECT id, code, name, deleted, source_updated_at, imported_at FROM ownership_forms ORDER BY code; SELECT id, code, name, inn, kpp, ownership_form_id, deleted, source_updated_at, imported_at FROM counterparties ORDER BY code;