python连接gbase 8a MPP
# coding: utf-8
from GBaseConnector import connect, GBaseError
import struct
def foo(res):
for n in res:
yield n,vsum
if __name__ == '__main__':
config = {'host':'192.168.1.5',
'user':'root',
'password':'',
'port':5258}
try:
conn = connect()
conn.connect(**config)
cur = conn.cursor()
#cur.execute("create DATABASE if exists testpython")
cur.execute("use tt")
#cur.execute("create table x1(id1 int,id2 int,id3 int,id4 int)")
#cur.execute("insert into x1 values(1,2,3,4)")
cur.execute("select * from test limit 100000000000")
res = cur.fetchall()
print("row length is %d" % len(res))
vsum=0
gg=foo(res)
next(gg)
for i in range(len(res)):
gg.send(i)
print('合计=',vsum)
except GBaseError.DatabaseError as err:
print(err)
finally:
conn.close()
cur.close()
res=None