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: fit column(s) on smaller screen sizes
[sheet.git]
/
tools
/
mkwordlist
diff --git
a/tools/mkwordlist
b/tools/mkwordlist
index bec1362b51b2c6a39cd94a2c75912ca1dc73f48f..5e965fed73c4894740d12fb4f4a849756171f8d8 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)
-" | sed 's/:/=>/g'
+ SELECT json_object_agg(coalesce(form, ''), forms) FROM _cat_words
+" | sed 's/ : / => /g'