def test_datetime(self):
value = datetime(1977, 4, 5, 12, 34, 56, 78)
self.connection.execute("INSERT INTO datetime_test (dt) VALUES (?)",
(value, ))
result = self.connection.execute("SELECT dt FROM datetime_test")
variable = DateTimeVariable()
result.set_variable(variable, result.get_one()[0])
if not self.supports_microseconds:
value = value.replace(microsecond=0)
self.assertEquals(variable.get(), value)
def test_datetime(self):
value = datetime(1977, 4, 5, 12, 34, 56, 78)
self.connection.execute("INSERT INTO datetime_test (dt) VALUES (?)",
(value,))
result = self.connection.execute("SELECT dt FROM datetime_test")
variable = DateTimeVariable()
result.set_variable(variable, result.get_one()[0])
if not self.supports_microseconds:
value = value.replace(microsecond=0)
self.assertEquals(variable.get(), value)
def parse_set(self, value, from_db):
if type(value) is datetime.date:
warnings.warn("Using datetime.date is deprecated, pass in "
"datetime.datetime instead", stacklevel=4)
value = datetime.datetime(value.year, value.month, value.day)
return DateTimeVariable.parse_set(self, value, from_db)
def parse_set(self, value, from_db):
# We need to use type here because in py3 datetime is a subclass of
# date, meaning that it would be considered too and loose its time
if type(value) is datetime.date:
warnings.warn("Using datetime.date is deprecated, pass in "
"datetime.datetime instead", stacklevel=4)
value = datetime.datetime(value.year, value.month, value.day)
return DateTimeVariable.parse_set(self, value, from_db)
def parse_set(self, value, from_db):
# We need to use type here because in py3 datetime is a subclass of
# date, meaning that it would be considered too and loose its time
if type(value) is datetime.date:
warnings.warn(
"Using datetime.date is deprecated, pass in "
"datetime.datetime instead",
stacklevel=4)
value = datetime.datetime(value.year, value.month, value.day)
return DateTimeVariable.parse_set(self, value, from_db)
def parse_set(self, value, from_db):
if type(value) is datetime.date:
value = datetime.datetime(value.year, value.month, value.day)
return DateTimeVariable.parse_set(self, value, from_db)
def compile_datetime(compile, expr, state):
state.parameters.append(DateTimeVariable(expr))
return "?"
def test_datetime_with_none(self):
self.connection.execute("INSERT INTO datetime_test (dt) VALUES (NULL)")
result = self.connection.execute("SELECT dt FROM datetime_test")
variable = DateTimeVariable()
result.set_variable(variable, result.get_one()[0])
self.assertEquals(variable.get(), None)
def test_datetime_with_none(self):
self.connection.execute("INSERT INTO datetime_test (dt) VALUES (NULL)")
result = self.connection.execute("SELECT dt FROM datetime_test")
variable = DateTimeVariable()
result.set_variable(variable, result.get_one()[0])
self.assertEquals(variable.get(), None)