sqlalchemy mysql死锁_sqlalchemy连接数据库踩过的坑

网上很多代码给的连接数据库是连的sqlite的例子，按照以下方法写没问题，我还用了ORM

# -*- coding:utf-8 -*-

from sqlalchemy import create_engine,Column,Integer,String

from sqlalchemy.orm import sessionmaker

from sqlalchemy.ext.declarative import declarative_base

dbPath = 'sqlite:Users/mbp/Downloads/JA.db'

engine = create_engine(dbPath,echo=True)

Session = sessionmaker(bind=engine)

session = Session()

Base = declarative_base()

class Actresses(Base):

__tablename__ = 'JA_NAME'

id = Column('id', Integer, primary_key=True, autoincrement=True)

name = Column('NAME_URL',String)

nameUrl = Column('NAME',String)

act = session.query(Actresses).all()

print act

如果有同学依葫芦画瓢把数据库地址直接改成mysql的连接就会报错

raise EnvironmentError("%s not found"