RQL queries for deploys

gistfile1.sql

-- select all deploys
select * from deploy;


-- select main columns for all deploys of a specific revision
select id, timestamp,  environment, comment from deploy
where revision = 'some git sha here'


-- deploys of 'production' by revision, and when they were first and last deployed
-- ordered by most recent deploy first
select revision, count(*), min(timestamp), max(timestamp)
from deploy
where environment = 'production'
group by 1
order by 4 desc