Skip to content

Instantly share code, notes, and snippets.

🏍
ブンブン

crssnky crssnky

🏍
ブンブン
Block or report user

Report or block crssnky

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@crssnky
crssnky / makeUnitList.sparql
Last active Jun 1, 2019
アイドルごとに所属ユニットを取得する
View makeUnitList.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#>
SELECT ?m (group_concat(?s;separator=",,,,,")as ?u)
WHERE {
?s rdf:type imas:Unit;
schema:member ?m.
}group by (?m) order by (?m)
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 (sample(?n)as ?公演名) (sample(?sD)as ?公演日) (group_concat(?a)as ?出演者)
View 言語に縛られない文字列リテラル.sparql
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
SELECT *
WHERE {
?主語 ?述語 "島村卯月"^^rdf:langString
}
View FIdol.h
USTRUCT(BlueprintType)
struct FIdol{
GENERATED_BODY()
UPROPERTY(BlueprintReadWrite, Category = "imasparql")
FString alternateName;
UPROPERTY(BlueprintReadWrite, Category = "imasparql")
FString birthDate;
UPROPERTY(BlueprintReadWrite, Category = "imasparql")
FString birthPlace;
UPROPERTY(BlueprintReadWrite, Category = "imasparql")
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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>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;rdfs:label ?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>
You can’t perform that action at this time.