import csv, re, sqlite3

con = sqlite3.connect("database_modfire.db")

cur = con.cursor()

f = open("adj_init.txt", "w+")
f2 = open("border_init.txt", "w+")

toWrite = ''

for i in range(0, 1406):
	cur.execute("Select ug2 from adj_int where ug1 like "+str(i))

	result = cur.fetchall()
	if(result == []):

		toWrite = "-1\n"

	else:
		for j in range(0, len(result)):	
			toWrite += str(result[j]).replace(')','').replace('(','')
		toWrite = toWrite[:-1]+"\n"
	f.write(toWrite)

	toWrite = ''

	cur.execute("Select front from adj_int where ug1 like "+str(i))

	result = cur.fetchall()

	if(result == []):
		toWrite = "-1\n"
	else:
		for j in range(0, len(result)):	
			toWrite += str(result[j]).replace(')','').replace('(','')
		toWrite = toWrite[:-1]+"\n"

	f2.write(toWrite)
	toWrite = ''