#!/usr/bin/env python3
import json, subprocess, sys

env = {'GOG_KEYRING_PASSWORD': '', 'PATH': '/usr/local/bin:/usr/bin:/bin', 'HOME': '/root'}
result = subprocess.run(
    ['gog', 'sheets', 'get', '1lPFmhuXnlTchsqE_V5Ntx7k46NFfHSGnldyeL6hH_jQ', 'A1:Z1000',
     '--account', 'alihajouoc@gmail.com', '--json'],
    capture_output=True, text=True, env=env,
    cwd='/root/.openclaw.pre-migration/workspace'
)
if result.returncode != 0:
    print(f'Error: {result.stderr}', file=sys.stderr)
    sys.exit(1)

data = json.loads(result.stdout)
rows = data.get('values', [])
print(f'Total rows: {len(rows)}')

pending = []
for i, row in enumerate(rows):
    if len(row) >= 4 and row[3] and row[3] != '4':
        task_id = row[0] if len(row) > 0 else ''
        name = row[1] if len(row) > 1 else ''
        cat = row[2] if len(row) > 2 else ''
        status = row[3] if len(row) > 3 else ''
        desc = row[4] if len(row) > 4 else ''
        print(f'Row {i+1}: ID={task_id}, Name={name}, Cat={cat}, Status={status}')
        if status in ('1', '2', '3') and task_id:
            pending.append({'row': i+1, 'id': task_id, 'name': name, 'status': status, 'desc': desc})

print(f'\nPending tasks: {len(pending)}')
for p in pending:
    print(f"  {p}")