这里服务端的user下index保持这样吗

Question

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

router.post('/addMany' , async(ctx) => {       const {         key = '',       } = ctx.request.body;           const path = `${config.UPLOAD_DIR}/${key}`;           const excel = loadExcel(path);           const sheet = getFirstSheet(excel);           const character = await Character.find().exec();             const member = character.find((item) => (item.name === 'member'));            const arr = [];           sheet.forEach((record) => {         const [account, password = config.DEFAULT_PASSWORD] = record;                   arr.push({               account,               password,               character: member._id,         });               });           await User.insertMany(arr);           ctx.body = {         code:1,         msg:'添加成功',     };       });

Answer 1

提问者 qq_蓝骏毅_04076633 2021-04-19 14:51:49

改了之后也可以拿到xls

Answer 2

提问者 qq_蓝骏毅_04076633 2021-04-19 14:48:49

有点区别

修改：

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

router.post('/addMany' , async(ctx) => {       const {         key = '',       } = ctx.request.body;           const path = `${config.UPLOAD_DIR}/${key}`;           const excel = loadExcel(path);           const sheet = getFirstSheet(excel);           const character = await Character.find().exec();             const member = character.find((item) => (item.name === 'member'));            const arr = [];           for (let i = 0; i < sheet.length; i++) {                   let record = sheet[i];                   const [account, password = config.DEFAULT_PASSWORD] = record;                   const one = await User.findOne({               account,         })                   if (one) {               continue;         }                   arr.push({               account,               password,               character: member._id,         });               }           await User.insertMany(arr);           ctx.body = {         code: 1,         msg: '添加成功',         data: {           addCount: arr.length,         },     }; });

Answer 3

然冬 2021-04-19 13:29:51

可以和仓库里的源码比对一下

https://git.imooc.com/coding-450/book-mgr

• 提问者 qq_蓝骏毅_04076633 #1

  有点区别
  修改成这样
  router.post('/addMany' , async(ctx) => {
  	  const {
  	    key = '',
  	  } = ctx.request.body;
  	
  	const path = `${config.UPLOAD_DIR}/${key}`;
  	
  	const excel = loadExcel(path);
  	
  	const sheet = getFirstSheet(excel);
  	
  	const character = await Character.find().exec();
  
  	
  	const member = character.find((item) => (item.name === 'member'));
  	
  	 const arr = [];
  	
  	for (let i = 0; i < sheet.length; i++) {
  		
  		let record = sheet[i];
  		
  		const [account, password = config.DEFAULT_PASSWORD] = record;
  		
  		const one = await User.findOne({
  		      account,
  		})
  		
  		if (one) {
  		      continue;
  		}
  		
  		arr.push({
  		      account,
  		      password,
  		      character: member._id,
  		});
  		
  	}
  	
  	await User.insertMany(arr);
  	
  	ctx.body = {
  	    code: 1,
  	    msg: '添加成功',
  	    data: {
  	      addCount: arr.length,
  	    },
  	};
  });