def prep_for_like_query(self, x):
"""Prepares a value for use in a LIKE query."""
# see EXASolution_User_Manual_5.0.13-en.pdf, section 2.7.2 List of predicates: [NOT] LIKE
# _ and % have special meaning inside LIKE comparisons...
# if they appear in the search string we need to escape them
return smart_text(x).replace(r'_', r'\_').replace(r'%', r'\%')
return x
def value_to_db_datetime(self, value):
"""
Transform a datetime value to an object compatible with what is expected
by the backend driver for datetime columns.
"""
if value is None:
return None
if self.connection._DJANGO_VERSION >= 14 and settings.USE_TZ:
if timezone.is_aware(value):
# pyodbc donesn't support datetimeoffset
value = value.astimezone(timezone.utc).replace(tzinfo=None)
if not self.connection.features.supports_microsecond_precision:
value = value.replace(microsecond=0)
return smart_text(value)
def prep_for_like_query(self, x):
"""Prepares a value for use in a LIKE query."""
# http://msdn2.microsoft.com/en-us/library/ms179859.aspx
return smart_text(x).replace('\\', '\\\\').replace('[', '[[]').replace('%', '[%]').replace('_', '[_]')
def prep_for_like_query(self, x):
"""Prepares a value for use in a LIKE query."""
# http://msdn2.microsoft.com/en-us/library/ms179859.aspx
return smart_text(x).replace("\\", "\\\\").replace("[", "[[]").replace("%", "[%]").replace("_", "[_]")
