# HG changeset patch
# User greg
# Date 1639763708 0
# Node ID 59edc91d0bea6e8ff922900ff94200c0ad2311fc
# Parent  68ca17b451f2b6796ba1f5c2122e16c8aff76d67
Uploaded

diff -r 68ca17b451f2 -r 59edc91d0bea ensure_synced.py
--- 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()