Fix unique ROWID values in a site

// #/API/FixRowIds.js
export default (save) => {
    // Only the site owner's team should run this. Replace with your own role check.
    if (!request.user || !docly.allowModify("/", request.user)) return docly.denyAccess();

    // Reading is safe on GET. Writing requires POST AND an explicit save=true.
    let doSave = save === "true" || save === true;
    if (doSave && request.method != "POST") throw new Error("Verb not supported");

    let result = [];
    let skipped = 0;
    let files = docly.listFiles("/", "*", false, true, false);
    let lookup = {};
    for (let f of files) {
        // Files without a schema have no ROWID fields — skip them. (Code files have the schema "Code File" and drop out later: they have no ROWID.)
        if (!f.Schema) continue;
        let o;
        try { o = JSON.parse(f.Values); } catch (e) { skipped++; continue; }
        if (!o || !o.ROWID) continue;

        if (lookup[o.ROWID]) {
            if (doSave) docly.patchFile(f.Path, { "ROWID": docly.guid() });
            result.push({ "file1": f.Path, "file2": lookup[o.ROWID].Path });
        }
        else
            lookup[o.ROWID] = f;
    }
    return {
        "Duplicates": result,
        "Corrected": doSave,
        "Skipped": skipped
    };
}