diff options
| author | Christopher Baines <mail@cbaines.net> | 2022-05-23 22:49:51 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2022-05-23 22:49:51 +0100 |
| commit | d4bb0ffaaaeb32044faf89c9634c0ed728a9cbb9 (patch) | |
| tree | 117d1178910ab6e6d72f33701b3f2c201d260a91 /scripts/guix-data-service-create-small-backup | |
| parent | 6d403cbc8d9b191ede4dc0a4d3bc7c81d17871ee (diff) | |
| download | data-service-d4bb0ffaaaeb32044faf89c9634c0ed728a9cbb9.tar data-service-d4bb0ffaaaeb32044faf89c9634c0ed728a9cbb9.tar.gz | |
Fix more issues with the git_commits introduction
Diffstat (limited to 'scripts/guix-data-service-create-small-backup')
| -rwxr-xr-x | scripts/guix-data-service-create-small-backup | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/scripts/guix-data-service-create-small-backup b/scripts/guix-data-service-create-small-backup index 285fdc2..f38597c 100755 --- a/scripts/guix-data-service-create-small-backup +++ b/scripts/guix-data-service-create-small-backup @@ -242,12 +242,14 @@ INNER JOIN ( ) AS revision_packages ON packages.id = revision_packages.package_id INNER JOIN guix_revisions ON revision_packages.revision_id = guix_revisions.id +INNER JOIN git_commits + ON guix_revisions.commit = git_commits.commit INNER JOIN git_branches - ON guix_revisions.commit = git_branches.commit + ON git_branches.id = git_commits.git_branch_id WINDOW package_version AS ( PARTITION BY git_branches.git_repository_id, git_branches.name, packages.name, packages.version, revision_packages.derivation_id - ORDER BY git_branches.datetime + ORDER BY git_commits.datetime RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) ORDER BY packages.name, packages.version; |