Files
rust-discovery/tests/windows_inventory_migration.py
2026-11-13 16:18:04 +01:00

58 lines
3.5 KiB
Python
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
#!/usr/bin/env python3
"""Real isolated PostgreSQL migration test, without ports, agents or RMM jobs."""
from pathlib import Path
import subprocess
import time
import uuid
ROOT=Path(__file__).resolve().parents[1]
NAME='rmm-windows-migration-'+uuid.uuid4().hex[:10]
def command(args,input=None,ok=True):
result=subprocess.run(args,input=input,capture_output=True,timeout=40)
if ok and result.returncode:raise RuntimeError('ISOLATED_POSTGRES_CHECK_FAILED: '+result.stderr.decode(errors='replace')[:500])
return result
def sql(text,ok=True):
return command(['docker','exec','-i',NAME,'psql','-X','-qAt','-v','ON_ERROR_STOP=1','-U','postgres'],text.encode(),ok)
def main():
command(['docker','run','-d','--network','none','--name',NAME,'-e','POSTGRES_HOST_AUTH_METHOD=trust','postgres:17.6-bookworm'])
try:
for _ in range(100):
logs=command(['docker','logs',NAME],ok=False)
if b'init process complete' in logs.stdout and command(['docker','exec',NAME,'pg_isready','-U','postgres'],ok=False).returncode==0:break
time.sleep(.2)
else:raise RuntimeError('ISOLATED_POSTGRES_NOT_READY')
sql('CREATE ROLE rmm_app;')
paths=sorted((ROOT/'migrations').glob('*.sql'))
assert len(paths)==13
for path in paths[:-1]:sql(path.read_text())
a='11111111-1111-4111-8111-111111111111';b='22222222-2222-4222-8222-222222222222'
asset=str(uuid.uuid4());agent=str(uuid.uuid4());boot=str(uuid.uuid4());snapshot=str(uuid.uuid4())
sql(f"INSERT INTO assets(tenant_id,asset_id) VALUES('{a}','{asset}'); INSERT INTO agent_installations(tenant_id,agent_id,asset_id,certificate_sha256) VALUES('{a}','{agent}','{asset}','{'a'*64}');")
def observation(scope,tenant=a,sequence=1):
return f"INSERT INTO observations(tenant_id,agent_id,message_id,boot_id,sequence,observed_at,source_id,quality,completeness,snapshot_id,data,payload_sha256) VALUES('{tenant}','{agent}','{uuid.uuid4()}','{boot}',{sequence},now(),'{scope}','valid','partial','{snapshot}','{{}}','{'b'*64}');"
sql(observation('linux.base'))
before=sql('SELECT row_to_json(o) FROM observations o;').stdout
assert sql(observation('windows.base',sequence=2),ok=False).returncode!=0
sql('BEGIN;'+paths[-1].read_text()+'COMMIT;')
assert sql('SELECT row_to_json(o) FROM observations o;').stdout==before
sql(observation('windows.base',sequence=2))
assert sql(observation('arbitrary.base',sequence=3),ok=False).returncode!=0
assert sql(f"SET ROLE rmm_app; SET app.tenant_id='{a}'; SELECT count(*) FROM observations;").stdout.strip()==b'2'
assert sql(f"SET ROLE rmm_app; SET app.tenant_id='{b}'; SELECT count(*) FROM observations;").stdout.strip()==b'0'
assert sql('SET ROLE rmm_app; SELECT count(*) FROM observations;').stdout.strip()==b'0'
assert sql(f"SET ROLE rmm_app; SET app.tenant_id='{b}';"+observation('windows.base',tenant=b,sequence=3),ok=False).returncode!=0
assert sql('SELECT relrowsecurity FROM pg_class WHERE oid=\'observations\'::regclass;').stdout.strip()==b't'
assert sql('SELECT (SELECT count(*) FROM jobs)+(SELECT count(*) FROM outbox)+(SELECT count(*) FROM execution_permits);').stdout.strip()==b'0'
print('PASS: migrations 1–13 on fresh PostgreSQL; old rows byte-preserved; Windows accepted; arbitrary scope rejected; tenant/missing-context RLS and composite identity FK retained; zero jobs/outbox/grants.')
finally:
command(['docker','rm','-f',NAME],ok=False)
if __name__=='__main__':main()