LightDB内置了可以直接访问jres t3后端服务的插件
安装t3插件
zhangliang[lightdb@localhost ~]$ ltsql postgres
ltsql (13.8-22.3)
Type "help" for help.
lightdb@postgres=# create extension t3sdk;
CREATE EXTENSION
请求后端t3服务
lightdb@postgres=# select * from t3sdk_send('ip:port', 'g', 'repo-app', 'v', 'getExpressInfoNdb', '');
- 参数1:JRES微服务侦听地址和端口
- 参数2:微服务分组
- 参数3:微服务应用名
- 参数4:微服务版本号
- 参数5:请求的报文
输出结果
{"result":[{"express_id":"a","order_id":"1","express_no":"123456789","company":"测试公司1","create_datetime":"20230407010201","stat
us":"0"},{"express_id":"b","order_id":"2","express_no":"123456789","company":"测试公司2","create_datetime":"20230407010201","status"
:"0"}]}