From eb8bf4bcefdbbf4d85ae4b98da4547de4c9b949d Mon Sep 17 00:00:00 2001 From: dakkar Date: Fri, 24 Feb 2023 14:46:01 +0000 Subject: fix storing misskey_following --- lib/Dakkar/TweetArchive/Store.pm | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) diff --git a/lib/Dakkar/TweetArchive/Store.pm b/lib/Dakkar/TweetArchive/Store.pm index f0068de..f5919d3 100644 --- a/lib/Dakkar/TweetArchive/Store.pm +++ b/lib/Dakkar/TweetArchive/Store.pm @@ -151,8 +151,8 @@ SQL } -sub store_misskey_following($self,$friends) { - my $ids = $self->_store_twitter_people($friends); +sub store_misskey_following($self,$following) { + my $ids = $self->_store_misskey_people($following); $self->dbh->do(<<"SQL", {}, $ids); INSERT INTO misskey_following(users) VALUES(?) @@ -513,12 +513,12 @@ CREATE FUNCTION misskey_people_details(data jsonb) RETURNS text[] AS $$ SELECT array[ (data->>'id'), (data->>'username'), - COALESCE(data->>'host',''), - (data->>'location'), - (data->>'description'), - (data->>'name'), - (data->>'avatarBlurhash'), - (data->>'bannerBlurhash') + COALESCE(data->>'host', ''), + COALESCE(data->>'location', ''), + COALESCE(data->>'description', ''), + COALESCE(data->>'name', ''), + COALESCE(data->>'avatarBlurhash', ''), + COALESCE(data->>'bannerBlurhash', '') ]; $$ LANGUAGE SQL IMMUTABLE RETURNS NULL ON NULL INPUT SQL -- cgit v1.2.3