使用DbtPy连接8s

1

2

3

4

5

6

7

8

9

10

import sys

import DbtPy

print("Python DbtPy测试程序开始运行.\n")

connectStr="PROTOCOL=onsoctcp;HOST=172.14.23.12;SERVICE=9899;SERVER=ol_gbasedbt12;DATABASE=testdb;DB_LOCALE=en_us.8859-1;CLIENT_LOCALE=en_us.8859-1"

conn=DbtPy.connect(connectStr, "gbasedbt", "123456")

stmt = DbtPy.exec_immediate(conn, "select * from YK_YX_RELY_AVC limit 3")

data = DbtPy.fetch_assoc(stmt)

print(data)