JEWGR3YVTBR536L6UPKSFD54CCCU23G3G723LKRESPRVYXIZAWAAC EQKLVT45KJNHQCSI56WCHTB4UKMLOIOXBXXEJ6JH46GME2RKTSWQC L56W77RVX5BNRQ3ZLH7GE5MYJGCNGB64ZWJTY7TUGW35P7TU5O4AC OBXY6BHNROIV7W4O3MMQ6GTQXU2XUKF5A4DCJYDLUEUHV72E7BNAC ONSQYCF6NFUEA24ORB62W4P62LKUMV7C5PLYRZQULHFDNROEY2HQC TKCG7EZ3MYG2FFWYRLGQTQXIRDSNGICDHK6CE6OZJPTBK6CNYFJAC EUEH65HBT4XZXCNWECJXNDEQAWR2NLNSAXFPXLMQ27NOVMQBJT5QC ZYT3JRERMYXLMJHLPZYQHAINVMPQLBKGGN7A4C7OTVZDY42ZLTKQC QPZE42LFURFXW6QNTVXY6AF7DZI7KTOLHMNSJHLFCRZMNMGQ6EVQC NYBASAG4KWZNPSFBXWQJWQRBCGT7C5B24IYO2IBCXCE2WGJQJOEQC LSAQ6ZM2NELU3FIWKEFBOXKVLSZS2ZOK2PHPHJRWPVZ5CVILSUYQC await tx.delete(cyclicRecordingPattern).where(eq(cyclicRecordingPattern.id, currentPatternId));
await tx.update(cyclicRecordingPattern).set({active: false,lastModified: new Date(),modifiedBy: userId,}).where(eq(cyclicRecordingPattern.id, currentPatternId));
* @description Soft deletes a cluster (sets active=false) and hard deletes its associated cyclic recording pattern if present.
* @description Soft deletes a cluster (sets active=false) and soft deletes its associated cyclic recording pattern if present.
await tx.delete(cyclicRecordingPattern).where(eq(cyclicRecordingPattern.id, clusterRecord.cyclicRecordingPatternId));
await tx.update(cyclicRecordingPattern).set({active: false,lastModified: new Date(),modifiedBy: userId}).where(eq(cyclicRecordingPattern.id, clusterRecord.cyclicRecordingPatternId));
-- Add active column to cyclic_recording_pattern for soft deletesALTER TABLE cyclic_recording_pattern ADD COLUMN active BOOLEAN DEFAULT TRUE;SELECT NOW();-- 2025-06-06 00:06:37.079+00-- Add active column to file_metadata for soft deletesALTER TABLE file_metadata ADD COLUMN active BOOLEAN DEFAULT TRUE;SELECT NOW();-- 2025-06-06 00:07:06.414+00-- Add active column to moth_metadata for soft deletesALTER TABLE moth_metadata ADD COLUMN active BOOLEAN DEFAULT TRUE;SELECT NOW();-- 2025-06-06 00:07:32.553+00
-- Create indexes for the new active columnsCREATE INDEX idx_cyclic_recording_pattern_active ON cyclic_recording_pattern(active);CREATE INDEX idx_file_metadata_active ON file_metadata(active);CREATE INDEX idx_moth_metadata_active ON moth_metadata(active);SELECT NOW();-- 2025-06-06 00:08:23.914+00