diff env/lib/python3.7/site-packages/galaxy/util/sqlite.py @ 2:6af9afd405e9 draft

"planemo upload commit 0a63dd5f4d38a1f6944587f52a8cd79874177fc1"
author shellac
date Thu, 14 May 2020 14:56:58 -0400
parents 26e78fe6e8c4
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/env/lib/python3.7/site-packages/galaxy/util/sqlite.py	Thu May 14 14:56:58 2020 -0400
@@ -0,0 +1,28 @@
+import re
+import sqlite3
+
+try:
+    import sqlparse
+
+    def is_read_only_query(query):
+        statements = sqlparse.parse(query)
+        for statement in statements:
+            if statement.get_type() != "SELECT":
+                return False
+        return True
+
+except ImportError:
+    # Without sqlparse we use a very weak regex check
+    def is_read_only_query(query):
+        if re.match("select ", query, re.IGNORECASE):
+            if re.search("^([^\"]|\"[^\"]*\")*?;", query) or re.search("^([^\']|\'[^\']*\')*?;", query):
+                return False
+            else:
+                return True
+        return False
+
+
+def connect(path):
+    connection = sqlite3.connect(path)
+    connection.row_factory = sqlite3.Row
+    return connection