Drizzle V1 Tests

[noxify]

drizzle is currently preparing the V1 release. There are some beta releases. Maybe it makes sense to extend the tests for drizzle to support also v1.

[noxify]

sorry for the delay and the silence if you're waiting for the tests for drizzle v1 support.

I found the time to integrate it in one of our internal apps and it seems that the current delete statements aren't working correctly with drizzle V1.

The solution is to update the cleanupJobs and clearJobs in the drizzle adapter.

Current workaround is to copy the current implementation locally ( = creating your own adapter ) and replace both methods with:

  async clearJobs(status?: JobStatus): Promise<number> {
    const conditions = [eq(this.model.queueName, this.queueName)]
    if (status) {
      conditions.push(eq(this.model.status, status))
    }

    // Define the expected return type from delete operation
    interface DeleteResult {
      rowCount: number
    }

    const result = (await this.db.delete(this.model).where(and(...conditions))) as DeleteResult

    return result.rowCount
  }

  async cleanupJobs(status: JobStatus, keepCount: number): Promise<number> {
    // Get jobs to delete (all except the most recent N)
    const jobsToDelete = await this.db

      .select({ id: this.model.id })
      .from(this.model)

      .where(and(eq(this.model.queueName, this.queueName), eq(this.model.status, status)))
      .orderBy(sql`${this.model.createdAt} DESC`)
      .offset(keepCount)

    if (jobsToDelete.length === 0) {
      return 0
    }

    const idsToDelete = jobsToDelete.map((job) => job.id)

    interface DeleteResult {
      rowCount: number
    }

    const result = (await this.db
      .delete(this.model)
      .where(
        and(
          eq(this.model.queueName, this.queueName),
          eq(this.model.status, status),
          inArray(this.model.id, idsToDelete),
        ),
      )) as DeleteResult

    return result.rowCount
  }

i will / have to check if the updated where statements are also working with drizzle v0