Snapquery/MetaQueries: Difference between revisions
Jump to navigation
Jump to search
(Created page with "<source lang='bash'> curl -X 'GET' \ 'https://snapquery.bitplan.com/api/meta_query/scholia_jinja_for_loops' \ -H 'accept: application/json' </source> <source lang='json'>...") |
No edit summary |
||
| Line 1: | Line 1: | ||
= Scholia Jinja For Loops Example = | |||
== RESTFul == | |||
<source lang='bash'> | <source lang='bash'> | ||
curl -X 'GET' \ | curl -X 'GET' \ | ||
| Line 24: | Line 26: | ||
] | ] | ||
</source> | </source> | ||
== Format in with dot convention == | |||
https://snapquery.bitplan.com/api/meta_query/scholia_jinja_for_loops.mediawiki | |||
=== query === | |||
<source lang='sql'> | |||
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 | |||
</source> | |||
=== result === | |||
{| class="wikitable" style="text-align: left;" | |||
|+ <!-- caption --> | |||
|- | |||
! align="right"| count(*) !! for_loop_content | |||
|- | |||
| align="right"| 28 || q in qs % | |||
|- | |||
| align="right"| 1 || q1 in qs % | |||
|- | |||
| align="right"| 1 || doi in dois % | |||
|- | |||
| align="right"| 1 || day in range(-32, 1) % | |||
|} | |||
[[Category:Snapquery]] | [[Category:Snapquery]] | ||
Revision as of 12:51, 13 December 2025
Scholia Jinja For Loops Example
RESTFul
curl -X 'GET' \
'https://snapquery.bitplan.com/api/meta_query/scholia_jinja_for_loops' \
-H 'accept: application/json'
[
{
"count(*)": 28,
"for_loop_content": " q in qs %"
},
{
"count(*)": 1,
"for_loop_content": " q1 in qs %"
},
{
"count(*)": 1,
"for_loop_content": " doi in dois %"
},
{
"count(*)": 1,
"for_loop_content": " day in range(-32, 1) %"
}
]
Format in with dot convention
https://snapquery.bitplan.com/api/meta_query/scholia_jinja_for_loops.mediawiki
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) % |