飞道科技

飞道科技文档总汇

如何连接两个表

参见./service/src/db-join.ts

两组数据使用join链接

import join from './atom/db/join-inner';

const a = [{'a':'a1','b':'b1','c':'c1'},{'a':'a2','b':'b2','c':'c2'},{'a':'a3','b':'b3','c':'c3'},{'a':'a4','b':'b4','c':'c4'}];
const b = [{'a':'a3','d':'d3','e':'e3'},{'a':'a4','d':'d4','e':'e4'},{'a':'a5','d':'d5','e':'e5'}];

const c = join(a,b,'a','a');
// 返回的数据为
[{'a':'a3','b':'b3','c':'c3','d':'d3','e':'e3'},{'a':'a4','b':'b4','c':'c4','d':'d4','e':'e4'}]
////////////////////////

const a = [{'a':'a1','b':'b1','c':'c1'},{'a':'a2','b':'b2','c':'c2'},{'a':'a3','b':'b3','c':'c3'},{'a':'a4','b':'b4','c':'c4'},{'a':'a5','b':'b5','c':'c5'}];
const b = [{'a':'a3','d':'d3','e':'e3'},{'a':'a5','d':'d5','e':'e5'},{'a':'a4','d':'d4','e':'e4'}];

const c = join(a,b,'a','a');
// 返回的数据为,数据顺序为右侧数据顺序
[{'a':'a3','b':'b3','c':'c3','d':'d3','e':'e3'},{'a':'a5','b':'b5','c':'c5','d':'d5','e':'e5'},{'a':'a4','b':'b4','c':'c4','d':'d4','e':'e4'}]

const c = join(b, a,'a','a');
[{'a':'a3','b':'b3','c':'c3','d':'d3','e':'e3'},{'a':'a4','b':'b4','c':'c4','d':'d4','e':'e4'},{'a':'a5','b':'b5','c':'c5','d':'d5','e':'e5'}]