add named query generation

[WolfgangFahl]

ceur-ws -nq > resources/queries.yaml

[WolfgangFahl]

sparqlquery -qp resources/queries.yaml --list
AllVolumes:AllVolumes
AllPapers:AllPapers
AllEvents:AllEvents
AllInstitutions:AllInstitutions
NumberOfPapersInWorkshop:NumberOfPapersInWorkshop
AverageNoOfPagesInWorkshop:AverageNoOfPagesInWorkshop
Publication_turnaround:Publication_turnaround

[WolfgangFahl]

sparqlquery -qp resources/queries.yaml -qn AllVolumes --limit 7 -f github

AllVolumes

query

# Q0.1
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT DISTINCT ?proceeding ?volumeNumber ?title 
  (SAMPLE(?_short_name) as ?short_name)
  (SAMPLE(?_pubDate) as ?pubDate)
  (SAMPLE(?_ceurwsUrl) as ?ceurwsUrl)
  (SAMPLE(?_language_of_work_or_name) as ?language_of_work_or_name)
  (SAMPLE(?_fullWorkUrl) as ?fullWorkUrl)
  (SAMPLE(?_urn) as ?urn)
  (SAMPLE(?_dblpPublicationId) as ?dblpPublicationId)
  (SAMPLE(?_K10plus) as ?K10plus)
WHERE{
  ?proceeding wdt:P31 wd:Q1143604.
  ?proceeding wdt:P179 wd:Q27230297.
  ?proceeding p:P179/pq:P478 ?volumeNumber.
  ?proceeding wdt:P1476 ?title. Filter(lang(?title)="en")
  OPTIONAL{?proceeding wdt:P1813 ?_short_name.}
  OPTIONAL{?proceeding wdt:P577 ?_pubDate.}
  OPTIONAL{?proceeding wdt:P973 ?_ceurwsUrl.}
  OPTIONAL{?proceeding wdt:P407 ?_language_of_work_or_name.}
  OPTIONAL{?proceeding wdt:953 ?_fullWorkUrl.}
  OPTIONAL{?proceeding wdt:P4109 ?_urn.}
  OPTIONAL{?proceeding wdt:P8978 ?_dblpPublicationId.}
  OPTIONAL{?proceeding wdt:P6721 ?_K10plus.}
} 
GROUP BY ?volumeNumber ?proceeding ?title
ORDER BY DESC(xsd:integer(?volumeNumber))

try it!

result

proceeding	volumeNumber	title	short_name	pubDate	ceurwsUrl	urn
http://www.wikidata.org/entity/Q117221730	3360	Proceedings of the Scholar’s Yearly Symposium of Technology, Engineering and Mathematics	SYSTEM 2022	2023-03-19 00:00:00	http://ceur-ws.org/Vol-3360/	urn:nbn:de:0074-3360-6
http://www.wikidata.org/entity/Q117190514	3359	Joint Proceedings of the IUI 2023 Workshops: HAI-GEN, ITAH, MILC, SHAI, SketchRec, SOCIALIZE	IUI-WS 23	2023-03-16 00:00:00	http://ceur-ws.org/Vol-3359/	urn:nbn:de:0074-3359-9
http://www.wikidata.org/entity/Q117190511	3358	Joint Proceedings of the 10th Illia O. Teplytskyi Workshop on Computer Simulation in Education, and Workshop on Cloud-based Smart Technologies for Open Education (CoSinEi and CSTOE 2022)	CoSinE and CSTOE 2022	2023-03-12 00:00:00	http://ceur-ws.org/Vol-3358/	urn:nbn:de:0074-3358-1
http://www.wikidata.org/entity/Q117190509	3357	Proceedings of the 4th Crowd Science Workshop on Collaboration of Humans and Learning Algorithms for Data Labeling	CSW 2023	2023-03-12 00:00:00	http://ceur-ws.org/Vol-3357/	urn:nbn:de:0074-3357-8
http://www.wikidata.org/entity/Q117074898	3356	Joint Short Paper Proceedings of the 4th International Workshop on Experience with SQuaRE Series and Its Future Direction, and 1st Asia-Pacific Software Engineering and Diversity, Equity, and Inclusion Workshop	IWESQ 2022 + APSEDEI 2022	2022-03-12 00:00:00	http://ceur-ws.org/Vol-3356/	urn:nbn:de:0074-3356-4
http://www.wikidata.org/entity/Q117074895	3355	Proceedings of the First International Workshop on Semantic Industrial Information Modelling (SemIIM 2022)	SemIIM 2022	2023-03-11 00:00:00	http://ceur-ws.org/Vol-3355/	urn:nbn:de:0074-3355-1
http://www.wikidata.org/entity/Q117018489	3354	Proceedings of the 6th Workshop on Advances in Argumentation in Artificial Intelligence 2022	AI^3 2022	2023-03-07 00:00:00	http://ceur-ws.org/Vol-3354/	urn:nbn:de:0074-3354-7