Advertisement
raphaelluiz128

api

Mar 10th, 2019
166
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.48 KB | None | 0 0
  1. api
  2.  
  3.  
  4.  
  5.  
  6. router.post('/', authMiddleware,async(req,res)=>{
  7.  
  8. let {id} = await generateId(req.headers.authorization);
  9.  
  10.  
  11. //let {id} = jwt.verify(TokenArray,authConfig.secret);
  12. console.log(id);
  13.  
  14. await singleUpload (req, res, async function(err) {
  15.  
  16.  
  17. const{
  18. idsizes,idtemperaments,idgroups,
  19. name, birthday, breed,
  20. phrase,sendimage
  21. } = req.headers;
  22.  
  23. console.log(sendimage);
  24. if (err) {
  25. console.log(err.message);
  26. return res.status(422).send({errors: [{title: 'Image Upload Error', detail: err.message}]});
  27. }
  28. else{
  29.  
  30.  
  31.  
  32. try{
  33. const pets = await model.pets.create({
  34. idusers:id,
  35. idgroups:idgroups,
  36. idsizes:idsizes,
  37. idtemperaments:idtemperaments,
  38. name:name,
  39. birthday:birthday,
  40. breed:breed,
  41. phrase:phrase
  42. });
  43.  
  44.  
  45.  
  46. petsId = await model.pets.findOne({
  47. where: {
  48.  
  49. idusers: id
  50. },order: [ [ 'idpets', 'DESC' ]],
  51.  
  52. })
  53.  
  54.  
  55. console.log(petsId.idpets);
  56.  
  57.  
  58. //return res.json({'imageUrl': req.file.location});
  59.  
  60.  
  61. //var location = req.file.location;
  62.  
  63. if(sendimage == '1') {
  64.  
  65.  
  66. const images = await model.imagesp.create({
  67. image:req.file.location
  68. });
  69.  
  70. console.log(req.file.location);
  71. location = req.file.location;
  72. //console.log(location);
  73.  
  74.  
  75. imagesId = await model.imagesp.findOne({
  76. where: {
  77. image: location,
  78. //password: password
  79. }
  80. })
  81.  
  82.  
  83.  
  84. const petsximages = await model.petsximages.create({
  85. idpets: petsId.idpets,
  86. idimages: imagesId.idimages
  87. });
  88. console.log(imagesId.idimages);
  89.  
  90.  
  91. const imageUpdate = await model.pets.update({
  92. imagep:imagesId.idimages},
  93. { where: {
  94. idpets: petsId.idpets
  95. }
  96. }).
  97. then(user => {
  98. console.log('update image ok');
  99. })
  100. .catch(error => {
  101. console.log(error.message);
  102. });
  103. }
  104.  
  105.  
  106. const pesq = await sequelize.query("SELECT * FROM `pets` left join `imagesp` on `pets`.`imagep` = `imagesp`.`idimages` left join `groups` on `pets`.`idgroups` = `groups`.`idgroups` left join `temperaments` on `pets`.`idtemperaments` = `temperaments`.`idtemperaments` left join `sizes` on `pets`.`idsizes` = `sizes`.`idsizes` where `pets`.`idpets` = "+petsId.idpets+" ;", { type: sequelize.QueryTypes.SELECT});
  107.  
  108.  
  109.  
  110. return res.send({
  111. //imagesId,petsximages,
  112. pesq
  113. });
  114. } catch (err) {
  115. console.log(err.message);
  116. return res.status(400).send({erro : err.message});
  117. }
  118.  
  119. }
  120.  
  121.  
  122. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement