as method

  1. @override
Query<HasResultSet, dynamic> as()
override

This method is overridden by Dart-defined views to declare the right query to run.

Implementation

@override
Query as() =>
    select([
      courseOfferings.id,
      courseOfferings.courseCode,
      courseOfferings.semester,
      courseOfferings.number,
      nameZh,
      nameEn,
      credits,
      hours,
      courseOfferings.phase,
      courseOfferings.courseType,
      courseOfferings.status,
      courseOfferings.language,
      courseOfferings.remarks,
      courseOfferings.enrolled,
      courseOfferings.withdrawn,
      courseOfferings.fetchedAt,
      courseOfferings.syllabusUpdatedAt,
      courseOfferings.objective,
      courseOfferings.weeklyPlan,
      courseOfferings.evaluation,
      courseOfferings.textbooks,
      courseOfferings.syllabusRemarks,
    ]).from(courseOfferings).join([
      leftOuterJoin(
        courses,
        courses.code.equalsExp(courseOfferings.courseCode),
      ),
    ]);