57 lines
2.8 KiB
Python
57 lines
2.8 KiB
Python
"""Run inside a governance container. Read the real application DB ledger only."""
|
|
import json
|
|
import os
|
|
import subprocess
|
|
from urllib.parse import parse_qsl, unquote, urlsplit
|
|
|
|
|
|
def connection_env(env):
|
|
# Keep only the connection properties actually shared by libpq and pgx.
|
|
# Unknown DSN options can change the database identity or schema search path.
|
|
u = urlsplit(env['DATABASE' + '_URL'])
|
|
if u.scheme not in ('postgres', 'postgresql') or not u.hostname or not u.username or not u.path[1:] or u.fragment:
|
|
raise ValueError('invalid database URL')
|
|
query = parse_qsl(u.query, strict_parsing=True, keep_blank_values=True)
|
|
supported = {'sslmode': 'PGSSLMODE', 'sslrootcert': 'PGSSLROOTCERT', 'sslcert': 'PGSSLCERT', 'sslkey': 'PGSSLKEY'}
|
|
if len(dict(query)) != len(query) or any(key not in supported or not val for key, val in query):
|
|
raise ValueError('unknown database connection options')
|
|
safe = {'PATH': '/usr/bin:/bin', 'HOME': env.get('HOME', '/nonexistent'), 'LC_ALL': 'C',
|
|
'PGHOST': u.hostname, 'PGPORT': str(u.port or 5432), 'PGDATABASE': unquote(u.path[1:]),
|
|
'PGUSER': unquote(u.username), 'PGCONNECT_TIMEOUT': '5',
|
|
'PGOPTIONS': '-c default_transaction_read_only=on -c statement_timeout=5000'}
|
|
for name in ('PGPASSFILE', 'PGSSLMODE', 'PGSSLROOTCERT', 'PGSSLCERT', 'PGSSLKEY'):
|
|
if env.get(name):
|
|
safe[name] = env[name]
|
|
for name in env:
|
|
if name.startswith('PG') and name not in safe:
|
|
raise ValueError('unknown inherited database connection options')
|
|
safe.update({supported[key]: value for key, value in query})
|
|
if u.password:
|
|
safe['PGPASSWORD'] = unquote(u.password)
|
|
for name in ('PGDATABASE', 'PGUSER'):
|
|
if any(char in safe[name] for char in '\r\n\x00='):
|
|
raise ValueError('unsafe database identifier')
|
|
return safe
|
|
|
|
|
|
def main():
|
|
env = connection_env(os.environ)
|
|
sql = """SELECT json_build_object('database', current_database(), 'user', current_user,
|
|
'read_only', current_setting('transaction_read_only'),
|
|
'versions', (SELECT json_agg(version ORDER BY version) FROM schema_migrations));"""
|
|
p = subprocess.run(['psql', '-XAtw', '-v', 'ON_ERROR_STOP=1', '-c', sql],
|
|
env=env, capture_output=True, timeout=12)
|
|
if p.returncode:
|
|
raise ValueError('query failed')
|
|
data = json.loads(p.stdout)
|
|
if data['read_only'] != 'on' or data['database'] != env['PGDATABASE'] or data['user'] != env['PGUSER']:
|
|
raise ValueError('database identity mismatch')
|
|
print(json.dumps(data['versions']))
|
|
|
|
|
|
if __name__ == '__main__':
|
|
try:
|
|
main()
|
|
except (OSError, ValueError, KeyError, subprocess.TimeoutExpired):
|
|
raise SystemExit('read-only migration probe failed') from None
|