Advertisement
Guest User

Untitled

a guest
Mar 21st, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.52 KB | None | 0 0
  1. function initAndReserveDBConnection(req, callback) {
  2. var username = req.session.username;
  3. var password = req.session.password;
  4.  
  5. if(!username || ! password) {
  6. callback(new Error("Bad username or password"))
  7. return;
  8. }
  9.  
  10. var db = new JDBC(dbConfig(username, password))
  11. db.initialize(function(err) {
  12. if(err) {
  13. callback(err);
  14. return;
  15. }
  16.  
  17. db.reserve(function(err, connObj) {
  18. if(err) {
  19. callback(err);
  20. return;
  21. }
  22.  
  23. callback(null, connObj, db);
  24. })
  25. })
  26. }
  27.  
  28. function releaseDBConnection(res, connObj, db, callback) {
  29. db.release(connObj, function(err) {
  30. if(err) {
  31. internalErrorResponse(res);
  32. return;
  33. }
  34.  
  35. callback();
  36. })
  37. }
  38.  
  39. function internalErrorResponse(res) {
  40. res
  41. .status(500)
  42. .end();
  43. }
  44.  
  45. app.post("/name", function(req, res) {
  46. var obj = req.body;
  47.  
  48. // init database
  49. initAndReserveDBConnection(req, (err, connObj, netezzadb) => {
  50. if(err) {
  51. internalErrorResponse(res);
  52. return;
  53. }
  54.  
  55. // Do something with connObj...
  56.  
  57. // Release the connection
  58. releaseDBConnection(res, connObj, netezzadb, function() {
  59. // If needed return data to client here
  60. /* exemple :
  61.  
  62. res.json({
  63. time: Date.now()
  64. })
  65.  
  66. */
  67. })
  68. })
  69. })
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement