Skip to content

Instantly share code, notes, and snippets.

Avatar

Daniel Thong dthongmtl

View GitHub Profile
View keybase.md

Keybase proof

I hereby claim:

  • I am dthongmtl on github.
  • I am dthong (https://keybase.io/dthong) on keybase.
  • I have a public key ASCaqjpb9oE_dR1n15u7Q9f4FnXsclxpbvdELl6BLmy_FAo

To claim this, I am signing this object:

View quartz
SELECT T.JOB_NAME,
FROM_UNIXTIME(T.NEXT_FIRE_TIME/1000, GET_FORMAT(DATETIME,'ISO')) NEXT_FIRE,
FROM_UNIXTIME(T.PREV_FIRE_TIME/1000, GET_FORMAT(DATETIME,'ISO')) PREV_FIRE,
T.TRIGGER_STATE,
FROM_UNIXTIME(T.START_TIME/1000, GET_FORMAT(DATETIME,'ISO')) START_JOB,
CASE T.TRIGGER_TYPE
WHEN 'SIMPLE' THEN
CASE T.MISFIRE_INSTR
WHEN -1 THEN 'IGNORE_MISFIRE_POLICY'
WHEN 1 THEN 'FIRE_NOW'
View queries.sql
SELECT p.id, CASE p.method_id
WHEN 1 THEN 'MANUAL'
WHEN 2 THEN 'VISA'
WHEN 3 THEN 'MASTERCARD'
WHEN 4 THEN 'AMEX'
WHEN 6 THEN 'DISCOVER'
WHEN 8 THEN 'PAYPAL'
WHEN 9 THEN 'GATEWAY'
WHEN 100 THEN 'CUSTOM'
WHEN 101 THEN 'DTAG'