Guest User

Untitled

a guest
Jun 1st, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.36 KB | None | 0 0
  1. var pg = require("pg");
  2. var rest;
  3.  
  4. var pool = new pg.Pool({
  5. host: "***",
  6. port: "***",
  7. user: "***",
  8. password: "****",
  9. database: "***"
  10. });
  11.  
  12. pool.connect(function (err,client,done) {
  13. if(err)console.log("connect " + err.toString());
  14.  
  15. else
  16. client.query('SELECT *' +
  17. 'FROM public."GeneralInfo";',function (err,result) {
  18.  
  19. if(err) console.log("query " + err.toString());
  20. else {
  21. console.log(result.rows[0]);
  22. rest = result.rows[0];
  23. }
  24. done();
  25. });
  26.  
  27.  
  28. });
  29. pool.end();
  30.  
  31.  
  32. module.exports.res = rest;
  33.  
  34. var express = require('express');
  35. var connectResult = require('./ConnectDB/connect');
  36.  
  37.  
  38. app.get("/",function (req,res) {
  39.  
  40. console.log(connectResult);
  41.  
  42. res.send(connectResult);
  43. });
  44.  
  45. var controller = function ($scope,$http) {
  46. $http.get("http://localhost:8080").then (function (response) {
  47. console.log("I get date with DB");
  48. console.log(response);
  49. $scope.dateWithDb = response;
  50. },function (res) {console.log(res.toString()) });
  51.  
  52. }
  53. angular.module("DB",[]).controller("controller",controller);
  54.  
  55. <!DOCTYPE html>
  56. <html lang="en" ng-app = DB>
  57. <head>
  58. <meta charset="UTF-8">
  59. <title>Title</title>
  60. </head>
  61. <body ng-controller="controller">
  62. <h1>{{dateWithDb}}</h1>
  63. <script src="./angular/angular.min.js"></script>
  64. <script src="./javascripts/controllerInfo.js"></script>
  65.  
  66. </body>
  67.  
  68. </html>
Add Comment
Please, Sign In to add comment