Transactions on @effect/sql-drizzle/Pg
Hi, how can I use transaction in the following code
export const action = Effect.gen(function* () {
const db = yield* PostgresDrizzle.PgDrizzle
yield* db.delete(users).where(D.eq(users.id, "1"))
yield* db.delete(users).where(D.eq(users.id, "2"))
yield* db.delete(users).where(D.eq(users.id, "3"))
yield* db.insert(users).values({ id: "1", name: "1" })
yield* db.insert(users).values({ id: "2", name: "2" })
yield* db.insert(users).values({ id: "3", name: "3" })
return yield* db.select().from(users)
})export const action = Effect.gen(function* () {
const db = yield* PostgresDrizzle.PgDrizzle
yield* db.delete(users).where(D.eq(users.id, "1"))
yield* db.delete(users).where(D.eq(users.id, "2"))
yield* db.delete(users).where(D.eq(users.id, "3"))
yield* db.insert(users).values({ id: "1", name: "1" })
yield* db.insert(users).values({ id: "2", name: "2" })
yield* db.insert(users).values({ id: "3", name: "3" })
return yield* db.select().from(users)
})
