Instantly share code, notes, and snippets.

🏍
ブンブン

crssnky crssnky

View GitHub Profile
View im@sparqlと"とあるSPARQL"から共通する声優を取得する.sparql
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX schema: <http://schema.org/>
PREFIX imas: <https://sparql.crssnky.xyz/imasrdf/URIs/imas-schema.ttl#>
PREFIX haiku: <https://sparql.crssnky.xyz/SeasonWordsRDF/SeasonWord-schema.ttl#>
PREFIX toaru: <https://metadata.moe/toaru-sparql/elements/>
SELECT distinct (?アイマス声優 as ?声優) {
service<https://metadata.moe/sparql/toaru/query>{
?toaru toaru:cv ?とある声優.
}
View im@sparqlに眠る季語を含むユニット名.sparql
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX schema: <http://schema.org/>
PREFIX imas: <https://sparql.crssnky.xyz/imasrdf/URIs/imas-schema.ttl#>
PREFIX haiku: <https://sparql.crssnky.xyz/SeasonWordsRDF/SeasonWord-schema.ttl#>
SELECT ?季語 ?季節 ?ユニット名{
service<https://sparql.crssnky.xyz/spql/SeasonWords/query>{
?ss haiku:SeasonWord ?季語;
haiku:Season ?季節.
}
View 千早.rdf
<rdf:Description rdf:about="detail/Kisaragi_Chihaya">
<imas:Attribute rdf:datatype="http://www.w3.org/2001/XMLSchema#string">Vo</imas:Attribute>
<schema:familyName xml:lang="ja">如月</schema:familyName>
<imas:familyNameKana xml:lang="ja">きさらぎ</imas:familyNameKana>
<schema:givenName xml:lang="ja">千早</schema:givenName>
<imas:givenNameKana xml:lang="ja">ちはや</imas:givenNameKana>
<imas:nameKana xml:lang="ja">きさらぎちはや</imas:nameKana>
<schema:name xml:lang="ja">如月千早</schema:name>
<foaf:age rdf:datatype="http://www.w3.org/2001/XMLSchema#integer">16</foaf:age>
<schema:height rdf:datatype="http://www.w3.org/2001/XMLSchema#float">162.0</schema:height>
View 前後3日間の誕生日.sparql
PREFIX schema: <http://schema.org/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT (sample(?o) as ?date) (sample(?n) as ?name)
WHERE {
?sub schema:birthDate ?o;
schema:name|schema:alternateName ?n;
bind("--xx-xx"^^xsd:gMonthDay as ?3ago)
bind("--xx-xx"^^xsd:gMonthDay as ?3later)
FILTER(?o>=?3ago && ?o<=?3later).
View im@sparql組み込んでみる.js
const URL = "https://sparql.crssnky.xyz/spql/imas/query?query=";
const Query = ['PREFIX schema: <http://schema.org/>PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>SELECT (sample(?o) as ?date) (sample(?n) as ?name)WHERE {?sub schema:birthDate ?o;schema:name|schema:alternateName ?n;bind("', '"^^xsd:gMonthDay as ?3ago)bind("', '"^^xsd:gMonthDay as ?3later)FILTER(?o>=?3ago && ?o<=?3later).}group by(?sub) order by(?o)'];
const date = new Date();
var strings = [];
date.setDate(date.getDate() - 3)
for (var i = 0; i < 7; i++) {
const month = date.getMonth() + 1;
const day = date.getDate();
strings.push("--" + (month < 10 ? "0" + month : month) + "-" + (day < 10 ? "0" + day : day));
View im@sparql組み込んでみる.html
<!DOCTYPE html>
<html lang="ja" xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8" />
<title>アイドルの誕生日</title>
</head>
<body>
<h1>直近の誕生日</h1>
<div id="0"></div>
<div id="1"></div>
View 千早さんのデータを全部見るまとめ.sparql
PREFIX schema: <http://schema.org/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX imas: <https://sparql.crssnky.xyz/imasrdf/URIs/imas-schema.ttl#>
PREFIX imasrdf: <https://sparql.crssnky.xyz/imasrdf/RDFs/detail/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX math: <http://www.w3.org/2005/xpath-functions/math#>
PREFIX xsd: <https://www.w3.org/TR/xmlschema11-2/#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
select distinct ?predicate ?object
View 千早さんのデータを全部見る.sparql
PREFIX schema: <http://schema.org/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX imas: <https://sparql.crssnky.xyz/imasrdf/URIs/imas-schema.ttl#>
PREFIX imasrdf: <https://sparql.crssnky.xyz/imasrdf/RDFs/detail/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX math: <http://www.w3.org/2005/xpath-functions/math#>
PREFIX xsd: <https://www.w3.org/TR/xmlschema11-2/#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT *
View 千早さんの主語を探す.sparql
PREFIX schema: <http://schema.org/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX imas: <https://sparql.crssnky.xyz/imasrdf/URIs/imas-schema.ttl#>
PREFIX imasrdf: <https://sparql.crssnky.xyz/imasrdf/RDFs/detail/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX math: <http://www.w3.org/2005/xpath-functions/math#>
PREFIX xsd: <https://www.w3.org/TR/xmlschema11-2/#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?千早の主語
View 使われてるクラスを知る.sparql
PREFIX schema: <http://schema.org/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX imas: <https://sparql.crssnky.xyz/imasrdf/URIs/imas-schema.ttl#>
PREFIX imasrdf: <https://sparql.crssnky.xyz/imasrdf/RDFs/detail/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX math: <http://www.w3.org/2005/xpath-functions/math#>
PREFIX xsd: <https://www.w3.org/TR/xmlschema11-2/#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT distinct ?クラス ?クラス名 ?説明