Namespace all modules under gn2.

We move all modules under a gn2 directory. This is important for
"correct" packaging and deployment as a Guix service.

1 files changed, 23 insertions, 0 deletions

diff --git a/gn2/utility/db_tools.py b/gn2/utility/db_tools.py
new file mode 100644
index 00000000..07a6d9ec
--- /dev/null
+++ b/gn2/utility/db_tools.py
@@ -0,0 +1,23 @@
+from gn2.utility.tools import get_setting
+from gn2.wqflask.database import database_connection
+
+
+def escape_(string):
+    with database_connection(get_setting("SQL_URI")) as conn:
+        return conn.escape_string(str(string))
+
+
+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"""
+    return [escape_(str(item)).decode('utf8') for item in items]
+
+
+def escape(string_):
+    return escape_(string_).decode('utf8')