import { Injectable } from "@nestjs/common"
import { InjectRepository } from "@nestjs/typeorm"
import { Repository } from "typeorm"
import { BaseAbstractRepository } from "../../../common/repository/base.repository"
import { State } from "../entities/state.entity"

@Injectable()
export class StateRepository extends BaseAbstractRepository<State> {
  constructor(
    @InjectRepository(State)
    private readonly stateRepository: Repository<State>,
  ) {
    super(stateRepository)
  }
  async findByCountryId(country_id: number) {
    return this.stateRepository.find({
      where: { country_id },
      select: ["id", "name"],
      order: { name: "ASC" },
    })
  }
}