From e46b28c2c0fbe8d8deba6bc33f435e59cade0d25 Mon Sep 17 00:00:00 2001 From: dakkar Date: Mon, 8 May 2017 12:34:26 +0100 Subject: giving up, just migrate the current set of people --- lib/Dakkar/TweetArchive/Store.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lib/Dakkar/TweetArchive/Store.pm b/lib/Dakkar/TweetArchive/Store.pm index c3840ea..cc64a87 100644 --- a/lib/Dakkar/TweetArchive/Store.pm +++ b/lib/Dakkar/TweetArchive/Store.pm @@ -216,7 +216,7 @@ DECLARE p RECORD; ids INTEGER[]; BEGIN - FOR f IN SELECT * FROM friends ORDER BY taken_at ASC LOOP + FOR f IN SELECT * FROM friends ORDER BY taken_at DESC LIMIT 1 LOOP RAISE NOTICE 'migrating friends at %s', f.taken_at; ids := '{}'; FOR p IN INSERT INTO people(data) @@ -229,7 +229,7 @@ BEGIN INSERT INTO new_friends(taken_at,users) VALUES (f.taken_at,ids); END LOOP; - FOR f IN SELECT * FROM followers ORDER BY taken_at ASC LOOP + FOR f IN SELECT * FROM followers ORDER BY taken_at DESC LIMIT 1 LOOP RAISE NOTICE 'migrating followers at %s', f.taken_at; ids := '{}'; FOR p IN INSERT INTO people(data) -- cgit v1.2.3