Finding duplicate relations in prisma1 export data.

gistfile1.txt

const numberOfRelationJSONFiles = 131; // NOTE: Change this to the number of json files in the relation folder

for (let i=1; i <= numberOfRelationJSONFiles; i++ ) {
    let filename = ``;
    if (i < 10) {
        filename = `00000${i}`
    }
    if (i < 100 && i > 9) {
        filename = `0000${i}`
    }
    if (i >= 100) {
        filename = `000${i}`
    }
    const relationJSON = require(`./relations/${filename}.json`);
    
    const allRelationAIDs = [];
    const duplicateRelationAIds = [];
    
    relationJSON.values.forEach(relation => {
        const [relationA, relationB] = relation;
        if (allRelationAIDs.includes(`${relationA.id} ${relationB.id}`)) {
            duplicateRelationAIds.push(`${relationA.id} ${relationB.id}`);
        }
        allRelationAIDs.push(`${relationA.id} ${relationB.id}`);
    })
    
    duplicateRelationAIds.length > 0 && console.log(`DUPLICATES FOUND IN (${filename}.json): \n`, duplicateRelationAIds);
    duplicateRelationAIds.length === 0 && console.log('Scanning files for duplicates...');
}