Guest User

Untitled

a guest
Dec 6th, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.04 KB | None | 0 0
  1. let con = mysql.createConnection({
  2. host : conf.get('db').connection,
  3. user : conf.get('db').user,
  4. password : conf.get('db').pass,
  5. database : conf.get('db').database
  6. });
  7. con.query('SELECT * FROM `clothing`', function(error, result, fields){
  8. if(error == null){
  9. var presets = [];
  10. result.forEach(function(v, i){
  11. presets.push({
  12. 'name': v.name,
  13. 'torso': [v.torso_draw, v.torso_tex],
  14. 'legs': [v.legs_draw, v.legs_tex],
  15. 'foot': [v.foot_draw, v.foot_tex],
  16. 'torso_acc': [v.torso_acc_draw, v.torso_acc_tex],
  17. 'hands': [v.hands_draw, v.hands_tex],
  18. 'helmet': [v.helmet_draw, v.helmet_tex],
  19. 'mask': [v.mask_draw, v.mask_tex]
  20. });
  21. });
  22. response.json(presets);
  23. } else{
  24. console.log(error);
  25. }
  26. });
  27.  
  28. const doQuery = callback => {
  29. const connection = require('mysql').createConnection({
  30. host: conf.get('db').connection,
  31. user: conf.get('db').user,
  32. password: conf.get('db').pass,
  33. database: conf.get('db').database
  34. });
  35. const presets = [];
  36.  
  37. connection.connect();
  38. connection.query('SELECT * FROM `clothing`', (err, results, fields) => {
  39. if (err) return callback(err, null);
  40.  
  41. results.forEach((v, i) => {
  42. presets.push({
  43. 'name': v.name,
  44. 'torso': [v.torso_draw, v.torso_tex],
  45. 'legs': [v.legs_draw, v.legs_tex],
  46. 'foot': [v.foot_draw, v.foot_tex],
  47. 'torso_acc': [v.torso_acc_draw, v.torso_acc_tex],
  48. 'hands': [v.hands_draw, v.hands_tex],
  49. 'helmet': [v.helmet_draw, v.helmet_tex],
  50. 'mask': [v.mask_draw, v.mask_tex]
  51. });
  52. });
  53.  
  54. connection.end();
  55. callback(null, presets);
  56. });
  57. };
  58.  
  59. // вызов в app (в промышленном использовании следует добавить обработку ошибок)
  60. doQuery((err, result) => response.json(presets));
Add Comment
Please, Sign In to add comment