Ytpi1XiB

1➜  ~  ruby dkubb.rb 
2 ~ (0.000028) SELECT sqlite_version(*)
3 ~ (0.000059) DROP TABLE IF EXISTS "environments"
4 ~ (0.000010) DROP TABLE IF EXISTS "alerts"
5 ~ (0.000008) PRAGMA table_info("environments")
6 ~ (0.000560) CREATE TABLE "environments" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(50), "watch" BOOLEAN)
7 ~ (0.000006) PRAGMA table_info("alerts")
8 ~ (0.000124) CREATE TABLE "alerts" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "severity" VARCHAR(50), "acknowledged" BOOLEAN, "created_at" TIMESTAMP, "environment_id" INTEGER NOT NULL)
9 ~ (0.000118) CREATE INDEX "index_alerts_environment" ON "alerts" ("environment_id")
10 ~ (0.000078) SELECT "environments"."id", "environments"."name", "environments"."watch" FROM "environments" INNER JOIN "alerts" ON "environments"."id" = "alerts"."environment_id" WHERE ("alerts"."acknowledged" = 'f' AND "alerts"."severity" = 'OMGWTFBBQ') GROUP BY "environments"."id", "environments"."name", "environments"."watch" ORDER BY "environments"."id"