Hello,
I have a question about regexes and sqlite3. I am executing a certain
line of code:
>>> regex = 'NET | INCOME'
>>> Table.objects.filter(name__iregex=regex).
When I have it print out the SQL sent, I get the following (this is a
simplified, but equivalent version):
SELECT *
FROM "table"
WHERE "table"."name"
REGEXP '(?i)' || 'NET | INCOME'
LIMIT 21
However if I execute that directly against the sqlite database i get the
following error:
sqlite3.OperationalError: no such function: REGEXP
I thought that maybe this magic was handled in python's sqlite3 module,
but if i do it there i get the same error. So basically my question is,
can anyone tell me where this is transformed into regular sql? it
obviously happens somehwere (I get no error when running in django after
all), but I can't for the life of me figure out where.
Thanks a lot!
Thomas
PS: I have tried using the shell_plus --print-sql extension, but that
shows me the same thing.
PPS: Obviously not django-related, but if anyone knows how to get a
sqlite database to log all queries issued against it, that would also
obviously solve this issue.
--
You received this message because you are subscribed to the Google Groups "Django
users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/a78c6d8a-4284-ec8a-9757-cf49da7b38b9%40gmx.com.
For more options, visit https://groups.google.com/d/optout.
