import xml.etree.ElementTree as xmlParser
import ftplib
import os
from urllib.request import urlopen
import smtplib
import datetime
from email.mime.text import MIMEText
from email.header import Header
import csv


host = "szelepcsenyi.net"
password = "AsC1i@IkEz1"
username = "idevelopmentpeto"
port = "22"

url = 'https://feeds.mergado.com/priemyselnytovar-sk-heureka-sk-b4ddd86487479eb10da0b164d6c533d5.xml'
urlOpen = urlopen(url)
contents = urlOpen.read()
data = contents.decode()

file = open("export.xml", 'w')
file.write(data)
file.close()

xmlDoc = xmlParser.parse('export.xml')
rootElement = xmlDoc.getroot()

for element in rootElement.iter():
    if element.tag == 'DESCRIPTION':
        element.tag = 'description'
    elif element.tag == 'PRODUCT':
        element.tag = 'title'
    elif element.tag == 'ITEM_ID':
        element.tag = 'id'
    elif element.tag == 'SHOPITEM':
        element.tag = 'product'
    elif element.tag == 'EAN':
        element.tag = 'gtin'
    elif element.tag == 'IMGURL':
        element.tag = 'image_link'
    elif element.tag == 'URL':
        element.tag = 'link'
    elif element.tag == 'CATEGORYTEXT':
        element.tag = 'product_type'
    elif element.tag == 'MANUFACTURER':
        element.tag = 'brand'
    elif element.tag == 'PRICE_VAT':
        element.tag = 'price'



for element in rootElement:
    for subElement in element:
        if subElement.tag == 'PRODUCTNAME':
            element.remove(subElement)
        elif subElement.tag == 'DELIVERY_DATE':
            element.remove(subElement)


def subElement_equal(subElement1,subElement2):
    if type(subElement1) != type(subElement2):
        return False
    if subElement1.tag != subElement1.tag:
        return False
    if subElement1.text != subElement2.text:
        return False
    if subElement1.tail != subElement2.tail:
        return False
    if subElement1.attrib != subElement2.attrib:
        return False
    if len(subElement1) != len(subElement2):
        return False
    return all([subElement_equal(c1,c2) for c1,c2 in zip(subElement1,subElement2)])

prev = None

for element in rootElement:
    elementsToDelete = []
    for subElement in element:
        if subElement_equal(subElement,prev):
            elementsToDelete.append(subElement)
            continue
        prev = subElement
    for elementToDelete in elementsToDelete:
        element.remove(elementToDelete)

xmlDoc.write('EditedFeedGMC.xml',encoding="UTF-16",xml_declaration=True)