Amit Posts - Answer Overflow

Amit

Explore posts from servers

CDCloudflare Developers SSolidJS TTCTheo's Typesafe Cult DTDrizzle Team

•Created by Amit on 8/13/2024 in #help

MYSQL iterator() streaming hangs randomly

https://orm.drizzle.team/docs/select#iterator I am trying to stream results using the iterator feature. But the iteration seems to hang randomly after some time. Any idea what could be leading to this or if it can be a bug?

const iterator = await db.select().from(users).iterator();
for await (const row of iterator) {
  console.log(row);
  // query another table
}

const iterator = await db.select().from(users).iterator();
for await (const row of iterator) {
  console.log(row);
  // query another table
}

1 replies

DTDrizzle Team

•Created by Amit on 3/15/2024 in #help

on cascade delete issue with multiple foreign keys and migrations

I have a mysql schema like this,

export const table1 = mysqlTable('table1', {
    id: int('id').primaryKey().autoincrement()
});

export const table2 = mysqlTable('table2', {
    id: int('id').primaryKey().autoincrement(),
    fk1: int('fk1')
        .references((): AnyMySqlColumn => table1.id)
        .notNull(),
    fk2: int('fk2')
        .references((): AnyMySqlColumn => table1.id)
        .notNull()
});

export const table1 = mysqlTable('table1', {
    id: int('id').primaryKey().autoincrement()
});

export const table2 = mysqlTable('table2', {
    id: int('id').primaryKey().autoincrement(),
    fk1: int('fk1')
        .references((): AnyMySqlColumn => table1.id)
        .notNull(),
    fk2: int('fk2')
        .references((): AnyMySqlColumn => table1.id)
        .notNull()
});

I ran the generate command and then added { onDelete: 'cascade' } to both fk1 and fk2. When i ran generate again, the generated migration file only contains statement for updating cascade delete for fk1.

// 0001_neat_thena.sql
ALTER TABLE `table2` DROP FOREIGN KEY `table2_fk1_table1_id_fk`;
--> statement-breakpoint
ALTER TABLE `table2` ADD CONSTRAINT `table2_fk1_table1_id_fk` FOREIGN KEY (`fk1`) REFERENCES `table1`(`id`) ON DELETE cascade ON UPDATE no action;

// 0001_neat_thena.sql
ALTER TABLE `table2` DROP FOREIGN KEY `table2_fk1_table1_id_fk`;
--> statement-breakpoint
ALTER TABLE `table2` ADD CONSTRAINT `table2_fk1_table1_id_fk` FOREIGN KEY (`fk1`) REFERENCES `table1`(`id`) ON DELETE cascade ON UPDATE no action;

Is this a bug ?

1 replies

Gaming

Programming