summaryrefslogtreecommitdiff
path: root/lib/Dakkar/TweetArchive/Store.pm
diff options
context:
space:
mode:
Diffstat (limited to 'lib/Dakkar/TweetArchive/Store.pm')
-rw-r--r--lib/Dakkar/TweetArchive/Store.pm16
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