Skip to content

Instantly share code, notes, and snippets.

View yancya's full-sized avatar
💭
😂

Shinta Koyanagi yancya

💭
😂
32 followers · 29 following
View GitHub Profile
@yancya
yancya / hoge.sql
Created April 30, 2024 12:56
https://sakaik.hateblo.jp/entry/20240430/sql_puzzle_island の考察
-- BigQueryのSQL
WITH moj_surface1 AS (
SELECT *
FROM unnest([
STRUCT('202404' AS var,'43443-3300-22.zip' AS `filename`,'F000000001' AS surface_id,'C000000199' AS curve_id,50 AS num),
('202404','43443-3300-22.zip','F000000001','C000000200',51),
('202404','43443-3300-22.zip','F000000001','C000000201',52),
('202404','43443-3300-22.zip','F000000001','C000000202',53),
('202404','43443-3300-22.zip','F000000001','C000000203',54),
@yancya
yancya / contextmanager_example.py
Created April 22, 2024 08:13
Python触ってて出てきたwithがなんなのか分からなかったので調べた
from contextlib import contextmanager
@contextmanager
def hoge():
try:
print("start")
yield "Hello, "
finally:
print("end")
@yancya
yancya / error.py
Last active June 5, 2023 06:36
Python 3.9.6で動かしてるけど、このエラーが出る条件が全く分からない…… １行のバイト数が影響してるのかな…… https://peps.python.org/pep-0263/
aaaa=['あああああああああああああああああああああああああああ','あああああああああああああああああああああああああああ','あああああああああああああああああああああああああああ','あああああああああああああああああああああああああああ','あああああああああああああああああああああああああああ','あああああああああああああああああああああああああああ','あああああああああああああああああああああああああああ','あああああああああああああああああああああああああああ','あああああああああああああああああああああああああああ','あああああああああああああああああああああああああああ','あああああああああああああああああああああああああああ','あああああああああああああああああああああああああああ','あああああああああああああああああああああああああああ','あああああああああああああああああああああああああああ']
print(aaaa)
#=> SyntaxError: Non-UTF-8 code starting with '\xe3' in file /Users/yancya/piyo.py on line 1, but no encoding declared; see http://python.org/dev/peps/pep-0263/ for details
@yancya
yancya / html_practice.html
Last active November 19, 2022 05:00 — forked from machida/html_practice.html
HTMLの練習（このレシピにマークアップをしてみましょう）
<!DOCTYPE html>
<html lang="ja">
<head>
<title>カレーのレシピ</title>
</head>
<body>
<article>
<h1>カレーのレシピ</h1>
@yancya
yancya / 1.sql
Last active October 10, 2022 03:31
カラム名にテーブル名を含めるべきか否か考える https://twitter.com/neko314_/status/1579000770938433536?s=61&t=TGIhzWS_A0b4j3dWhxK50A
WITH teams AS (
SELECT 1 AS id
, 'yancya-club' AS name)
, members AS (
SELECT 1 AS id
, 'yancya' AS name
, 1 AS team_id)
SELECT *
@yancya
yancya / fuga.sql
Last active September 16, 2022 01:11
> 【緩募】SQL で b が空集合の時は a をそのまま、そうでない時は a を b の要素でフィルタしたものを結果とする、みたいなクエリの書き方。 https://twitter.com/okapies/status/1570367933968420868?s=21&t=YKmgbQmmUQxfi4pdtWNFcw
WITH a AS (
SELECT 1 AS n UNION SELECT 2 AS n
), b AS (
SELECT 2 AS n UNION SELECT 3 AS n
), t AS (
SELECT a.n AS n, b.n AS b_n, COUNT(b.n) OVER() AS b_count
FROM a LEFT OUTER JOIN b USING(n)
)
SELECT n
FROM t
@yancya
yancya / 8queens.sql
Last active July 29, 2022 05:32
エイト・クイーン問題 全解 BigQuery 版
CREATE TEMP FUNCTION safe_check(queens ARRAY<STRUCT<x INT64, y INT64>>) RETURNS BOOLEAN AS ((
SELECT COUNT(x) = COUNT(DISTINCT x) AND
COUNT(y) = COUNT(DISTINCT y) AND
COUNT(x+y) = COUNT(DISTINCT x+y) AND
COUNT(x-y) = COUNT(DISTINCT x-y)
FROM UNNEST(queens)
));
CREATE TEMP FUNCTION print_queen(x INT64) RETURNS STRING AS (
(SELECT COALESCE(STRING_AGG('.', ''), '') FROM UNNEST(GENERATE_ARRAY(1, x-1))) ||
@yancya
yancya / hoge.ts
Last active December 26, 2020 15:42
Answer to https://twitter.com/excelspeedup/status/1342851311507623937
type Key = ['a','b','c']
type Value = [string, number, boolean]
type Obj = {a: string, b: number, c: boolean};
const keys: Key = ['a','b','c'];
const values: Value = ['a', 1, true];
const object: Obj = keys.reduce((acc, key, index) => {
acc[key] = values[index];
return acc;
}, {}) as Obj;
@yancya
yancya / create_db.sql
Last active December 16, 2020 01:08
https://blog.kamipo.net/entry/2020/12/15/213359 for PostgreSQL
-- psql -f create_db.sql postgres
CREATE DATABASE hogehoge;
@yancya
yancya / composer.json
Last active June 26, 2020 13:45
謎の HAML ライブラリを使う方法
{
"name": "yancya/php_sandbox",
"authors": [
{
"name": "yancya",
"email": "yancya@upec.jp"
}
],
"require": {
"mthaml/mthaml": "*"