fin = open("nomeFile","r")
App = fin.readlines()
L = []

for frase in App:
    if ('NomeUniv' or 'NomeRett' not in frase):
        L.append(frase.replace('.','').split())

LUniv = L[:(len(L)/2-1)]
LRett = L[(len(L)/2):]

#oppure for i in L:
#           if len(i) == 4:
#                LUniv.append(i)
#           if len(i) == 3:
#                LRett.append(i)


import MySQLdb

db = MySQLdb.connect("localhost","user","passw","DB" )
cursor = db.cursor()
#cursor.execute('create database if not exists NOME') # non e' richiesto
#cursor.execute('use NOME') #non e' richiesto

tab1 = "CREATE TABLE Universita' (NomeUniversita’ char(30) primary key not null, Iscritti int, Ndocenti int)"
cursor.execute(tab1)
insert_stmt1 = ("INSERT INTO Universita' (NomeUniversita’, Iscritti, Ndocenti) " "VALUES (%s, %s,%s)")

tab2 = "CREATE TABLE Rettori (Rettore char(30), AnnoElezione int, NomeUniversita’ char(50) references on Universita' (NomeUniversita'), Citta’ char(30))"
cursor.execute(tab2)
insert_stmt2 = ("INSERT INTO Rettori (Rettore, Annoelezione, NomeUniversita', Citta') " "VALUES (%s,%s,%s,%s)")

for i in LUniv:
    data = (i[0], i[2], i[3]) 
    cursor.execute(insert_stmt1, data)
    db.commit()

for i in LUniv:
    for j in LRett:
        if i[0] == j[2]:
            data = (j[0], j[1], j[2], i[1]) 
            cursor.execute(insert_stmt2, data)
            db.commit()

db.close()