From c06a1108304eb31d15523fcd3caf78509eefd841 Mon Sep 17 00:00:00 2001
From: Frédéric Guillot <fred@kanboard.net>
Date: Tue, 2 Oct 2018 15:15:23 -0700
Subject: Reduce number of SQL queries when doing groups sync

---
 app/Model/GroupModel.php | 20 ++++++++++++++++++--
 1 file changed, 18 insertions(+), 2 deletions(-)

(limited to 'app/Model')

diff --git a/app/Model/GroupModel.php b/app/Model/GroupModel.php
index 5acf7e3f..ca15d409 100644
--- a/app/Model/GroupModel.php
+++ b/app/Model/GroupModel.php
@@ -45,10 +45,10 @@ class GroupModel extends Base
     }
 
     /**
-     * Get a specific group by external id
+     * Get a specific group by externalID
      *
      * @access public
-     * @param  integer $external_id
+     * @param  string $external_id
      * @return array
      */
     public function getByExternalId($external_id)
@@ -56,6 +56,22 @@ class GroupModel extends Base
         return $this->db->table(self::TABLE)->eq('external_id', $external_id)->findOne();
     }
 
+    /**
+     * Get specific groups by externalIDs
+     *
+     * @access public
+     * @param  string[] $external_ids
+     * @return array
+     */
+    public function getByExternalIds(array $external_ids)
+    {
+        if (empty($external_ids)) {
+            return [];
+        }
+
+        return $this->db->table(self::TABLE)->in('external_id', $external_ids)->findAll();
+    }
+
     /**
      * Get all groups
      *
-- 
cgit v1.2.3