From 155e2997613c0750de30b734686f8977524956f9 Mon Sep 17 00:00:00 2001
From: Lei Yan
Date: Fri, 12 Jul 2013 22:58:39 +0000
Subject: Rewrote code related to getting the tissue correlation column to
 display

Created new files for mrna assay tissue data and commonly used
db query related functions
---
 wqflask/utility/db_tools.py | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 wqflask/utility/db_tools.py

(limited to 'wqflask/utility/db_tools.py')

diff --git a/wqflask/utility/db_tools.py b/wqflask/utility/db_tools.py
new file mode 100644
index 00000000..4034f39c
--- /dev/null
+++ b/wqflask/utility/db_tools.py
@@ -0,0 +1,15 @@
+from __future__ import absolute_import, print_function, division
+
+from MySQLdb import escape_string as escape
+
+def create_in_clause(items):
+    """Create an in clause for mysql"""
+    in_clause = ', '.join("'{}'".format(x) for x in mescape(*items))
+    in_clause = '( {} )'.format(in_clause)
+    return in_clause
+
+def mescape(*items):
+    """Multiple escape"""
+    escaped = [escape(str(item)) for item in items]
+    #print("escaped is:", escaped)
+    return escaped
-- 
cgit v1.2.3