Skip to content

Instantly share code, notes, and snippets.

View jglorioso's full-sized avatar

John Glorioso jglorioso

  • Nayya
  • Baltimore, MD
View GitHub Profile
require "services/nifi_notifier"
RSpec.describe NifiNotifier do
.
.
.
let(:load_key) do
<<-YAML
--- +
- :schema_owner_id: #{connection.id}
CREATE TEMP TABLE "sub_queries" AS
SELECT "date" AS "date", "line item id" AS "line item id", (CAST("line item id" AS VARCHAR(255)) || CAST(' ' AS VARCHAR(255))) AS "line i id", "advertiser" AS "advertiser",
"advertiser id" AS "advertiser id", "order" AS "order", "order id" AS "order id", "order po number" AS "order po number", "line item" AS "line item",
"line item type" AS "line item type", "line item priority" AS "line item priority", "creative size" AS "creative size", "ad unit" AS "ad unit", "ad unit id" AS "ad unit id",
"rate" AS "rate", "total impressions" AS "total impressions", "total clicks" AS "total clicks", "total active view viewable impressions" AS "total active view viewable impressions",
"total active view measurable impressions" AS "total active view measurable impressions", "ad exchange impressions" AS "ad exchange impressions",
"ad exchange clicks" AS "ad exchange clicks", "ad exchange revenue" AS "ad exchange revenue"
FROM "cc120_s1406"
WHERE ("date" BET
SELECT MD5((CAST(COALESCE(CAST("ad type" AS VARCHAR(255)), '') AS VARCHAR(255)) || CAST(COALESCE(CAST("ad unit" AS VARCHAR(255)), '') AS VARCHAR(255)) || CAST(COALESCE(CAST("ad unit id" AS VARCHAR(255)), '') AS VARCHAR(255)) || CAST(COALESCE(CAST("ad_type_1" AS VARCHAR(255)), '') AS VARCHAR(255)) || CAST(COALESCE(CAST("advertiser" AS VARCHAR(255)), '') AS VARCHAR(255)) || CAST(COALESCE(CAST("advertiser id" AS VARCHAR(255)), '') AS VARCHAR(255)) || CAST(COALESCE(CAST("creative size" AS VARCHAR(255)), '') AS VARCHAR(255)) || CAST(COALESCE(CAST("date" AS VARCHAR(255)), '') AS VARCHAR(255)) || CAST(COALESCE(CAST("direct or network" AS VARCHAR(255)), '') AS VARCHAR(255)) || CAST(COALESCE(CAST("line i id" AS VARCHAR(255)), '') AS VARCHAR(255)) || CAST(COALESCE(CAST("line item" AS VARCHAR(255)), '') AS VARCHAR(255)) || CAST(COALESCE(CAST("line item date" AS VARCHAR(255)), '') AS VARCHAR(255)) || CAST(COALESCE(CAST("line item id" AS VARCHAR(255)), '') AS VARCHAR(255)) || CAST(COALESCE(CAST("line item priority" AS VAR

Keybase proof

I hereby claim:

  • I am jglorioso on github.
  • I am zuulioso (https://keybase.io/zuulioso) on keybase.
  • I have a public key whose fingerprint is F3B7 9DC3 443D 979F 69B8 6628 C8E9 0C27 05B8 06D5

To claim this, I am signing this object: