如何在上链前确定一笔交易的transaction hash

// 使用了 sequlize

const transactionHash = await getTransactionHashBeforeSendingTransaction(); // 这个方法是用来获取交易的 transaction hash

// 修改订单状态的时候，我们把 transaction hash 也一起写入数据库
// 下面代码的sql 语句: update order set status = '发货中' and transactionHash = 'transactionHash' where id = 1 and status = '已付款';
await order.update({ status: '发货中', transactionHash }, { where: { id: 1, status: '已付款' } });

// (发货)给用户 mint nft
await contract.batchMintBox(owner, blindBoxTypes, assetIds); 

// 下面代码的sql 语句:  update order set status = '发货完成' where id = 1 and status = '发货中';
await order.update({ status: '发货完成' }, { where: { id: 1, status: '发货中' } });

// web3.js 实现方式
import Web3 from 'web3';
const web3 = new Web3(blockchainNetRpcUrl); // blockchainNetRpcUrl 是链的 rpc 地址
const account = web3.eth.accounts.privateKeyToAccount(privateKey); // privateKey 是账户私钥
web3.eth.accounts.wallet.add(account);

const contract = new web3.eth.Contract(contractAbi, contractAddress); // contractAbi 是合约的 abi
const contractMethod = contract.methods.batchMintBox(owner, blindBoxTypes, assetIds); // 具体的mint nft 的方法
const gasLimit = await contractMethod.estimateGas();
const data = contractMethod.encodeABI();
const txParams = {
  nonce,
  gasLimit: gasLimit.toNumber(),
  gasPrice: new BigNumber(5).times(1000000000).toNumber(),
  to: contractAddress,
  data,
};
const signedTx = await web3.eth.accounts.signTransaction(txParams, admin.wallet.PrivateKey);
const transactionHash = signedTx.transactionHash; // 这个就是我们要的 transaction hash
const rawTransaction = signedTx.rawTransaction; 

// 发送交易, 真正执行 mint nft 的方法
// sendSignedTransaction 会返回 TransactionReceipt 对象，解析这个对象可以获取到 transaction hash
// 对比上文的 transaction hash 你会发现, 解析的 transaction hash 和上文的 transaction hash 是一样的
const receipt = await web3.eth.sendSignedTransaction(rawTransaction);
assert.equal(receipt.transactionHash, transactionHash); // 两个 transaction hash 是一样的

// web3.js 确认transaction hash 是否在链上确认
const transaction = await web3.eth.getTransaction(hash);
if (transaction === null) {
  console.log('交易未上链');
} else {
  console.log('交易已上链');
}

// ethers.js 实现方式
import { ethers } from 'ethers';
import { parse as TransactionParser } from '@ethersproject/transactions';

const getTransactionAdvance = async (originTransactionHash: ethers.PopulatedTransaction, wallet: ethers.Wallet) => {
  const txPopulated = await wallet.populateTransaction(originTransactionHash);
  const rawTransaction = await wallet.signTransaction(txPopulated);
  const { hash: transactionHash } = TransactionParser(rawTransaction);
  return { rawTransaction, transactionHash };
};

const provider = new ethers.providers.JsonRpcProvider(blockchainNetRpcUrl); // blockchainNetRpcUrl 是链的 rpc 地址
const wallet = new ethers.Wallet(privateKey, provider); // privateKey 是账户私钥
const contract = new ethers.Contract(contractAddress, contractAbi, wallet); // contractAbi 是合约的 abi

const nonce = await wallet.getTransactionCount();
const txOrigin = await contract.populateTransaction.batchMintBox(owner, blindBoxTypes, assetIds, { nonce }); // 调用具体的合约的方法
const { rawTransaction, transactionHash } = await getTransactionAdvance(txOrigin, wallet); // 获取 transaction hash

// 发送交易, 真正执行 mint nft 的方法, sendTransaction 会返回 TransactionResponse 对象
const tx = await this.provider.sendTransaction(rawTransaction);
await tx.wait(); // 等待交易确认
assert.equal(tx.hash, transactionHash); // 两个 transaction hash 是一样的

// ethers.js 确认transaction hash 是否在链上确认
const isTransactionConfirmed = async (transactionHash: string, provider: ethers.providers.JsonRpcProvider): Promise<boolean> => {
  const txReceipt = await provider.getTransactionReceipt(transactionHash);
  if (txReceipt && txReceipt.blockNumber) {
    return true;
  } else {
    return false;
  }
};

const ethersProvider = new ethers.providers.JsonRpcProvider(blockchainNetRpcUrl); // blockchainNetRpcUrl 是链的 rpc 地址
const isConfirmed = await isTransactionConfirmed(transactionHash, ethersProvider);
if (!isConfirmed) {
  console.log('交易未上链');
} else {
  console.log('交易已上链');
}