Circular Import Error while importing create_engine in Sqlalchemy

Question

I am trying the CS50 Web Development with Python Course, and in the sql section, while importing create_engine from sqlalchemy I got this error

ImportError: cannot import name 'create_engine' from partially initialized module 'sqlalchemy' (most likely due to a circular import)

Here is the snippet:

DATABASE_URL = "postgres://usrname:password@YourHost:5432/flights"


from sqlalchemy import create_engine
from sqlalchemy.orm import scoped_session, sessionmaker

engine = create_engine(DATABASE_URL)
db = scoped_session(sessionmaker(bind=engine))   

flights = db.execute("SELECT origin, destination, duration FROM flights").fetchall() 

for flight in flights:
    print(f"{flight.origin} to {flight.destination}, {flight.duration} minutes.")

Timestamp for the Video:

https://video.cs50.net/web/2018/spring/lectures/3?t=1h9m52s

alex · Accepted Answer · 2021-11-23 22:50:52Z

8

This can result from a namespace collision - i.e. naming the file you are executing sqlalchemy.py. To fix this, change the name of the script you are executing to something else.

answered Nov 23, 2021 at 22:50

alex

7,59812 gold badges62 silver badges116 bronze badges

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

Comments

c8999c 3f964f64 · Accepted Answer · 2020-03-09 12:41:41Z

1

I dont see a circular import here, but a possible work-around is to

import sqlalchemy as sqlalchemy_package
engine = sqlalchemy_package.create_engine(DATABASE_URL)

, replacing the line engine = create_engine(DATABASE_URL)

answered Mar 9, 2020 at 12:41

c8999c 3f964f64

1,6491 gold badge18 silver badges32 bronze badges

1 Comment

Vighnesh Pathrikar Over a year ago

I got the problem, It was a dumb mistake, I had my .py file named as sqlalchemy.

Collectives™ on Stack Overflow

Circular Import Error while importing create_engine in Sqlalchemy

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related