4 replies

id on transaction conflict

hey all, using mysql (planetscale). when a transaction conflict happens over an insert with the same 'serial'

id

id

i believe that mysql will resolve this by changing one of the inserts to the next available.
my concern is that within a transaction i want to reference the returned

id

id

to use as a reference. will this

id

id

match the 'new'

id

id

after the conflict has resolved, or will it reference the original?
here is some code to better explain maybe:

async function test() {
  await db.transaction(async (tx) => {
    const insertRecord = await tx.insert(record).values({
      foo: "bar",
    });

    await tx
      .insert(user)
      .values({
        foo: "bar",
        recordId: parseInt(insertRecord.insertId)  // is insertId ok on conflict?
       });
  });
}

async function test() {
  await db.transaction(async (tx) => {
    const insertRecord = await tx.insert(record).values({
      foo: "bar",
    });

    await tx
      .insert(user)
      .values({
        foo: "bar",
        recordId: parseInt(insertRecord.insertId)  // is insertId ok on conflict?
       });
  });
}

This is my first time trying to make something production ready so want to make sure all situations are covered, any help is appreciated thank you!

Drizzle Team•3y ago•

4 replies

Jim

id on transaction conflict

hey all, using mysql (planetscale). when a transaction conflict happens over an insert with the same 'serial'

id

id

i believe that mysql will resolve this by changing one of the inserts to the next available.
my concern is that within a transaction i want to reference the returned

id

id

to use as a reference. will this

id

id

match the 'new'

id

id

after the conflict has resolved, or will it reference the original?
here is some code to better explain maybe:

async function test() {
  await db.transaction(async (tx) => {
    const insertRecord = await tx.insert(record).values({
      foo: "bar",
    });

    await tx
      .insert(user)
      .values({
        foo: "bar",
        recordId: parseInt(insertRecord.insertId)  // is insertId ok on conflict?
       });
  });
}

async function test() {
  await db.transaction(async (tx) => {
    const insertRecord = await tx.insert(record).values({
      foo: "bar",
    });

    await tx
      .insert(user)
      .values({
        foo: "bar",
        recordId: parseInt(insertRecord.insertId)  // is insertId ok on conflict?
       });
  });
}

This is my first time trying to make something production ready so want to make sure all situations are covered, any help is appreciated thank you!

id on transaction conflict

Similar Threads

id on transaction conflict

Similar Threads

Similar Threads

Similar Threads