Flutter/摩尔中如何编写返回Future costomselect查询

w41d8nur  于 11个月前  发布在  Flutter
关注(0)|答案(1)|浏览(114)

我正在用flutter/摩尔开发应用程序。但是我不知道如何编写返回Future类对象的自定义查询。
我可以写一个返回Stream类对象的查询。但是这还不够。现在有没有人可以把它改成一个返回Future类的查询。
我写的查询是bellow

db.dart

Stream<List<QuestionHeader>> selectQuestionHeaderByKey(int businessYear,int period, int questionNo) {
    return
      customSelect(
        'SELECT *'
            +'From question_Headers '
            +'WHERE business_Year = ? '
            +'AND period = ? '
            +'AND question_No = ?;',
        variables: [Variable.withInt(businessYear),Variable.withInt(period),Variable.withInt(questionNo)],
        readsFrom: {questionHeaders},
      ).watch().map((rows) {
        return rows
            .map((row) => QuestionHeader(
            businessYear:row.readInt('businessYear')
            ,period:row.readInt('period')
            ,questionNo:row.readInt('questionNo')
            ,subjectId:row.readInt('subjectId')
            ,compulsoryType:row.readInt('compulsoryType')
            ,answerType:row.readInt('answerType')
            ,questionText:row.readString('questionText')
            ,numberAnswer:row.readInt('numberAnswer')
            ,correctType1:row.readInt('correctType1')
            ,correctType2:row.readInt('correctType2')
            ,correctType3:row.readInt('correctType3')
            ,favorite:row.readBool('favorite')
        )).toList();
      });
  }

字符串
这可以工作,但我需要Future类返回。

相关问题