Flutter - stuck on multiple google sheets calls

Question

New to flutter and need help. I'm using google sheets as a database. Supposed to use multiple sheets each with different sheetId.

I have 2 function to get the data:
getChildSchedule - to get data from one specific sheet
getAllSchedule - to get data from multiple sheets.

In the widget I'm checking if I'm supposed to display data from a particular sheet or from all the sheets and call the appropriate func. When I'm calling getChildSchedule from the widget all works perfectly and it shows the data.
But when I need the getAllSchedule it gets stuck. It doesn't stop running but seems as if it's in an infinite loop though there is no such loop to get stuck on. From the prints and the tracking I did, it calls on the getChild with index 0 but never returns from it - though the child data is being printed inside getChild.
What am I doing wrong here?

Future<List<Lesson>> getChildSchedule(int childId) async {
    print('in getChild: child $childId: ${ChildrenManager.children[childId].spreadsheetId}');
    spreadsheetId = ChildrenManager.children[childId].spreadsheetId;
    await init();
    final lessons = await _scheduleSheet.values.allRows(fromRow: 2);
    print('in getChild: child $childId lessons: $lessons');
    return List.generate(
      lessons.length,
      (index) => Lesson(
        weekDay: lessons[index][0],
        startTime: double.tryParse(lessons[index][1] ?? ''),
        endTime: double.tryParse(lessons[index][2] ?? ''),
        grade: ChildrenManager.children[childId].grade,
        teacher: lessons[index][3],
        header: lessons[index][4],
        description: lessons[index][5],
        zoomLink: Uri.tryParse(lessons[index][6] ?? ''),
        meetingID: lessons[index][7],
        meetingCode: lessons[index][8],
        supplies: lessons[index][9],
        assignment: Uri.tryParse(lessons[index][10] ?? ''),
      ),
    );
  }

  Future<List<Lesson>> getAllSchedule() async {
    List<List<Lesson>> schedules = List<List<Lesson>>();
    for (int i = 0; i < ChildrenManager.children.length; i++) {
      print('in getAll schedules: $i');
      schedules[i] = await getChildSchedule(i);
      print('in getAll schedules: got $i child');    //this never gets printed
    }
    print('in getAll schedules: $schedules');
    List<Lesson> schedule = List<Lesson>();
    for (List<Lesson> sc in schedules) {
      schedule.addAll(sc);
    }
    schedule.sort((a, b) {
      int result = a.startTime.compareTo(b.startTime);
      if (result == 0) {
        return a.endTime.compareTo(b.endTime);
      }
      return result;
    });
    return schedule;
  }

Answer 1

I think the issue here was because of repeated calls that changed the sheet id while the previous was still running. I've moved the getAll to another class and called it with a new manager object(that contains the getChild) for each child and it solved the issue.