import requests, json

r = requests.post(
    'http://192.168.1.127:8091/api/user/token-auth/',
    json={'email': 'kmorhaim@hotmail.com', 'password': 'nYKG9!x?s8?hCyeb'},
)
token = r.json()['access_token']
headers = {'Authorization': f'JWT {token}'}

fields = [
    ("Problèmes rencontrés", "long_text"),
    ("Solutions trouvées", "long_text"),
    ("Matériel utilisé", "long_text"),
    ("Équipement", "long_text"),
    ("Prochaines étapes", "long_text"),
    ("Photos à prendre", "long_text"),
    ("Conformité sécurité", "single_select"),
    ("Durée chantier", "text"),
    ("Heure début", "text"),
    ("Heure fin", "text"),
    ("Clients présents", "text"),
    ("Coût estimé", "text"),
    ("Documents joints", "long_text"),
    ("Commentaires supplémentaires", "long_text"),
]

for name, ftype in fields:
    if ftype == 'single_select':
        body = json.dumps({
            'type': 'single_select',
            'name': name,
            'settings': {
                'choices': [
                    {'name': 'Conforme'},
                    {'name': 'Non conforme'},
                    {'name': 'En cours'},
                ]
            }
        })
    else:
        body = json.dumps({'type': ftype, 'name': name})

    result = requests.post(
        f'http://192.168.1.127:8091/api/database/fields/table/715/',
        headers=headers,
        json=json.loads(body),
    )
    resp = result.json()
    if 'id' in resp:
        print(f"✓ {resp['name']} ({resp['id']})")
    else:
        print(f"✗ {resp.get('detail', resp)}")

# List all fields
result = requests.get(
    'http://192.168.1.127:8091/api/database/fields/table/715/',
    headers=headers,
)
print("\n--- Table fields ---")
for f in result.json():
    print(f"  {f['id']:4d} | {f['name']:<25s} | {f['type']}")