android sqlite递归,递归SQLite查询

开始

相对

免疫缺陷

包括

B细胞缺陷

包括

免疫缺陷

包括

T细胞缺乏症

包括

DiGeorge综合征

有更多的价值,但这是要点。

我正在尝试进行一个递归查询,以获取

immunodeficiencies

. 例如,我想

Bruton agammaglobulinemia, DiGeorge syndrome

with recursive tc( i )

as ( select endn from dx_graph where startn = 'immunodeficiencies' and rel = 'includes'

union endn from dx_graph, tc where startn = tc.i and rel = 'includes'

)

select * from tc;

样本数据:

CREATE TABLE "dx_graph" (

"startn" TEXT,

"rel" TEXT,

"endn" TEXT,

)

insert into dx_graph values ('immunodeficiencies', 'includes', 'B-cell deficiencies')

insert into dx_graph values ('immunodeficiencies', 'includes', 'T-cell deficiencies')

insert into dx_graph values ('immunodeficiencies', 'includes', 'complement disorders')

insert into dx_graph values ('B-cell deficiencies', 'includes', 'Bruton agammaglobulinemia')

insert into dx_graph values ('T-cell deficiencies', 'includes', 'DiGeorge syndrome')

insert into dx_graph values ('complement disorders', 'includes', 'C1 esterase inhibitor deficiency')

insert into dx_graph values ('complement disorders', 'includes', 'C5-C9 deficiency')