wikidata synchronization check

[WolfgangFahl]

cd pyCEURmake/ceurws/resources/queries
sqlquery -qn WikidataSync -en ceurws -qp ceurws.yaml -f github

WikidataSync

query

-- Volumes in Proceedings not in Volumes (no title, so we don't include these)
SELECT p.sVolume AS VolumeNumber, NULL AS Title, NULL AS Valid, 
       strftime('%Y-%m-%d', datetime(p.publication_date / 1000000, 'unixepoch')) AS PublicationDate
FROM Proceedings p
LEFT JOIN volumes v ON p.sVolume = v.number
WHERE v.number IS NULL

UNION

-- Volumes in Volumes not in Proceedings (include title, valid flag, and publication date only when title is not NULL)
SELECT v.number AS VolumeNumber, v.title AS Title, v.valid AS Valid, 
       strftime('%Y-%m-%d', datetime(v.pubDate / 1000000, 'unixepoch')) AS PublicationDate
FROM volumes v
LEFT JOIN Proceedings p ON v.number = p.sVolume
WHERE p.sVolume IS NULL AND v.title IS NOT NULL;

result

VolumeNumber	Title	Valid	PublicationDate
559	Proceedings of the Workshop on Semantic Web Applications and Tools for Life Sciences	1	2010-01-19
3609	Proceedings of the 6th International Conference on Informatics & Data-Driven Medicine	1	2024-01-07
3615	Proceedings of the 2nd Workshop on Bias, Ethical AI, Explainability and the role of Logic and Logic Programming	0	2024-01-12
3635	Joint Proceedings of the Workshop on Intelligent Systems (WINS 2023) and the Workshop on Computer Vision and Machine Learning for Healthcare (CVMLH 2023)	0	2024-02-07
3637	Proceedings of the Joint Ontology Workshops 2023	1	2024-02-08
3639	Proceedings of the First Workshop on the Normative Design and Evaluation of Recommender Systems (NORMalize 2023)	1	2023-02-12
3655	Proceedings of the 2nd International Workshop on Intelligent Software Engineering	1	2024-03-21
3656	Proceedings of the Workshop on Scientific Document Understanding	1	2024-02-03
3657	Proceedings of the 8th Human-Computer Interaction Slovenia (HCI SI) Conference 2023	1	2024-03-23
3667	Joint Proceedings of LAK 2024 Workshops	1	2024-04-20
3668	Proceedings of the 8th International Conference on Computational Linguistics and Intelligent Systems. Volume II: Modeling, Optimization, and Controlling in Information and Technology Systems Workshop (MOCITSW-CoLInS 2024)	1	2024-04-24
3669	Proceedings of the 8th International GamiFIN Conference	1	2024-04-25
3670	Proceedings of the AIxIA Doctoral Consortium 2023	1	2024-04-27
3671	Proceedings of Text2Story — Seventh Workshop on Narrative Extraction From Texts	1	2024-04-27
3672	Joint Proceedings of REFSQ-2024 Workshops, Doctoral Symposium, Posters & Tools Track, and Education and Training Track	1	2024-04-27
3673	Proceedings of the 16th ZEUS Workshop on Services and their Composition (ZEUS 2024)	1	2024-04-29
3674	Joint Proceedings of RCIS 2024 Workshops and Research Projects Track	1	2024-04-30
3675	Proceedings of the 5th International Workshop on Intelligent Information Technologies & Systems of Information Security with CEUR-WS		2024-05-03
3676	Proceedings of the 14th International Conference on Business Information Security (BISEC 2023)	1	2024-05-04
3678	Proceedings of the Doctoral Consortium at ISWC 2023		2023-05-07

[WolfgangFahl]

result

VolumeNumber	Title	Valid	PublicationDate
559	Proceedings of the Workshop on Semantic Web Applications and Tools for Life Sciences	1	2010-01-19
3725	Proceedings of the 22nd International Workshop on Satisfiability Modulo Theories	1	2024-07-10