• Home
• io.gravitee.apim.repository
• gravitee-apim-repository-mongodb
• 4.5.2
• source code
• api-keys-migration.js

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

scripts.3.12.0.api-keys-migration.js Maven / Gradle / Ivy

// Override this variable if you use prefix
const prefix = '';

print(`Add 'key' and 'api' columns in 'keys' table`);

const keys = db.getCollection(`${prefix}keys`);
const subscriptions = db.getCollection(`${prefix}subscriptions`);

keys.find({}).forEach((key) => {
    subscriptions.find({_id: key.subscription}).forEach((subscription) => {
        key.key = key._id;
        key.api = subscription.api;
        keys.replaceOne({ _id: key._id }, key);
    });
});

print(`Create new indexes in 'keys' table`);

keys.createIndex( { "key" : 1 } );
keys.createIndex( { "key" : 1, "api" : 1 } );
keys.reIndex();