2025年1月26日版
2025/1/26 13:26:00
duckdb ./t_w-rinkaku.duckdb –json -c "SELECT fg.title as fgtitle, bg.title as bgtitle FROM post as fg, PostRelation, post as bg WHERE LEN(fg.title) > 1 AND LEN(bg.title) > 1 AND LEN(bg.title) < LEN(fg.title) AND regexp_extract(fg.title, '([あ-ん]|[b-z])+')=fg.title AND PostRelation.fg = fg.kno AND PostRelation.bg = bg.kno ORDER BY fg.title;" > dict.json
cat dict.json | jq ".[] | .fgtitle + \"\t\" + .bgtitle + \"\t名詞\t\"" -r > dict.txt
dict.txtのエンコードをUTF-16LEに変更する