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

const eqaroPropertiesDB: any = {};

eqaroPropertiesDB.getByPropId = async ({ propId }: eqaroPropertiesType) => {
    const query = "Select * from EqaroProperties where propId = ?";
    const data = [propId];
    const [rows] = await DB.query<RowDataPacket[]>(query, data);
    return rows[0];
};

export default eqaroPropertiesDB;