aboutsummaryrefslogtreecommitdiff
path: root/wqflask/maintenance/dataset
diff options
context:
space:
mode:
Diffstat (limited to 'wqflask/maintenance/dataset')
-rw-r--r--wqflask/maintenance/dataset/__init__.py0
-rw-r--r--wqflask/maintenance/dataset/calculation/__init__.py0
-rw-r--r--wqflask/maintenance/dataset/calculation/correlation/__init__.py0
-rw-r--r--wqflask/maintenance/dataset/calculation/correlation/about.txt (renamed from wqflask/maintenance/dataset/special/correlation/about.txt)0
-rw-r--r--wqflask/maintenance/dataset/calculation/correlation/conf.ini (renamed from wqflask/maintenance/dataset/special/correlation/conf.ini)0
-rw-r--r--wqflask/maintenance/dataset/calculation/correlation/correlations.py (renamed from wqflask/maintenance/dataset/special/correlation/correlations.py)0
-rw-r--r--wqflask/maintenance/dataset/calculation/correlation/run.sh (renamed from wqflask/maintenance/dataset/special/correlation/run.sh)0
-rw-r--r--wqflask/maintenance/dataset/datastructure/__init__.py0
-rw-r--r--wqflask/maintenance/dataset/datastructure/datastructure.py20
-rw-r--r--wqflask/maintenance/dataset/genotypes/__init__.py0
-rw-r--r--wqflask/maintenance/dataset/genotypes/genotypes_load.py (renamed from wqflask/maintenance/dataset/genotypes/code/genotypes_load.py)0
-rw-r--r--wqflask/maintenance/dataset/phenotypes/__init__.py0
-rw-r--r--wqflask/maintenance/dataset/probesets/__init__.py0
-rw-r--r--wqflask/maintenance/dataset/utilities/__init__.py0
-rw-r--r--wqflask/maintenance/dataset/utilities/db.py10
-rw-r--r--wqflask/maintenance/dataset/utilities/test.py3
16 files changed, 33 insertions, 0 deletions
diff --git a/wqflask/maintenance/dataset/__init__.py b/wqflask/maintenance/dataset/__init__.py
new file mode 100644
index 00000000..e69de29b
--- /dev/null
+++ b/wqflask/maintenance/dataset/__init__.py
diff --git a/wqflask/maintenance/dataset/calculation/__init__.py b/wqflask/maintenance/dataset/calculation/__init__.py
new file mode 100644
index 00000000..e69de29b
--- /dev/null
+++ b/wqflask/maintenance/dataset/calculation/__init__.py
diff --git a/wqflask/maintenance/dataset/calculation/correlation/__init__.py b/wqflask/maintenance/dataset/calculation/correlation/__init__.py
new file mode 100644
index 00000000..e69de29b
--- /dev/null
+++ b/wqflask/maintenance/dataset/calculation/correlation/__init__.py
diff --git a/wqflask/maintenance/dataset/special/correlation/about.txt b/wqflask/maintenance/dataset/calculation/correlation/about.txt
index a12f8c47..a12f8c47 100644
--- a/wqflask/maintenance/dataset/special/correlation/about.txt
+++ b/wqflask/maintenance/dataset/calculation/correlation/about.txt
diff --git a/wqflask/maintenance/dataset/special/correlation/conf.ini b/wqflask/maintenance/dataset/calculation/correlation/conf.ini
index 9c23bb45..9c23bb45 100644
--- a/wqflask/maintenance/dataset/special/correlation/conf.ini
+++ b/wqflask/maintenance/dataset/calculation/correlation/conf.ini
diff --git a/wqflask/maintenance/dataset/special/correlation/correlations.py b/wqflask/maintenance/dataset/calculation/correlation/correlations.py
index b089e446..b089e446 100644
--- a/wqflask/maintenance/dataset/special/correlation/correlations.py
+++ b/wqflask/maintenance/dataset/calculation/correlation/correlations.py
diff --git a/wqflask/maintenance/dataset/special/correlation/run.sh b/wqflask/maintenance/dataset/calculation/correlation/run.sh
index eccfa507..eccfa507 100644
--- a/wqflask/maintenance/dataset/special/correlation/run.sh
+++ b/wqflask/maintenance/dataset/calculation/correlation/run.sh
diff --git a/wqflask/maintenance/dataset/datastructure/__init__.py b/wqflask/maintenance/dataset/datastructure/__init__.py
new file mode 100644
index 00000000..e69de29b
--- /dev/null
+++ b/wqflask/maintenance/dataset/datastructure/__init__.py
diff --git a/wqflask/maintenance/dataset/datastructure/datastructure.py b/wqflask/maintenance/dataset/datastructure/datastructure.py
new file mode 100644
index 00000000..ed429cb4
--- /dev/null
+++ b/wqflask/maintenance/dataset/datastructure/datastructure.py
@@ -0,0 +1,20 @@
+import sys
+sys.path.append('.')
+sys.path.append('..')
+
+from utilities import db
+
+def get_type(inbredsetid):
+ cursor=db.get_cursor()
+ sql = """
+ SELECT ProbeSetFreeze.`Id`, ProbeSetFreeze.`Name`, ProbeSetFreeze.`FullName`
+ FROM ProbeSetFreeze, ProbeFreeze
+ WHERE ProbeSetFreeze.`ProbeFreezeId`=ProbeFreeze.`Id`
+ AND ProbeFreeze.`InbredSetId`=%s
+ """
+ cursor.execute(sql, (inbredsetid))
+ return cursor.fetchall()
+
+
+print get_type()
+ \ No newline at end of file
diff --git a/wqflask/maintenance/dataset/genotypes/__init__.py b/wqflask/maintenance/dataset/genotypes/__init__.py
new file mode 100644
index 00000000..e69de29b
--- /dev/null
+++ b/wqflask/maintenance/dataset/genotypes/__init__.py
diff --git a/wqflask/maintenance/dataset/genotypes/code/genotypes_load.py b/wqflask/maintenance/dataset/genotypes/genotypes_load.py
index e4988446..e4988446 100644
--- a/wqflask/maintenance/dataset/genotypes/code/genotypes_load.py
+++ b/wqflask/maintenance/dataset/genotypes/genotypes_load.py
diff --git a/wqflask/maintenance/dataset/phenotypes/__init__.py b/wqflask/maintenance/dataset/phenotypes/__init__.py
new file mode 100644
index 00000000..e69de29b
--- /dev/null
+++ b/wqflask/maintenance/dataset/phenotypes/__init__.py
diff --git a/wqflask/maintenance/dataset/probesets/__init__.py b/wqflask/maintenance/dataset/probesets/__init__.py
new file mode 100644
index 00000000..e69de29b
--- /dev/null
+++ b/wqflask/maintenance/dataset/probesets/__init__.py
diff --git a/wqflask/maintenance/dataset/utilities/__init__.py b/wqflask/maintenance/dataset/utilities/__init__.py
new file mode 100644
index 00000000..e69de29b
--- /dev/null
+++ b/wqflask/maintenance/dataset/utilities/__init__.py
diff --git a/wqflask/maintenance/dataset/utilities/db.py b/wqflask/maintenance/dataset/utilities/db.py
new file mode 100644
index 00000000..453ee707
--- /dev/null
+++ b/wqflask/maintenance/dataset/utilities/db.py
@@ -0,0 +1,10 @@
+import MySQLdb
+
+def get_cursor():
+ host = 'localhost'
+ user = 'webqtl'
+ passwd = 'webqtl'
+ db = 'db_webqtl'
+ con = MySQLdb.Connect(db=db, host=host, user=user, passwd=passwd)
+ cursor = con.cursor()
+ return cursor \ No newline at end of file
diff --git a/wqflask/maintenance/dataset/utilities/test.py b/wqflask/maintenance/dataset/utilities/test.py
new file mode 100644
index 00000000..340377b3
--- /dev/null
+++ b/wqflask/maintenance/dataset/utilities/test.py
@@ -0,0 +1,3 @@
+import db
+
+print db.get_cursor() \ No newline at end of file