I can't seem to understand what's going on.
The code works fine everywhere except in Visual Studio Code.
Take a look at this example:
import sqlite3
_connection = sqlite3.connect(":memory:")
connection.row_factory = sqlite3.Row
create_table = """
create table food (
id int not null,
data json not null,
primary key(id)
)
"""
insert = """
insert into food (id, data)
values (1, '{"name": "Steak"}')
"""
update = """
update food
set data = json_set(data, '$.name', 'Bacon and Eggs')
where id = 1
"""
fetch_query = "select json_extract(data, '$.name') as name from food where id = 1"
with _connection:
_connection.execute(create_table)
_connection.execute(insert)
_connection.execute(update)
food = _connection.execute(fetch_query)
new_food = dict(food.fetchone()).get('name')
print(new_food)
It should print out Bacon and Eggs but for some reason Visual Studio Code is giving an error saying json_set is not a function.
How can I check the version of sqlite3 being used internally by Visual Studio Code? I'm puzzled why it behaves differently inside vs outside the editor.
Update 1
Linux Terminal
https://i.stack.imgur.com/5j5fg.png
Visual Studio Code https://i.stack.imgur.com/VuEYB.png
Update 2
I'm specifying the Python version explicitly, it's not dependent on VS code to decide. No issues with pip either. Both images show the same version of pip being used.
Vs code https://i.stack.imgur.com/MUkak.png
Linux terminal https://i.stack.imgur.com/oRvYM.png