def _updateXupdateDel(self,
document=None,
xml=None,
previous_xml=None,
**kw):
""" This method is called in updateNode and allows to remove elements. """
conflict_list = []
tag = xml.get('select').split('/')[-1]
integration_site = document.context.getParentValue()
if tag.split('[')[0] == 'category':
# retrieve the previous xml etree through xpath
previous_xml = previous_xml.xpath(tag)
try:
previous_value = integration_site.getMappingFromCategory(
previous_xml[0].text, )
except IndexError:
raise IndexError, 'Too little or too many value, only one is required for %s' % (
previous_xml)
# retrieve the current value to check if exists a conflict
current_value = etree.XML(document.asXML()).xpath(tag)[0].text
current_value = integration_site.getMappingFromCategory(
current_value)
# work on variations
variation_brain_list = document.context.getProductCategoryList(
product_id=document.getId())
for brain in variation_brain_list:
if brain.category == current_value and previous_value == current_value:
base_category, variation = current_value.split('/', 1)
document.context.product_module.deleteProductAttributeCombination(
product_id=document.getId(),
base_category=base_category,
variation=variation,
)
else:
# previous value different from current value
conflict = Conflict(
object_path=document.getPhysicalPath(),
keyword=tag,
)
conflict.setXupdate(etree.tostring(xml, encoding='utf-8'))
conflict.setLocalValue(previous_value)
conflict.setRemoteValue(current_value)
conflict_list.append(conflict)
else:
keyword = {
'product_id': document.getId(),
tag: 'NULL',
}
document.context.product_module.updateProduct(**keyword)
return conflict_list
def _updateXupdateDel(self, document=None, xml=None, previous_xml=None, **kw):
""" This method is called in updateNode and allows to remove elements. """
conflict_list = []
tag = xml.get('select').split('/')[-1]
integration_site = document.context.getParentValue()
if tag.split('[')[0] == 'category':
# retrieve the previous xml etree through xpath
previous_xml = previous_xml.xpath(tag)
try:
previous_value = integration_site.getMappingFromCategory(
previous_xml[0].text,
)
except IndexError:
raise IndexError, 'Too little or too many value, only one is required for %s' % (
previous_xml
)
# retrieve the current value to check if exists a conflict
current_value = etree.XML(document.asXML()).xpath(tag)[0].text
current_value = integration_site.getMappingFromCategory(current_value)
# work on variations
variation_brain_list = document.context.getProductCategoryList(product_id=document.getId())
for brain in variation_brain_list:
if brain.category == current_value and previous_value == current_value:
base_category, variation = current_value.split('/', 1)
document.context.product_module.deleteProductAttributeCombination(
product_id=document.getId(),
base_category=base_category,
variation=variation,
)
else:
# previous value different from current value
conflict = Conflict(
object_path=document.getPhysicalPath(),
keyword=tag,
)
conflict.setXupdate(etree.tostring(xml, encoding='utf-8'))
conflict.setLocalValue(previous_value)
conflict.setRemoteValue(current_value)
conflict_list.append(conflict)
else:
keyword = {'product_id': document.getId(), tag: 'NULL' , }
document.context.product_module.updateProduct(**keyword)
return conflict_list
def _updateXupdateUpdate(self, document=None, xml=None, previous_xml=None, **kw):
"""
This method is called in updateNode and allows to work on the update of
elements.
"""
conflict_list = []
xpath_expression = xml.get('select')
tag = xpath_expression.split('/')[-1]
value = xml.text
# retrieve the previous xml etree through xpath
previous_xml = previous_xml.xpath(xpath_expression)
try:
previous_value = previous_xml[0].text
except IndexError:
raise IndexError, 'Too little or too many value, only one is required for %s' % (
previous_xml
)
# check if it'a work on person or on address
if tag in ['street', 'zip', 'city', 'country']:
try:
# work on the case: "/node/address[x]"
address_index = \
int(xpath_expression.split('address[')[-1].split(']')[0]) - 1
except ValueError:
# Work on the case: "/node/address"
address_index = 0
# build the address list
address_list = document.context.person_module.getPersonAddressList(
person_id=document.getId(),
)
# FIXME: Is the sort can be removed ???
# Build a list of tuple which contains :
# - first, the title build to realise the sort
# - the second element is the brain itself
sorted_address_list = [
(' '.join([address.street,
address.zip,
address.city,
address.country]),
address)
for address in address_list]
sorted_address_list.sort()
address_list = [t[1] for t in sorted_address_list]
try:
address = address_list[address_index]
except IndexError:
# create and fill a conflict when the integration site value, the erp5
# value and the previous value are differents
conflict = Conflict(
object_path=document.getPhysicalPath(),
keyword=tag,
)
conflict.setXupdate(etree.tostring(xml, encoding='utf-8'))
conflict.setLocalValue(None)
conflict.setRemoteValue(value)
conflict_list.append(conflict)
return conflict_list
current_value = getattr(address, tag, None)
if current_value not in [value, previous_value]:
# create and fill a conflict when the integration site value, the erp5
# value and the previous value are differents
conflict = Conflict(
object_path=document.getPhysicalPath(),
keyword=tag,
)
conflict.setXupdate(etree.tostring(xml, encoding='utf-8'))
conflict.setLocalValue(current_value)
conflict.setRemoteValue(value)
conflict_list.append(conflict)
else:
# set the keyword dict which defines what will be updated
keyword = {
'address_id': address.getId(),
'person_id': document.getId(),
}
if tag == 'country':
# through the mapping retrieve the country
mapping = document.context.getMappingFromCategory('region/%s' % value)
value = mapping.split('/', 1)[-1]
keyword[tag] = value
document.context.person_module.updatePersonAddress(**keyword)
else:
# getter used to retrieve the current values and to check conflicts
property_list = ['birthday', ]
getter_value_dict = dict([
(prop, getattr(document, prop))
for prop in property_list
if getattr(document, prop, None) is not None
])
# create and fill a conflict when the integration site value, the erp5
# value and the previous value are differents
current_value = getter_value_dict[tag]
if current_value not in [value, previous_value]:
conflict = Conflict(
object_path=document.getPhysicalPath(),
keyword=tag,
)
conflict.setXupdate(etree.tostring(xml, encoding='utf-8'))
conflict.setLocalValue(current_value)
conflict.setRemoteValue(value)
conflict_list.append(conflict)
else:
# XXX: when the DateTime format will be required to sync date
# - 1 - retrieve the format through the integration site
# - 2 - through using of DateTime build the date and render it
# if tag == 'birthday':
# integration_site = self.getIntegrationSite(kw.get('domain'))
# date_format = integration_site.getDateFormat()
# # build the required format
# format = dict_format[date_format] -> render "%Y/%m/%d", ...
# value = DateTime(value).strftime(format)
keyword = {'person_id': document.getId(), tag: value, }
document.context.person_module.updatePerson(**keyword)
return conflict_list
def _updateXupdateInsertOrAdd(self, document=None, xml=None, previous_xml=None, **kw):
""" This method is called in updateNode and allows to add elements. """
conflict_list = []
for subnode in xml.getchildren():
tag = subnode.attrib['name']
value = subnode.text
if tag == 'address':
keyword = {'person_id': document.getId(), }
for subsubnode in subnode.getchildren():
if subsubnode.tag == 'country':
# through the mapping retrieve the country
keyword[subsubnode.tag] = document.context.getMappingFromCategory(
'region/%s' % subsubnode.text,
).split('/', 1)[-1]
else:
keyword[subsubnode.tag] = subsubnode.text
document.context.person_module.createPersonAddress(**keyword)
elif tag in ['street', 'zip', 'city', 'country']:
try:
# work on the case: "/node/address[x]"
address_index = int(xml.get('select').split('address[')[-1].split(']')[0]) - 1
except ValueError:
# Work on the case: "/node/address"
address_index = 0
# build the address list
address_list = document.context.person_module.getPersonAddressList(
person_id=document.getId(),
)
# FIXME: Is the sort can be removed ???
# Build a list of tuple which contains :
# - first, the title build to realise the sort
# - the second element is the brain itself
sorted_address_list = [
(' '.join([
getattr(address, i, '')
for i in ['street', 'zip', 'city','country']]
), address)
for address in address_list
]
sorted_address_list.sort()
address_list = [t[1] for t in sorted_address_list]
try:
address = address_list[address_index]
except IndexError:
# create and fill a conflict when the integration site value, the erp5
# value and the previous value are differents
conflict = Conflict(
object_path=document.getPhysicalPath(),
keyword=tag,
)
conflict.setXupdate(etree.tostring(xml, encoding='utf-8'))
conflict.setLocalValue(None)
conflict.setRemoteValue(value)
conflict_list.append(conflict)
return conflict_list
# set the keyword dict which defines what will be updated
keyword = {
'person_id': document.getId(),
'address_id': address.getId(),
}
if tag == 'country':
# through the mapping retrieve the country
mapping = document.context.getMappingFromCategory('region/%s' % value)
value = mapping.split('/', 1)[-1]
keyword[tag] = value
document.context.person_module.updatePersonAddress(**keyword)
else:
# XXX: when the DateTime format will be required to sync date
# - 1 - retrieve the format through the integration site
# - 2 - through using of DateTime build the date and render it
# if tag == 'birthday':
# integration_site = self.getIntegrationSite(kw.get('domain'))
# date_format = integration_site.getDateFormat()
# # build the required format
# format = dict_format[date_format] -> render "%Y/%m/%d", ...
# value = DateTime(value).strftime(format)
keyword = {'person_id': document.getId(), tag:value, }
document.context.person_module.updatePerson(**keyword)
return conflict_list
def _updateXupdateDel(self, document=None, xml=None, previous_xml=None, **kw):
""" This method is called in updateNode and allows to remove elements. """
conflict_list = []
tag = xml.get('select').split('/')[-1]
# this variable is used to retrieve the id of address and to not remove the
# orginal tag (address, street, zip, city or country)
tag_for_id = tag
# specific work for address and address elements
if tag.split('[')[0] in ['address', 'street', 'zip', 'city', 'country']:
# work on the good part of the xml to retrieve the address id
if tag_for_id.split('[')[0] != 'address':
tag_for_id = xml.get('select')
try:
# work on the case: "/node/address[x]"
address_index = int(tag_for_id.split('[')[-1].split(']')[0]) - 1
except ValueError:
# Work on the case: "/node/address"
address_index = 0
# build the address list
address_list = document.context.person_module.getPersonAddressList(
person_id=document.getId(),
)
# FIXME: Is the sort can be removed ???
# Build a list of tuple which contains :
# - first, the title build to realise the sort
# - the second element is the brain itself
sorted_address_list = [
(' '.join([
getattr(address, i, '')
for i in ['street', 'zip', 'city','country']]
), address)
for address in address_list
]
sorted_address_list.sort()
address_list = [t[1] for t in sorted_address_list]
try:
address = address_list[address_index]
except IndexError:
# create and fill a conflict when the integration site value, the erp5
# value and the previous value are differents
conflict = Conflict(
object_path=document.getPhysicalPath(),
keyword=tag,
)
conflict.setXupdate(etree.tostring(xml, encoding='utf-8'))
conflict.setLocalValue(None)
conflict_list.append(conflict)
return conflict_list
# remove the corresponding address or the element of the address
keyword = {'person_id': document.getId(), 'address_id': address.getId()}
if tag.split('[')[0] == 'address':
document.context.person_module.deletePersonAddress(**keyword)
else:
# set the keyword dict which defines what will be updated
keyword[tag] = 'NULL'
document.context.person_module.updatePersonAddress(**keyword)
else:
keyword = {'person_id': document.getId(), tag: 'NULL', }
document.context.person_module.updatePerson(**keyword)
# it always return conflict_list but it's empty
return conflict_list
def _updateXupdateUpdate(self, document=None, xml=None, previous_xml=None, **kw):
"""
This method is called in updateNode and allows to work on the update of
elements.
"""
conflict_list = []
xpath_expression = xml.get('select')
tag = xpath_expression.split('/')[-1]
integration_site = document.context.getParentValue()
new_value = xml.text
# retrieve the previous xml etree through xpath
previous_xml = previous_xml.xpath(xpath_expression)
try:
previous_value = previous_xml[0].text
except IndexError:
raise ValueError, 'Too little or too many value, only one is required for %s' % (
previous_xml
)
# check if it'a work on product or on categories
if tag.split('[')[0] == 'category':
# init the base category and the variation through the mapping
mapping = integration_site.getMappingFromCategory(new_value)
base_category, variation = mapping.split('/', 1)
updated = False
# init the previous value through the mapping
previous_value = integration_site.getMappingFromCategory(previous_value)
# work on variations
variation_brain_list = document.context.getProductCategoryList()
for brain in variation_brain_list:
if brain.category == previous_value:
old_base_category, old_variation = previous_value.split('/', 1)
# remove all variations
document.context.product_module.deleteProductAttributeCombination(
product_id=document.getId(),
base_category=old_base_category,
variation=old_variation,
)
# retrieve the variations which have a different axe from the updated
# and build the cartesian variation for this new variations
external_axe_list = [
tuple(x.category.split('/', 1))
for x in document.context.getProductCategoryList()
if x.category.split('/', 1)[0] != brain.category.split('/', 1)[0]
]
builder_variation_list = [
[tuple(mapping.split('/', 1))], external_axe_list,
]
variation_list = cartesianProduct(builder_variation_list)
for var_list in variation_list:
document.context.product_module.createProductAttribute(
id_product=document.getId(),
)
id_product_attribute = document.context.IntegrationSite_lastID(
type='Product Attribute',
)[0].getId()
for variation in var_list:
document.context.product_module.createProductAttributeCombination(
id_product_attribute=id_product_attribute,
id_product=document.getId(),
base_category=variation[0],
variation=variation[1],
)
else:
# previous value not find, so multiple update on the same product
conflict = Conflict(
object_path=document.getPhysicalPath(),
keyword=tag,
)
conflict.setXupdate(etree.tostring(xml, encoding='utf-8'))
conflict.setLocalValue(previous_value)
conflict.setRemoteValue(new_value)
conflict_list.append(conflict)
else:
# getter used to retrieve the current values and to check conflicts
property_list = ['sale_price', 'purchase_price', 'ean13']
getter_value_dict = dict(zip(
property_list, [
getattr(document, prop, None)
for prop in property_list
]
))
# create and fill a conflict when the integration site value, the erp5
# value and the previous value are differents
current_value = getter_value_dict[tag]
if type(current_value) == float:
current_value = '%.6f' % current_value
if current_value not in [new_value, previous_value]:
conflict = Conflict(
object_path=document.getPhysicalPath(),
keyword=tag,
)
conflict.setXupdate(etree.tostring(xml, encoding='utf-8'))
conflict.setLocalValue(current_value)
conflict.setRemoteValue(new_value)
conflict_list.append(conflict)
else:
keyword = {'product_id': document.getId(), tag: new_value , }
document.context.product_module.updateProduct(**keyword)
return conflict_list
def _updateXupdateUpdate(self,
document=None,
xml=None,
previous_xml=None,
**kw):
"""
This method is called in updateNode and allows to work on the update of
elements.
"""
conflict_list = []
xpath_expression = xml.get('select')
tag = xpath_expression.split('/')[-1]
integration_site = document.context.getParentValue()
new_value = xml.text
# retrieve the previous xml etree through xpath
previous_xml = previous_xml.xpath(xpath_expression)
try:
previous_value = previous_xml[0].text
except IndexError:
raise ValueError, 'Too little or too many value, only one is required for %s' % (
previous_xml)
# check if it'a work on product or on categories
if tag.split('[')[0] == 'category':
# init the base category and the variation through the mapping
mapping = integration_site.getMappingFromCategory(new_value)
base_category, variation = mapping.split('/', 1)
updated = False
# init the previous value through the mapping
previous_value = integration_site.getMappingFromCategory(
previous_value)
# work on variations
variation_brain_list = document.context.getProductCategoryList()
for brain in variation_brain_list:
if brain.category == previous_value:
old_base_category, old_variation = previous_value.split(
'/', 1)
# remove all variations
document.context.product_module.deleteProductAttributeCombination(
product_id=document.getId(),
base_category=old_base_category,
variation=old_variation,
)
# retrieve the variations which have a different axe from the updated
# and build the cartesian variation for this new variations
external_axe_list = [
tuple(x.category.split('/', 1))
for x in document.context.getProductCategoryList()
if x.category.split('/', 1)[0] != brain.category.split(
'/', 1)[0]
]
builder_variation_list = [
[tuple(mapping.split('/', 1))],
external_axe_list,
]
variation_list = cartesianProduct(builder_variation_list)
for var_list in variation_list:
document.context.product_module.createProductAttribute(
id_product=document.getId(), )
id_product_attribute = document.context.IntegrationSite_lastID(
type='Product Attribute', )[0].getId()
for variation in var_list:
document.context.product_module.createProductAttributeCombination(
id_product_attribute=id_product_attribute,
id_product=document.getId(),
base_category=variation[0],
variation=variation[1],
)
else:
# previous value not find, so multiple update on the same product
conflict = Conflict(
object_path=document.getPhysicalPath(),
keyword=tag,
)
conflict.setXupdate(etree.tostring(xml, encoding='utf-8'))
conflict.setLocalValue(previous_value)
conflict.setRemoteValue(new_value)
conflict_list.append(conflict)
else:
# getter used to retrieve the current values and to check conflicts
property_list = ['sale_price', 'purchase_price', 'ean13']
getter_value_dict = dict(
zip(property_list,
[getattr(document, prop, None) for prop in property_list]))
# create and fill a conflict when the integration site value, the erp5
# value and the previous value are differents
current_value = getter_value_dict[tag]
if type(current_value) == float:
current_value = '%.6f' % current_value
if current_value not in [new_value, previous_value]:
conflict = Conflict(
object_path=document.getPhysicalPath(),
keyword=tag,
)
conflict.setXupdate(etree.tostring(xml, encoding='utf-8'))
conflict.setLocalValue(current_value)
conflict.setRemoteValue(new_value)
conflict_list.append(conflict)
else:
keyword = {
'product_id': document.getId(),
tag: new_value,
}
document.context.product_module.updateProduct(**keyword)
return conflict_list
