kylemocode/update.js

## update.js
// 開始一個 transaction
await conn.query("BEGIN");

// 執行更新
const sqlU= "update seats set isbooked = 1, name = $2 where id = $1 and isbooked = 0"
const updateResult = await conn.query(sqlU,[id, name]);

// 結束 transaction
await conn.query("COMMIT");
	// 開始一個 transaction
	await conn.query("BEGIN");

	// 執行更新
	const sqlU= "update seats set isbooked = 1, name = $2 where id = $1 and isbooked = 0"
	const updateResult = await conn.query(sqlU,[id, name]);

	// 結束 transaction
	await conn.query("COMMIT");