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_))