lightdb内置特性之jres(t3)远程调用

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"}]}