def convert_value(self, col_type, value): if col_type == 'timecode': timecode = TimeCode(timecode=value) value = timecode.get_frames() elif col_type in ["time", "timestamp"]: from pyasm.common import SPTDate if not value: value = "" elif not SPTDate.has_timezone(value): timezone = PrefSetting.get_value_by_key('timezone') if timezone: value = SPTDate.add_timezone(value, timezone) else: value = SPTDate.add_local_timezone(value) elif col_type in ["float", "integer"]: if isinstance(value, basestring): value = value.replace(",", "") if value.startswith("$"): value = value.lstrip("$") try: if not value: value = None elif col_type == "float": value = float(value) else: value = int(value) except: raise UserException("[%s] must a number." % value) return value
def convert_value(my, col_type, value): if col_type == 'timecode': timecode = TimeCode(timecode=value) value = timecode.get_frames() elif col_type in ["time", "timestamp"]: from pyasm.common import SPTDate if not SPTDate.has_timezone(value): timezone = PrefSetting.get_value_by_key('timezone') if timezone: value = SPTDate.add_timezone(value, timezone) else: value = SPTDate.add_local_timezone(value) elif col_type in ["float", "integer"]: if isinstance(value, basestring): value = value.replace(",", "") return value