init fetch all probeset datasets

1 files changed, 13 insertions, 0 deletions

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