libsql-experimental-python
libsql-experimental-python copied to clipboard
Published
20 hours ago •
tursodatabase
tursodatabase
Support named parameters with dictionary of values
In sqlite3, these work the way you would expect with each variety of named parameter using a dictionary to specify values:
cur.execute("INSERT INTO users VALUES (:id, :email)", {"id": 2, "email": '[email protected]'})
cur.execute("INSERT INTO users VALUES (@id, @email)", {"id": 3, "email": '[email protected]'})
cur.execute("INSERT INTO users VALUES ($id, $email)", {"id": 4, "email": '[email protected]'})
However, in libsql, these yield the following error:
TypeError: argument 'parameters': 'dict' object cannot be converted to 'PyTuple'
