diff options
author | dakkar <dakkar@thenautilus.net> | 2023-02-24 14:46:01 +0000 |
---|---|---|
committer | dakkar <dakkar@thenautilus.net> | 2023-02-24 14:46:01 +0000 |
commit | eb8bf4bcefdbbf4d85ae4b98da4547de4c9b949d (patch) | |
tree | 90738b2d09534ece2ad7e854dba1cdf320a5ddff | |
parent | fix following/followers return values (diff) | |
download | tweet-archive-eb8bf4bcefdbbf4d85ae4b98da4547de4c9b949d.tar.gz tweet-archive-eb8bf4bcefdbbf4d85ae4b98da4547de4c9b949d.tar.bz2 tweet-archive-eb8bf4bcefdbbf4d85ae4b98da4547de4c9b949d.zip |
fix storing misskey_following
-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 |