CLAUDE TESTING: Input Validation and Data Processing Failures

[yijint]

This issue was detected by running schemathesis on a Claude-generated API.

• Claude-generated API: https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/openapi/api_claude.yaml
• schemathesis test logs: https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt
• Claude-generated summary of issues: https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/summaries/api_claude.md

Data Processing Failures (~90-95% of errors, ~196-207 failures):

• Missing database records causing assertion failures (e.g., "AssertionError: gid_list is None")
• Type errors when processing data structures (e.g., trying to iterate over scalars)
• Missing backend methods/attributes (e.g., 'get_image_scout_tile_aids' doesn't exist)
• Data format incompatibilities (e.g., eval() expecting strings, unpacking None values)
• Missing required parameters when called without query strings (backend doesn't validate before processing)
• Root cause: Backend functions have insufficient input validation and assume well-formed, database-consistent data

Examples:

• https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt#L48: POST /api/annot/ - add_annots() called with valid parameters but fails during execution
• https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt#L61: PUT /api/annot/bbox/ - set_annot_bboxes() throws exception when processing test data
• https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt#L74: PUT /api/annot/species/ - set_annot_species() fails with test data
• https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt#L87: PUT /api/annot/species/rowid/ - AssertionError: index=0 in gid_list is None (annotations have no associated images in DB)
• https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt#L100: DELETE /api/annot/species/rowid/ - AssertionError: gid_list is None (missing database records)
• https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt#L139: GET /api/annot/image/uuid/ - AssertionError: gid_list is None (annotations not linked to images)
• https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt#L165: PUT /api/annot/yaw/ - AssertionError: gid_list is None (missing image associations)
• https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt#L178: PUT /api/annot/theta/ - AssertionError: gid_list is None (missing image associations)
• https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt#L191: GET /api/annot/vert/ - TypeError: eval() expects string but receives incompatible type
• https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt#L204: PUT /api/annot/vert/ - set_annot_verts() fails processing vertex data
• https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt#L217: GET /api/annot/tile/rowid/ - AttributeError: missing method 'get_image_scout_tile_aids' (backend incomplete)
• https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt#L230: GET /api/annot/image/file/path/ - AssertionError: gid_list is None (no images for annotations)
• https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt#L243: GET /api/image/ - Function fails with test parameters
• https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt#L256: PUT /api/image/uri/ - TypeError: tries to iterate over scalar integer (schemathesis generated int instead of [int])
• https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt#L269: PUT /api/image/gps/ - Function fails with test GPS data
• https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt#L282: PUT /api/image/orientation/ - AssertionError: Cannot find image file path (image path is None in DB)
• https://github.com/WildMeOrg/wildbook-ia/blob/api/api_docs/schemathesis/logs/api_claude.txt#L295: GET /api/image/gps2/ - TypeError: tries to unpack None GPS coordinates