Advertisement
Guest User

Untitled

a guest
Aug 24th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. app.post('/select', (req, res) => {
  2. config.database = req.body.db;
  3.  
  4. var sqlQuery = `SELECT ${req.body.select} FROM ${req.body.from}`;
  5. if (req.body.where !== '' && req.body.where !== undefined) sqlQuery += ` WHERE ${req.body.where}`;
  6. if (req.body.order !== '' && req.body.order !== undefined) sqlQuery += ` ORDER BY ${req.body.order}`;
  7. console.log(`Query: ${sqlQuery}`);
  8.  
  9. sql.connect(config).then(pool => {
  10. return pool.request().query(sqlQuery)
  11. }).then(result => {
  12. sql.close();
  13. sqlDone = true;
  14. console.dir(result);
  15. res.header('Content-Type', 'Application/JSON');
  16. res.json(result.recordset);
  17. }).catch(err => {
  18. sql.close();
  19. sqlDone = true;
  20. console.log('Caught Error:');
  21. console.log(err);
  22. });
  23. sql.on('error', err => {
  24. sql.close();
  25. console.log('SQL Request Error:');
  26. console.log(err);
  27. });
  28. });
  29.  
  30. Error: Global connection already exists. Call sql.close() first.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement