# -*- coding: utf8 -*-
import MySQLdb
import urllib2
import urlparse
from xml.dom.minidom import parse
def my_get():
        url = open('C:\Title3.xml')
        xml = parse(url)
        name = xml.getElementsByTagName('w:p')
        for node in name:
                el = node.getElementsByTagName('w:rStyle')
                if (len(el) != 0) and (el[0].hasAttribute('w:val')) and (el[0].attributes['w:val'].value == "a3"):
                        title =  node.getElementsByTagName('w:t')[0].firstChild.nodeValue
                        print title
        con = MySQLdb.connect(host="localhost", user="root", passwd="vertrigo", db="moodle")
        cur = con.cursor()
        sql_1="INSERT INTO mdl_course (category, sortorder, fullname, shortname, summaryformat, newsitems) VALUES (1, 10003, '"+title+"', '"+title+"', 1, 5);"
        try:
                cur.execute(sql_1)
        except MySQLdb.DatabaseError, err:
                print u"Ошибка:", err
        else:
                print u"Запрос успешно выполнен"
                con.commit()
        cur.close()
        con.close()
        raw_input()