wallet address index covering

nitsujlangston · nitsujlangston · commit a4a4fac5d920 · 2019-01-06T11:39:30.000-05:00
diff --git a/packages/bitcore-node/src/models/transaction.ts b/packages/bitcore-node/src/models/transaction.ts
@@ -343,6 +343,7 @@ export class TransactionModel extends BaseModel<ITransaction> {
       mintOpsAddresses = Object.keys(mintOpsAddresses);
       let wallets = await WalletAddressStorage.collection
         .find({ address: { $in: mintOpsAddresses }, chain, network }, { batchSize: 100 })
+        .project({ wallet: 1, address: 1 })
         .toArray();
       if (wallets.length) {
         mintOps = mintOps.map(mintOp => {
diff --git a/packages/bitcore-node/src/models/walletAddress.ts b/packages/bitcore-node/src/models/walletAddress.ts
@@ -22,8 +22,8 @@ export class WalletAddressModel extends BaseModel<IWalletAddress> {
   allowedPaging = [];
 
   onConnect() {
-    this.collection.createIndex({ address: 1, wallet: 1 }, { background: true });
-    this.collection.createIndex({ wallet: 1 }, { background: true });
+    this.collection.createIndex({ chain: 1, network: 1, address: 1, wallet: 1 }, { background: true, unique: true });
+    this.collection.createIndex({ chain: 1, network: 1, wallet: 1, address: 1 }, { background: true, unique: true });
   }
 
   _apiTransform(walletAddress: { address: string }, options: TransformOptions) {

Original file line number	Diff line number	Diff line change
`@@ -22,8 +22,8 @@ export class WalletAddressModel extends BaseModel<IWalletAddress> {`
`22`	`22`	`allowedPaging = [];`
`23`	`23`
`24`	`24`	`onConnect() {`
`25`		`- this.collection.createIndex({ address: 1, wallet: 1 }, { background: true });`
`26`		`- this.collection.createIndex({ wallet: 1 }, { background: true });`
	`25`	`+ this.collection.createIndex({ chain: 1, network: 1, address: 1, wallet: 1 }, { background: true, unique: true });`
	`26`	`+ this.collection.createIndex({ chain: 1, network: 1, wallet: 1, address: 1 }, { background: true, unique: true });`
`27`	`27`	`}`
`28`	`28`
`29`	`29`	`_apiTransform(walletAddress: { address: string }, options: TransformOptions) {`