From 1e4eafe104fd55d4ffe7b2391d542260db714f31 Mon Sep 17 00:00:00 2001
From: Alexander_Kabui
Date: Mon, 23 Jan 2023 13:10:46 +0300
Subject: fetch all  strain names

---
 .../correlation/correlation_file_generator.py      | 33 +++++++++++++++-------
 1 file changed, 23 insertions(+), 10 deletions(-)

diff --git a/wqflask/wqflask/correlation/correlation_file_generator.py b/wqflask/wqflask/correlation/correlation_file_generator.py
index f9421a65..28e12bf7 100644
--- a/wqflask/wqflask/correlation/correlation_file_generator.py
+++ b/wqflask/wqflask/correlation/correlation_file_generator.py
@@ -1,13 +1,26 @@
-def get_probesetfreezes(conn,inbredsetid=1):
+def get_probesetfreezes(conn, inbredsetid=1):
+    with conn.cursor() as cursor:
+        cursor.execute(
+            "SELECT ProbeSetFreeze.Id, ProbeSetFreeze.Name, ProbeSetFreeze.FullName "
+            "FROM ProbeSetFreeze, ProbeFreeze "
+            "WHERE ProbeSetFreeze.ProbeFreezeId=ProbeFreeze.Id "
+            "AND ProbeFreeze.InbredSetId=%s",
+            (inbredsetid,)
+        )
 
+        return cursor.fetchall()
 
-	with conn.cursor() as cursor:
-		cursor.execute(
-			"SELECT ProbeSetFreeze.Id, ProbeSetFreeze.Name, ProbeSetFreeze.FullName "
-    		"FROM ProbeSetFreeze, ProbeFreeze "
-    		"WHERE ProbeSetFreeze.ProbeFreezeId=ProbeFreeze.Id "
-    		"AND ProbeFreeze.InbredSetId=%s",
-    		(inbredsetid,)
-			)
 
-		return  cursor.fetchall() 
+def get_strains(conn, inbredsetid=1):
+
+    with conn.cursor() as cursor:
+        cursor.execute(
+            "SELECT Strain.Id, Strain.Name "
+            "FROM StrainXRef, Strain "
+            "WHERE StrainXRef.InbredSetId=%s "
+            "AND StrainXRef.StrainId=Strain.Id "
+            "ORDER BY StrainXRef.OrderId",
+            (inbredsetid)
+        )
+
+        return cursor.fetchall()
-- 
cgit v1.2.3