Guest User

Untitled

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