def ListPorts(Where=''):
out = []
DbConnection = sqlite3.connect('main.db')
DbCursor = DbConnection.cursor()
#cursor=DbCursor.execute("SELECT * FROM PORTS "+Where)
for row in DbCursor.execute("SELECT * FROM PORTS " + Where).fetchall():
Obj = Port()
Obj.Id = row[0]
Obj.RouterId = row[1]
Obj.Ip = row[2]
out.append(Obj)
DbConnection.close()
return out
