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(+) 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