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
+ 173
− 186
Compare changes
  • Side-by-side
  • Inline
Files
3
funkwhale_network/db.py
+ 12
− 5
@@ -156,11 +156,18 @@ class DB:
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=""), []