Skip to content
Snippets Groups Projects

chore(deps): update dependency aiohttp to v3.11.11

Merged chore(deps): update dependency aiohttp to v3.11.11
renovate/aiohttp-3.x into main
Merged RenovateBot requested to merge renovate/aiohttp-3.x into main
Compare
and
Show latest version
3 files
+ 353
− 211
Compare changes
  • Side-by-side
  • Inline
Files
3
funkwhale_network/db.py
+ 51
− 28
@@ -129,38 +129,61 @@ class DB:
data["users"], "activeHalfyear", check["usage_users_active_half_year"]
)
self.increment_stat(data["instances"], "total", 1)
self.increment_stat(
data["instances"], "openRegistrations", int(check["open_registrations"])
)
self.increment_stat(
data["instances"],
"anonymousCanListen",
int(check["anonymous_can_listen"]),
)
self.increment_stat(
data["artists"], "total", int(check["library_artists_total"])
)
self.increment_stat(
data["tracks"], "total", int(check["library_tracks_total"])
)
self.increment_stat(
data["albums"], "total", int(check["library_albums_total"])
)
self.increment_stat(
data["listenings"], "total", int(check["usage_listenings_total"])
)
self.increment_stat(
data["downloads"], "total", int(check["usage_downloads_total"] or 0)
)
if check["open_registrations"]:
self.increment_stat(
data["instances"],
"openRegistrations",
int(check["open_registrations"]),
)
if check["anonymous_can_listen"]:
self.increment_stat(
data["instances"],
"anonymousCanListen",
int(check["anonymous_can_listen"]),
)
if check["library_artists_total"]:
self.increment_stat(
data["artists"], "total", int(check["library_artists_total"])
)
if check["library_tracks_total"]:
self.increment_stat(
data["tracks"], "total", int(check["library_tracks_total"])
)
if check["library_albums_total"]:
self.increment_stat(
data["albums"], "total", int(check["library_albums_total"])
)
if check["usage_listenings_total"]:
self.increment_stat(
data["listenings"], "total", int(check["usage_listenings_total"])
)
if check["usage_downloads_total"]:
self.increment_stat(
data["downloads"], "total", int(check["usage_downloads_total"] or 0)
)
return data
def get_domain_query(self, **kwargs):
base_query = """
SELECT DISTINCT on (domain) domain, *
FROM checks
INNER JOIN domains ON checks.domain = domains.name
WHERE domains.blocked = false
ORDER BY domain, time DESC
SELECT *
FROM domains LEFT
JOIN (
SELECT *
FROM checks
WHERE (domain, time) in (
SELECT domain, max(time)
FROM checks GROUP BY domain
)
) AS checks
ON domains.name=checks.domain
WHERE blocked=false;
"""
return base_query.format(where_clause=""), []