diff options
| -rw-r--r-- | wqflask/wqflask/correlation/correlation_file_generator.py | 13 |
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() |