diff options
| author | Lei Yan | 2014-01-31 16:12:36 -0600 |
|---|---|---|
| committer | Lei Yan | 2014-01-31 16:12:36 -0600 |
| commit | d6543befcdaf4786f42c10c1cdd0cb473a8d8453 (patch) | |
| tree | 41170e9f8a2bc81734760493500474fb33e71156 /wqflask/maintenance/dataset | |
| parent | 4a3c48c4b91c0cce9d7d0e9896be893d6e80a883 (diff) | |
| download | genenetwork2-d6543befcdaf4786f42c10c1cdd0cb473a8d8453.tar.gz | |
On branch master
Diffstat (limited to 'wqflask/maintenance/dataset')
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 |