Revision 37896
Added by Marek Horst almost 9 years ago
pdbquery.sql | ||
---|---|---|
7 | 7 |
select pubid,pdbid, case when conf=1 then 0.25 when conf=2 then 0.45 when conf = 3 then 0.55 when conf > 3 and conf<7 then 0.75 else 0.9 end as conf from |
8 | 8 |
(unindexed select *, regexpcountwords(var('pdbpos'),context) - regexpcountwords(var('pdbneg'),context) as conf from |
9 | 9 |
(select regexpr("(\b\d\w{3})",middle) as pdbid,pubid, j2s(prev1,prev2,prev3,prev4,prev5,prev6,prev7,prev8,prev9,prev10,middle,next1,next2,next3,next4,next5) as context from |
10 |
(select c1 as pubid,textwindow(comprspaces(lower(filterstopwords(regexpr('[^\w-]',c2,' ')))) ,-10,5,'(?:-|^)\d\w{3}(?:-|$)') from (select * from (setschema 'c1,c2' select jsonpath(c1, '$.id', '$.text') from stdinput()) where c2 is not null)) |
|
10 |
(setschema 'pubid,prev1,prev2,prev3,prev4,prev5,prev6,prev7,prev8,prev9,prev10,middle,next1,next2,next3,next4,next5' select c1 as pubid,textwindow(comprspaces(lower(filterstopwords(regexpr('[^\w-]',c2,' ')))) ,-10,5,'(?:-|^)\d\w{3}(?:-|$)') from (select * from (setschema 'c1,c2' select jsonpath(c1, '$.id', '$.text') from stdinput()) where c2 is not null))
|
|
11 | 11 |
where regexpr("(\b\d\w{3})",middle) in (select c1 from pdb))) |
12 | 12 |
|
13 | 13 |
where (pdbid != "3dna" or not regexprmatches(var('dnaneg'),context)) and |
Also available in: Unified diff
merging trunk changes with 20150518_new_funding_model branch