From dfc43506047d9fbb25f5ce5328f6743da891ca97 Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Fri, 2 Jun 2023 14:15:40 +0300
Subject: auth: Increase limit to 100K records

---
 scripts/migrate_existing_data.py | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'scripts')

diff --git a/scripts/migrate_existing_data.py b/scripts/migrate_existing_data.py
index 0dfc89a..8fb9467 100644
--- a/scripts/migrate_existing_data.py
+++ b/scripts/migrate_existing_data.py
@@ -180,7 +180,7 @@ def __unassigned_mrna__(bioconn, assigned):
             "WHERE (s.SpeciesId, iset.InbredSetId, pf.ProbeFreezeId, psf.Id) "
             f"NOT IN ({paramstr}) ")
 
-    query = query + "LIMIT 5000"
+    query = query + "LIMIT 100000"
     with bioconn.cursor(DictCursor) as cursor:
         cursor.execute(query, tuple(item for row in assigned for item in row))
         return (row for row in cursor.fetchall())
@@ -238,7 +238,7 @@ def __unassigned_geno__(bioconn, assigned):
             "WHERE (s.SpeciesId, iset.InbredSetId, gf.Id) "
             f"NOT IN ({paramstr}) ")
 
-    query = query + "LIMIT 5000"
+    query = query + "LIMIT 100000"
     with bioconn.cursor(DictCursor) as cursor:
         cursor.execute(query, tuple(item for row in assigned for item in row))
         return (row for row in cursor.fetchall())
@@ -302,7 +302,7 @@ def __unassigned_pheno__(bioconn, assigned):
             "WHERE (spc.SpeciesId, iset.InbredSetId, pf.Id, pxr.Id) "
             f"NOT IN ({paramstr}) ")
 
-    query = query + "LIMIT 5000"
+    query = query + "LIMIT 100000"
     with bioconn.cursor(DictCursor) as cursor:
         cursor.execute(query, tuple(item for row in assigned for item in row))
         return (row for row in cursor.fetchall())
-- 
cgit v1.2.3