computer-playbook/roles/web-app-stalwart/files/sql/store/layout.sql at fix/dev-python/python-upper-bound - computer-playbook - Infinito.Nexus Code Hub

kevinveenbirkenbach/computer-playbook

0 Fork 0

mirror of https://github.com/kevinveenbirkenbach/computer-playbook.git synced 2026-11-06 10:59:59 +00:00

Files

T

kevinveenbirkenbachandClaude Opus 5.5 4d9c3c1cfc refactor(web-app-stalwart): group the store SQL files and use the vars SPOT constant

- test_prefix_grouped_files: files/sql/store_database.sql and
  store_layout.sql become files/sql/store/database.sql and layout.sql.
- test_file_spot: test_store_guard.py builds the vars path with
  ROLE_FILE_VARS_MAIN instead of a hard-coded "vars" / "main.yml" chain.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>

2026-10-28 03:46:55 +01:00

10 lines

305 B

SQL

Raw Permalink Blame History

 SELECT
     coalesce((
         SELECT format_type(attribute.atttypid, attribute.atttypmod)
         FROM pg_catalog.pg_attribute AS attribute
         WHERE
             attribute.attrelid = to_regclass('u')
             AND attribute.attname = 'v'
             AND NOT attribute.attisdropped
     ), 'absent');