class Sqlclient():
def __init__(self, name, obj):
self.name = name #session name
self.obj = obj #数据库实例
self.p = self.get_sql_cli()
def set_handler(self,hs):
self.hs = hs
def get_sql_cli(self):
con_str = "数据库连接串"
pp = pexpect.spawn(con_str)
ret = pp.expect([">", pexpect.TIMEOUT, pexpect.EOF]) # 捕获命令提示符,因为我们qsql 进库后 都是以">"结尾的
print(ret)
if ret == 0:
return pp
def execute_sql(sql,client_p):
if client_p.p :
client_p.p.sendline(sql)
result = sql + "\n"
ret = client_p.p.expect([">", pexpect.TIMEOUT, pexpect.EOF]) # 捕获命令提示符,因为我们qsql 进库后 都是以">"结尾的
if ret == 0:
s = client_p.p.before.decode('utf-8').split('\r')
for line in s[1:-1]:
resul
python之pexpect模块 连接数据库(多session)
最新推荐文章于 2024-09-29 16:19:38 发布