From dd2a8a5e28d2544780e98639db8d9a8180d2a558 Mon Sep 17 00:00:00 2001
From: Alexander_Kabui
Date: Mon, 23 Jan 2023 13:12:11 +0300
Subject: fetch all strains for a given dataset

---
 .../wqflask/correlation/correlation_file_generator.py    | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'wqflask')

diff --git a/wqflask/wqflask/correlation/correlation_file_generator.py b/wqflask/wqflask/correlation/correlation_file_generator.py
index 28e12bf7..97b8bde8 100644
--- a/wqflask/wqflask/correlation/correlation_file_generator.py
+++ b/wqflask/wqflask/correlation/correlation_file_generator.py
@@ -24,3 +24,19 @@ def get_strains(conn, inbredsetid=1):
         )
 
         return cursor.fetchall()
+
+def fetch_datasets(conn):
+
+	#fi parents included?????
+	with conn.cursor() as cursor:
+	    cursor.execute(
+	        "SELECT ProbeSet.Name, Strain.Name, ProbeSetData.value "
+	        "FROM Strain LEFT JOIN ProbeSetData "
+	        "ON Strain.Id = ProbeSetData.StrainId "
+	        "LEFT JOIN ProbeSetXRef ON ProbeSetData.Id = ProbeSetXRef.DataId "
+	        "LEFT JOIN ProbeSet ON ProbeSetXRef.ProbeSetId = ProbeSet.Id "
+	        "WHERE ProbeSetXRef.ProbeSetFreezeId IN "
+	        "(SELECT Id FROM ProbeSetFreeze WHERE Name = %s) "
+	        "ORDER BY Strain.Name",
+	        (db_name,))
+	    return cursor.fetchall()
-- 
cgit v1.2.3