[v1.0.0b] - OCR recipe batch creation capped at 10 recipes

[Bibz87]

First Check

• This is not a feature request
• I added a very descriptive title to this issue.
• I used the GitHub search to find a similar issue and didn't find it.
• I searched the Mealie documentation, with the integrated search.
• I already read the docs and didn't find an answer.

What is the issue you are experiencing?

Creating more than 10 recipes using the API (POST /api/recipes/create-ocr) without renaming them will cause an internal server error.

Log:

INFO:     10.42.1.101:55522 - "POST /api/recipes/create-ocr HTTP/1.1" 500 Internal Server Error
ERROR:    Exception in ASGI application
Traceback (most recent call last):
  File "/opt/pysetup/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
    self.dialect.do_execute(
  File "/opt/pysetup/.venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 748, in do_execute
    cursor.execute(statement, parameters)
sqlite3.IntegrityError: UNIQUE constraint failed: recipes.slug, recipes.group_id

Adding a name parameter to the API (like the one POST /api/recipes has) would help fixing the issue by explicitly giving a name to the created recipe.

Also, the API could return a 409 in these situations instead of simply returning a generic server error. That would help diagnose problems when using the API.

This issue also makes Mealie's Frontend UI fail silently when creating more than 10 OCR recipes without changing their title.

Deployment

Other

Deployment Details

Both components deployed to Kubernetes (k3s):

• API image: hkotel/mealie:api-nightly
• Frontend image: hkotel/mealie:frontend-nightly

Build info:
Details
Version: nightly
Build: 674774d
Application Mode: Production
Demo Status: Not Demo
API Port: 9000
API Docs: Enabled
Database Type: sqlite
Recipe Scraper Version: 14.36.0

Checks
Secure Site: Yes
Server Side Base URL: Yes
LDAP Ready: No
Email Configured: No
Docker Volumes: success

[Bibz87]

The reason why the limit is 10 seems to come from here.

[michael-genson]

FYI we have decided to remove OCR from Mealie. You can read more on #2838.

If you need to use OCR to import recipes, I recommend using external tools such as this online OCR tool to extract the text, which you then copy-paste into Mealie.