validateIntegrity method

  1. @override
VerificationContext validateIntegrity(
  1. Insertable<User> instance, {
  2. bool isInserting = false,
})
override

Validates that the given entity can be inserted into this table, meaning that it respects all constraints (nullability, text length, etc.).

Implementation

@override
VerificationContext validateIntegrity(
  Insertable<User> instance, {
  bool isInserting = false,
}) {
  final context = VerificationContext();
  final data = instance.toColumns(true);
  if (data.containsKey('id')) {
    context.handle(_idMeta, id.isAcceptableOrUnknown(data['id']!, _idMeta));
  }
  if (data.containsKey('fetched_at')) {
    context.handle(
      _fetchedAtMeta,
      fetchedAt.isAcceptableOrUnknown(data['fetched_at']!, _fetchedAtMeta),
    );
  }
  if (data.containsKey('student_id')) {
    context.handle(
      _studentIdMeta,
      studentId.isAcceptableOrUnknown(data['student_id']!, _studentIdMeta),
    );
  } else if (isInserting) {
    context.missing(_studentIdMeta);
  }
  if (data.containsKey('name_zh')) {
    context.handle(
      _nameZhMeta,
      nameZh.isAcceptableOrUnknown(data['name_zh']!, _nameZhMeta),
    );
  } else if (isInserting) {
    context.missing(_nameZhMeta);
  }
  if (data.containsKey('name_en')) {
    context.handle(
      _nameEnMeta,
      nameEn.isAcceptableOrUnknown(data['name_en']!, _nameEnMeta),
    );
  }
  if (data.containsKey('date_of_birth')) {
    context.handle(
      _dateOfBirthMeta,
      dateOfBirth.isAcceptableOrUnknown(
        data['date_of_birth']!,
        _dateOfBirthMeta,
      ),
    );
  }
  if (data.containsKey('program_zh')) {
    context.handle(
      _programZhMeta,
      programZh.isAcceptableOrUnknown(data['program_zh']!, _programZhMeta),
    );
  }
  if (data.containsKey('program_en')) {
    context.handle(
      _programEnMeta,
      programEn.isAcceptableOrUnknown(data['program_en']!, _programEnMeta),
    );
  }
  if (data.containsKey('department_zh')) {
    context.handle(
      _departmentZhMeta,
      departmentZh.isAcceptableOrUnknown(
        data['department_zh']!,
        _departmentZhMeta,
      ),
    );
  }
  if (data.containsKey('department_en')) {
    context.handle(
      _departmentEnMeta,
      departmentEn.isAcceptableOrUnknown(
        data['department_en']!,
        _departmentEnMeta,
      ),
    );
  }
  if (data.containsKey('avatar_filename')) {
    context.handle(
      _avatarFilenameMeta,
      avatarFilename.isAcceptableOrUnknown(
        data['avatar_filename']!,
        _avatarFilenameMeta,
      ),
    );
  } else if (isInserting) {
    context.missing(_avatarFilenameMeta);
  }
  if (data.containsKey('email')) {
    context.handle(
      _emailMeta,
      email.isAcceptableOrUnknown(data['email']!, _emailMeta),
    );
  } else if (isInserting) {
    context.missing(_emailMeta);
  }
  if (data.containsKey('password_expires_in_days')) {
    context.handle(
      _passwordExpiresInDaysMeta,
      passwordExpiresInDays.isAcceptableOrUnknown(
        data['password_expires_in_days']!,
        _passwordExpiresInDaysMeta,
      ),
    );
  }
  if (data.containsKey('semesters_fetched_at')) {
    context.handle(
      _semestersFetchedAtMeta,
      semestersFetchedAt.isAcceptableOrUnknown(
        data['semesters_fetched_at']!,
        _semestersFetchedAtMeta,
      ),
    );
  }
  return context;
}