def get_display(self):
sobject = self.get_current_sobject()
name = self.get_name()
value = self.get_value()
if sobject:
data_type = SearchType.get_column_type(sobject.get_search_type(),
name)
else:
data_type = 'text'
if data_type in ["timestamp", "time"] or self.name == "timestamp":
if value == 'now':
value = ''
elif value:
date = parser.parse(value)
# we want to match what's in the db which is server local timezone
if not SPTDate.has_timezone(value):
value = SPTDate.convert_to_local(value)
#value = SPTDate.add_gmt_timezone(date)
value = str(value)
else:
value = ''
return value
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(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):
value = SPTDate.add_local_timezone(value)
elif col_type in ["float", "integer"]:
if isinstance(value, basestring):
value = value.replace(",", "")
return value
def get_display(my):
sobject = my.get_current_sobject()
name = my.get_name()
value = my.get_value()
if sobject:
data_type = SearchType.get_column_type(sobject.get_search_type(), name)
else:
data_type = 'text'
if data_type in ["timestamp","time"] or my.name == "timestamp":
if value == 'now':
value = ''
elif value:
date = parser.parse(value)
# we want to match what's in the db which is server local timezone
if not SPTDate.has_timezone(value):
value = SPTDate.convert_to_local(value)
#value = SPTDate.add_gmt_timezone(date)
value = str(value)
else:
value = ''
return value
