Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- executeMany
- simpleConn
- [sql|
- INSERT INTO eligible_subscriptions (class_type_id, subscription_type_id)
- VALUES (?, ?)
- INNER JOIN class_types AS ct
- ON class_type_id = ct.id
- INNER JOIN subscription_types AS st
- ON subscription_type_id = st.id
- WHERE ct.tenant_id = ? AND st.tenant_id = ?
- |]
- params
- where
- addParams subTypeId = (classTypeId, subTypeId, tenantId, tenantId)
- params = addParams <$> subTypeIds
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement