git.shiar.nl
/
sheet.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
word: select mkwordlist forms from _cat_words view
[sheet.git]
/
tools
/
mkwordlist
diff --git
a/tools/mkwordlist
b/tools/mkwordlist
index bec1362b51b2c6a39cd94a2c75912ca1dc73f48f..d4dfaa245cf8e28e563b4bc4c47f9ca64aefdecd 100755
(executable)
--- a/
tools/mkwordlist
+++ b/
tools/mkwordlist
@@
-1,8
+1,4
@@
#!/bin/sh
psql sheet -XAt -c "
#!/bin/sh
psql sheet -XAt -c "
- SELECT json_object_agg(coalesce(form, ''), forms)
- FROM word RIGHT JOIN (
- SELECT cat id, array_agg(form ORDER BY form) forms
- FROM word WHERE ref IS NULL GROUP BY cat
- ) sub USING (id)
+ SELECT json_object_agg(coalesce(form, ''), forms) FROM _cat_words
" | sed 's/:/=>/g'
" | sed 's/:/=>/g'