export_sources_and_versions.js

db.export.sources.drop();
db.export.source_ids.drop();
db.export.sourceversions.drop();
db.export.sourceversion_ids.drop();


org_ids = db.orgs_organization.find({mnemonic: {$in: ["OHRITechGroup", "OMRSCOVIDSquad", "EthiopiaNHDD", "MSF-OCB", "MOH-DM", "IAD", "integrated-impact", "SSAS", "DSME-Test", "GFPVAN", "im", "Kuunika", "DSME", "DSME-CDD", "MOH", "mTOMADY", "IRDO", "ibwighane", "mw-terminology-service", "mw-product-master", "ICI", "mw-terminology-service-development", "mw-product-master-ocl-instance", "mw-product-master-ocl", "malawi-diseases-diagnosis", "TestOrg", "DWB", "CMDF", "MUDHC", "MSF", "MU", "MUDH", "nproto", "MSFTW", "TWABC", "kuunika-registries", "UNIMED", "SHC", "MSFOCP", "SELF", "OpenSandbox", "sandbox", "ATH", "Reverton"]}}, {_id: 1}).map(doc => doc._id.str);
user_ids = db.users_userprofile.find({mnemonic: {$in: ["gpotma"]}}, {_id: 1}).map(doc => doc._id.str);
source_ids = db.sources_source.find({ $or: [{parent_id: {$in: org_ids}}, {parent_id: {$in: user_ids}}]}, {_id: 1}).map(doc => doc._id.str);

db.export.sources.insertMany(db.sources_source.find({ $or: [{parent_id: {$in: org_ids}}, {parent_id: {$in: user_ids}}]}).map(doc => doc));
db.export.sourceversions.insertMany(db.sources_sourceversion.find({versioned_object_id: {$in: source_ids}, mnemonic: {$ne: 'HEAD'}}).map(doc => doc));
db.export.source_ids.insertMany(db.sources_source.find({}).map(doc => ({_id: doc._id, uri: doc.uri})))
db.export.sourceversion_ids.insertMany(db.sources_sourceversion.find({mnemonic: {$ne: 'HEAD'}}).map(doc => ({_id: doc._id, uri: doc.uri})))

print(db.export.sources.count() + " matching source found");
print(db.export.sourceversions.count() + " matching sourceversion found");