擅长:python、mysql、java
<p>对于那些寻找如何指定<em>服务名</em>而不是SID的用户。</p>
<p>来自<a href="http://docs.sqlalchemy.org/en/latest/changelog/changelog_10.html#change-1.0.0b1" rel="nofollow noreferrer">changelog</a>的SQLAlchemy 1.0.0b1(2015年3月13日发布):</p>
<blockquote>
<p>[oracle] [feature] Added support for cx_oracle connections to a
specific service name, as opposed to a tns name, by passing
<code>?service_name=<name></code> to the URL. Pull request courtesy Sławomir
Ehlert.</p>
</blockquote>
<p>更改引入了新的Oracle方言特定选项<strong><code>service_name</code></strong>,该选项可用于构建如下连接字符串:</p>
<pre><code>from sqlalchemy import create_engine
from sqlalchemy.engine import url
connect_url = url.URL(
'oracle+cx_oracle',
username='some_username',
password='some_password',
host='some_host',
port='some_port',
query=dict(service_name='some_oracle_service_name'))
engine = create_engine(connect_url)
</code></pre>