Using Python, access SQL database table field with stored path to get Image

Question

I have many combinations of the following Python code, the data is stored in a Microsoft local SQL database, which has a table & field with a path & name of a image to load.

Here is the code:

import pyodbc
from PIL import Image

# Trusted Connection to Named Instance
connection = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER=localhost;DATABASE=MorthoAI;Trusted_Connection=yes;')
cursor=connection.cursor()

cursor.execute("SELECT TOP (1) [Id],[MorthoImagePath] ,[MorthoHipFemurSize]  FROM [MorthoAI].[dbo].[MorthoImagePathFemurSize20Rows]")
while 1:
    row = cursor.fetchone()
    if not row:
        break
    print(row.MorthoImagePath)

    filename = row.MorthoImagePath
    print(filename)

    with Image.open(filename) as image:
            width, height = image.size
cursor.close()
connection.close()

Here is the data: 'C:\dir1\DX PELVIS 1 OR 2 VIEWS LOW AP PELVIS PELVIS FROG BILAT 0001.jpg'

Here is the error happening:

C:\ProgramData\Anaconda3\envs\TF29Py39\python.exe C:/github/murphymj5209/MorthoEntTraining/main.py
Traceback (most recent call last):
  File "C:\github\murphymj5209\MorthoEntTraining\main.py", line 18, in <module>
    with Image.open(filename) as image:
  File "C:\ProgramData\Anaconda3\envs\TF29Py39\lib\site-packages\PIL\Image.py", line 3092, in open
    fp = builtins.open(filename, "rb")
OSError: [Errno 22] Invalid argument: "'C:\\dir1\\DX PELVIS 1 OR 2 VIEWS LOW AP PELVIS PELVIS FROG BILAT 0001.jpg'"
'C:\dir1\DX PELVIS 1 OR 2 VIEWS LOW AP PELVIS PELVIS FROG BILAT 0001.jpg'
'C:\dir1\DX PELVIS 1 OR 2 VIEWS LOW AP PELVIS PELVIS FROG BILAT 0001.jpg'

Process finished with exit code 1

Let me know if you have an idea of why this happening. thanks ahead

Michael Kopp · Accepted Answer · 2022-07-31 21:12:59Z

1

It looks like the filename is repeated multiple times in the filename variable. The error has the path once quoted and twice without quotes.

answered Jul 31, 2022 at 21:12

Michael Kopp

1,73114 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Michael Murphy Over a year ago

As you suggested, I took out the single quotes in my sql table and it worked. thanks

Michael Murphy · Accepted Answer · 2022-07-31 21:44:23Z

0

As you suggested, I took out the single quotes in my sql table and it worked

answered Jul 31, 2022 at 21:44

Michael Murphy

239 bronze badges

Collectives™ on Stack Overflow

Using Python, access SQL database table field with stored path to get Image

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related