conn = dbapi.connect(
address = 'hxehost',
port = '39013', # connecting to the HANA system, not the DB directly
user = '...',
password = '...',
databasename = 'HXE', # using the DB name instead of a port number
#key='USER1UserKey', # address, port, user and password are retreived from the hdbuserstore
encrypt=True, # must be set to True when connecting to HANA Cloud
sslValidateCertificate=False # True HC, False for HANA Express.
)
#If no errors, print connected
print('connected')
c1 = conn.cursor()
c1.execute("SET SCHEMA R_C") # < here we set the current schema for the connection
c1.execute("SELECT current_schema FROM DUMMY") # < checking the current schema
rows = c1.fetchall(); # < [('R_C',)]
AFAIK没有允许设置/切换到特定架构的连接属性
但是,您可以轻松地做到的是,在创建连接后立即切换到所需的模式:
这对我来说很好,除了设置模式的额外命令之外,我没有看到任何副作用
相关问题 更多 >
编程相关推荐