This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ 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) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
$i = 1; | |
while(true): | |
if($i%15 === 0): | |
echo 'FizzBuzz'; | |
elseif($i%3 === 0): | |
echo 'Fizz'; | |
elseif($i%5 === 0): | |
echo 'Buzz'; | |
else: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT i, TRANSLATE(str, | |
'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ', | |
'nopqrstuvwxyzabcdefghijklmNOPQRSTUVWXYZABCDEFGHIJKLM' | |
) AS converted_str | |
FROM tbl; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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), |
NewerOlder