kyontan

録画リスト

名前	局	放送時間	done
魔法少女 俺	TOKYO MX	2018/04/03(Tuesday) 01:40〜	done
立花館To Lieあんぐる	TOKYO MX	2018/04/04(Wednesday) 01:00〜	done
3D彼女 リアルガール	日本テレビ	2018/04/04(Wednesday) 01:59〜	done
ありすorありす	TOKYO MX	2018/04/04(Wednesday) 22:25〜	done
アイカツフレンズ！	テレビ東京系	2018/04/05(Thursday) 18:25〜	done
多田くんは恋をしない	TOKYO MX	2018/04/05(Thursday) 22:00〜	done
こみっくがーるず	TOKYO MX	2018/04/05(Thursday) 23:30〜	done

kyontan

#standardSQL

-- ref: https://gist.github.com/campoy/122f5e24740488e6ea3c973ab195e158

CREATE TEMPORARY FUNCTION twice(x INT64)
RETURNS INT64
LANGUAGE js AS """
  const memory = new WebAssembly.Memory({ initial: 256, maximum: 256 });
  const env = {
      'abortStackOverflow': _ => { throw new Error('overflow'); },

kyontan

# [1, 2].atom_map{|x| Integer === x ? x * 2 : x }
# => [2, 4]
#
# [1, 2, [3, 4]].atom_map{|x| Integer === x ? x * 2 : x }
# => [2, 4, [6, 8]]
#
# [1, 2, [3, {k: 4, v: 3}]].atom_map{|x| Integer === x ? x * 2 : x }
# => [2, 4, [6, {:k=>8, :v=>6}]]
#

kyontan

#!/usr/bin/env ruby

require "json"
require "ipaddress"

patterns = [
  "10\\.([0-9]|[1-9][0-9]|1([0-9][0-9])|2([0-4][0-9]|5[0-5]))\\.([0-9]|[1-9][0-9]|1([0-9][0-9])|2([0-4][0-9]|5[0-5]))\\.([0-9]|[1-9][0-9]|1([0-9][0-9])|2([0-4][0-9]|5[0-5]))",
  "172\\.(1[6-9]|2[0-9]|3[0-1])\\.([0-9]|[1-9][0-9]|1([0-9][0-9])|2([0-4][0-9]|5[0-5]))\\.([0-9]|[1-9][0-9]|1([0-9][0-9])|2([0-4][0-9]|5[0-5]))",
  "192\\.168\\.([0-9]|[1-9][0-9]|1([0-9][0-9])|2([0-4][0-9]|5[0-5]))\\.([0-9]|[1-9][0-9]|1([0-9][0-9])|2([0-4][0-9]|5[0-5]))",
]

kyontan

$ embulk run -b ./ -l debug test.yaml.liquid -c test_diff.yaml                                 
2019-02-27 15:22:24.626 +0000: Embulk v0.8.18
2019-02-27 15:22:26.115 +0000 [INFO] (0001:transaction): Loaded plugin embulk-input-mysql (0.9.3)
2019-02-27 15:22:26.144 +0000 [INFO] (0001:transaction): Loaded plugin embulk-output-gcs (0.4.3)
2019-02-27 15:22:26.175 +0000 [INFO] (0001:transaction): JDBC Driver = /some_path/vendor/bundle/jruby/2.3.0/gems/embulk-input-mysql-0.9.3/default_jdbc_driver/mysql-connector-java-5.1.44.jar
2019-02-27 15:22:26.183 +0000 [INFO] (0001:transaction): Fetch size is 10000. Using server-side prepared statement.
2019-02-27 15:22:26.184 +0000 [INFO] (0001:transaction): Connecting to jdbc:mysql://xxx options {useCompression=true, socketTimeout=3600000, useSSL=..., user=..., useLegacyDatetimeCode=..., tcpKeepAlive=..., useCursorFetch=..., connectTimeout=..., password=***, zeroDateTimeBehavior=convertToNull}
2019-02-27 15:22:26.436 +0000 [INFO] (0001:transaction): Using JDBC Driver mysql-co

kyontan

version: '2'

services:
  db:
    container_name: database
    image: mariadb:10.2.22
    ports:
      - "3306:3306"
    volumes:
      - ./db:/var/lib/mysql

kyontan

Patch to use ECDSA keys in PKCS#11

This is updated version of https://bugzilla.mindrot.org/show_bug.cgi?id=2474

Tested under macOS Mojave 10.14.4 with Homebrew to use YubiKey 5C

# openssl version
OpenSSL 1.0.2r  26 Feb 2019
# ssh -V

kyontan

MERGE {destination} T
USING (
  SELECT * EXCEPT(rn)
  FROM (
    SELECT
      *,
      row_number() over (PARTITION BY {primary_keys} ORDER BY updated_at DESC) AS rn
    FROM {source})
    WHERE rn = 1
) S

kyontan

-- HOWTO:
-- after saving it, open with Script Editor (default) and run it

-- PREREQUISITES:
-- make sure your Keynote presentation is open in the background

set presenterNotes to ""
set slideNumber to 1

tell application "Keynote"

kyontan

class LazyProduct
  include Enumerable

  def initialize(array)
    @array = array
  end

  def self.from(array)
    new(array)
  end