# coding: utf-8
 
import re
import sqlite3
import lxml.etree as ET
from datetime import datetime
from itertools import count
 
NAME = re.compile(ur'([\w-]+)\s+([\w-]+)\s*([\w\s-]*)', re.I + re.U)
 
 
def data_iter(root):
    for item in root.iter('item'):
        yield {i.tag: i.text for i in item}
 
 
def name_split(name):
    fam, im, ot = NAME.match(name.upper()).groups()
    return fam, im, ot
 
 
class _Database(object):
    def __init__(self):
        self.con = sqlite3.connect('data.db')
        self.cur = self.con.cursor()
        self.cur.execute(
            '''CREATE TABLE IF NOT EXISTS "patient" ( `id` INTEGER, `n5` TEXT, `n6` TEXT, `fam` TEXT, `im` TEXT, 
            `ot` TEXT, `drd` DATE, `drdy` TEXT, `lnkd` DATE, `smo_cod` INTEGER, PRIMARY KEY(`id`) )''')
        self.cur.execute('CREATE INDEX IF NOT EXISTS `ix_patient_drd` ON `patient` (`drd` )')
        self.cur.execute('CREATE INDEX IF NOT EXISTS `ix_patient_drdy` ON `patient` (`drdy` )')
        self.cur.execute('CREATE INDEX IF NOT EXISTS `ix_patient_fam` ON `patient` (`fam` )')
        self.cur.execute('CREATE INDEX IF NOT EXISTS `ix_patient_im` ON `patient` (`im` )')
        self.cur.execute('CREATE INDEX IF NOT EXISTS `ix_patient_n6` ON `patient` (`n6` )')
        self.cur.execute('CREATE INDEX IF NOT EXISTS `ix_patient_ot` ON `patient` (`ot` )')
        self.cur.execute('CREATE UNIQUE INDEX IF NOT EXISTS `ix_patient_primary_key` ON `patient` (`id` )')
        self.cur.execute('DELETE FROM `patient`')
 
    def append(self, rec):
        self.cur.execute("insert into `patient` values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", rec)
 
    def close(self):
        self.con.commit()
        self.cur.close()
 
 
def main(name):
    db = _Database()
    tree = ET.parse(name)
    root = tree.getroot()
    counter = count(1)
    for item in data_iter(root):
        fam, im, ot = name_split(item['attr_84896_'])
        dr = datetime.strptime(item['attr_84891_'], '%d.%m.%Y').date()
        dl = datetime.strptime(item['attr_84913_'], '%d.%m.%Y').date()
        db.append([
            counter.next(),
            '',
            item['attr_84895_'],
            fam, im, ot,
            dr,
            str(dr.year),
            dl,
            0,
        ])
    db.close()
 
 
if __name__ == '__main__':
    main('data.xml')

[code ini]
~$ pip install sqlite3
Collecting sqlite3
  Downloading sqlite3-99.0.tar.gz
    Complete output from command python setup.py egg_info:
    Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/tmp/pip-build-z8SdZJ/sqlite3/setup.py", line 2, in <module>
        raise RuntimeError("Package 'sqlite3' must not be downloaded from pypi")
    RuntimeError: Package 'sqlite3' must not be downloaded from pypi
    
    ----------------------------------------
Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-z8SdZJ/sqlite3/
[/code]

  File "/home/irip/test/py/PY/setup.py", line 9
    NAME = re.compile(ur'([\w-]+)\s+([\w-]+)\s*([\w\s-]*)', re.I + re.U)
                                                         ^
SyntaxError: invalid syntax

 from lxml import etree
    
def get_node(node):
    print(node.tag,node.attrib,node.text)
    for n in node: get_node(n)
    
tree = etree.parse('DBSchema.xml')
get_node(tree.getroot())

Traceback (most recent call last):
  File "/home/irip/test/py/xml/setup.py", line 1, in <module>
    from lxml import etree
ImportError: No module named lxml