python删除mysql表无效_python – SqlAlchemy Mysql：由于IntegrityError而无法删除表

当我尝试重新初始化我的数据库时,我不断收到IntegrityError：

sqlalchemy.exc.IntegrityError: (IntegrityError) (1217, 'Cannot delete or update a parent row: a foreign key constraint fails') '\nDROP TABLE users' ()

在我的init_db脚本中,我有：

def main(argv=sys.argv):

if len(argv) != 2:

usage(argv)

config_uri = argv[1]

setup_logging(config_uri)

settings = get_appsettings(config_uri)

engine = create_engine('...')

Session.configure(bind=engine)

session = Session()

Base.metadata.bind=engine

Base.metadata.drop_all(engine)

Base.metadata.create_all(engine)

它会让我删除Users表,这是：

class User(Base):

__tablename__='users'

__table_args__={

'mysql_engine':'InnoDB',

'mysql_charset':'utf8',

}