digirati-co-uk/capture-models

capture-models's Issues

Error saving OCR

Test fixture + replication required.

Before:

{"id":"5246535f-ee25-4543-ae6c-3f9e75708817","structure":{"id":"e5ec4a70-173c-4f33-86ca-f475ef5b1880","type":"choice","label":"OCR Correction","items":[{"id":"9f5624fc-d05d-4ccc-b674-23f72d0c1e0e","type":"model","label":"Default","fields":[["ocr-correction",[["lines",["text"]]]]]}]},"document":{"id":"69e2a9cb-07e4-4db4-a13d-b051d203d466","type":"entity","label":"OCR Correction","properties":{"ocr-correction":[{"id":"ea0d0a97-e528-4264-9555-6a372b894813","type":"madoc-paragraphs","label":"OCR Correction","value":""}]}},"target":[{"id":"urn:madoc:manifest:9665","type":"Manifest"},{"id":"urn:madoc:canvas:9693","type":"Canvas"}],"profile":null,"derivedFrom":"2420cacd-d8b0-4234-b706-a378a10847a0","contributors":{"urn:madoc:user:1":{"id":"urn:madoc:user:1","type":"Person","name":"Madoc TS"}}}

JSON saved
https://gist.githubusercontent.com/stephenwf/958aa9739b662c260d3545117f71829b/raw/f568979d699f460e4bfbc90d7e6b5f3deefa247a/model.json

error message:

ERROR:  syntax error at or near ")" at character 91
STATEMENT:  SELECT id FROM "models_api"."document" "d" WHERE "d"."parentId" = $1 AND "d"."id" not IN ()
ERROR:  syntax error at or near ")" at character 88
STATEMENT:  SELECT id FROM "models_api"."field" "d" WHERE "d"."parentId" = $1 AND "d"."id" not IN ()