import { Injectable } from '@nestjs/common';
import { CreateDiagnosisCategoryListDto } from './dto/create-diagnosis-category-list.dto';
import { DataSource } from 'typeorm';

@Injectable()
export class DiagnosisCategoryListService {
  constructor(private readonly connection: DataSource
  ) { }
  async create(createDiagnosisCategoryListDto: CreateDiagnosisCategoryListDto) {
    await this.connection.query(`insert into diagnosis_test_category (diagnosis_test_category) values (?)`, [
      createDiagnosisCategoryListDto.diagnosis_test_category
    ])
    return {
      "status": "success",
      "message": "diagnosis category added successfully"
    };
  }

  async findAll(search: string) {
    let getAllCategoryList
    if (search) {
      search = search.toLocaleLowerCase()
      getAllCategoryList = await this.connection.query(`select * from diagnosis_test_category 
        WHERE diagnosis_test_category LIKE ? 
        limit 10`, ['%' + search + '%'])
    } else {
      getAllCategoryList = await this.connection.query(`select * from diagnosis_test_category limit 10`)
    }
    return {
      "status": "success",
      "message": "diagnosis category list fetched successfully",
      "details": getAllCategoryList
    }
  }


}