def test_field_conversion_varchar_precision(self):
field = {"name": "string_field",
"datatype": "varchar",
"precision": "8", }
self.assertEqual(validator.field_conversion(field),
"cast(string_field as varchar(8))")
def test_field_conversion_timestamp_alias(self):
field = {"name": "time_field",
"format": "MM/dd/yyyy hh:mm:ss aa",
"datatype": "timestamp"}
self.assertEqual(validator.field_conversion(field, 'a'), "cast(from_unixtime(unix_timestamp(a.time_field, " +
"'MM/dd/yyyy hh:mm:ss aa')) as timestamp)")
def test_field_conversion_none(self):
field = {"name": "string_field",
"datatype": "varchar"}
self.assertEqual(validator.field_conversion(field),
"cast(string_field as varchar)")
def test_field_conversion_date_alias(self):
field = {"name": "date_field",
"format": "dd/mm/yyyy",
"datatype": "date"}
self.assertEqual(validator.field_conversion(field, 'a'), "cast(to_date(from_unixtime(unix_timestamp(a.date_field, " +
"'dd/mm/yyyy'))) as date)")