Skip to content

Instantly share code, notes, and snippets.

@LnL7

LnL7/hydra-export.sql Secret

Created April 19, 2020 14:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save LnL7/9c5857ca139cf8fc2d3968d1386007dc to your computer and use it in GitHub Desktop.
Save LnL7/9c5857ca139cf8fc2d3968d1386007dc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
hydra-export.sql
COPY (SELECT * FROM builds as b JOIN jobsetevalmembers as m ON b.id = m.build JOIN jobsetevals as e ON e.id = m.eval WHERE e.project = 'nixpkgs' AND e.jobset = 'trunk' AND e.id > 1515735) TO '/tmp/builds.csv';
COPY (SELECT * FROM jobsetevalinputs as i JOIN jobsetevals as e ON e.id = i.eval WHERE i.name = 'nixpkgs' AND e.project = 'nixpkgs' AND e.jobset = 'trunk' AND e.id > 1515735) TO '/tmp/jobsetevalinputs.csv';
COPY (SELECT * FROM jobsetevalmembers as m JOIN jobsetevals as e ON e.id = m.eval WHERE e.project = 'nixpkgs' AND e.jobset = 'trunk' AND e.id > 1515735) TO '/tmp/jobsetevalmembers.csv';
COPY (SELECT * FROM jobsetevals as e WHERE e.project = 'nixpkgs' AND e.jobset = 'trunk' AND e.id > 1515735) TO '/tmp/jobsetevals.csv';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment