def Thing2Literal(o, d):
"""Convert something into a SQL string literal. If using
MySQL-3.23 or newer, string_literal() is a method of the
_mysql.MYSQL object, and this function will be overridden with
that method when the connection is created."""
return string_literal(o, d)
def Thing2Literal(o, d):
"""Convert something into a SQL string literal. If using
MySQL-3.23 or newer, string_literal() is a method of the
_mysql.MYSQL object, and this function will be overridden with
that method when the connection is created."""
return string_literal(o, d)
def DateTimeToLiteral(date, converter):
"""Format a DateTime object as an ISO timestamp."""
try:
date = date.astimezone(pytz.utc)
except ValueError:
pass # naive datetime object
return _mysql.string_literal(date.isoformat(), converter)
def adapt_datetime_with_timezone_support(value, conv):
# Equivalent to DateTimeField.get_db_prep_value. Used only by raw SQL.
if settings.USE_TZ:
if timezone.is_naive(value):
warnings.warn(u"SQLite received a naive datetime (%s)"
u" while time zone support is active." % value,
RuntimeWarning)
default_timezone = timezone.get_default_timezone()
value = timezone.make_aware(value, default_timezone)
value = value.astimezone(timezone.utc).replace(tzinfo=None)
return string_literal(value.strftime("%Y-%m-%d %H:%M:%S"), conv)
def time2str(data):
return string_literal(data.strftime('%H:%M:%S'))
def datetime2str(data):
return string_literal(data.strftime('%Y-%m-%d %H:%M:%S'))
def thing2str(data):
return string_literal(data)
def _escape_string(s, d):
return _mysql.string_literal(s.encode('utf-8'), d).decode('utf-8')
def _escape_bytes(b, c):
return _mysql.string_literal(b, c).decode('utf-8')
def TimeDeltaToLiteral(timedelta, converter): """Formats a DateTimeDelta object as a string-literal time delta.""" hours, seconds = divmod(timedelta.seconds, 3600) minutes, seconds = divmod(seconds, 60) literal = '%d %d:%d:%d' % (timedelta.days, hours, minutes, seconds) return _mysql.string_literal(literal, converter)
def Set2Str(s, d):
# Only support ascii string. Not tested.
return string_literal(','.join(s), d)
def my_dict_escape(*args):
from _mysql import string_literal, escape_string
return ','.join([
'%s=%s' % (escape_string(k), string_literal(v))
for k, v in args[0].items()
])
def Set_to_sql(value, conv):
"""Convert a Python xet to an SQL literal."""
return string_literal(','.join(value), conv)
def timedelta_to_sql(obj, conv):
"""Format a timedelta as an SQL literal."""
return string_literal(timedelta_to_str(obj), conv)
def DateTimeDelta2literal(d, c):
"""Format a DateTimeDelta object as a time."""
return string_literal(format_TIME(d),c)
def DateTimeDelta2literal(d, c):
"""Format a DateTimeDelta object as a time."""
return string_literal(format_TIMEDELTA(d), c)
def TimeStructToLiteral(date, converter):
"""Formats a time_struct as an ISO timestamp."""
return _mysql.string_literal(time.strftime('%FT%T', date), converter)
def datetime_to_sql(obj, conv):
"""Format a DateTime object as an ISO timestamp."""
return string_literal(datetime_to_str(obj), conv)
def thing2str(data):
return string_literal(data)
def Set2Str(s, d):
# Only support ascii string. Not tested.
return string_literal(','.join(s), d)
def unicode2str(data):
return string_literal(data.encode(DATA_ENCODING))
def unicode2str(data):
return string_literal(data.encode(DATA_ENCODING))
def datetime2str(data):
return string_literal(data.strftime('%Y-%m-%d %H:%M:%S'))
def date2str(data):
return string_literal(data.strftime('%Y-%m-%d'))
def date2str(data):
return string_literal(data.strftime('%Y-%m-%d'))
def timedelta2str(data):
seconds = int(data.seconds) % 60
minutes = int(data.seconds / 60) % 60
hours = int(data.seconds / 3600) % 24
return string_literal('%d %d:%d:%d' % (data.days, hours, minutes, seconds))
def time2str(data):
return string_literal(data.strftime('%H:%M:%S'))
def Set2Str(s, d):
return string_literal(','.join(s), d)
def timedelta2str(data):
seconds = int(data.seconds) % 60
minutes = int(data.seconds / 60) % 60
hours = int(data.seconds / 3600) % 24
return string_literal('%d %d:%d:%d' %
(data.days, hours, minutes, seconds))
def DateTime2literal(d, c):
"""Format a DateTime object as an ISO timestamp."""
return string_literal(format_TIMESTAMP(d),c)
def string_literal(self, obj, dummy=None):
return origmysqlc.string_literal(obj)
def DateTime2literal(d, c):
"""Format a DateTime object as an ISO timestamp."""
return string_literal(format_TIMESTAMP(d), c)
def string_literal(self, obj, dummy=None): return origmysqlc.string_literal(obj)
def Set2Str(s, d):
return string_literal(','.join(s), d)
def _escape_bytes(b, c):
return _mysql.string_literal(b, c).decode('utf-8')
def _escape_string(s, d):
return _mysql.string_literal(s.encode('utf-8'), d).decode('utf-8')
def unicode2str(data):
return string_literal(data.encode(Compiler.encoding))
