ユーザー辞書データを作るコマンド
2024/6/24 8:08:00
duckdb ./t_w-rinkaku.duckdb "SELECT fg.title as fgtitle, bg.title as bgtitle FROM post as fg, PostRelation, post as bg WHERE regexp_extract(fg.title, '([あ-ん]|[ｂ-ｚ])+')=fg.title AND LEN(fg.title) > 1 AND LEN(bg.title) > 1 AND NOT CONTAINS(bgtitle, fgtitle) AND PostRelation.fg = fg.kno AND PostRelation.bg = bg.kno ORDER BY fg.title;" --json | jq ".[] | .fgtitle + \"\t\" + .bgtitle + \"\t名詞\t\"" -r > import.txt