const { models } = require('../db')
const { validateField, handleAdd, handleUpdate, handleDelete } = require('../common')

async function findFileRangee(parameter) {
    const { _id, rangee, tag_id } = parameter

    //sql语句
    const sql = "select * from file_manage where _id != '" + _id + "' and tag_id = '" + tag_id + "' and rangee REGEXP '" + rangee + "'"
    try {
        // 查询数据sql
        const records = await models.$runSQL(sql)
        return {
            sql,
            success: true,
            msg: '查询成功',
            records: records.data.executeResultList,
        }
    } catch (error) {
        return {
            success: false,
            msg: '查询失败',
            sql,
            error: error
        }
    }
}

module.exports = {
    findFileRangee
}