brianr · August 29, 2015 14:18
diff --git a/gistfile1.sql b/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
	-- 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