diff options
| author | Frederick Muriuki Muriithi | 2023-06-02 14:15:40 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2023-06-02 14:16:11 +0300 |
| commit | dfc43506047d9fbb25f5ce5328f6743da891ca97 (patch) | |
| tree | 80fef7a153c602fb828377a4aeb61ba7d65f5f13 | |
| parent | c25b148eabdd836920614eacfe345af9ea1d2fe7 (diff) | |
| download | genenetwork3-dfc43506047d9fbb25f5ce5328f6743da891ca97.tar.gz | |
auth: Increase limit to 100K records
| -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()) |