def selectAllLocations(self, accountId): conn = sqlite3.connect(self.dbName) locationCursor = conn.cursor() data = locationCursor.execute( "select * from Location where AccountId = %d" % accountId ).fetchall() locationCursor.close() locations = [] for ldata in data: location = Location(ldata[0], ldata[1], ldata[2], ldata[3], ldata[4]) growCursor = conn.cursor() growData = growCursor.execute( "select * from Grow, FruitCrop where (Grow.FC_Id) = FruitCrop.Id and Grow.L_Id = %d" % ldata[0] ).fetchall() for g in growData: FC = FruitCrop(g[4], g[5], g[6], g[7]) grow = Grow(g[0], g[1], FC, g[2], g[3]) location.appendGrow(grow) growCursor.close() locations.append(location) conn.close() return locations