1 files changed, 38 insertions, 0 deletions

diff --git a/server/models/request-to-pod.ts b/server/models/request-to-pod.ts
new file mode 100644
index 000000000..479202e40
--- /dev/null
+++ b/server/models/request-to-pod.ts
@@ -0,0 +1,38 @@
+module.exports = function (sequelize, DataTypes) {
+  const RequestToPod = sequelize.define('RequestToPod', {}, {
+    indexes: [
+      {
+        fields: [ 'requestId' ]
+      },
+      {
+        fields: [ 'podId' ]
+      },
+      {
+        fields: [ 'requestId', 'podId' ],
+        unique: true
+      }
+    ],
+    classMethods: {
+      removeByRequestIdsAndPod
+    }
+  })
+
+  return RequestToPod
+}
+
+// ---------------------------------------------------------------------------
+
+function removeByRequestIdsAndPod (requestsIds, podId, callback) {
+  if (!callback) callback = function () { /* empty */ }
+
+  const query = {
+    where: {
+      requestId: {
+        $in: requestsIds
+      },
+      podId: podId
+    }
+  }
+
+  this.destroy(query).asCallback(callback)
+}