import { Injectable } from '@nestjs/common';
import { InjectRepository } from '@nestjs/typeorm';
import { FieldLovMapper } from '../entity/field-lovs.entity';
import { Repository } from 'typeorm';

@Injectable()
export class FieldLovsRepository {
  constructor(@InjectRepository(FieldLovMapper) private readonly fieldLovMapperRepository: Repository<FieldLovMapper>) {
  }

  async saveBulk(dtos: FieldLovMapper[]) {
    return await this.fieldLovMapperRepository.save(dtos)
  }

  async findByMapperFieldIdAndSourceAttributeValue(mapper_field_id: number, source_attribute_value: string) {
    return await this.fieldLovMapperRepository.findOne({
      where: { mapper_field_id, source_attribute_value },
    });
  }

  async findByMapperFieldIdAndDestinationAttributeValue(mapper_field_id: number, destination_attribute_value: string) {
    return await this.fieldLovMapperRepository.findOne({
      where: { mapper_field_id, destination_attribute_value },
    })
  }

  async findByMapperFieldId(mapper_field_id: number) {
    return await this.fieldLovMapperRepository.find({
      where: { mapper_field_id },
    })
  }

  async deleteByMapperFieldId(mapper_field_id: number) {
    return await this.fieldLovMapperRepository.delete({ mapper_field_id });
  }
}