From d68b02d36abf98b11d3756940163f4edb961d10f Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Mon, 19 Apr 2021 16:40:57 +0200 Subject: [PATCH] remove unused word recomputation script Has been replaced by a script recomputing counts from search_name. --- lib-sql/words.sql | 14 -------------- 1 file changed, 14 deletions(-) delete mode 100644 lib-sql/words.sql diff --git a/lib-sql/words.sql b/lib-sql/words.sql deleted file mode 100644 index 8be17814..00000000 --- a/lib-sql/words.sql +++ /dev/null @@ -1,14 +0,0 @@ -CREATE TABLE word_frequencies AS - (SELECT unnest(make_keywords(v)) as id, sum(count) as count - FROM (select svals(name) as v, count(*)from place group by v) cnt - WHERE v is not null - GROUP BY id); - -select count(getorcreate_postcode_id(v)) from (select distinct address->'postcode' as v from place where address ? 'postcode') as w where v is not null; -select count(create_housenumber_id(v)) from (select distinct address->'housenumber' as v from place where address ? 'housenumber') as w; - --- copy the word frequencies -update word set search_name_count = count from word_frequencies wf where wf.id = word.word_id; - --- and drop the temporary frequency table again -drop table word_frequencies; -- 2.45.1