I need import some data from a collection to other.
Hi, I need to import from source collection 'Tuss_22' to target collection 'Convenio' filling 'Convenio.procedimentos' array.
I am trying clear the array 'Convenio.procedimentos' before insert a new by a 'forEach' in Tuss_22.
But I am get an error of 'exec is not a function'.
///Schemas and router
const express = require('express');
const router = express.Router();
const Convenio = require('../models/convenio');
const Tuss_22 = require('../models/tuss_22');
var conveniosSchema = new mongoose.Schema({
nr: {type: Number, unique:true},
procedimentos:[{codigo:{type:String},descricao:{type:String},tipo:{type:mongoose.Schema.Types, ref:'TipoConsulta'}}]
});
//router
router.importarTabelaTUSS=function(req,res,next){
console.log(req);
const query={};
Convenio.findById(req.params.id, function (err, data) {
// Handle any possible database errors
if (err) {
res.status(500).send(err);
return next(error);
} else {
// Drop entire other collection
data.procedimentos.remove().exec( (err_p,data_p) => {
Tuss_22.find({}, (err_t,data_t) => {
data_t.forEach(function(doc){
data.procedimentos.push({'codigo':doc.codigo, 'descricao':doc.descricao}); // start to replace
});
});
})
}
})
};
via Luiz Alves
No comments:
Post a Comment