Guest User

Untitled

a guest
May 23rd, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 KB | None | 0 0
  1. let getPlayer = (args) => {
  2. let id = args.id;
  3. console.log("id: " + id);
  4. let myPromise = new Promise((resolve, reject) => {
  5. const connection = mysql.createConnection(config.ddbb_connection);
  6. connection.connect();
  7. connection.query("select json_object('id', id) as player from tbl003_player where id = " + id,
  8. function (error, results, fields) {
  9. if (!error){
  10. if (results.length > 0){
  11. resolve(results[0]);
  12. console.log("resultado: " + results[0]);
  13. }else{
  14. reject(new Error("No se ha encontrado ninguna jugadora con el ID: " + id));
  15. }
  16. }else{
  17. reject(new Error("Se ha producido un error de acceso a BBDD"));
  18. }
  19. });
  20. connection.end();
  21. });
  22. console.log("Salgo de la consulta");
  23. myPromise.then((resolve) => {
  24. console.log("resolve: " + JSON.stringify(resolve));
  25. return resolve;
  26. },(error) => {
  27. console.log(error);
  28. return error;
  29. });
  30. };
Add Comment
Please, Sign In to add comment