validateIntegrity method

@override VerificationContext validateIntegrity(Insertable<EmployeeData> instance, { bool isInserting = false, })

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<EmployeeData> 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('emp_number')) {
    context.handle(
      _empNumberMeta,
      empNumber.isAcceptableOrUnknown(data['emp_number']!, _empNumberMeta),
    );
  } else if (isInserting) {
    context.missing(_empNumberMeta);
  }
  if (data.containsKey('name')) {
    context.handle(
      _nameMeta,
      name.isAcceptableOrUnknown(data['name']!, _nameMeta),
    );
  } else if (isInserting) {
    context.missing(_nameMeta);
  }
  if (data.containsKey('email')) {
    context.handle(
      _emailMeta,
      email.isAcceptableOrUnknown(data['email']!, _emailMeta),
    );
  } else if (isInserting) {
    context.missing(_emailMeta);
  }
  if (data.containsKey('employee_position_id')) {
    context.handle(
      _employeePositionIdMeta,
      employeePositionId.isAcceptableOrUnknown(
        data['employee_position_id']!,
        _employeePositionIdMeta,
      ),
    );
  } else if (isInserting) {
    context.missing(_employeePositionIdMeta);
  }
  if (data.containsKey('department_id')) {
    context.handle(
      _departmentIdMeta,
      departmentId.isAcceptableOrUnknown(
        data['department_id']!,
        _departmentIdMeta,
      ),
    );
  } else if (isInserting) {
    context.missing(_departmentIdMeta);
  }
  if (data.containsKey('birthday')) {
    context.handle(
      _birthdayMeta,
      birthday.isAcceptableOrUnknown(data['birthday']!, _birthdayMeta),
    );
  } else if (isInserting) {
    context.missing(_birthdayMeta);
  }
  if (data.containsKey('hire_date')) {
    context.handle(
      _hireDateMeta,
      hireDate.isAcceptableOrUnknown(data['hire_date']!, _hireDateMeta),
    );
  } else if (isInserting) {
    context.missing(_hireDateMeta);
  }
  if (data.containsKey('image_path')) {
    context.handle(
      _imagePathMeta,
      imagePath.isAcceptableOrUnknown(data['image_path']!, _imagePathMeta),
    );
  }
  if (data.containsKey('address')) {
    context.handle(
      _addressMeta,
      address.isAcceptableOrUnknown(data['address']!, _addressMeta),
    );
  }
  return context;
}