diff options
Diffstat (limited to 'uploader/phenotypes/models.py')
| -rw-r--r-- | uploader/phenotypes/models.py | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/uploader/phenotypes/models.py b/uploader/phenotypes/models.py index 4454ba3..3ec17e7 100644 --- a/uploader/phenotypes/models.py +++ b/uploader/phenotypes/models.py @@ -327,11 +327,11 @@ def save_phenotypes_data( with conn.cursor(cursorclass=DictCursor) as cursor: for batch in take(data, 5000): cursor.executemany( - (f"INSERT INTO {_table_details['table']}" - f"(Id, StrainId, {_table_details['valueCol']}) " - "VALUES " - f"(%(data_id)s, %(sample_id)s, %({_table_details['valueCol']})s) " - "RETURNING *"), + (f"INSERT INTO {_table_details['table']}" + f"(Id, StrainId, {_table_details['valueCol']}) " + "VALUES " + f"(%(data_id)s, %(sample_id)s, %({_table_details['valueCol']})s) " + "RETURNING *"), tuple(batch)) _data = data + tuple(cursor.fetchall()) |