How to add a file path into the SQLite3 database without experiencing sqlite3.InterfaceError?

Question

Here's my code:

import sqlite3
from pathlib import WindowsPath

#Create database
conn = sqlite3.connect('file_path.db')
cursor = conn.cursor()

cursor.execute('''
    CREATE TABLE IF NOT EXISTS paths (
        id INTEGER PRIMARY KEY,
        file_path TEXT NOT NULL
    )
''')

cursor.execute('SELECT * FROM paths WHERE id = 1')

#Read input
input_path = input('enter file path: ')
path = WindowsPath(input_path.replace('"', ''))


#insert path
cursor.execute('INSERT INTO paths (id, file_path) VALUES (1, ?)', (path,))

conn.commit()

With the input something like:

enter file path: C:\Users\User\File

The following error pops up:

    cursor.execute('INSERT INTO paths (id, file_path) VALUES (1, ?)', (path,))
sqlite3.InterfaceError: Error binding parameter 0 - probably unsupported type.

Anyone know how to resolve this? The end goal is to store this file path into the database so I can use it later on.

Alexander · Accepted Answer · 2024-06-17 02:32:32Z

0

The problem isn't that it is a file path the problem is that it is a WindowsPath. sqlite is expecting a string and instead it is getting and object of type WindowsPath and doesn't know what to do with it, hence the error.

Simply wrapping path in a str will solve your issue.

Example:

cursor.execute('INSERT INTO paths (id, file_path) VALUES (1, ?)', (str(path),))

answered Jun 17, 2024 at 2:32

Alexander

17.5k5 gold badges15 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

How to add a file path into the SQLite3 database without experiencing sqlite3.InterfaceError?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related