def validate_against_schema(self, schema, row_nr, fieldname, value):
"""
"""
field = schema[fieldname]
if field.type == 'boolean':
value = str(value).strip().lower()
return value
if field.type == 'reference':
value = str(value).strip()
if field.required and not value:
raise ValueError("Row %s: %s field requires a value" % (
row_nr, fieldname))
if not value:
return value
brains = self.lookup(field.allowed_types, UID=value)
if not brains:
raise ValueError("Row %s: value is invalid (%s=%s)" % (
row_nr, fieldname, value))
if field.multiValued:
return [b.UID for b in brains] if brains else []
else:
return brains[0].UID if brains else None
if field.type == 'datetime':
try:
ulocalized_time(DateTime(value), long_format=True,
time_only=False, context=self)
except:
raise ValueError('Row %s: value is invalid (%s=%s)' % (
row_nr, fieldname, value))
return value
def folderitems(self, **kwargs):
items = super(ARImportsView, self).folderitems()
for x in range(len(items)):
if 'obj' not in items[x]:
continue
obj = items[x]['obj']
items[x]['Title'] = obj.title_or_id()
if items[x]['review_state'] == 'invalid':
items[x]['replace']['Title'] = "<a href='%s/edit'>%s</a>" % (
obj.absolute_url(), items[x]['Title'])
else:
items[x]['replace']['Title'] = "<a href='%s/view'>%s</a>" % (
obj.absolute_url(), items[x]['Title'])
items[x]['Creator'] = obj.Creator()
items[x]['Filename'] = obj.getFilename()
parent = obj.aq_parent
items[x]['Client'] = parent if IClient.providedBy(parent) else ''
items[x]['replace']['Client'] = "<a href='%s'>%s</a>" % (
parent.absolute_url(), parent.Title())
items[x]['DateCreated'] = ulocalized_time(
obj.created(), long_format=True, time_only=False, context=obj)
date = getTransitionDate(obj, 'validate')
items[x]['DateValidated'] = date if date else ''
date = getTransitionDate(obj, 'import')
items[x]['DateImported'] = date if date else ''
return items
def getTransitionDate(obj, action_id):
workflow = getToolByName(obj, 'portal_workflow')
review_history = list(workflow.getInfoFor(obj, 'review_history'))
# invert the list, so we always see the most recent matching event
review_history.reverse()
for event in review_history:
if event['action'] == action_id:
value = ulocalized_time(event['time'], long_format=True,
time_only=False, context=obj)
return value
return None
def getTransitionDate(obj, action_id, return_as_datetime=False):
"""
Returns date of action for object. Sometimes we need this date in Datetime
format and that's why added return_as_datetime param.
"""
review_history = getReviewHistory(obj)
for event in review_history:
if event.get('action') == action_id:
evtime = event.get('time')
if return_as_datetime:
return evtime
if evtime:
value = ulocalized_time(evtime, long_format=True,
time_only=False, context=obj)
return value
return None
def getTransitionDate(obj, action_id):
workflow = getToolByName(obj, 'portal_workflow')
try:
# https://jira.bikalabs.com/browse/LIMS-2242:
# Sometimes the workflow history is inexplicably missing!
review_history = list(workflow.getInfoFor(obj, 'review_history'))
except WorkflowException:
logger.error(
"workflow history is inexplicably missing."
" https://jira.bikalabs.com/browse/LIMS-2242")
return None
# invert the list, so we always see the most recent matching event
review_history.reverse()
for event in review_history:
if event['action'] == action_id:
value = ulocalized_time(event['time'], long_format=True,
time_only=False, context=obj)
return value
return None
def getTransitionDate(obj, action_id):
workflow = api.portal.get_tool("portal_workflow")
try:
# https://jira.bikalabs.com/browse/LIMS-2242:
# Sometimes the workflow history is inexplicably missing!
review_history = list(workflow.getInfoFor(obj, 'review_history'))
except WorkflowException as e:
message = str(e)
logger.error("Cannot retrieve review_history on {}: {}".format(
obj, message))
return None
# invert the list, so we always see the most recent matching event
review_history.reverse()
for event in review_history:
if event['action'] == action_id:
value = ulocalized_time(event['time'], long_format=True,
time_only=False, context=obj)
return value
return None
def munge_field_value(self, schema, row_nr, fieldname, value):
"""Convert a spreadsheet value into a field value that fits in
the corresponding schema field.
- boolean: All values are true except '', 'false', or '0'.
- reference: The title of an object in field.allowed_types;
returns a UID or list of UIDs
- datetime: returns a string value from ulocalized_time
Tho this is only used during "Saving" of csv data into schema fields,
it will flag 'validation' errors, as this is the only chance we will
get to complain about these field values.
"""
field = schema[fieldname]
if field.type == 'boolean':
value = str(value).strip().lower()
value = '' if value in ['0', 'no', 'false', 'none'] else '1'
return value
if field.type == 'reference':
value = str(value).strip()
brains = self.lookup(field.allowed_types, Title=value)
if not brains:
brains = self.lookup(field.allowed_types, UID=value)
if not brains:
raise ValueError('Row %s: value is invalid (%s=%s)' %
(row_nr, fieldname, value))
if field.multiValued:
return [b.UID for b in brains] if brains else []
else:
return brains[0].UID if brains else None
if field.type == 'datetime':
try:
value = DateTime(value)
return ulocalized_time(value,
long_format=True,
time_only=False,
context=self)
except:
raise ValueError('Row %s: value is invalid (%s=%s)' %
(row_nr, fieldname, value))
return str(value)
def getTransitionDate(obj, action_id):
workflow = ploneapi.portal.get_tool("portal_workflow")
try:
# https://jira.bikalabs.com/browse/LIMS-2242:
# Sometimes the workflow history is inexplicably missing!
review_history = list(workflow.getInfoFor(obj, 'review_history'))
except WorkflowException as e:
message = str(e)
logger.error("Cannot retrieve review_history on {}: {}".format(
obj, message))
return None
# invert the list, so we always see the most recent matching event
review_history.reverse()
for event in review_history:
if event['action'] == action_id:
value = ulocalized_time(event['time'],
long_format=True,
time_only=False,
context=obj)
return value
return None
def munge_field_value(self, schema, row_nr, fieldname, value):
"""Convert a spreadsheet value into a field value that fits in
the corresponding schema field.
- boolean: All values are true except '', 'false', or '0'.
- reference: The title of an object in field.allowed_types;
returns a UID or list of UIDs
- datetime: returns a string value from ulocalized_time
Tho this is only used during "Saving" of csv data into schema fields,
it will flag 'validation' errors, as this is the only chance we will
get to complain about these field values.
"""
field = schema[fieldname]
if field.type == 'boolean':
value = str(value).strip().lower()
value = '' if value in ['0', 'no', 'false', 'none'] else '1'
return value
if field.type == 'reference':
value = str(value).strip()
brains = self.lookup(field.allowed_types, Title=value)
if not brains:
brains = self.lookup(field.allowed_types, UID=value)
if not brains:
raise ValueError('Row %s: value is invalid (%s=%s)' % (
row_nr, fieldname, value))
if field.multiValued:
return [b.UID for b in brains] if brains else []
else:
return brains[0].UID if brains else None
if field.type == 'datetime':
try:
value = DateTime(value)
return ulocalized_time(
value, long_format=True, time_only=False, context=self)
except:
raise ValueError('Row %s: value is invalid (%s=%s)' % (
row_nr, fieldname, value))
return str(value)
