def getPrefixObj(mydb): dbcursor = mydb.cursor() f = open('d:/fajlovi/prefiksi.txt', 'r') line = f.readline() prefixi = [] while line: # iskljucujemo komentare if not(len(line) > 8 or len(line) < 7): p = Prefix() p.oznaka = line[:2] p.polje = line[3:6] p.podpolje = line[6:7] prefixi.append(p) line = f.readline() f.close() f = open('d:/fajlovi/PrefixNames_sr.properties', 'r', encoding="utf8") line = f.readline() line = line[1:] while line: oznaka = line[:2] labela = line[3:-1] for p in prefixi: if p.oznaka == oznaka: p.labela = labela line = f.readline() for p in prefixi: if(p.labela == ''): p.labela = p.oznaka sql = "INSERT INTO prefixi (prefix, label) VALUES (%s, %s)" val = (p.oznaka, p.labela) dbcursor.execute(sql, val) mydb.commit() ''' for p in prefixi: print(p.oznaka, p.polje, p.podpolje, p.labela) ''' return prefixi