import spmpool 

# 添加连接池配置
spmpool.add_config('local', 'root', '123456', 'testdb', init_pool_size=20)
spmpool.add_config('remote', 'ujued', '123456', 'db', init_pool_size=120)

# 获取连接池  
local_pool = spmpool.spmpool('local')
remote_pool = spmpool.spmpool('remote')

# 获取连接并使用
conn = local_pool.get()
result = conn.execute('select id, name, password from user')
rows = result.fetchall()
for row in rows:
    print(row.id, row.password, row.name)
conn.close()