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