Goryudyuma

export NEXT_RAIN_TIME
export NEXT_RAIN_TIME_LAST_UPDATE=0

update_weather_countdown() {
  NEXT_RAIN_TIME=$(curl -s 'https://map.yahooapis.jp/weather/V1/place?coordinates=139.7649361,35.6812405&appid=$(Client ID)&output=json&interval=5' | jq -r -c '.Feature[0].Property.WeatherList.Weather | map(select(.["Rainfall"] > 0)) | .[0].Date')
  NEXT_RAIN_TIME_LAST_UPDATE=$(date '+%s')
}
PERIOD=60
add-zsh-hook periodic update_weather_countdown

Goryudyuma

$ mysql -uroot

mysql> create database testDB;
Query OK, 1 row affected (0.00 sec)

mysql> use testDB
Database changed

mysql> create table A(num int not null unique);
Query OK, 0 rows affected (0.03 sec)

Goryudyuma

def authenticate(email, password)
  user = db.xquery('SELECT * FROM users WHERE email = ?', email).first
  fail Ishocon1::AuthenticationError unless user[:password] == password
  session[:user_id] = user[:id]
end

def current_user
  db.xquery('SELECT * FROM users WHERE id = ?', session[:user_id]).first
end

Goryudyuma

<?php
$i = 1;
while(true):
	if($i%15 === 0):
		echo 'FizzBuzz';
	elseif($i%3 === 0):
		echo 'Fizz';
	elseif($i%5 === 0):
		echo 'Buzz';
	else:

Goryudyuma

WITH RECURSIVE
tblidx AS (
    SELECT ROW_NUMBER() OVER() AS id, x, y 
    FROM tbl),
root AS (
    SELECT ROW_NUMBER() OVER() AS id, map.aid AS aid, map.bid AS bid, map.len AS len 
    FROM (
        SELECT a.id AS aid, b.id AS bid, 
            SQRT(POW(a.x-b.x,2)+POW(a.y-b.y,2)) AS len 
        FROM tblidx AS a 

Goryudyuma

WITH RECURSIVE solve(strrow,str) AS (
    SELECT str,str
    FROM tbl
  UNION ALL
    SELECT strrow,REPLACE(REPLACE(REPLACE(str, '()', ''),'{}',''),'[]','') 
    FROM solve 
    WHERE str!=REPLACE(REPLACE(REPLACE(str, '()', ''),'{}',''),'[]','')
)
SELECT i, 
  CASE WHEN str IN 

Goryudyuma

SELECT n

FROM (
  (WITH RECURSIVE numbers (x) AS (
    SELECT 2
  UNION ALL
    SELECT x + 1 FROM numbers WHERE x <= 10000) 
  SELECT tbl.n, COUNT(tbl.n) 
  FROM numbers AS n
  INNER JOIN tbl 

Goryudyuma

WITH RECURSIVE solve(min, max, n) AS (
    VALUES(1.0, 2.1, 0)
  UNION ALL
    SELECT 
    (
      CASE WHEN t.a * POWER( 2.718281828459045235360287471352, (s.min + s.max) / 2) + t.b * POW((s.min + s.max) / 2, 3) + t.c * (s.min + s.max) / 2 + t.d > 0 THEN
        s.min
      ELSE 
        (s.min + s.max) / 2
     END

Goryudyuma

SELECT i, TRANSLATE(str, 
  'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ', 
  'nopqrstuvwxyzabcdefghijklmNOPQRSTUVWXYZABCDEFGHIJKLM'
  ) AS converted_str 
FROM tbl;

Goryudyuma

SELECT n,
  CASE 
    WHEN n % 15 = 0 THEN 'FizzBuzz'
    WHEN n % 3 = 0 THEN 'Fizz'
    WHEN n % 5 = 0 THEN 'Buzz'
    ELSE CAST(n AS text)
  END AS f 
FROM 
  GENERATE_SERIES(
    (SELECT a FROM tbl),