aboutsummaryrefslogtreecommitdiff
path: root/scripts
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2023-06-02 14:15:40 +0300
committerFrederick Muriuki Muriithi2023-06-02 14:16:11 +0300
commitdfc43506047d9fbb25f5ce5328f6743da891ca97 (patch)
tree80fef7a153c602fb828377a4aeb61ba7d65f5f13 /scripts
parentc25b148eabdd836920614eacfe345af9ea1d2fe7 (diff)
downloadgenenetwork3-dfc43506047d9fbb25f5ce5328f6743da891ca97.tar.gz
auth: Increase limit to 100K records
Diffstat (limited to 'scripts')
-rw-r--r--scripts/migrate_existing_data.py6
1 files changed, 3 insertions, 3 deletions
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())