diff options
Diffstat (limited to 'lib/Dakkar')
| -rw-r--r-- | lib/Dakkar/TweetArchive/Store.pm | 16 |
1 files 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 |