def testDateTime(self):
tdf = TicDatFactory(table_with_stuffs=[["field one"], ["field two"]],
parameters=[["a"], ["b"]])
tdf.add_parameter("p1", "Dec 15 1970", datetime=True)
tdf.add_parameter("p2", None, datetime=True, nullable=True)
tdf.set_data_type("table_with_stuffs", "field one", datetime=True)
tdf.set_data_type("table_with_stuffs",
"field two",
datetime=True,
nullable=True)
dat = tdf.TicDat(table_with_stuffs=[[
"July 11 1972", None
], [datetime.datetime.now(),
dateutil.parser.parse("Sept 11 2011")]],
parameters=[["p1", "7/11/1911"], ["p2", None]])
self.assertFalse(
tdf.find_data_type_failures(dat)
or tdf.find_data_row_failures(dat))
file_one = os.path.join(_scratchDir, "datetime.json")
tdf.json.write_file(dat, file_one)
dat_1 = tdf.json.create_tic_dat(file_one)
self.assertFalse(tdf._same_data(dat, dat_1))
self.assertTrue(
isinstance(dat_1.parameters["p1"]["b"], datetime.datetime))
self.assertTrue(
all(
isinstance(_, datetime.datetime)
for _ in dat_1.table_with_stuffs))
self.assertTrue(
all(
isinstance(_, datetime.datetime) or _ is None
for v in dat_1.table_with_stuffs.values() for _ in v.values()))
def test_parameters(self):
path = os.path.join(_scratchDir, "parameters.json")
tdf = TicDatFactory(parameters=[["Key"], ["Value"]])
tdf.add_parameter("Something", 100)
tdf.add_parameter("Different",
'boo',
strings_allowed='*',
number_allowed=False)
dat = tdf.TicDat(
parameters=[["Something", float("inf")], ["Different", "inf"]])
tdf.json.write_file(dat, path)
dat_ = tdf.json.create_tic_dat(path)
self.assertTrue(tdf._same_data(dat, dat_))
def test_parameters(self):
filePath = os.path.join(_scratchDir, "parameters")
tdf = TicDatFactory(parameters=[["Key"], ["Value"]])
tdf.add_parameter("Something", 100)
tdf.add_parameter("Different",
'boo',
strings_allowed='*',
number_allowed=False)
dat = tdf.TicDat(
parameters=[["Something", float("inf")], ["Different", "inf"]])
tdf.sql.write_sql_file(dat, filePath + ".sql")
dat_ = tdf.sql.create_tic_dat_from_sql(filePath + ".sql")
self.assertTrue(tdf._same_data(dat, dat_))
tdf.sql.write_db_data(dat, filePath + ".db")
dat_ = tdf.sql.create_tic_dat(filePath + ".db")
self.assertTrue(tdf._same_data(dat, dat_))
