From 6bb9f94ea49a6c098744fe2d710a781263f8c5af Mon Sep 17 00:00:00 2001
From: Alexander_Kabui
Date: Mon, 23 Jan 2023 13:08:57 +0300
Subject: init fetch all probeset datasets

---
 wqflask/wqflask/correlation/correlation_file_generator.py | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 wqflask/wqflask/correlation/correlation_file_generator.py

diff --git a/wqflask/wqflask/correlation/correlation_file_generator.py b/wqflask/wqflask/correlation/correlation_file_generator.py
new file mode 100644
index 00000000..f9421a65
--- /dev/null
+++ b/wqflask/wqflask/correlation/correlation_file_generator.py
@@ -0,0 +1,13 @@
+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() 
-- 
cgit v1.2.3