import { eq, sql as sqlExpr, inArray } from "drizzle-orm";

import { eq, sql as sqlExpr, inArray, and } from "drizzle-orm";

      .where(inArray(fileMetadata.fileId, fileIds)),

      .where(
        and(
          inArray(fileMetadata.fileId, fileIds),
          eq(fileMetadata.active, true)
        )
      ),

      .where(inArray(mothMetadata.fileId, fileIds)),

      .where(
        and(
          inArray(mothMetadata.fileId, fileIds),
          eq(mothMetadata.active, true)
        )
      ),

import { eq, sql as sqlExpr, inArray } from "drizzle-orm";

import { eq, sql as sqlExpr, inArray, and } from "drizzle-orm";

      .where(inArray(fileMetadata.fileId, fileIds)),

      .where(
        and(
          inArray(fileMetadata.fileId, fileIds),
          eq(fileMetadata.active, true)
        )
      ),

      .where(inArray(mothMetadata.fileId, fileIds)),

      .where(
        and(
          inArray(mothMetadata.fileId, fileIds),
          eq(mothMetadata.active, true)
        )
      ),

import { eq } from "drizzle-orm";

import { eq, and } from "drizzle-orm";

      eq(cluster.cyclicRecordingPatternId, cyclicRecordingPattern.id)

      and(
        eq(cluster.cyclicRecordingPatternId, cyclicRecordingPattern.id),
        eq(cyclicRecordingPattern.active, true)
      )

          active: true,

 *   - recordingPattern?: Object | null (optional) - { recordS: number, sleepS: number } or null to remove

 *   - recordingPattern?: Object | null (optional) - { recordS: number, sleepS: number } or null to soft delete

 *   recordingPattern can be provided to add/update or set to null to remove recording pattern.

 *   recordingPattern can be provided to add/update or set to null to soft delete recording pattern.

          // Remove recording pattern

          // Soft delete recording pattern

            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));

              active: true,

            .where(eq(cyclicRecordingPattern.id, updatedCluster.cyclicRecordingPatternId))

            .where(
              and(
                eq(cyclicRecordingPattern.id, updatedCluster.cyclicRecordingPatternId),
                eq(cyclicRecordingPattern.active, true)
              )
            )

 * @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.

      // Hard delete associated cyclic recording pattern if it exists (no active field in this table)

      // Soft delete associated cyclic recording pattern if it exists

        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));

    console.log("Soft deleted cluster:", clusterId, "and hard deleted associated recording pattern by user:", userId);

    console.log("Soft deleted cluster:", clusterId, "and soft deleted associated recording pattern by user:", userId);

});

  active: boolean("active").default(true),
}, (table) => ([
  index("idx_cyclic_recording_pattern_active").on(table.active),
]));

});

  active: boolean("active").default(true),
}, (table) => ([
  index("idx_moth_metadata_active").on(table.active),
]));

  active: boolean("active").default(true),

  index("idx_file_metadata_active").on(table.active),

    modified_by VARCHAR(64) NOT NULL

    modified_by VARCHAR(64) NOT NULL,
    active BOOLEAN DEFAULT TRUE

CREATE INDEX idx_cyclic_recording_pattern_active ON cyclic_recording_pattern(active);

    active BOOLEAN DEFAULT TRUE,

CREATE INDEX idx_moth_metadata_active ON moth_metadata(active);

    active BOOLEAN DEFAULT TRUE,

CREATE INDEX idx_file_metadata_active ON file_metadata(active);

-- Add active column to cyclic_recording_pattern for soft deletes
ALTER 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 deletes
ALTER 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 deletes
ALTER 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 columns
CREATE 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

stats doint work in species