validateIntegrity method

  1. @override
VerificationContext validateIntegrity(
  1. Insertable<EmploymentHistoryData> instance, {
  2. 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<EmploymentHistoryData> 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('employee_id')) {
    context.handle(
      _employeeIdMeta,
      employeeId.isAcceptableOrUnknown(data['employee_id']!, _employeeIdMeta),
    );
  } else if (isInserting) {
    context.missing(_employeeIdMeta);
  }
  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('company_id')) {
    context.handle(
      _companyIdMeta,
      companyId.isAcceptableOrUnknown(data['company_id']!, _companyIdMeta),
    );
  } else if (isInserting) {
    context.missing(_companyIdMeta);
  }
  if (data.containsKey('from_date')) {
    context.handle(
      _fromDateMeta,
      fromDate.isAcceptableOrUnknown(data['from_date']!, _fromDateMeta),
    );
  } else if (isInserting) {
    context.missing(_fromDateMeta);
  }
  if (data.containsKey('to_date')) {
    context.handle(
      _toDateMeta,
      toDate.isAcceptableOrUnknown(data['to_date']!, _toDateMeta),
    );
  } else if (isInserting) {
    context.missing(_toDateMeta);
  }
  return context;
}