Mercurial > repos > shellac > guppy_basecaller
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