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
