Problem with regexp python and sqlite

by

Use parametrized sql. Then you don’t need to escape the quotes yourself:

import sqlite3
import re

def regexp(expr, item):
    reg = re.compile(expr)
    return reg.search(item) is not None

conn = sqlite3.connect(':memory:')
conn.create_function("REGEXP", 2, regexp)
cursor = conn.cursor()
cursor.execute('CREATE TABLE foo (bar TEXT)')
cursor.executemany('INSERT INTO foo (bar) VALUES (?)',[('aaa"test"',),('blah',)])
cursor.execute('SELECT bar FROM foo WHERE bar REGEXP ?',['"test"'])
data=cursor.fetchall()
print(data)

yields

[(u'aaa"test"',)]

More Related Contents:

  1. Match a whole word in a string using dynamic regex
  2. How to check for valid email address? [duplicate]
  3. Case insensitive regular expression without re.compile?
  4. Python string.replace regular expression [duplicate]
  5. Regex matching 5-digit substrings not enclosed with digits
  6. How to split but ignore separators in quoted strings, in python?
  7. Parameter substitution for a SQLite “IN” clause
  8. Regular expression to extract URL from an HTML link
  9. BeautifulSoup – search by text inside a tag
  10. Get the string within brackets in Python
  11. How to read datetime back from sqlite as a datetime instead of string in Python?
  12. Split string based on a regular expression
  13. Split string on commas but ignore commas within double-quotes?
  14. Python regex: splitting on pattern match that is an empty string
  15. Python – Locating the position of a regex match in a string?
  16. Bulk insert huge data into SQLite using Python
  17. Python unicode regular expression matching failing with some unicode characters -bug or mistake?
  18. How to split a string by commas positioned outside of parenthesis?
  19. sqlite3.OperationalError: unable to open database file
  20. Regex: match only outside parenthesis (so that the text isn’t split within parenthesis)?
  21. Faster way to remove stop words in Python
  22. Why doesn’t Python’s `re.split()` split on zero-length matches?
  23. Creating a custom categorized corpus in NLTK and Python
  24. Warning raised by inserting 4-byte unicode to mysql
  25. Python 3 sqlite parameterized SQL-query
  26. SQLite, python, unicode, and non-utf data
  27. Pycharm environment different than command line
  28. Remove non-ASCII characters from a string using python / django
  29. How to strip whitespace from before but not after punctuation in python
  30. re.split() gives empty elements in list

Leave a Comment