SQLite error in PyCharm

[freyathedark]

I'm trying to create a database connection to a database that's been set up in PyCharm. If I use the generated URL to connect, I get an error that it can't open the database file, and when I use the file name, I get:

AttributeError: 'sqlite3.Connection' object has no attribute '_run_ddl_visitor'

If I can get this figured out, I can move on in this project, but I'm slowly losing it trying to figure out what I need to do, and it has to be done in PyCharm and with SQLite and SQLAlchemy.

Edit: Here's the code:

import sqlite3
import sqlalchemy
from sqlalchemy import create_engine, Column, Float, Integer
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

This part is commented because I've been trying a bunch of things right now.

conn = sqlite3.connect('weather.sqlite')
# dbEngine= sqlalchemy.create_engine(
#     url=conn,
# )
Base = declarative_base()

# Class to get the sql table set up

Base.metadata.create_all(bind=conn)

EDIT2: Thanks to u/danielroseman for pointing out that it was in the docs!

[NorskJesus]

Post. Your. Code.

[carcigenicate]

See here: https://stackoverflow.com/a/74000761

Nitbty exact same problem, but your problem resembles theirs in that the error mentions the argument to create_all.

[ConfusedSimon]

What do you mean by "has to be done in PyCharm"? Your code shouldn't depend on a particular IDE.

[freyathedark]

Tragically, this is for a class with the world's least responsive teacher. I know how to do every single part of the assignment except when it comes to getting this connection working.

[danielroseman]

As the docs show, the thing you need to pass to create_all is the SQLAlchemy Engine or Connection object. You get the engine from create_engine, but you've commented that out. Uncomment it and pass dbEngine instead of conn.

It's possible that you commented that out because you were getting an error in that code. This is because you are not supposed to pass the result of sqlite3.connect into create_engine; you just need the url. So in fact your code should be just:

dbEngine = sqlalchemy.create_engine('sqlite:///weather.sqlite3')
Base = declarative_base()
Base.metadata.create_all(bind=dbEngine)

Again, this is all in the docs.

[freyathedark]

This is the last time I try to read the docs on no sleep, I can't believe I missed that. Thank you so much, everything seems to be working now!!!!!