diff ensure_synced.py @ 7:59edc91d0bea draft

Uploaded
author greg
date Fri, 17 Dec 2021 17:55:08 +0000
parents 68ca17b451f2
children aaa6ae7c64de
line wrap: on
line diff
--- a/ensure_synced.py	Fri Dec 17 17:46:31 2021 +0000
+++ b/ensure_synced.py	Fri Dec 17 17:55:08 2021 +0000
@@ -5,9 +5,8 @@
 import sys
 
 import psycopg2
-
+from sqlalchemy import create_engine
 from sqlalchemy import MetaData
-from sqlalchemy import create_engine
 from sqlalchemy.engine.url import make_url
 
 metadata = MetaData()
@@ -35,7 +34,7 @@
         self.conn = psycopg2.connect(**args)
 
     def get_affy_ids_from_db(self):
-        cmd = "SELECT coral_mlg_rep_sample_id, coral_mlg_clonal_id FROM genotype WHERE coral_mlg_rep_sample_id IS NOT NULL AND coral_mlg_rep_sample_id != '' AND coral_mlg_clonal_id != 'failed' ORDER BY coral_mlg_rep_sample_id;”
+        cmd = "SELECT coral_mlg_rep_sample_id, coral_mlg_clonal_id FROM genotype WHERE coral_mlg_rep_sample_id IS NOT NULL AND coral_mlg_rep_sample_id != '' AND coral_mlg_clonal_id != 'failed' ORDER BY coral_mlg_rep_sample_id;"
         cur = self.conn.cursor()
         cur.execute(cmd)
         rows = cur.fetchall()