import { ResultSetHeader, RowDataPacket } from "mysql2";
import DB from "../config/database/db";
import fittingsAndFixturesTypes from "../schemas/fittingsAndFixtures.schema";

let fittingsAndFixturesDB: any = {};

fittingsAndFixturesDB.getByClientId = async ({ clientId, propId, type }: fittingsAndFixturesTypes) => {
  const query = "Select * from FittingsAndFixtures where clientId = ? and propId=? and type=?";
  const data = [clientId, propId, type];
  const [rows] = await DB.query<RowDataPacket[]>(query, data);
  if (rows?.length > 0) return rows;
  else return false;
};

export default fittingsAndFixturesDB;