Python DateTimeVariable.get Examples

Example #1

File: base.py Project: datnguyen0606/storm

 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)

Example #2

File: base.py Project: olivecoder/mamba-storm

 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)

Example #3

File: postgres.py Project: Tibodef/PythonBlog

 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)

Example #4

File: postgres.py Project: welitonfreitas/storm-py3

 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)