Guest User

Untitled

a guest
Dec 12th, 2019
80
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. executeMany
  2. simpleConn
  3. [sql|
  4. INSERT INTO eligible_subscriptions (class_type_id, subscription_type_id)
  5. VALUES (?, ?)
  6. INNER JOIN class_types AS ct
  7. ON class_type_id = ct.id
  8. INNER JOIN subscription_types AS st
  9. ON subscription_type_id = st.id
  10. WHERE ct.tenant_id = ? AND st.tenant_id = ?
  11. |]
  12. params
  13. where
  14. addParams subTypeId = (classTypeId, subTypeId, tenantId, tenantId)
  15. params = addParams <$> subTypeIds
RAW Paste Data