Scholia Parameter Handling

From BITPlan cr Wiki
Revision as of 09:51, 9 July 2024 by Wf (talk | contribs)
Jump to navigation Jump to search

params_stats

query

SELECT count(*),
    params 
FROM "QueryDetails" 
GROUP BY params 
ORDER BY 1 desc


result

count(*) params
682
293 q
14 q1,q2
9 q,q
3 q,q,q
3 p
1 q,q2
1 q,q,q,q,q
1 q,doi,q,doi,q,doi,q,doi,q,doi
1 lexeme
1 keyword

scholia_jinja_for_loops

query

SELECT
  count(*),
  substr(
    sparql,
    instr(sparql, '{% for') + length('{% for'),  -- Start position right after "{% for"
    instr(substr(sparql, instr(sparql, '{% for')), '%}') - length('{% for')  -- Length of substring
  ) as for_loop_content
FROM
  NamedQuery
WHERE
  sparql LIKE '%{% for%' ESCAPE '\' and for_loop_content like "%in%"
group by for_loop_content
order by 1 desc


result

count(*) for_loop_content
28 q in qs %
1 q1 in qs %
1 doi in dois %
1 day in range(-32, 1) %