Guest User

Untitled

a guest
Jun 1st, 2018
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.26 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>
  69.  
  70. {"data": "<! DOCTYPE html> r n <html lang = " en "ng-app = DB> r n <head> r n <meta charset = " UTF-8 "> r n <title> Заголовок </ title> r n </ head> r n <body ng-controller = " controller "> r n <h1> {{date. result}} </ h1> r n <h2> {{dateWithDb}} </ h2> r n <script src = "./ angular / angular.min.js "> </ script> r n <script src = "./ javascripts / controllerInfo.js "> </ script> r n r n </ body> r n r n </ html> "," статус ": 200," конфигурация ": {" метод ":" GET " "transformRequest": [пустой] "transformResponse": [нуль], "jsonpCallbackParam": "Обратный вызов", "URL":" HTTP: / / локальный: 8080" , "заголовки": { "Accept":»application / json, text / plain, * / * "}}," statusText ":" OK "," xhrStatus ":" complete "}
  71.  
  72. app.listen(8000, () => {
  73. console.log('Сервер стартовал!');
  74. });
Add Comment
Please, Sign In to add comment