[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

[Git][ftp-team/dak][master] 2 commits: dakweb: fix binary_by_metadata query

Title: GitLab

Ansgar pushed to branch master at Debian FTP Team / dak

Commits:

  • 72996e14
    by Julien Cristau at 2022-09-26T11:41:00+02:00 
    dakweb: fix binary_by_metadata query

It was failing after the bullseye upgrade with:

  sqlalchemy.exc.InvalidRequestError: Can't determine which FROM clause to join from, there are multiple FROMS which can join to this entity. Please use the .select_from() method to establish an explicit left side, as well as providing an explcit ON clause if not present already to help resolve the ambiguity.
  • 1a09fd2d
    by Ansgar at 2022-10-05T22:39:21+02:00 
    Merge remote-tracking branch 'origin/merge-requests/262'

1 changed file:

Changes:

  • dakweb/queries/binary.py
    ... ... @@ -60,7 +60,7 @@ def binary_by_metadata(key=None):
    60 60
    61 61 
         s = DBConn().session()
    62 62 
         q = s.query(DBBinary.package, DBSource.source, SourceMetadata.value)
    63 
    -    q = q.join(DBSource).join(SourceMetadata).join(MetadataKey)
    63 
    +    q = q.join(DBSource, DBBinary.source_id == DBSource.source_id).join(SourceMetadata).join(MetadataKey)
    64 64 
         q = q.filter(MetadataKey.key == key)
    65 65 
         q = q.group_by(DBBinary.package, DBSource.source, SourceMetadata.value)
    66 66 
         ret = []

    • —
    View it on GitLab.
    You're receiving this email because of your account on salsa.debian.org. Manage all notifications · Help

    Reply to: