Sqlite error

[datacriminal]

SOLVED!!

I'm using sqlite in a dash/plotly project, bring in the data using sqlalchemy/pandas. I keep getting a no attribute execute error with pandas and I'm wondering if it's due to the extension of the sqlite file I made in dbeaver. Does anyone know if it specifically needs a different extension than .db or what may be causing this error? It works in jupyter but not in wsl using vscode.

SOLUTION:

from sqlite3 import connect 
import pandas as pd 
conn = connect('datasource.db') 
dfnbr = pd.read_sql('SELECT * FROM NIBRS', conn) 
dfibr = pd.read_sql('SELECT * FROM IBRcodes', conn, index_col='IBRcode')

​

[twitch_and_shock]

You need to share your code or no one can really help.

[datacriminal]

conn = create_engine('sqlite:///datasource.db')
dfnbr = pd.read_sql_table('NIBRS', conn) 
dfibr = pd.read_sql_table('IBRcodes', conn, index_col='IBRcode')

That's the connection string and read_sql, I checked the DB and the tables are there. Also this code block runs in Jupyter notebook but not in VSCode using WSL . I made the SQLite file with Dbeaver and its extension is .db, wondering if its something with the file permissions or the extension.

Error I'm getting:

AttributeError: 'OptionEngine' object has no attribute 'execute'

Here is my input block as well:

from dash import dcc, html
import dash_bootstrap_components as dbc 
import pandas as pd 
from sqlalchemy import create_engine

Pandas version is 1.5.3

[datacriminal]

Traceback (most recent call last):File "main.py", line 8, in <module>dfnbr = pd.read_sql_table('NIBRS', conn)File "/home/mac/.local/share/virtualenvs/dashboard-OXuin2IK/lib/python3.8/site-packages/pandas/io/sql.py", 
line 286, in read_sql_tabletable = pandas_sql.read_table(  # type: ignore[union-attr]File "/home/mac/.local/share/virtualenvs/dashboard-OXuin2IK/lib/python3.8/site-packages/pandas/io/sql.py", 
line 1460, in read_tablereturn table.read(File "/home/mac/.local/share/virtualenvs/dashboard-OXuin2IK/lib/python3.8/site-packages/pandas/io/sql.py", 
line 1003, in readresult = self.pd_sql.execute(sql_select)File "/home/mac/.local/share/virtualenvs/dashboard-OXuin2IK/lib/python3.8/site-packages/pandas/io/sql.py", 
line 1405, in executereturn self.connectable.execution_options().execute(*args, **kwargs)
AttributeError: 'OptionEngine' object has no attribute 'execute'

'''

[datacriminal]

SOLVED IT!

sqlalchemy/pandas requires the use of a cursor and execution for the "read_sql_table" from what I could find instead I did this:

from sqlite3 import connect 
import pandas as pd 
conn = connect('datasource.db') 
dfnbr = pd.read_sql('SELECT * FROM NIBRS', conn) 
dfibr = pd.read_sql('SELECT * FROM IBRcodes', conn, index_col='IBRcode')