yancya’s gists

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 / 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 / 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 / html_practice.html

Last active November 19, 2022 05:00 — forked from machida/html_practice.html

HTMLの練習（このレシピにマークアップをしてみましょう）

yancya / 1.sql

Last active October 10, 2022 03:31

カラム名にテーブル名を含めるべきか否か考える https://twitter.com/neko314_/status/1579000770938433536?s=61&t=TGIhzWS_A0b4j3dWhxK50A

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 / 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 / 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 / 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 / composer.json

Last active June 26, 2020 13:45

謎の HAML ライブラリを使う方法

Shinta Koyanagi yancya