import base64, subprocess, os
SD='/tmp/claude-0/-home-danvics-docker-quiz/c1e0577a-e42c-4a3d-b1ea-3edd61103a4e/scratchpad'
rows=[l.split('|') for l in open(f'{SD}/plates.txt').read().strip().split('\n')]
script = "import base64,sys\nfrom app.services import storage_service\n"
script += "for key in %r:\n    d=storage_service.load(key)\n    print(key + ' ' + base64.b64encode(d).decode())\n" % [r[1] for r in rows]
out = subprocess.run(["docker","compose","exec","-T","-w","/app","-e","PYTHONPATH=/app","backend","python","-c",script],
                     capture_output=True, text=True, cwd='/home/danvics/docker/quiz')
by_key = {}
for line in out.stdout.strip().split('\n'):
    if ' ' in line:
        k, b = line.split(' ', 1)
        by_key[k] = b
for r in rows:
    if r[1] in by_key:
        open(f"{SD}/plates/{r[0]}.png","wb").write(base64.b64decode(by_key[r[1]]))
print(len(by_key), "written")