takanakahiko

function addLog(text/*ログ内容*/) {
  var spreadsheetId = "シートのID";
  var sheetName = "シート1";
  var spreadsheet = SpreadsheetApp.openById(spreadsheetId);
  var sheet = spreadsheet.getSheetByName(sheetName);
  sheet.appendRow([new Date()/*タイムスタンプ*/,text]);
  return text;
}

takanakahiko

ubuntuで自分の環境作るメモ

anyenvいれる

git clone https://github.com/riywo/anyenv ~/.anyenv
echo 'export PATH="$HOME/.anyenv/bin:$PATH"' >> ~/.bash_profile
echo 'eval "$(anyenv init -)"' >> ~/.bash_profile
exec $SHELL -l

takanakahiko

prefix vlueprint: <https://vlueprint.org/schema/>
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>

select ?LABEL ?TWITTER {
  ?uri rdf:type vlueprint:VirtualBeing.
  ?uri rdfs:label ?LABEL.
  ?uri vlueprint:twitterAccount ?TWITTER.
}

takanakahiko

prefix vlueprint: <https://vlueprint.org/schema/>
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>

select ?LABEL ?ORGLABEL {
  ?uri rdf:type vlueprint:VirtualBeing.
  ?uri rdfs:label ?LABEL.
  ?uri vlueprint:belongTo ?orgUri.
  ?orgUri rdfs:label ?ORGLABEL.
}

takanakahiko

prefix vlueprint: <https://vlueprint.org/schema/>
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>

select ?YOUTTUBE {
  ?uri vlueprint:youtubeChannelId ?YOUTTUBE.
  ?uri rdfs:label "月ノ美兎".
}

takanakahiko

// これを全てコピーしてjavascriptコンソールに貼り付けて実行します
setInterval(() => {
  const video = document.getElementById("player-embed-videoid_html5_api");
  if(video.currentTime>1088) video.currentTime=954;
 }, 1000);

takanakahiko

// これを全てコピーしてjavascriptコンソールに貼り付けて実行します
setInterval(() => {
  const video = document.getElementById("player-embed-videoid_html5_api");
  if(video.currentTime>1088) video.currentTime=954;
 }, 1000);

takanakahiko

var CONSUMER_KEY = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';
var CONSUMER_SECRET = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';
var PROJECT_KEY = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';

function AccessTwitter(endPoint,payload,method) {
  var service = getTwitterService();
  if (service.hasAccess()) {
    var url = 'https://api.twitter.com/1.1/'+endPoint+'.json';
    var options = {
      method: method,

takanakahiko

PREFIX prism: <https://prismdb.takanakahiko.me/prism-schema.ttl#>

SELECT ?n ?st ?title
WHERE {
    ?live a prism:Live;
        prism:performer "solami_smile";
        prism:songPerformed/prism:name ?title;
        prism:liveOfEpisode ?ep.
    ?ep a prism:Episode;
        prism:話数 ?n;

takanakahiko

PREFIX prism: <https://prismdb.takanakahiko.me/prism-schema.ttl#>
PREFIX imas: <https://sparql.crssnky.xyz/imasrdf/URIs/imas-schema.ttl#>
PREFIX toaru: <https://metadata.moe/toaru-sparql/elements/>
SELECT distinct (?prism_cv as ?cv) {
   service<https://sparql.crssnky.xyz/spql/imas/query>{
      ?imas imas:cv ?imas_cv.
   }
   ?prism prism:cv ?prism_cv.
   filter((str(?prism_cv)=str(?imas_cv)))
}