diff options
Diffstat (limited to 'scripts/migrate_existing_data.py')
| -rw-r--r-- | scripts/migrate_existing_data.py | 6 |
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()) |