const db = context.env.ACCOUNT_D1_TEST;
await db.batch([
db
.prepare(
/*sql*/ `
INSERT INTO account
(id, date_created)
VALUES (?,?);
`
)
.bind(newAccountId, now),
db
.prepare(
/*sql*/ `
INSERTZ INTO account_user
(id, date_created, account_id, credential_username, credential_password_hash, role_of_owner)
VALUES (?1,?2,?3,?4,?5,?6);
`
)
.bind(newAccountUserId, now, newAccountId, username, cipherText, 1),
]);
const db = context.env.ACCOUNT_D1_TEST;
await db.batch([
db
.prepare(
/*sql*/ `
INSERT INTO account
(id, date_created)
VALUES (?,?);
`
)
.bind(newAccountId, now),
db
.prepare(
/*sql*/ `
INSERTZ INTO account_user
(id, date_created, account_id, credential_username, credential_password_hash, role_of_owner)
VALUES (?1,?2,?3,?4,?5,?6);
`
)
.bind(newAccountUserId, now, newAccountId, username, cipherText, 1),
]);