无法运行包含sqlalchemy的代码

7vhp5slm  于 2021-07-29  发布在  Java
关注(0)|答案(1)|浏览(348)

我正在使用postgresql,并尝试在cmd(py list.py)终端中运行以下代码,但无法运行,它显示:
错误消息:

File "list.py", line 3, in <module>
    from sqlalchemy import create_engine
ModuleNotFoundError: No module named 'sqlalchemy'

我需要帮助,因为我试图在虚拟环境目录(pip install sqlalchemy)中运行这个,然后仍然显示相同的错误消息!
代码:

import os

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

engine = create_engine(os.getenv("DATABASE_URL"))
db = scoped_session(sessionmaker(bind=engine))

def main():
    flights = db.execute("SELECT origin, destination, duration FROM flights").fetchall()
    for flight in flights:
        print(f"{flight.origin} to {flight.destination}, {flight.duration} minutes.")

if __name__ == "__main__":
    main()
lyfkaqu1

lyfkaqu11#

最后!!,我在这个有用的页面上找到了答案:https://cs50.stackexchange.com/questions/30610/cs50w-list-py-attributeerror-nonetype-object-has-no-attribute-instantia ,然后需要键入以下命令:

pip3 install Psycopg2

您将成功连接到数据库。

相关问题