擅长:python、mysql、java
<p>更新:根据熊猫团队的说法,这将在熊猫1.2.4中得到修正,截至撰写本文时,该版本尚未发布</p>
<p>添加此作为答案,因为谷歌在这里领先,但接受的答案不适用</p>
<p>使用Pandas<em>的周围代码使用上下文管理器:</p>
<pre><code>with get_engine(dbname).connect() as conn:
df = pd.read_sql(stmt, conn, **kwargs)
return df
</code></pre>
<p>在我的例子中,这个错误是从pandas本身抛出的,而不是在<em>使用</em>pandas的周围代码中抛出的:</p>
<pre><code> /Users/tommycarpenter/Development/python-indexapi/.tox/py37/lib/python3.7/site-packages/pandas/io/sql.py:1430: SADeprecationWarning: The Engine.run_callable() method is deprecated and will be removed in a future release. Use the Engine.connect() context manager instead. (deprecated since: 1.4)
</code></pre>
<p>熊猫本身的片段是:</p>
<pre><code>def has_table(self, name, schema=None):
return self.connectable.run_callable(
self.connectable.dialect.has_table, name, schema or self.meta.schema
)
</code></pre>
<p>我提出了一个问题:<a href="https://github.com/pandas-dev/pandas/issues/40825" rel="nofollow noreferrer">https://github.com/pandas-dev/pandas/issues/40825</a></p>